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
$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