2 questions, 1 about a drop-down menu problem, 2 about a query.

Ganon

Hi,

Q1. How would you go about retrieving a data from a mysql table and put it into a drop-down menu, but as something else. e.g. if record in db was '1', i'd like to be able to display 'Yes'. and if value was '0', i'd liike it to display 'No'.

Secondly, I am creating an image gallery for my website, however I need to know the qyery will look like, if I wanted it to display all the images from a specific category.

So basically, there are 2 tables, db_categories and db_images.
db categories contains all the categories and their id's. In db_images, there are fielsa for the iomage itself, id and finally in which category it is(cat_ID). So how would the query look like if I wanted it to fetch it by a specific category.

Make any sense?

Thanks!😉

devinemke

Originally posted by Ganon
Q1. How would you go about retrieving a data from a mysql table and put it into a drop-down menu, but as something else. e.g. if record in db was '1', i'd like to be able to display 'Yes'. and if value was '0', i'd liike it to display 'No'.

$result = mysql_query("SELECT boolean FROM table");

echo '<select name="booleans">';
while ($row = mysql_fetch_assoc($result))
{
	if ($row['boolean'] == 1) {$boolean = 'YES';}
	if ($row['boolean'] == 0) {$boolean = 'NO';}

echo '<option>' . $boolean;
}
echo '</select>';

Originally posted by Ganon
Secondly, I am creating an image gallery for my website, however I need to know the qyery will look like, if I wanted it to display all the images from a specific category.

SELECT * FROM db_images WHERE cat_ID = 123

Ganon

Thanks very much!

However, I have another question, how would I display all the categories name in a drop-down menu? So if I add another category into the database, it will automatically be displayed in the drop-down menu.

Thanks!

devinemke

Originally posted by Ganon
how would I display all the categories name in a drop-down menu?

$result = mysql_query('SELECT * FROM db_categories');

echo '<select name="categories">';
while ($row = mysql_fetch_assoc($result))
{
	echo '<option value="' . $row['cat_id'] . '">' . $row['cat_name'];
}
echo '</select>';