Re: Making a Variable from different tables with Matching Dbfields?

From: Date: Thu, 29 Jan 2009 01:31:36 +0000
Subject: Re: Making a Variable from different tables with Matching Dbfields?
References: 1 2 3 4 5 6 7 8 9 10 11 12  Groups: php.general 
Request: Send a blank email to php-general+get-287348@lists.php.net to get a copy of this message
The main problem is that you've never explained what you want to get from the query. The replies have used your code as an example and I'm pretty sure that's not what you want. Unless I totally mis-understand what you want, you have 2 options: 1. Use the 2 queries that I gave you in a previous post. 2. Use a subquery: $sql = "SELECT * FROM workorders WHERE AdminID = (SELECT AdminID FROM admin WHERE UserName = '" . mysql_real_escape_string($_SESSION['user']) . "')";
3 - fix the join ;) -- Postgresql & php tutorials http://www.designmagick.com/

« previous php.general (#287348) next »