Arsenal Posted March 15, 2006 Share Posted March 15, 2006 I have something wrong and I am missing what. Help please.[code]$fac_qry = mysql_query("SELECT name, email FROM ".$SET['pref']."_stor_facility WHERE abbr = '$locat'"); list($fac_name, $fac_email) = mysql_fetch_object($fac_qry);[/code] Link to comment https://forums.phpfreaks.com/topic/5056-php-and-mysql-retrieval/ Share on other sites More sharing options...
ober Posted March 15, 2006 Share Posted March 15, 2006 Do you want to tell us what is wrong? (ie. what errors, what you expect and what you don't get?) Link to comment https://forums.phpfreaks.com/topic/5056-php-and-mysql-retrieval/#findComment-17901 Share on other sites More sharing options...
Arsenal Posted March 15, 2006 Author Share Posted March 15, 2006 Oh yeah....that would help.[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in C:\Server\Apache Group\Apache2\htdocs\PHP-ECHO\fusions\faccontactus\index.inc.php on line 141[/quote] Link to comment https://forums.phpfreaks.com/topic/5056-php-and-mysql-retrieval/#findComment-17906 Share on other sites More sharing options...
XenoPhage Posted March 15, 2006 Share Posted March 15, 2006 [!--quoteo(post=355445:date=Mar 15 2006, 02:38 PM:name=Arsenal)--][div class=\'quotetop\']QUOTE(Arsenal @ Mar 15 2006, 02:38 PM) [snapback]355445[/snapback][/div][div class=\'quotemain\'][!--quotec--]Oh yeah....that would help.[/quote]Your query failed, or possibly returned no rows. Try your query directly in mysql and make sure it works. Also, add this :[code]$fac_qry = mysql_query("SELECT name, email FROM ".$SET['pref']."_stor_facility WHERE abbr = '$locat'") or die ( 'MySQL Error : ' . mysql_error() );[/code] Link to comment https://forums.phpfreaks.com/topic/5056-php-and-mysql-retrieval/#findComment-17934 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.