You are missing a " before $booktitle.
old:booktitle=$booktitle AND quantity=quantity";
new:booktitle="$booktitle AND quantity=quantity";
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
----- Original Message -----
From: "Jason Wong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 14, 2002 8:51 PM
Subject: Re: [PHP] PHP and mySQL
> 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
