Help needed in terms of searching

[amareal]

I am new to php/MySQL. I manage to install phptriad, and it was running fine, I created a db, and a table within it, The table name is Adm_List with the following fields 'S_No' 'Form_No' 'Name' 'Course' 'Level'. My problems
are; I want to search this table using Form_No field as my search field and if the item been searched for is found, how do I display the entire record on the browser. Thanks

Abdullahi M Abubakar

[drzoid]

Something like this?

$result=mysql_query('SELECT * FROM Adm_List WHERE Form_No="'.$SOME_VARIABLE.'"');
while ($row=mysql_fetch_array($result))
{
    /* Here you can access the individual dates by their column names
    $row['S_No']
    $row['Form_No']
    $row['Name']
    $row['Course']
    $row['Level'] */
} 

[swdev]

Before you get into the coding, you need to answer some design questions

1. How do you wnat your users to enter the Form_No - from a drop-down box or a text field?
2. Will there be just one record returned, or can there be many records?
3. How do you want the data to be displayed - in a table? just dumped on screen in a sngle line?
4. Is any of the displayed data to be linked to other pages?

Hope this hepls

[JZA]

I wonder what is your development enviroment, if you are using dreamweaver you can take a look at this extensions which work for you in term of creating this searchable tables (http://www.interaktonline.com/Produc...nsio/Overview/) and (http://www.interaktonline.com/Produc...rter/Overview/) are just some of the extensions that might be of great help for you.