i have this query set: $EditQuery="select * from $EventsTable where Id='$edit'"; $query=mysql_query($EditQuery)||die(mysql_error()); //later in the code i have this: while($old=mysql_fetch_array($query)){ //do stuff } when i run the page i get: warning: supplied argument to mysql_fetch_array is not a valid mysql resource type on line 98
im lost i wrote this code hundreds of times and it always works... the query looks right : echo $EditQuery; output: select * from rnjresort.events where Id='1' and that is exactly what i want (i ran that exact string in mysql client) and it gave me what i was looking for...
Did you select a database to run you query on?
-- *********************************************************************** * _ __ __ __ _ * John Nichel * * | |/ /___ __ \ \ / /__ _ _| |__ ___ __ ___ _ __ * 716.856.9675 * * | ' </ -_) _` \ \/\/ / _ \ '_| / /(_-<_/ _/ _ \ ' \ * 737 Main St. * * |_|\_\___\__, |\_/\_/\___/_| |_\_\/__(_)__\___/_|_|_|* Suite #150 * * |___/ * Buffalo, NY * * http://www.KegWorks.com [EMAIL PROTECTED] * 14203 - 1321 * ***********************************************************************
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php