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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
![http://badge.facebook.com/badge/1542024891.237.919247960.png"](http://badge.facebook.com/badge/1542024891.237.919247960.png"){kind=link}
