Hi ya!
I'm building a drop down menu to select "cats" categories
it's working except that the "cats" that have / contain multi words are printing out like this -
<select name="site_search">
<option value="Pen" case="">Pen Case</option>
<option value="news">news</option>
<option value="List" of="" names="">List of names</option>
<option value="Library">Library</option>
</select>
This is the mysql and php that I'm using to create the above
$result = mysqli_query($conn,"select distinct cats from URLS order by cats desc");
$total = mysqli_num_rows($result);
while ($myrow = mysqli_fetch_array($result))
{
echo "<option value=".$myrow["cats"].">".$myrow["cats"]."</option>";
}
echo "</select>";
Server Version
mysql Ver 15.1 Distrib 10.3.34-MariaDB, for debian-linux-gnueabihf (armv8l) using readline 5.2
Any thoughts with regard the above?
TIA
Steve