Jay2391 Posted January 29, 2007 Share Posted January 29, 2007 I have this condiction an I get the ...Registration Closed part so i know that $tfull == TRUE is working now i want to get status to update on the table from 1 to 2...what am i missing ...if($tfull == TRUE){ echo "<br>Registration Closed"; $staus_2 = 2; $change = "UPDATE $tablet SET (status=\"$status_2\") WHERE (tourney_id=\"$tourney_id\")"; } Link to comment https://forums.phpfreaks.com/topic/36210-missing-something-to-update/ Share on other sites More sharing options...
paul2463 Posted January 29, 2007 Share Posted January 29, 2007 try this[code]<?phpf($tfull == TRUE){ echo "Registration Closed"; $status_2 = 2; $change = "UPDATE $tablet SET status='$status_2' WHERE tourney_id='$tourney_id'"; mysql_query($change) or die ("Cannot Update Table". mysql_error()); }?>[/code] Link to comment https://forums.phpfreaks.com/topic/36210-missing-something-to-update/#findComment-171996 Share on other sites More sharing options...
Jay2391 Posted January 29, 2007 Author Share Posted January 29, 2007 Awsome ...Thanks!! Link to comment https://forums.phpfreaks.com/topic/36210-missing-something-to-update/#findComment-172017 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.