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 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? 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
Archived
This topic is now archived and is closed to further replies.