Help!php Posted March 2, 2012 Share Posted March 2, 2012 This is the query which should likes salestrack productid with printers productid, but even though there are data no result is showing and I really dont know why. Please help SELECT salestrack.orderid AS orderid, salestrack.salesman AS salesman, printers.rrp AS price, salestrack.name AS name, salestrack.phone AS phone, salestrack.email AS email, printers.name AS printername, salestrack.orderdate AS orderdate, salestrack.status AS STATUS FROM printers, salestrack WHERE salestrack.productid = printers.productid AND salestrack.status = 'OPEN' ORDER BY salestrack.orderdate Quote Link to comment https://forums.phpfreaks.com/topic/258100-query-wont-display-on-the-webpage-urgent/ Share on other sites More sharing options...
Drummin Posted March 2, 2012 Share Posted March 2, 2012 I don't see any mysql_query. Can I also assume you DB connection and the code to display results of the query that you're not showing? Quote Link to comment https://forums.phpfreaks.com/topic/258100-query-wont-display-on-the-webpage-urgent/#findComment-1323046 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.