Hello i have made a query using dreamwever wizard(iam a novice) and when i upload my script it returns one of the users which is the first in the list and not the rest which i want to be able to display. The query is below which i put in a php file

<?php require_once('Connections/webmail.php');

mysql_select_db($database_webmail, $webmail);
$query_Recordset1 = "SELECT `username` , `password` FROM `hive_user` ORDER BY `username` ASC LIMIT 0 , 30";
$Recordset1 = mysql_query($query_Recordset1, $webmail) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

can anyone help me so that is returns all the users in a list rather than just one
Thankyou

You need to create a loop and fetch a new row on each iteration

PHP Code:


require_once('Connections/webmail.php');

mysql_select_db($database_webmail, $webmail);
$query_Recordset1 = "SELECT `username` , `password` FROM `hive_user` ORDER BY `username` ASC LIMIT 0 , 30";

$Recordset1 = mysql_query($query_Recordset1, $webmail) or die(mysql_error());

$totalRows_Recordset1 = mysql_num_rows($Recordset1);

// begin loop
while ( $row_Recordset1 = mysql_fetch_assoc($Recordset1) ) { 
    echo $row_Recordset1['username']. "<br />"
} 


Hi thanks for the extra code it worked but only

// begin loop
while ( $row_Recordset1 = mysql_fetch_assoc($Recordset1) )
echo $row_Recordset1['username']. "<br />"

with the end brackets which i took off sot hat brings up all users how do i bring up all the passwords next to them as well as users this is now the code with the added bit

<?php require_once('Connections/webmail.php');

mysql_select_db($database_webmail, $webmail);
$query_Recordset1 = "SELECT `username` , `password` FROM `hive_user` ORDER BY `username` ASC LIMIT 0 , 30";
$Recordset1 = mysql_query($query_Recordset1, $webmail) or die(mysql_error());
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

// begin loop
while ( $row_Recordset1 = mysql_fetch_assoc($Recordset1) )
echo $row_Recordset1['username']. "<br />"


?>
thankyou

To show the password, just concatnate the two columns in the output

PHP Code:

while ( $row_Recordset1 = mysql_fetch_assoc($Recordset1) )
    echo $row_Recordset1['username']. " -- " . $row_Recordset1['password']. "<br />" 


Thankyou
that fixed the problem