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>"; } Quote 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? Quote 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 Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.