Page is a not externally linkable
- Code, Content, and Presentation
-- PHP Server Side Scripting
---- Using PHP to search an entire column contents in MySQL


SEO_Speedster - 5:10 pm on Nov 8, 2001 (gmt 0)


Sorry for being a little vague-

Here is the process I need to solve, from a user point of view.

1) User accesses an HTML document with a form. That form contains a list menu in which a user selects a city, then submits that information.

2) That information is then parsed (with mySQL selecting the value from the list within a given column)

3) Data is then used in supplying the user with a document.

I know it's pretty simple, but I'm coming from an ASP/MSSQL background, and my great "use for any case" scripts just can't transer all that well into PHP.

I can build the form, but don't know where to go from there. I suspect that it would be best to set up the final PHP document with the ability to read a querystring, and create the information on the fly... like: "results.phtml?city=boston" - - But it's getting the beginning of that PHP document squared away that confuses me.

Okay.. I think in the most basic form, what I need is to be able to declare a variable, assign it's value from a querystring, then insert it into my SQL statement.

Make sense?

Again, thank you for helping - all of you!

~Speedster


Thread source:: http://www.webmasterworld.com/php/351.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com