i would like create a script that allows me to make multiple table UPDATEs all at the same time...i don't have any sample code as i'm not really sure where to begin...although i have been reading documentation on this...
this is the scenario...
a query pulls up 15 records (it's LIMITed to 15)...i'm going to have this information display itself in basically just a list as it will be emailed directly from the webpage...this is easy enough...
BUT...how do i compose the script info for the table update...i'm only updating the table in two columns...one with a static number and the other with a date from the server...so nothing complicated...
I WANT to create a submit button that will enact the UPDATE query and update the appropriate records from there...possible?
any thoughts about this? would i even use the UPDATE function for this? or does php have another method?
oh crap...i just realized i should have asked this in the db area...well...i hope nobody will kill me for this...
I'M GOING TO GET BANNED FOR ASKING SO MANY QUESTIONS...I KNOW IT...BUT I HAVE ANOTHER ONE...SO I'LL JUST POST IT HERE...
my stupid count won't work...it's giving me the general error...how could this be wrong?
$count = mysql_query ("SELECT COUNT (*) FROM main WHERE ad1='1' AND ad2='0' " ) or die ("2Unexpected error for MySQL database [3b]");
$row_count = mysql_fetch_row($count);
thanks much...jv
