PHP and MySQL Retrieval

[Arsenal]

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]

[ober]

Do you want to tell us what is wrong? (ie. what errors, what you expect and what you don't get?)

[Arsenal]

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]

[XenoPhage]

[!--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]