On Tuesday 14 May 2002 18:38, City Colleges of Chicago - Mannheim wrote:
> 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.

if ($booktitle AND $quantity) { ...

> <?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>

-- 
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *

/*
"All we are given is possibilities -- to make ourselves one thing or another."
-- Ortega y Gasset
*/


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to