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`, `email@example.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