SELECT variables

[Darrylw99]

I want to return the number of rows in a table, so that I can use it in another sQL statement.
Using Select Count(*) as nVacs from Vacancies
..works, but how do I get the nVacs back into another statement

DW

[Elena_Mitovska]

The easiest way to solve yuor problem is to use PHP:
$res=$db->select ("Select count(*) from mytable");
$count=$res[0][0];

and after use variable $cound in ANY queries you need, it stores amount of rows in table "mytable".

But if you need to use count() in other queries using only SQL script ,tell me exactely for which queries you need count() ( select or insert, or update).

[Darrylw99]

Hi
I've tried using the code from Elena:
$res=$db->select ("Select count(*) from mytable");
$count=$res[0][0];
But get the error message:
Fatal error: Call to a member function on a non-object in /publish.php on line 28

I inititially tried:
$rs=mysql_db_query($db,"Select Count(*) from Vacancies");
print "Result: $rs[0]\n";

But this doesn't work either.
I just need to access the value for Count(*)

Cheers
DW

[[deleted]]

Why don't you just mysq mysql_query, and then mysql_fetch_assoc or something? The manual tends to explain these elementary things quite well...