Re: Whats the correct syntax for using query results in a new query

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 > > Thanks > Terion > > Happy Freecycling > Free the List !! > www.freecycle.org > Over Moderation of Freecycle List Prevents Post Timeliness. > ------------------------------------------------ > Twitter? > http://twitter.com/terionmiller > ------------------------------------------------ > Facebook: > <a > href="http://www.facebook.com/people/Terion-Miller/1542024891" > title="Terion Miller's Facebook profile" target=_TOP><img src=" > > http://badge.facebook.com/badge/1542024891.237.919247960.png" > border=0 > alt="Terion Miller's Facebook profile"></a> > Joe DiMaggio - "Pair up in threes." > $query = "SELECT UserName, AdminID FROM admin WHERE Retail1 = 'YES' "; When you run this in phpMyAdmin, what is returned? Ash www.ashleysheridan.co.uk