Can someone tell me whats wrong with this?

sonfohud

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT username, COUNT (*) AS rowcount FROM phpbb_user_group, phpbb_users WHERE (phpbb_user_group.group_id= '4') AND (phpbb_user_group.user_id= phpbb_users.user_id)";
$result=mysql_query($query);

mysql_close();

$row['rowcount'];

Trying to count the number of usernames.......I'm not really sure how to do the echo command or print command to get it to show if the query is indeed right.

kevinsequeira

to debug ....
.
.
.
$result=mysql_query($query);

if(mysql_error()){
echo $query."<BR>";

echo mysql_error();
}
mysql_close();
.
.
.

and the whole code to get total users

<?php
mysql_connect(localhost,$username,$password);
mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * AS rowcount FROM phpbb_user_group, phpbb_users WHERE (phpbb_user_group.group_id= '4') AND (phpbb_user_group.user_id= phpbb_users.user_id)";
$result=mysql_query($query);
if(mysql_error()){
	echo mysql_error();
}
$count = mysql_num_rows($result)
echo $count;

mysql_close();
?>

reg
kevin

WizyWyg

Originally posted by sonfohud
Trying to count the number of usernames.......I'm not really sure how to do the echo command or print command to get it to show if the query is indeed right.

first off, never supress your "error" messages, because 90% of the time, that's where you will find your answers. im not too sure how phpbb sets up its tables ( sorry, i never liked that board) but a simple structure to count:

mysql_connect(localhost,$username,$password); 
mysql_select_db($database) or die( "Unable to select database"); 
$query = "SELECT * FROM table WHERE foo=4";
$result = mysql_query($query) or die(mysql_error().$query);
$num_rows = mysql_num_rows($result);

echo "$num_rows";

crain

first i am a chinese ~~my english is too bad~forgive me please!

you can do it like this ~~`

after you send a query to mysql,you will fetch the result !

$row=mysql_fetch_array($result);

you can use:

echo $row[rowcount];

sonfohud

k great...got it! thanks a bunch