[RESOLVED] mysql_num_rows in 'while' loop

[knucklehead]

hello! i have a little problem with counting rows from one table while there's another query already in 'while loop'...

so, the general thing is to:

select all from 'galerie' table
display results and show how many rows are in the second ('galerie_fill') table for the specific result
loop until first table ends...

in table 'galerie' every 'name' has its own unique id and in table 'galerie_fill' ids are not unique but they correspond to that 'name' in the first table...

my code for now is:

$selekt = mysql_query("SELECT * FROM galerie") or die(mysql_error());

while ($row=mysql_fetch_array($selekt)) {

$counting = mysql_num_rows("SELECT * FROM galerie_fill WHERE id = " . $row['id'] . "") or die(mysql_error());

echo "name: " . $row['name'] . "<br>" . $counting . " results";
}

for now i know that the error is in '$counting = ...' line but i don't get any error report at all so i'm not sure what am i doing wrong....
thanks in advance!

[ClarkF1]

You need a query to get the mysql_num_rows from.........

$counting = mysql_num_rows(mysql_query("SELECT * FROM galerie_fill WHERE id = " . $row['id'] . "")) or die(mysql_error());

[laserlight]

I am a little rusty on this, so pardon me if my SQL query is incorrect:

$query = "SELECT galerie.name AS galerie_name, COUNT(galerie_fill.id) AS galerie_count
    FROM galerie, galerie_fill
    WHERE galerie.id=galerie_fill.id
    GROUP BY galerie_fill.id";
$result = mysql_query($query)
    OR die(mysql_error());
while ($row = mysql_fetch_assoc($result)) {
    echo "name: " . $row['galerie_name'] . "<br>" . $row['galerie_count'] . " results";
}

[plapeyre]

to save time cant you just make:

 $query = "SELECT galerie.name AS galerie_name, COUNT(galerie_fill.id) AS galerie_count
    FROM galerie, galerie_fill
    WHERE galerie.id=galerie_fill.id
    GROUP BY galerie_fill.id";
$result = mysql_query($query)

into:

 $result = mysql_query("SELECT galerie.name AS galerie_name, COUNT(galerie_fill.id) AS galerie_count
    FROM galerie, galerie_fill
    WHERE galerie.id=galerie_fill.id
    GROUP BY galerie_fill.id");

[ClarkF1]

You can but if you have a problem with the query it's hard to see what's going on.

Storing the query in a variable first means you can just use echo $query; to see what query is actually being sent to the database. This is especially useful if you are using variables in the query

[knucklehead]

THIS ONE WORKS.... THANKS A LOT AND SORRY FOR DELAYS IN REPLYING 🙂

plapeyre wrote:

to save time cant you just make:

 $query = "SELECT galerie.name AS galerie_name, COUNT(galerie_fill.id) AS galerie_count
    FROM galerie, galerie_fill
    WHERE galerie.id=galerie_fill.id
    GROUP BY galerie_fill.id";
$result = mysql_query($query)

into:

 $result = mysql_query("SELECT galerie.name AS galerie_name, COUNT(galerie_fill.id) AS galerie_count
    FROM galerie, galerie_fill
    WHERE galerie.id=galerie_fill.id
    GROUP BY galerie_fill.id");