hi all, i have problem in creating a formula of my code. this is all about updating a mysql database in including it in php. I dont know how to generate it. can you please give me some code in a working php with mysql.
This code is to update after clicking the word update and to subtract each time to click by once..
Please help me..
Sample code:
"SELECT * FROM tablename WHERE time = 20";
$time1 = time -1 ;
"UPDATE tablename SET time = $time1";
Is this correct?
What else would i add to make my code complete in updating my mysql database?