PHP and mySQL
| From: | City Colleges of Chicago - Mannheim | Date: | Tue, 14 May 2002 10:38:37 +0000 |
| Subject: | PHP and mySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-97515@lists.php.net to get a copy of this message | ||
I am getting a parse error on line 75. I am trying to say:
if there is a booktitle and a quantity chosen, then go to that booktitle and
adjust the quantity in the database.
Thanks!
Renee
<?php
$user = "adminer";
$pass = "hoosiers";
$db = "Book Store1";
$local = "jolinux";
$link = mysql_connect( "$local", $user, $pass );
if (! $link )
die ( "Couldn't open the database" );
mysql_select_db( $db, $link )
or die ( "Couldn't open the $db: ".mysql_error() );
if ($submit){
if( $booktitle, "quantity" ){
$sql = "UPDATE Book2 SET stock ='$stock-quantity' WHERE booktitle=$booktitle
AND quantity=quantity";
}
// $result = mysql_query($mysql);
}else if(!$submit){
echo "Your order has not been placed.<p>";
}
?>
</BODY>
</HTML>