Want to display how many users are in my chat :(

YogaSukha

Does anybody know what's wrong ? Your help is appreciated 🙂

This is the error that I get:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/*****/public_html/cvtchat/HowManyUsersde.php3 on line 9
There are currently users in phpMyChat

This is the php3 file:

<?
$mysql = mysql_connect ("localhost","yogajan_pchat2"
,"Your Password");
$dbase = mysql_select_db("yogajan_pchat2");
$query = "SELECT DISTINCT u.username "
. "FROM C_USERS u, C_MESSAGES m WHERE "
. "u.room = m.room AND m.type = 1";
$result = mysql_query($query);
$num_of_rows = mysql_num_rows($result);
mysql_close($mysql);
echo ("There are currently $num_of_rows users in phpMyChat");
?>

I give up with this. Thanks in advance for your help 🙂

YogaSukha

kevinsequeira

.
.
.
$query = "SELECT DISTINCT u.username FROM C_USERS u, C_MESSAGES m WHERE u.room = m.room AND m.type = 1"; 
echo $query; 
$result = mysql_query($query) or die(mysql_error()); 
.
.
.

see if your query is properly formed.
then try running it in the database directly

reg
kevin

YogaSukha

Hi Kevin, the tables were in big letters and needed to be in small letters 🙂

That is fixed, now I have another problem, I can't get the numbers of users to show up in my .htm file 🙁

I use this:

<?php3 include("http://www.domain.name/cvtchat/HowManyUsersde.php3"); ?>

but it shows nothing 🙁

And I have this in my meta tags:

Again, I have no idea 🙁

Best,
YogaSukha

Rex__

Do you get a result when you run the query directly on the database? if so, then i am guessing it's an html problem. make sure that the echo takes place in the body. you can perform the query anywhere on the page, but if the echo is in the <head> tag then it won't be displayed. try putting tis in the body:

<? echo ("There are currently $num_of_rows users in phpMyChat");
?>

YogaSukha

That way it is not known where to pull the $num_of_rows users from 🙁

Yours,
Jan

YogaSukha

I just got this info:

is your web server configured to pre-process .htm files for php script?
if it doesn't appear to be processing the script, that may be what it is and just discarding the php tags as irrelevant>>>

I sent a message to my host, hopefully that solves the problem.

Yoga