Making a Variable from different tables with Matching Db fields?
| From: | Terion Miller | Date: | Wed, 28 Jan 2009 20:18:10 +0000 |
| Subject: | Making a Variable from different tables with Matching Db fields? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-287300@lists.php.net to get a copy of this message | ||
Not sure if I'm wording this right, what I am trying to do is look in two
tables, match the ID to use to pull information....
Here's my code but it's not right, although it is picking up the user from
the session, I will also post what my variable debugging lists:
$query = "SELECT admin.AdminID, workorders.AdminID FROM admin,
workorders WHERE admin.UserName = '".$_SESSION['user']."' ";
$result = mysql_query ($query);
$row = mysql_fetch_assoc ($result);
echo $row['AdminID'];
if ($row['ViewMyOrders'] == "NO") {
header ("Location: Welcome.php?AdminID=$AdminID&msg=Sorry, you do
not have access to that page.");
}
*Also tried this to pull just this persons orders:*
$sql = "SELECT workorders.WorkOrderID , workorders.AdminID,
admin.AdminID FROM workorders, admin WHERE workorders.AdminID =
admin.AdminID ";
$result = mysql_query ($sql);
Thanks for looking, t.