Inserting into the Database

[Aybabtu]

When I rung the following code $query works but $query2 does not. Can anyone explain this to me?

---

<?
$set = "1";
// set up some variables

// server name
$server = "localhost";

// username
$user = "aybabtu";

// password
$pass = "some_pass";

// database to query
$db = "laptop";

// open a connection to the database
$connection = mysql_connect($server, $user, $pass);

// formulate the SQL query - same as above
$query = "INSERT INTO loan
(girs,user,manager,date_out_one,date_out_two,date_out_three,due_in_one,due_in_two,due_in_three,floppy,cdrom,power,mouse,adapters,other) VALUES

('$gticket','$lto','$umanager','$dloan1','$dloan2','$dloan3','$dback1','$dback2','$dback3','$afdrive','$acdrom','$apcables','$amouse','$aiadapt','$

aother')";

$query2 = "INSERT INTO inventory (on_loan) VALUES ('$set') WHERE serial = '$serial'";

// run the query on the database

$result = mysql_db_query($db,$query,$connection);
$result2 = mysql_db_query($db,$query2,$connection);

[YappyDog]

$query2 doesn't work because you are not allowed to have a WHERE clause in an INSERT statement.

[tuf-web_co_uk]

when inserting information into the database using

INSERT INTO

you will never use "where value='something'"

i think the correct syntax your looking for is

$query2 = "UPDATE inventory SET on_loan='$set' WHERE serial = '$serial'";