Gensic Posted October 12, 2014 Share Posted October 12, 2014 Hey guys, I have problem displaying some stuff from mysql. Idea was that Order's have rows like - OrderID|CustomerID|OrderDesc So when i run $checkIsHavingOrders = mysql_query("SELECT * FROM orders ORDER BY OrderID DESC limit 10 WHERE CustomerID = '$myID'"); it should print OrderID|CustomerID|OrderDesc 1001|1|Skin 1021|1|Skin 1031|1|Skin (I made up the numbers so you can get image of thing i am trying to do..) Thanks for your time! Quote Link to comment https://forums.phpfreaks.com/topic/291597-php-sql-display-problem/ Share on other sites More sharing options...
Ch0cu3r Posted October 12, 2014 Share Posted October 12, 2014 What are you asking? How to get the results from the query? Have a look at the mysql_fetch_assoc. NOTE: You should stop using the mysql_* functions as they are deprecated. Meaning they are no longer supported and could be removed from future versions of PHP. YOu should use mysqli or pdo instead. 1 Quote Link to comment https://forums.phpfreaks.com/topic/291597-php-sql-display-problem/#findComment-1493416 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.