how to extract a certain row

blckspder

Hello I have a table with these fields. Name, Park, geocache

In them contain all the places Ive been to with my GPS, Ive figured out how to display the whole table from a tutorial on this site. But I cant seem to find anything about using a form to extract certain data. Does anyone know of any place I could learn this? Thank you

Antoni

blckspder

I figured it out!! 🙂 lol thanks anyways guys.. I was using the incorrect structure for the select and then I had the while statement pulling the information nested in an if statement.. so I had to get rid of the if statement.

leatherback

Hi Antoni,

how have you been goiung on this? Can you show some code? Did you check out the FAQ I suggested in this thread: http://phpbuilder.com/board/showthread.php?t=10315486 ?

In short:
- You need a form, which you use to set the values you want to look for.
- The form submits to a processing script, which extracts the variables from the $POST or the $GET array (Depends on the METHOD you have set for your form. Typical is to use post):
$your_variable = $_POST['your_form_field_name'];
- You query the database:

$query = "select * from YOUR_TABLE where SOMECOLUM = '$your_variable'";
$result = mysql_query($query) or die('I was unable to extract the data. Please notify the administrator and report: '.mysql_error());

display as you have done with the full-table display