View Single Post
  #2 (permalink)  
Old 01-05-2005, 05:28 AM
eagle00789 eagle00789 is offline
Junior Member
 
Join Date: Dec 2004
Posts: 20
This is the solution. if it seems to be incorrect, please say so
Code:
   if (1 > sql_num_rows($resultpersons, $dbi)) {
      echo "Geen items gevonden";
   } else {
      for ($m=0; $m < sql_num_rows($resultpersons, $dbi); $m++) { 
         list($id, $datum, $tijd, $klantid, $description, $addby) = sql_fetch_row($resultpersons, $dbi);
         $resultname = sql_query("SELECT Naam, Voornaam FROM ".$prefix."_probs_klant WHERE id='$klantid'", $dbi);
         list($lastname, $firstname) = sql_fetch_row($resultname, $dbi);
      }
   }
Reply With Quote