mysql

[coja1]

Hi,

I am new to PHP and Mysql and need a little help in setting up a simple database query.
I have created a data base table, 'tracks' , and need to search via php one of the columns in the table by using a drop down menu in a form on a web page, which would in turn display all the colums of the matching entries on a results page.

I know this is probably very simple stuff, but I am new to this and having huge problems!

Many thanks

Joe

[shastry]

Try with this:
$query="select urColumn from tracks";
$query = stripSlashes($query) ;
$result = mysql_query($query);

print "<FORM METHOD=\"POST\" ACTION="$PHP_SELF">
<TABLE>
<TR>
<TD>
<SELECT NAME=\"search_text\" SIZE=1>";
for ($i = 0; $i < mysql_num_rows($result); $i++)
{
$row_array = mysql_fetch_row($result);

             for ($j = 0; $j < mysql_num_fields($result); $j++)
                 {
                     print("<OPTION>" . $row_array[$j]."</OPTION>");
                 }
         }    
   print("</SELECT></TD>");
?>
    </TR></TABLE></FORM>

Query:
$query1 = "SELECT col1,col2,col3.. FROM tracks where urColumn LIKE '%$search_text%'";
--Shastry