[SOLVED] Drop Down not getting data.

[daveoffy]

The menu is not being filled up. Please help. I don't get any errors.

 

<form method="POST" enctype="multipart/form-data" name="image_upload_form" action="">
<p>Season Name: <input name="name" type="text" class="textfield" id="name"></p>
<p>Show Name: <SELECT NAME="show">
<?php
$q = "SELECT * FROM `season` ORDER BY name ASC";
$r = mysql_query($q);
while($column = mysql_fetch_assoc($r)){
	$id = $column['id'];
	$showtitle = $column['name'];
	echo '<OPTION VALUE="'.$id.'">'.$showtitle.'</option>';
	}
?>
</SELECT>
<p>Image: <input type="file" name="image" size="20"></p>
<p><input type="Submit" value="Add Show" name="Submit"></p>
</form>

[rhodesa]

change

$r = mysql_query($q);

to

$r = mysql_query($q) or die(mysql_error());

get any errors now?

[daveoffy]

Nope but I did find the problem. I was pulling data from the wrong table. Sorry for wasting your time. I hate when I have stupid mistakes like that.