help with this :|

[corillo181]

i asked for help before but i still got nothing..

this is inside a loop..

nd it suposed to count how many is inside of what ever the id is

[code]

$myquery=mysql_query("select count(*) from comment WHERE p_id='".$onep['p_id']."'")or die(mysql_error());
while($times=mysql_fetch_array($myquery)){
$rows=mysql_num_rows($times);
echo $rows;
}


[/code]

i think the code is self explanatory.. i'm trying to count how many things are in side the table with the same id as the variable id..

[poirot]

Well, if the query is not wrong, you can simply use this:

[code]$myquery = mysql_query("SELECT COUNT(...");
$rows = mysql_result($myquery, 0);[/code]

[wisewood]

<?php
$query = "SELECT * FROM comment WHERE p_id = '$your_variable'";
$result = mysql_query($query);

$num_rows = mysql_num_rows($query);

echo $num_rows;
?>

[corillo181]

thanx wise and thanx p for your assistance..