Someone with some Talent please help.

[todayme]

See below between //------------ I have written an explination, I have tried and tried to do this can someone please help.

 

 

?>
<select name="Location">

<?php

  $query=mysql_query("SELECT $dbState FROM $locationtype");
  while ($fetch=mysql_fetch_assoc($query)) {

//-----------------------------------------------------------------

Select from table where Industry = $dbIndustry and Location1 = $dbState

If one or more records exists


put the value of the first query into the drop down box if not dont do it






//-----------------------------------------------------------------





   echo '<option value="'.$fetch[$dbState].'">'.$fetch[$dbState].'</option>';
  }
mysql_close($db);?></select>

[todayme]

Also the the query in the //------------ is to a different table to the first one outside the //--------

[monk.e.boy]

$sql=mysql_query("SELECT $dbState FROM $locationtype");
if ($row=mysql_fetch_assoc($sql))
{
  echo 'one value found : '. $row[0];
}
else
{
  echo 'None found.';
}

 

This is a neat little trick to grab the top row.

 

monk.e.boy