function not echoing result

[tkinsella]

I have a function that when it runs does not return a result, and does not throw an error in the log... Any advice? Thanks!

 

function getFullsize ($vn) {
   global $conn;
   global $myDate;
   $get = "SELECT * FROM storeStats.$vn WHERE date = '$myDate'";
   $go = mysql_query($get,$conn);
   list($data['fullSize']) = mysql_fetch_row($go);
   echo $data['fullSize'];

}

 

I would expect on the echo for it to return the result from the database, but I get nothing :/ I can echo $get and get a result though.

 

Thanks!

[trq]

Have you tried checking your query succeeds?

[ManiacDan]

You're also not really doing functions right.  You pass in a variable that's never used and then use globals to pull in two more that ARE used.  Pass variables into functions, you defeat their entire purpose using global.

 

Also, it's possible that field in that row is just empty, or non-printable characters like an HTML tag.