Output multiple rows.

STXman

Hiya Im still new to PHP so please pardon me for my lack of knowledge. Can someone tell me how to output multiple rows of data from the code below. At the moment I can only output a single row of data from the table. If I repeat the echo statements as below, I simply receive a repeat of the same row of data. I believe I may need an array of some type, however, I don’t know 1) How to use one here. 2) Whether or not it will be the most efficient way to output multiple rows from my query. Thanx in advance.

<?php
$mysql_access = mysql_connect("localhost","root","");
mysql_select_db("test", $mysql_access);
$gender = $REQUEST['gender'];
$country = $REQUEST['country'];

$query_Recordset1 = "SELECT * FROM USERDETAILS where gender = '$gender' AND country = '$country'";
$Recordset1 = mysql_query($query_Recordset1, $mysql_access) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$picture_path = $row_Recordset1['PICTURE_PATH'];

?>
<?php echo "<img src=$picture_path>";?>
<br>Firstname: <?php echo $row_Recordset1['FIRSTNAME']; ?>
<br>Lastname: <?php echo $row_Recordset1['LASTNAME']; ?>
<br>Country:<?php echo $row_Recordset1['COUNTRY']; ?>
<br>gender:<?php echo $row_Recordset1['GENDER']; ?>
<?php echo $row_Recordset1['ID']; ?>

weevil

You need to loop through the results to print them out

<?php 
$mysql_access = mysql_connect("localhost","root",""); 
mysql_select_db("test", $mysql_access); 
$gender = $_REQUEST['gender']; 
$country = $_REQUEST['country']; 
$query_Recordset1 = "SELECT * FROM USERDETAILS where gender = '$gender' AND country = '$country'"; 
$Recordset1 = mysql_query($query_Recordset1, $mysql_access) or die(mysql_error()); 

while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)) {
  $picture_path = $row_Recordset1['PICTURE_PATH']; 
  echo "<img src=$picture_path>";
  echo "<br>Firstname: $row_Recordset1['FIRSTNAME']";
  echo "<br>Lastname: $row_Recordset1['LASTNAME']";
  echo "<br>Country:$row_Recordset1['COUNTRY']";
  echo "<br>gender:$row_Recordset1['GENDER']";
  echo "$row_Recordset1['ID']";
}
?>

STXman

Thanx for the responce. However, I receive the following error after the changes. What can do to fix it?

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in c:\Apache\htdocs\mlresultspage3.php on line 12

czambran

Try it like this🙁It's exactly the same code that was given by somebody but I fixed some syntax error.)

<?php  

$mysql_access = mysql_connect("localhost","root","");  

mysql_select_db("test", $mysql_access);  

$gender = $_REQUEST['gender'];  

$country = $_REQUEST['country'];  

$query_Recordset1 = "SELECT * FROM USERDETAILS where gender = '$gender' AND country = '$country'";  

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

while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)) { 
  $picture_path = $row_Recordset1['PICTURE_PATH'];  

  echo "<img src=$picture_path>"; 
  echo "<br>Firstname: {$row_Recordset1['FIRSTNAME']}"; 
  echo "<br>Lastname: {$row_Recordset1['LASTNAME']}"; 
  echo "<br>Country:{$row_Recordset1['COUNTRY']}"; 
  echo "<br>gender:{$row_Recordset1['GENDER']}"; 
  echo "{$row_Recordset1['ID']}"; 
} 
?>

STXman

Thanx it worked. One more thing: If I wanted to put the results in a php-generated table with two rows and two columns (4cells) how do I alter this query?

czambran

I am sorry but I do not understand your question. Could u give me an example?

weevil

I think STX means something like this:
(not sure what you want to do with the images and ids if you only had 2 rows so here is 4)

echo "<table>";
while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)) {  

  $picture_path = $row_Recordset1['PICTURE_PATH'];   

  echo "<tr><td colspan=2><img src=$picture_path></td></tr>";  

  echo "<tr><td>Firstname: {$row_Recordset1['FIRSTNAME']}</td>";  

  echo "<td>Lastname: {$row_Recordset1['LASTNAME']}</td></tr>";  

  echo "<tr><td>Country:{$row_Recordset1['COUNTRY']}</td>";  

  echo "<td>gender:{$row_Recordset1['GENDER']}</td></tr>";  

  echo "<tr><td colspan=2>{$row_Recordset1['ID']}</td></tr>";  

}  

echo "</table>";