[robertpro2a]

Thank you both.

Dismounted: quick question. I'm not trying to trick you into writing the code for me, but I need a bit of help, please.

My query is fine, but if you'd like to see it here it is:

PHP Code:

//query
$query = "SELECT * From `gun_ranges` where `state` = '$state' "; 


I need to retrieve 5 columns of data from that. So, using your code, would I do this?

PHP Code:

 $array = array();
$data = $vbulletin->db->query_read(    $query );

while ($row = $vbulletin->db->fetch_array($data))
{
 
    $array[$row['website']] = $row; //gun range's website
 
    $array[$row['phone']] = $row; //gun range's phone number

   //etc....
} 


Is this correct? And if so, could you please point me in the direction on how I would retrieve this information via the template HTML?

Thank you.