Terion Miller wrote:
Actually I have tried EVERYTHING suggested and it just does not work, in
my last query here I put in a user I know has orders and still nothing :
$sql3 = "SELECT admin.AdminID, workorders.WorkOrderID,
workorders.DATE_FORMAT(CreatedDate,'%m/%e/%y') AS SubmitDate,
workorders.Location, workorders.AdminID, workorders.FormName,
workorders.Status FROM admin INNER JOIN workorders ON admin.AdminID =
workorders.AdminID WHERE admin.username = 'lhanford' ";
Are there mySQL settings that could prevent JOINS?
Definitely not.
Try it manually in two parts:
select adminID from admin WHERE username='lhanford';
remember that id, then:
select * from workorders where adminID='admin_id_from_last_result';
Any results?
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
