getting all rows

tito

hello, How can I finish the below so I could retrieve all users instead of just the first one?
<?php
require ("config.php");
mysql_connect($host,$user,$pass);
@mysql_select_db($database) or die( "Unable to select database");
$result = mysql_query('SELECT username FROM sessions WHERE status="1"') or die(mysql_error());
$row = mysql_fetch_array($result);
$username = $row['username'];
mysql_free_result($result);
echo "$username";
?>

and display them like:

user1, user2, user3, user4

if possible without the comma at the end.

Thank you.

sidney

 <?php 
require ("config.php"); 
mysql_connect($host,$user,$pass); 
@mysql_select_db($database) or die( "Unable to select database"); 
$result = mysql_query('SELECT username FROM `sessions` WHERE status="1"') or die(mysql_error()); 
while($row = mysql_fetch_array($result))
{ 
$username = $row['username']; 
echo "$username";
}
 mysql_free_result($result); 
?>

tito

you people here never cease to amaze me... the willingness and the quickness to help. Thank you.

tito

I am getting this result:
emile yuny a timecode user kan a timecode user
a timecode user are the names of non members.
how can I make it to count those, and display the count at the end, 2 timecode user(s)

sidney

 
$c=0;
while($row = mysql_fetch_array($result)) 
{  

$username = $row['username'];  

echo "$username, "; 
if($username=="a timecode user")
{
$c++;
}
} 
echo " ".$c." tiimecode users";
 mysql_free_result($result);  

?>

tito

it is telling me:
yuny, a timecode user, kan, rich, and 1 timecode user(s)
displaying timecode user twice

tito

got it , thank you... I added if($username!="a timecode user")

tito

Based on the code earlier on this post, I am trying to get the total count of members. Unfortunately, I get it repeated 1 member(s) john doe, 2 member(s) jane doe etc... how can I just echo the total members only and list them separately, like:
total members: (2) john doe, jane doe

$c=0;
while($row = mysql_fetch_array($result))

{

$username = $row['username'];
if($username!="a timecode user")
{
$d++;
}

echo "".$d." member(s): <a href=http://$username.sites.com>$username</a>, ";
if($username=="a timecode user")
{
$c++;
}
}
if ($c==0 and $username=="")
echo "store hours are: Mon-Thu 9:00 AM to Midnight, Fri-Sat 9:00 AM - 2:00 AM; Sun 10:00 AM -

10:00 PM there are no members ";

if ($c==0)
echo ("and there are no timecode users.");
if ($c>=1)
echo "and ".$c." timecode user(s).";
mysql_free_result($result);

?>

Thank you.

sidney

 <?php 
error_reporting(E_ALL);
require ("config.php");  

mysql_connect($host,$user,$pass) or die(mysql_error());    

@mysql_select_db($database) or die( "Unable to select database");  

$result = mysql_query('SELECT username FROM `sessions` WHERE status="1"'); 
$result2 = mysql_query('SELECT username as count FROM `sessions` WHERE status="1" and username<>"a timecode user"');
$d=mysql_num_rows($result2); 
$c=0;
echo"<b><font face=arial size=1>".$d." member(s): "; 
while($row = mysql_fetch_array($result)) 
	{ 
	if($username!="a timecode user") 
		{ 
		$username = $row['username'];  

		} 
	echo "<b><font face=arial size=1>".$d." member(s): <a href=http://$username.sites.com>$username</a>,</font></b> "; 
	if($username=="a timecode user") 
		{ 
		$c++; 
		} 
	} 
if ($c==0 and $username=="") 
	echo "<b><font face=arial size=1>store hours are: Mon-Thu 9:00 AM to Midnight, Fri-Sat 9:00 AM - 2:00 AM; Sun 10:00 AM - 
	10:00 PM<br> there are no members</font> </b>"; 
if ($c==0) 
	echo ("<b><font face=arial size=1>and there are no timecode users.</font></b>"); 
if ($c>=1) 
	echo "<b><font face=arial size=1>and ".$c." timecode user(s).</font></b>"; 
mysql_free_result($result); 
?>

tito

thank you! It displays, but I get an error at line 23
Notice: Undefined variable: username in /mnt/hda3/www/online.php on line 23

line 23 is
if ($c==0 and $username=="")

and it is saying:
1 user username, 2 users username2

sidney

 <?php 
error_reporting(E_ALL);
$c=0;
$username="";
require ("config.php");  

mysql_connect($host,$user,$pass) or die(mysql_error());    

@mysql_select_db($database) or die( "Unable to select database");  

$result = mysql_query('SELECT username FROM `sessions` WHERE status="1"'); 
$result2 = mysql_query('SELECT username as count FROM `sessions` WHERE status="1" and username<>"a timecode user"');
$d=mysql_num_rows($result2); 

echo"<b><font face=arial size=1>".$d." member(s):</b> "; 
while($row = mysql_fetch_array($result)) 
	{
	$username = $row['username'];
	if($username!="a timecode user") 
		{   

		echo "<b><a href=http://$username.sites.com>$username</a>,</font></b> "; 
		} 	
	if($username=="a timecode user") 
		{ 
		$c++; 
		} 
	} 
if ($c==0 and $username=="") 
	echo "<b><font face=arial size=1>store hours are: Mon-Thu 9:00 AM to Midnight, Fri-Sat 9:00 AM - 2:00 AM; Sun 10:00 AM - 
	10:00 PM<br> there are no members</font> </b>"; 
if ($c==0) 
	echo ("<b><font face=arial size=1>and there are no timecode users.</font></b>"); 
if ($c>=1) 
	echo "<b><font face=arial size=1>and ".$c." timecode user(s).</font></b>"; 
mysql_free_result($result); 
?>

tito

perfect! Thanks. I had turned off error reporting before, but it is always better to be error free like now.

sidney

cool glad your happy

you can remove error_reporting(E_ALL);
from script once the developement and testing are finished
and script is running on server