Member Avatar for niths

hi, iam new to php.
i am having projects table in the backend. so my query is how to get those project names in a dropdown box. please help me.
thank u.

  • 2 Contributors
  • 1 Reply
  • 29 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by cwarn23
Member Avatar for cwarn23

Like the following?

echo '<select size=1>';
$r=mysql_query('SELECT * FROM `table`');
while ($row=mysql_fetch_assoc($r)) {
echo '<option value="'.htmlentities($row['column'],ENT_QUOTES);
echo '">'.$row['column'].'</option>';
}
echo '</select>';
Edited by cwarn23 because: bug
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.