[Resolved] Basic query that searches DB for keyword

[tazdog]

I found a post from last yr on this board that I thought was going to help out but it didnt seem to do what I wanted it to do, so I thought I would ask here to see if this is possible.

What I would like to have is a form that a user can type in a name, say Scott

And then the php page would query the DB and return all rows that had Scott in them.

I tried LIKE in the query but it seemed that it would only go by column name.!!

Is there anyway to say extract out names (scott) from a column named (name)?

Hope this makes sense.. I'm new to MySql and just learning, so I did try to locate the answer before hand..

thanks
Scott

[tazdog]

Turns out I was closer than I was..

I had some formatting wrong..

$query = "SELECT * FROM schedule WHERE DepartureAP LIKE '$fieldname'";

This is what I used and it did work..

Sorry for wasting space, I didnt think I would get this on my own..

thanks
Scott