Line 29:
$sql2="UPDATE inventory SET inv_status="assigned" where inv_tag='$inv_tag' ";
will give a php error - it should read either
$sql2="UPDATE inventory SET inv_status='assigned' where inv_tag='$inv_tag' ";
or
$sql2="UPDATE inventory SET inv_status=\"assigned\" where inv_tag='$inv_tag' ";
to be syntactically correct in php.
Balaji Ankem schrieb am Samstag, 28. Juli 2001, 10:41:21:
> Hi dearest friend,
> can we update the same row immediately after selection.
> please see the following code at line number 29 it is giving error.
> code
> ------------------------------------
> <?php
> // Connect to MySQL
> $connection = mysql_connect( 'localhost', 'balaji', 'pingpong' )
> or die ( 'Unable to connect to server.' );
> // Select database on MySQL server
> mysql_select_db( 'imac' )
> or die ( 'Unable to select database.' );
> // Formulate the query (inv_tag will come by post method
> $sql1 = "SELECT * FROM inventory WHERE inv_tag = '$inv_tag'";
> // Execute the query and put results in $result
> $result1 = mysql_query( $sql1 )
> or die ( 'Unable to select the data from inventory.' );
> if ( $result1 )
> {
> //change the status of the inventory item in inventory table
> $sql2="UPDATE inventory SET inv_status="assigned" where inv_tag='$inv_tag'
>"; // This is line number 29.
> $result2 = mysql_query( $sql2 )
> or die ( 'Unable to execute query for upadation of inventory
>table.' );
> $sql3 = "insert into status
>values('$inv_name','$inv_type','$inv_tag','$issued_to','$issued_by','$issue_date')";
> $result3 = mysql_query( $sql3 )
> or die ( 'Unable to execute query for insertion in to status
>table.' );
> }
> else
> {
> // header( 'WWW-Authenticate: Basic realm="Private"' );
> // header( 'HTTP/1.0 401 Unauthorized' );
> echo '$inv_tag does not exist';
> exit;
> }
> ?>
> please inform if any errors.
> Thanks in advance.
> Regards
> -Balaji
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]