Query using array results in WHILE loop

[Anon]

Hi everyone. I am trying to use a result from an array in a while loop, and it is not working the way I want it too. When I include the variable in the query, it doesn't work at all - it outputs a parse error. I can echo the result so I know it exists, but I can't get the result to work in the query. Any suggestions?

What I have:

$result = mysql_query("SELECT DISTINCT state FROM areas ORDER BY state",$db_states);

$gstates=0;
$gcities=0;

while ($states = mysql_fetch_array($result)) {

$gstates++;

print "group[$gstates][0]=new Option(\"Choose...\",\"/sellers_new.shtml#choose\")\n";

	mysql_select_db("fsbozone_com",$db_cities);

	$result2 = mysql_query("SELECT city, city_initials, state_initials FROM areas WHERE state='$states['state']' ORDER BY city",$db_cities);

[Anon]

The '' are probably confusing the parser. Assign it to a temp variable before the query and use the temp variabel in the query.

[[deleted]]

I've said it before and I'll say it again;
keep your vars outside of quotes.

this fails:
"SELECT city, city_initials, state_initials FROM areas WHERE state='$states['state']' ORDER BY city"

this works

"SELECT city, city_initials, state_initials FROM areas WHERE state='".$states['state']."' ORDER BY city"

[Anon]

Vincent, I can't tell you how thankful I am to you!! It worked perfectly, and you gave me the bulldozer to knock down that brick wall.

Thanks - have a great day!

[[deleted]]

Autographs after the show, send your postcards, money-orders and tall slender brunettes to [e-mail]

[Anon]

Hi,

I use this query to give me a list of Agents:

$result = mysql_query("SELECT DISTINCT Agent FROM $today ORDER BY Agent")

and this to display the results:

$number = mysql_numrows($result);

               if ($number == 0) {
                 ;
                 } else
               {
                 $i = 0;
                 while ($i < mysql_num_rows($result))
                 {
                 //Display results of agent search
                 $Agent[$i] = mysql_result($result, $i, "Agent");
                 echo $Agent[$i] . "<BR>";
                 $i++;
                 }
               }

It all works fine.
Now I want to include the reuslts of the above query in a new query.

I want the new query to count then display the number of 'M' values in the field 'Type' for all the Agents. ie. If Agent Dave has 3 rows with M in the type to return 3, and if Agent Jake has two rows with M in the type to return 2.

Now I'm only a beginner at PHP so I knew that my attempt would not work.

$resultm = mysql_query("SELECT COUNT (*) AS Type FROM $today WHERE AGENT='".$Agent['$i']."' AND Type=M ORDER BY Agent");

I would like to display the results below eachother using line breaks.

Please can someone help?

Thanks,

Dave.