Echo-ing data from table

[focus310]

Hello:

I have a table which looks like this:
ID | client_id | event_date | event_type
1 | 4 | 08/01/2007 | SV
2 | 4 | 09/01/2007 | AD

All I need to do is display this information in an HTML format. Thus far, all I get is the last entry for that client.

How can I print both entries into a report?

Thanks for the help.

[roscor]

Heres a basic idea of what to do, untested, hope it helps

Put all the code together on the one page in the order set out here!

<?PHP 

mysql_connect($host,$username,$password);
mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM your_table";
$result = mysql_query($query) or die ("Could not run query.");
$result=mysql_query($query);
$num=mysql_num_rows($result);
if ($num==0) {
$empty = "No Matching";
}
 else {
$num_rows = mysql_num_rows($result);

//echo "$num_rows Record Found ";
}

mysql_close();

 ?>  

 

<table width="800" border="0" cellspacing="0" cellpadding="0" align="centre">
<tr>
	<td width="16%" align="center"><font face="Verdana" size="2" color="#000000">ID</font></td>
	<td width="16%" align="center"><font face="Verdana" size="2" color="#000000">Client Id</font></td>
	<td width="16%" align="center"><font face="Verdana" size="2" color="#000000">Event date</font></td>		
   <td width="16%" align="center"><font face="Verdana" size="2" color="#000000">Event Type</font></td>
	</tr>
</tr>
</table>



<table border="0" width="800" height="50"  bordercolor="#111111">


<tr>

  <td style="border-style:solid; border-width:1px; border-color:#000000;" width="100%" height="20" valign="top"  bgcolor="#FFFFFF" bordercolor="#111111">


<div class="scrollable" style="height:100px; width:100%; overflow:auto;">

<table cellSpacing="0" cellPadding="1" border="0" id="" class="itemTable" width="100%" height="20">
<td  align="center"><font face="Verdana" size="2" color="#000000"></td>
<td  align="center"><font face="Verdana" size="2" color="#000000"></td>
<td  align="center"><font face="Verdana" size="2" color="#000000"></td>
<td  align="center"><font face="Verdana" size="2" color="#000000"></td>
</tr>

  <?PHP
$i=0;

while ($row = mysql_fetch_array($result)) {
//if ($foo % 2 )
if($i % 2)
{
$bg_color = '#FFFFFF';
}
else
{
$bg_color = '#EEEEEE';
}

$id = $row["id"];
$client_id = $row["client_id"];
$event_date = $row["event_date"];
$event_type = $row["event_type"];

?>

<td><? echo "<td width='150' align='center' bgcolor=$bg_color><font face='Verdana' size='2' color='#000000'>$id"; ?></td>
  <td><? echo "<td width='150' bgcolor=$bg_color align='center'><font face='Verdana' size='2' color='#000000'>$client_id</td>"; ?></td>
  <td><? echo "<td width='150' bgcolor=$bg_color align='center'><font face='Verdana' size='2' color='#000000'>$event_date</td>"; ?></td>
<td><? echo "<td width='150' align='center' bgcolor=$bg_color><font face='Verdana' size='2' color='#000000'>$event_type"; ?></td>

[focus310]

Hi,

This is the code I wrote.

The first bit of code selects the client from a drop down box.

<?php
include('header_admin.html');
require_once('mysql_connect.php');

?>  

<fieldset><legend>Please select a client</legend>
<form action="testing.php" method="post">        

<p><label for="client_id">Client Name:</label>
  <select name="client_id">
   <option value="">- Please Select -</option>
	<?php
          $query="SELECT * FROM client";
	  $result = @mysql_query ($query) or die (mysql_error());

         while($row=@mysql_fetch_array($result, MYSQL_ASSOC))
           {

             $client_id = $row['client_id'];
             $client_name = $row['client_name'];



                 print '<option value="' . $client_id . "\"  >" . $client_name . "</option>\n";
	}
?>
  </select>
</p>

  <p><label for="blank">&nbsp;</label><input type="submit" name="btnSubmit" id="btnSubmit" value="Submit" class="btn" /></p>
<input type="hidden" name="submitted" value="TRUE" />
</fieldset>
</form>

This bit should display the results for that client.

<?php 

require_once ('mysql_connect.php');

$query="SELECT client_name
        FROM client 
        WHERE client_id = $_POST[client_id]";

$result = @mysql_query ($query) or die (mysql_error()); 

if ($result) {

while($row=@mysql_fetch_array($result, MYSQL_ASSOC))
{

             $client_name = $row['client_name'];
}
}


$query9="SELECT * FROM progress_note WHERE client_id = $_POST[client_id]";

$result9 = @mysql_query ($query9) or die (mysql_error()); 

if ($result9) {

while($row9=@mysql_fetch_array($result9, MYSQL_ASSOC))
{

             $progress_note_id = $row9['progress_note_id'];
             $client_id = $row9['client_id'];
             $event_date = $row9['event_date'];
             $event_type = $row9['event_type'];
             $event_entry = $row9['event_entry'];
             $loc = $row9['loc'];

}
}


?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title></title>
<link href="output_style.css" rel="stylesheet" type="text/css">

</head>
<body>
<div id="container">
</div>
<div id="content">

<table class="apptable">
<tr>
<td class="j"><b>Client's Name:</b></td><td class="j"><?php echo $client_name; ?></td>
<td class="j"><b>LOC:</b></td><td class="j"><?php echo $loc; ?></td></tr>
</table>

<tr><td>&nbsp;</td></tr>
<table class="apptable">
<tr><th>Date</th><th scope="col">Type of Event</th><th scope="col">Entry</th></tr>
<tr><td class="d"><?php echo $event_date; ?></td><td class="d"><?php echo $event_type; ?></td><td class="d"><?php echo $event_entry; ?></td></tr>
</table>

I don't understand why I'm receiving one record for the client not all.

Thanks for the help.

[roscor]

I dont think that you are creating an array with the results, use progress_note_id[] and so on,

good luck

$query9="SELECT * FROM progress_note WHERE client_id = $_POST[client_id]";

$result9 = @mysql_query ($query9) or die (mysql_error()); 

if ($result9) {

while($row9=@mysql_fetch_array($result9, MYSQL_ASSOC))
{

             $progress_note_id = $row9['progress_note_id'];
             $client_id = $row9['client_id'];
             $event_date = $row9['event_date'];
             $event_type = $row9['event_type'];
             $event_entry = $row9['event_entry'];
             $loc = $row9['loc'];

}
}
?>

<form action="????.php" method="post">
<font face="Verdana" size="2" color="#000000">
<th><input type="checkbox" name="progress_note_id[]" value="<?php echo $progress_note_id;?>" MULTIPLE> <? echo "<td bgcolor=$color align='center' size='100'><font face='Verdana' size='2' color='#000000'>$progress_note_id</td>"; ?>

<input type="hidden" name="client_id[]" value="<?php echo $client_id; ?>"><? echo "<td bgcolor=$color align='center' size='200'><font face='Verdana' size='2' color='#000000'>$client_id</td>"; ?>
<input type="hidden" name="event_date[]" value="<?php echo $event_date;?>"><? echo "<td bgcolor=$color align='center' size='200'><font face='Verdana' size='2' color='#000000'>$event_date</td>"; ?>


</tr>

<?
$i++;
}
}

echo "</table>";


?>
&nbsp;<input type="checkbox" name="checkall" onclick="checkUncheckAll(this);"/>select/unselect<br /><input type="submit" value ="send"></form>