An Array of result1,2,3,4...etc

[Anon]

I have something like:

$result1 = mysql_query("SELECT FROM table WHERE ref LIKE '1'", $db);
$result2 = mysql_query("SELECT FROM table WHERE ref LIKE '2'", $db);

$result3 = mysql_query("SELECT * FROM table WHERE ref LIKE '3'", $db);

and I need it to work something like below:

for ($n=1;$n<4;$n++) {

$results = $result.$n;
$rownumbers = mysql_numrows($results);

echo"number: $n , rows: $rownumbers\n";

}

it should look something like:
number: 1, row: 0
number: 2, row: 3
number: 3, row: 5

but instead, it gave an error on the $rownumbers = mysql_numrows($results); line

and results

number: 1, row:
number: 2, row: 0

number: 3, row: 3

COuld someone correct this? THanks!@

[Anon]

Where does the $result var in $result.$n come from? :=)

[Anon]

I'm sorry, but what do you mean?

I don't know much about php (self learning from websites)

and how I understand $result.$n is that it combines the result and n together, hence making the result1, result2...etc

[Anon]

every thing seemes working

there is no error i think

check if ur database has that rows

if there r no rows then mysql_num_rows ($result1) would return error

mandar

[Anon]

There are some results that returns no rows.. that's what I was trying to do, I used numrow to see if it returns 0, and if it does, there's an echo saying that there're no rows...

If this returns error in php/mysql, is there another approach to this?