ive just got a simple problem with a select statement
<?php
$db = mysql_connect("localhost", "root");
mysql_select_db("Health",$db);
$result = mysql_query("SELECT MainAccr FROM practitioners
WHERE Practitioner_ID='$prac_id'",$db);
if ($myrow = mysql_fetch_array($result)) {
with the last line, is there a way so that if one record is returned, it does something, and if more than one record is returned, it does something else. thats the only conditions i want. if one record is returned, it goes straignt to a roster, and if more than one is returned, it gives a list first so they can choose which one they want to change.
