MySQL help

[def1]

I need to set up one database with 2 tables

heres what I go so far

CREATE TABLE bands (
uband varchar(20) NOT NULL default '',
umembers longtext NOT NULL,
ubio longtext NOT NULL,
unews longtext NOT NULL,
time varchar(50) NOT NULL default '',
id int(11) NOT NULL auto_increment,
PRIMARY KEY (id)
) TYPE=MyISAM;

CREATE TABLE mpThree (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(30) NOT NULL,
type VARCHAR(30) NOT NULL,
size INT NOT NULL,
content MEDIUMBLOB NOT NULL,
PRIMARY KEY(id)
);

For the first table I want to add more like City, State, Country, Zip Code, Genre 1, Genre 2, Genre 3 but I want them to have drop down menus and I dont know how to do that with mysql. Im really confused can someone shed some light on me how to do this. Also with the mp3 table ready will I be able to extract audio files from the table and use them in a flash player?

Any help will be useful thanks

 

[cx409]

If you want to make a new column in a table:

alter table bands add whatever_column definition goes here;

If you want to make a drop-down menu ordered by city (in ascending order):

<?php
$sql = "select unique(city) from bands order by city asc";
$exe = mysql_query($sql);

if (mysql_num_rows($exe) < 1) {
echo "No cities found."
} else {
while ($array = mysql_fetch_array($exe)) {
$dropdown .= "<option value=\"".$array["city"]."\">".$array["city"]."</option>";
}
}
?>

Basically that's it. Just echo $dropdown (remember to add: the <input> elements to it, and after the while (closing tag) so that you have a full dropdown)

 

[def1]

thanks alot