In message <[EMAIL PROTECTED]>, John R. Sims,
Jr. <[EMAIL PROTECTED]> writes
>HI All,
>
>I have this script. (See below) it was designed to allow my case managers to
>look at a list of the case noted they have generated on a specific client.
>
>It allows the case manager to select the client and then it shows them the
>case note. Only problem is that it only shows them one case note, and most
>of the clients will have several case notes that have been entered over the
>period of the program.
>
>Can anyone offer any suggestions.
You only ask for one record...
> if ($result && mysql_num_rows($result)>0)
> {
> $row = mysql_fetch_array($result);
while( $row = mysql_fetch_array($result) {
>
> }
>?>
><font face="Verdana">
to here...
></table>
><?php
>include_once ('include/footer.html');
>?>
></body>
>
></html>
But you will have to move your <TABLE> start up, so that it is outside
the loop.
--
Pete Clark
http://www.hotcosta.com
http://www.spanishholidaybookings.com
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
