bigleo23

Thanks, I figured it out I have the search working.

I know you have provided me with so much help global moderater, I feel lost now that I will not recieve any help from you.

So basically what you are saying fenway is that you absolutely have wasted my time. In the subject and a few of my posts I let it be known that I am working with dreamweaver and that is basically what my question revolves around. You have no idea about what dreamweaver does and you only want to give me one line answers that absolutely do not help, so why did you even start replying to my post in the first place.

OK, I think the problem in communication we ae haveing is, I thought dreamweaver automaticly inserted the php code when the recordset was created. The problem I am having is creating the where in the recordset so that dreamweaver could create this code. If it would help at all, I have no problem with you looking at the source code

Is this truly that difficult, I thought this was a simple fix, or am I just explaining my problem in a way that makes it more complex than it really is?

That is exactly what I want, so what do I do, I don't join the fields do I because I only want the city field searched when a city is entered?

I am sorry fenway, but I am not understanding. I have two search parameters city and state I want it to search two fields in the table the city and state fields. I'm not tring to be rude, as I am not used to building two field WHERE clauses

I have a mysql table being searched by two fields city and state using dreamweaver, I have set up a form with a text field as city and a menu as state field. The problem is on the results page, I have a recordset SELECT * FROM table name. What do I do with the WHERE, I have tried multiple configurations, and I can't get anything to work. I only want to search by two fields, city and state. The state has to match, but if the city is left blank, I still want to filter by state. Can somebody help me or point me in the right direction, please?

I need pointed in the right direction, I have a social networking site that is almost finished. I only have one problem, I want the user to be able to import photo albums kinda like myspace. I would like for them to be able to upload multiple photos at the same time. Any help would be appreciated, or at least point me in the right direction. Thank You!!!

I would like to thank everybody who helped me!!!!! Hopefully I can help you out one day!!

OK so how do I set this up, I imagine I have to declare a variable for each of the fields that I want to search (col1 = 'something'). how would I set this up in dream weaver? The variable box asks for name default value and run time value?

Did it work?

I am truly sorry toplay, but could you explain a little bit more please?

I have a small problem that should be simple to fix, I am programming my site with dreamweaver since I don't know programming lang. yet. I am building a search results page and since I don't know php I am having trouble with the where statement, all I want is to search 5 0r 6 fields in the same table for the url variable. if someone could help me with what I am suppose to put in the where, in dreamweaver I would greatly appreciate it. Thank You