imohammad
سه شنبه 03 مرداد 1391, 01:04 صبح
سلام
دوستان اگه ممکنه بگین این کد چه ایرادی داره؟
<form method="post">
<label>E-Mail</label>
<input type="text" name="email" />
<label>Name</label>
<input type="text" name="uname" />
<input type="submit" />
</form>
<?php
//Import config.php and connect tu db
include('config.php');
$con = mysql_connect($db['host'],$db['user'],$db['pass']);
mysql_select_db($db['name']);
$query = "INSERT INTO 'users'('email','name','active','key') VALUES('".$_POST['email']."','".$_GET['uname']."','0','aaabbbccc)";
$qry = mysql_query($query);
echo mysql_error($con);
echo mysql_error();
mysql_close($con);
?>
همش ارور زیر رو میده:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''users'('email','name','active','key') VALUES('xxx@xxx.xx','','0','aaabb' at line 1
ممنون
دوستان اگه ممکنه بگین این کد چه ایرادی داره؟
<form method="post">
<label>E-Mail</label>
<input type="text" name="email" />
<label>Name</label>
<input type="text" name="uname" />
<input type="submit" />
</form>
<?php
//Import config.php and connect tu db
include('config.php');
$con = mysql_connect($db['host'],$db['user'],$db['pass']);
mysql_select_db($db['name']);
$query = "INSERT INTO 'users'('email','name','active','key') VALUES('".$_POST['email']."','".$_GET['uname']."','0','aaabbbccc)";
$qry = mysql_query($query);
echo mysql_error($con);
echo mysql_error();
mysql_close($con);
?>
همش ارور زیر رو میده:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''users'('email','name','active','key') VALUES('xxx@xxx.xx','','0','aaabb' at line 1
ممنون