Sanjib Sinha Posted January 11, 2009 Share Posted January 11, 2009 Here is my code: <?php $c = mysql_connect('localhost','root',""); $c = mysql_select_db('user', $c); for($i=1; $i<=5; $i++){ $sql = "INSERT INTO 'users' ('username') VALUES('$i')"; $res = mysql_query($sql) or die(mysql_error()); echo "Row $i has been added <br>\n" ; } ?> Here is the output: 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' ('username') VALUES('1')' at line 1 Where is the problem? Quote Link to comment Share on other sites More sharing options...
ratcateme Posted January 11, 2009 Share Posted January 11, 2009 ' are used in mysql to contain strings ` are used to contain field names (or at least that is my belief) try this $sql = "INSERT INTO `users` (`username`) VALUES('$i')"; Scott. Quote Link to comment Share on other sites More sharing options...
redarrow Posted January 11, 2009 Share Posted January 11, 2009 $sql = "INSERT INTO 'users' ('username') VALUES('$i')"; you put single slash around users take them away or use `` button under esc. Quote Link to comment Share on other sites More sharing options...
Sanjib Sinha Posted January 11, 2009 Author Share Posted January 11, 2009 ' are used in mysql to contain strings ` are used to contain field names (or at least that is my belief) try this $sql = "INSERT INTO `users` (`username`) VALUES('$i')"; Scott. Hi Scott Your belief is true. I removed ' and replaced with ` and it solved. Thank you. I have learnt a new thing. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.