Re: PHP and mySQL
| From: | Jason Wong | Date: | Tue, 14 May 2002 10:51:28 +0000 |
| Subject: | Re: PHP and mySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-97517@lists.php.net to get a copy of this message | ||
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
*/