pulling a query of sql array using headers

takeanu

can anyone help me w/ a php script where i can pull a query from mysql (which has many results) and put (in a header not a link) the results into a page where i can use the infromation to update or query another statment.

if (session_is_registered("loginUsername"))
{

$query = "select w.brewers_id, h.brewers_firstname, w.wine_class, w.wine_points, count(wine_points) from wine_entries w, homebrewer h

where w.wine_points < 18 and w.wine_points >=16
and wine_class != 'u'
and wine_class !='v'
and wine_class !='t'
and h.brewers_id = w.brewers_id
group by wine_class, brewers_id;";
if (!($result = @ mysql_query ($query, $connection)))
showerror();
{
for ($rowCounter = 0;

       $row = @ mysql_fetch_array($result);

       $rowCounter++) 

	  { header("Location: try.php?brewid=" . $row["brewers_id"]  .
          "count=" . $row["count(wine_points)"] . "");}
}

this is mysql statement: if anyone can help thank you.

nemonoman

Can you restate your question? It isn't clear to me what you want us to suggest.

takeanu

sorry for the confusion. what i'm trying to do is query sql with

$query = "select w.brewers_id, h.brewers_firstname, w.wine_class, w.wine_points, count(wine_points) from wine_entries w, homebrewer h
where w.wine_points < 18 and w.wine_points >=16
and wine_class != 'u'
and wine_class !='v'
and wine_class !='t'
and h.brewers_id = w.brewers_id
group by wine_class, brewers_id";

if (!($result = @ mysql_query ($query, $connection)))
showerror();

for ($rowCounter = 0;

$row = @ mysql_fetch_array($result);

$rowCounter++)

then php gives me all the results on many different rows repeating the brewers_id.

i need to take each of the queried results and do a count() function to add up the
count(wine_points) for each of the brewers id that belongs to a certain class from a-z to another page.

So in the end i want to display one row w/ each brewers_id(not repeating the same brewers id), display all the points count(for the id) from many different classes and have a grand total on one page.

I was thinking of using headers but that won't work b/c it only gives me 1 brewers id and 1 count(wine_points) in another page.

i hope anyone can help, and don't know if this is clear or not.
another thing that might work but don't know if mysql does this, is to have a sum for the count(wine_points) associated w/ each brewers id

nemonoman

Well, to start with, you don't want COUNT(wine_points) , you want SUM(wine_points).

You write:

i need to take each of the queried results and do a count() function to add up the
count(wine_points) for each of the brewers id that belongs to a certain class from a-z to another page.

Therefore I think you want to group by brewer first, wine second:
For my own understanding I simplified your query:
SELECT w.brewers_id,
h.brewers_firstname,
w.wine_class,
w.wine_points,
SUM( wine_points )
FROM wine_entries w,
homebrewer h
WHERE w.wine_points
BETWEEN 16
AND 17
AND wine_class NOT in( 't', 'u','v' )
AND h.brewers_id = w.brewers_id
GROUP BY

brewers_id, wine_class

Next, I'll just note that this code is just wrong:
for ($rowCounter = 0;
$row = @ mysql_fetch_array($result);
$rowCounter++)

You want something like:

while($row = mysql_fetch_array($result)){
DoSomethingWithThisRow($row);
}

You write:

i want to display one row w/ each brewers_id(not repeating the same brewers id)

You can't achieve that with your SQL query; you would instead fix the returned values [Note that in your query 'h.brewers_id' is first value returned, so it will be found in array element [0] of the returned array...in other words in in $row[0]... ]

$OldBrewersId='';
while($row = mysql_fetch_array($result)){
if($row[0]<>$OldBrewersId=''){
echo $row[0]; //show the new id
$OldBrewersId=$row[0];
}

You could add code to the loop above to subtotal and grand total the wine points