Training, Open Source computer languages
PerlPHPPythonMySQLApache / TomcatTclRubyJavaC and C++LinuxCSS 
Search for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
 
20.9.2014 - We have just updated our course layouts and descriptions and added our 2015 schedule.

php sql problem

Posted by phillipmulvaney (phillipmulvaney), 29 April 2004
hi,
I am having trouble with some simple maths here.
I want to retrieve "quantity" from table "a" subtract 1 from the "quantity" and then post this new "quantity" back to the database.
I can retrieve the "quantity" but when I subtract 1 from it nothing happens.

Here is the code:

$table_name = "a";

$sql = "SELECT quantity FROM $table_name
       WHERE barcode = '$_POST[barcode]'";

$result = @mysql_query($sql,$connection)
         or die(mysql_error());

$num = mysql_num_rows($result);
$sum = 0;

// want to take 1 from quantity
$sum = quantity --;
quantity = $sum;

//now want to post the new quantity
// back to the database
$sql = "update a set quantity
       where barcode = '$_POST[barcode]'";

Cheers!

Posted by admin (Graham Ellis), 29 April 2004
Answer linked (somewhat) to your other post.

You've carefully written an sql command into the $sql variable, but you haven't run mysql_query on the variable to send it across to the MySQL daemon  



This page is a thread posted to the opentalk forum at www.opentalk.org.uk and archived here for reference. To jump to the archive index please follow this link.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2014: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho