PHP - MYSQL - Drop Down Menu

[boneXXX]

Hi all,

 

I am trying to do a drop down menu which gets the options from a specific table in the database. Such as there is a table called EventType and this table has a single column that is called Event_Name. I want to make a drop down menu and each option will get a row from the table. In that way users will be able to pick a event from the EventType table. This is I have done so far could you help me on this please? Thanks

 

           
<?
include ("../databaseConnect/dbfuncs.inc.php");
$link = connectToDatabase();

$result = mysql_result("SELECT Event_Name FROM EventType");
$rows = mysql_num_rows($result);

echo "<select name='Events'>";
        echo "<option>Select Event</option>";
        for($x=0; $x = $rows; $x++)
        {
                $data = mysql_fetch_row($result);
	echo "<option value=$data[1]>$data[1]</option>";
        }
        echo "</select><td/>";
?>

 

[pocobueno1388]

Try

 

<?php
include ("../databaseConnect/dbfuncs.inc.php");
$link = connectToDatabase();

$result = mysql_result("SELECT Event_Name FROM EventType");
$rows = mysql_num_rows($result);

echo "<select name='Events'>";
echo "<option>Select Event</option>";

while ($row = mysql_fetch_assoc($result)){
   echo "<option value='{$row['Event_Name']}'>{$row['Event_Name']}</option>";
}

echo "</select><td/>";

?>

[boneXXX]

Thank you for the reply but I got these errors

 

Warning: Wrong parameter count for mysql_result()

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

[zenag]

check ur fieldname or database name..

[pocobueno1388]

You should be using mysql_query() instead of mysql_result().

 

So change:

$result = mysql_result("SELECT Event_Name FROM EventType");

 

To:

$result = mysql_query("SELECT Event_Name FROM EventType");

[boneXXX]

Thank you all it is working.

 

<?php
include ("../databaseConnect/dbfuncs.inc.php");
$link = connectToDatabase();

$result = mysql_query("SELECT Event_Name FROM EventType");
$rows = mysql_num_rows($result);

echo "<select name='Events'>";
echo "<option>Select Event</option>";

while ($row = mysql_fetch_assoc($result)){
echo "<option value='{$row['Event_Name']}'>{$row['Event_Name']}</option>";
}

echo "</select><td/>";

?>