MySQL Table changin
#9

Try this:
PHP код:
mysql_query_nodata("SELECT * FROM `plr_veteran` ORDER BY `ID` ASC"); //Change the `ID` to the name of the variable which you are using line order
mysql_query_nodata("UPDATE `plr_veteran` SET `Actve`= '1' WHERE `VHOURS` > '20'"); 
I'm not sure if it will work! (I'm still learning MySQL)
EDITED: Code was edited a little!
Reply


Messages In This Thread
MySQL Table changin - by Xportaler - 17.05.2018, 18:34
Re: MySQL Table changin - by JasonRiggs - 17.05.2018, 18:39
Re: MySQL Table changin - by Xportaler - 17.05.2018, 18:44
Re: MySQL Table changin - by JasonRiggs - 17.05.2018, 18:50
Re: MySQL Table changin - by Kraeror - 17.05.2018, 18:51
Re: MySQL Table changin - by Xportaler - 17.05.2018, 18:53
Re: MySQL Table changin - by Kraeror - 17.05.2018, 18:56
Re: MySQL Table changin - by Xportaler - 17.05.2018, 19:13
Re: MySQL Table changin - by Kraeror - 17.05.2018, 19:15
Re: MySQL Table changin - by JasonRiggs - 17.05.2018, 19:16

Forum Jump:


Users browsing this thread: 1 Guest(s)