tjhilder Posted November 4, 2005 Share Posted November 4, 2005 Hi, I'm new to MySQL and know a limited knowledge of PHP, so I'm having a problem with trying to put information into MySQL, can someone tell me what I'm doing wrong with this code? <?php $uid = 'member_userid'; $uname = 'member_username'; $pwd = 'member_password'; $fname = 'member_fullname'; $email = 'member_email'; $rank = 'member_rank'; // get connection and database information require_once('admin/mysql/mysql_connect.inc'); // Insert information into members for member: tjhilder $query = "INSERT INTO members ($uid,$uname,$pwd,$fname,$email,$rank) VALUES ( `1`, `tjhilder`, `something`, `TJ Hilder`, `tjhilder@something.com`, `1` )"; // Create data for Members mysql_query($query) or die(mysql_error()); echo "<a href=\"mysql3.php\">Click Here</a>"; ?> I'm getting this error: Unknown column '1' in 'field list' thanks in advance if you can help me TJ Quote Link to comment Share on other sites More sharing options...
Cook Posted November 4, 2005 Share Posted November 4, 2005 Your strings in the VALUES() clause should be enclosed with single-quotes ('), not backticks (`). Quote Link to comment Share on other sites More sharing options...
tjhilder Posted November 4, 2005 Author Share Posted November 4, 2005 thanks, I believe that worked, but I'm not sure. how do I check it? I don't know how to display the information, can anyone help me please? Quote Link to comment Share on other sites More sharing options...
ryanlwh Posted November 4, 2005 Share Posted November 4, 2005 I'm showing you the basic. $query = "SELECT * FROM members"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_row($result)) { foreach($row as $value) echo "$value "; } Quote Link to comment Share on other sites More sharing options...
tjhilder Posted November 6, 2005 Author Share Posted November 6, 2005 thanks, it's working 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.