help on while loop

[osusano]

hi there i have a code something like this and i dont know what to do anymore

// fieldname from the table
$usersFields = " userId, username, password, firstName, lastName, level;
$string = ereg_replace(' ', '$', $usersFields);
while ( list ( $string ) = mysql_fetch_row($res) ){
}

here is goes.. if im going to echo the $string value it will going to displays liek this

$userId,$username,$password,$firstName,$lastName,$level,$dateAdded

that what i need to put on my while statement but since i did put the $string value inside the while it doesnt display the values of each variable.

what do u think is the problem here?

[osusano]

by the way i saw an error on my post

// fieldname from the table 
$usersFields = " userId, username, password, firstName, lastName, level"; 
$string = ereg_replace(' ', '$', $usersFields); 
while ( list ( $string ) = mysql_fetch_row($res) ){ 
}

[seby]

where is the mysql_query function???

$usersFields = mysql_query("SELECT userId,username,password,firstName,lastName,level FROM your_table");  

while(list($userID,$username,$password,$firstName,$lastName,$level) = mysql_fetch_row($usersFields) ){  

// output here ..
}

now you may use those variables, in the list()