need help with sending queries

Junior WebHelper Joined: 09 May 2002 Posts: 15

<?
$db = mysql_connect("localhost", "root");
mysql_select_db("reginfo", $db);
mysql_query("insert into info (indexnum,login,password) values (1,'Adam','Adam'");
?>

why doesnt this code work? its purpose is to register those values into the fields "indexnum", "login", and "password" in my table named "info" in my database named "reginfo"

Team Member Joined: 06 Jan 2002 Posts: 2564

You MIGHT want to use capitals.

Posted: Thu May 09, 2002 6:29 am (21 years, 11 months ago)

<?
$db = mysql_connect("localhost", "root");
mysql_select_db("reginfo", $db);
mysql_query("insert into info (indexnum,login,password) values (1,'Adam','Adam')");
?>

Does it need an extra closing braket after the values - see above

WebHelper Joined: 08 Jan 2002 Posts: 69 Location: Ireland

Daniel wrote:

You MIGHT want to use capitals.

You don't have to use capitals, but it does enhance readability.

Garth Farley