Rows returned but empty variables?? 1

[Elliott3]

I am running a query and it returns one record as it should (which i find out from mysql_num_rows()) but the variables are empty?? This is my code:
$sSQL = "SELECT pdf FROM articlesnew WHERE ID = " . $_GET['articleid'];
$result = @mysql_query($sSQL); //run the query
$row = mysql_fetch_array($result,MYSQL_ASSOC);
$pdfFile = $row['articleDate'];
$num = mysql_num_rows($result);

$num returns 1
$pdfFile returns nothing
$GET['articleid'] returns the correct value

Any suggestions...am interested in any possibilties..

CES

 

[skiflyer]

The only things which will be in the $row variable will be the items from your SELECT statement... in this case there will be exactly one entry for

$row['pdf'];

For debugging purposes you'll probably get alot of mileage from

echo '<pre>';
print_r($row);

-Rob

 

[sleipnir214]

I see two possible things wrong with this line:

$result = @mysql_query($sSQL);


First, you're using the "@" error-suppressiong operator. If you were getting an error from the function, you'd never know it. In my opinion, you should never use "@".

Second, if MySQL were to return an error, you would not know it.

I recommend that you change the line to read:

$result = mysql_query($sSQL) or die(mysql_error());

This may or may not have any effect on your problem, though.


For checking on returned values, I recommend that for testing purposes you add the line:

print_r($row);

to the script immediately after the line where you invoke mysql_fetch_array(). It can give you a view of what you've fetched.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Elliott3]

thanks...i was just trying some different things and forgot that i left that like that..the line:
$pdfFile = $row['articleDate'];
actually does read:
$pdfFile = $row['pdf'];
and the var still returned nothing??


CES

 

[skiflyer]

Have you tried the print_r?

-Rob

 

[Elliott3]

New to php/mysql so i have never used print_r() before...this is what it returned:
Array ( [pdf] => )

CES

 

[Elliott3]

I figured it out...i was just trying to work on too many parts of the code at once and did something stupid. On related sillyness I never realized that the @ symbol suppressed errors. That was just the way my book shows that. Thanks for the tip. I appreciate it!

CES