Mysql 4 Select into

[wickedinfinity]

can COUNT (*) be used in a select into statment

 

any help apprectated :-)

[Cook]

Well yes, but knowing a bit more about what exactly it is that you're trying to do would help to help you better. Anyway, try something like this:

 

$query = "SELECT COUNT(*) AS `mycount` FROM `mytable` WHERE (some condition of yours)";
$result = mysql_query($query);
$row = mysql_fetch_assoc($result);
echo $row['mycount'];