SocomNegotiator Posted February 11, 2009 Share Posted February 11, 2009 Do you see anything wrong with this code? I don't get this...a few months ago this iece of code was working fine, but now it does not work. I think that my host provider upgraded his PHP version or something. $ladders=mysql_query("SELECT item.id, item.name, pre_order.amount, DATE_FORMAT(pre_order.date,'%m/%d/%y - %H:%i') FROM pre_order LEFT JOIN item ON pre_order.item_id = item.id WHERE pre_order.user_id='".$user_id."'") or die(mysql_error()); while(list($id,$name,$amount,$date)=mysql_fetch_row($ladders)){ $out[body].="<tr><td align='center'>$amount</td><td align='center'>$name</td><td align='center'>$date</td></tr>"; } Link to comment https://forums.phpfreaks.com/topic/144708-do-you-see-anything-wrong-with-this-piece-of-code/ Share on other sites More sharing options...
gevans Posted February 11, 2009 Share Posted February 11, 2009 Do you get an error? Link to comment https://forums.phpfreaks.com/topic/144708-do-you-see-anything-wrong-with-this-piece-of-code/#findComment-759343 Share on other sites More sharing options...
SocomNegotiator Posted February 11, 2009 Author Share Posted February 11, 2009 It's just not displaying anything...when in the DB I know there are items Link to comment https://forums.phpfreaks.com/topic/144708-do-you-see-anything-wrong-with-this-piece-of-code/#findComment-759371 Share on other sites More sharing options...
PFMaBiSmAd Posted February 11, 2009 Share Posted February 11, 2009 $user_id is probably empty. You need to follow the advice given in your other thread - http://www.phpfreaks.com/forums/index.php/topic,238134.msg1109227.html#msg1109227 Link to comment https://forums.phpfreaks.com/topic/144708-do-you-see-anything-wrong-with-this-piece-of-code/#findComment-759372 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.