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>