On Tue, 2009-03-03 at 15:54 -0500, Bastien Koert wrote: > On Tue, Mar 3, 2009 at 3:51 PM, Ashley Sheridan <ash@xxxxxxxxxxxxxxxxxxxx>wrote: > > > On Tue, 2009-03-03 at 14:36 -0600, Terion Miller wrote: > > > On Tue, Mar 3, 2009 at 2:20 PM, Ashley Sheridan < > > ash@xxxxxxxxxxxxxxxxxxxx>wrote: > > > > > > > On Tue, 2009-03-03 at 14:09 -0600, Terion Miller wrote: > > > > > I'm trying to use the AdminID that returns from query #1 in the WHERE > > > > > AdminID = AdminID from Query 1 > > > > > > > > > > $sql= "SELECT WorkOrderID, CreatedDate, Location, WorkOrderName, > > > > > AdminID, FormName, Status, Notes, pod FROM `workorders` WHERE AdminID > > = > > > > > '".$row['AdminID']."' "; > > > > > > > > > > that isn't working and the query 1 does return in this case 3 > > AdminID's > > > > so > > > > > I'm thinking it's just the .$row['AdminID'] part that is wrong > > > > > and I have tried some different things but am not sure the correct > > term > > > > for > > > > > what I'm trying to do so I can' t seem to google answers.... > > > > > > > > > > Here is my query #1 > > > > > > > > > > $query = "SELECT `UserName`, `AdminID` FROM admin > > > > > WHERE Retail1 = 'YES' "; > > > > > > > > > > $result = mysql_query ($query) ; > > > > > //$row = mysql_fetch_array($result); > > > > > while ($row = mysql_fetch_row($result)){ > > > > > for ($i=0; $i<mysql_num_fields($result); $i++) > > > > > echo $row[$i] . " "; > > > > > > > > > > } > > > > > Above returns 3 AdminID ... I also tried using the While statement in > > my > > > > > second query to return the sets but nothing... yet the code isn't > > > > breaking, > > > > > just returning 0 > > > > > > > > > > > > > > > > > > > > > > > $query = "SELECT `UserName`, `AdminID` FROM admin WHERE Retail1 = > > > > 'YES' "; > > > > > > > > When you run this in phpMyAdmin, what is returned? > > > > > > > > Ash > > > > www.ashleysheridan.co.uk > > > > > > > > When I run the second query the one where the WHERE syntax is wrong if > > I > > > put it like this I still get one record: > > > > > > SQL query: SELECT WorkOrderID, CreatedDate, Location, WorkOrderName, > > AdminID > > > , FormName, > > > STATUS , Notes, pod > > > FROM `workorders` > > > WHERE AdminID = '20' > > > AND '61' > > > AND '24' > > > LIMIT 0 , 30 this part keeps getting put in by phpMyAdmin > > > > > > the first query works and returns the records it should... which are 3 > > > usernames and 3 adminID > > What about joining the queries? > > > > SELECT admin.UserName, admin.AdminID, workorders.WorkOrderID, > > workorders.CreateDate, workorders.Location, workorders.WorkOrderName, > > workorders.FormName, workorders.STATUS, workorders.Notes, workorders.pod > > FROM admin LEFT JOIN workorders ON (admin.AdminID = workorders.AdminID) > > WHERE admin.Retail1 = 'yes' > > > > I know it looks like a mess, but it should do the trick > > > > > > Ash > > www.ashleysheridan.co.uk > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > incorrect syntax on your query > > try > > SQL query: SELECT WorkOrderID, CreatedDate, Location, WorkOrderName, AdminID > , FormName, > STATUS , Notes, pod > FROM `workorders` > WHERE AdminID in ( '20','61','24') > Where and what is the syntax error? Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php