[RESOLVED] I'm lost...mysql_query

michaewlewis

I've just started to get into the mysql side of php and can't figure out how to insert into the database. Here's the code I'm working with.

<?php
$db = "inventory";
$dbtable = "instock";
$link = mysql_connect ("localhost", "root", "root")
  or die("Could not connect: " . mysql_error());
print "Connected successfully to MySQL<br>";
mysql_select_db($db) or die("Could not select database: $db");
print "Connected successfully to $db<br>";

//$input = "INSERT INTO $dbtable VALUES(Primary_Key  curdate  description  partno  serialno  quantused  usedfor  areaofwork  initials  comments)";
$input = "INSERT INTO $dbtable VALUES('Primary_Key', 'curdate', 'description', 'partno', 'serialno', 'quantused', 'usedfor', 'areaofwork', 'initials', 'comments')
          VALUES(NULL, $curdate, $description, $partno, $serialno, $quantused, $usedfor, $areaofwork, $initials, $comments);";
print $input . "<br>";
$query = mysql_query($input) or die(mysql_error());


// $row = mysql_fetch_assoc(mysql_query(SELECT * FROM instock, mysql_connect("localhost", "root", "root")));
$getit = "SELECT * FROM instock";
$gotit = mysql_query($getit, $link);
while($row = mysql_fetch_assoc($gotit))
{
  foreach($row as $col=>$val)
    print "$val &nbsp; ";
  print "<br>";
}

When it runs, it tells me that there is an error in my sql sytax; check the manual that corresponds to you mysql server version for the right syntax near 'VALUES(NULL, 2007/01/01, description partnpumber, serialnumber, 3, every' at line 2)

I've got no idea what that means. Any input?
Thanks.

alimadzi

Just remove the first instance of "VALUES" from your query. That's the column list and doesn't require any specific word in front of it. Keep the word "VALUES" in place just before your list of values to insert.

michaewlewis

thanks for the help, I took out the extra VALUES instance, but it still is showing up with the same error.

tams

Change this

$input = "INSERT INTO $dbtable VALUES('Primary_Key', 'curdate', 'description', 'partno', 'serialno', 'quantused', 'usedfor', 'areaofwork', 'initials', 'comments')
          VALUES(NULL, $curdate, $description, $partno, $serialno, $quantused, $usedfor, $areaofwork, $initials, $comments);";

to this format

$input = "INSERT INTO $dbtable (Primary_Key, curdate, description, partno, serialno, quantused, usedfor, areaofwork, nitials, comments)
          VALUES('NULL', '$curdate', '$description', '$partno', '$serialno', '$quantused', '$usedfor', '$areaofwork', '$initials', '$comments')";

That usually solves this syntax error.

michaewlewis

hey thanks. Its working now. Now I just need to figure out how to auto increment the primary key. 🙂

michaewlewis

never mind, I got it. thanks for the help.