Jump to content

Archived

This topic is now archived and is closed to further replies.

Arsenal

PHP and MySQL Retrieval

Recommended Posts

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]

Share this post


Link to post
Share on other sites
Do you want to tell us what is wrong? (ie. what errors, what you expect and what you don't get?)

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites
[!--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]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.