Fig. 4: The end result   all of the computer related businesses in Malahide 

$handle1=mysql_query($gp);  queries  the  database  and  assigns  the  results  in  a  two 

dimensional  associative  array  to  $handle1.  As  this  pulls  every  column  from  both  the 

clients and the categories tables, the following columns (listed here in no particular order) 

are returned: bizid, category.cid (or clients.category   same value), bizname, street1, 

street2, town, countycode, areacode, phone, web, email, picfile and pictext. 

In summary, a while loop processes each line in turn.  

  As can be seen in any screenshot of the results table, name, street1, street2, town, 

countycode, areacode and phone are directly visible on the screen.  

  The values for web and email are embedded in hyperlinks around respective  www  

and  envelope  icons.  

  If a value is set for shop, a hyperlink to  shop.php?xml=shop  is inserted around a 

 +  icon and a checkbox is placed beside it with its value set to the URL of the shop`s 

XML  database.  Each  checkbox  is  part  of  a  form  which  submission  button,  marked 

34