Jump to content

Archived

This topic is now archived and is closed to further replies.

tjhilder

Trouble inserting data

Recommended Posts

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

Share this post


Link to post
Share on other sites

Your strings in the VALUES() clause should be enclosed with single-quotes ('), not backticks (`).

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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 ";
}

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.