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
 
For 2023 (and 2024 ...) - we are now fully retired from IT training.
We have made many, many friends over 25 years of teaching about Python, Tcl, Perl, PHP, Lua, Java, C and C++ - and MySQL, Linux and Solaris/SunOS too. Our training notes are now very much out of date, but due to upward compatability most of our examples remain operational and even relevant ad you are welcome to make us if them "as seen" and at your own risk.

Lisa and I (Graham) now live in what was our training centre in Melksham - happy to meet with former delegates here - but do check ahead before coming round. We are far from inactive - rather, enjoying the times that we are retired but still healthy enough in mind and body to be active!

I am also active in many other area and still look after a lot of web sites - you can find an index ((here))
math equation in php

Posted by phillipmulvaney (phillipmulvaney), 29 April 2004
I am working on a php page which extracts "quantity" from database "a".
I then want to subtract 1 from quantity and then send the new quantity back to the database.


$db_name = "harro";
$table_name = "a";
$connection = @mysql_connect("localhost", "harro", "eMHiGiTU") or
die(mysql_error());
$db = @mysql_select_db($db_name, $connection) or die(mysql_error());

// select quantity from database 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 subtract 1 from quantity and post back to database

quantiy --;
     "update a set quantity ='$sum' where   barcode = '$_POST[barcode]'";
     

}



Posted by admin (Graham Ellis), 29 April 2004
Perhaps I'm missing something here, but I think your query might be as simple as:

// mysql_connect as in your example
// mysql_select_db as in your example
mysql_query("update a set quanitiy = quantity - 1 where barcode = '$_POST[barcode]'");

Suggestions:

a) Try out the SQL command to see if it does what you want using the mysql client before you wrap it up in PHP.  That way, you're developing the code in two easy steps

b) Do NOT put the @ in front of the MySQL calls until your code is tested and working - as it stands, you're supressing error and warning messages which will be very useful in helping you find out where problems lie

Posted by phillipmulvaney (phillipmulvaney), 29 April 2004
cheers that was it.
think im just tired have been working on a website for days and had tried everything for the last 2 hours and nothing would work.
thanks again,
phillip



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., 2024: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 793803 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho