ahill

For example if I have a database right now if I search "oil type" it only brings up"what is my oil type"Where "oil and type "are right next to each other.and I want it to bring up"What is my oil type"" what oil goes in my type of engine"Where oil and type can be anywhere in the sentencemy sql looks like thissql="select distinct * from database where mproblem like '" +mproblem+ "' and post='true'"

example?

Right now my search box is set up to search multiple words but they have to be right next to each other. How do I set it up so it searches for multiple wordsregardless of where they are in the statment

It works for the first greeting but does not change to the second greeting when selected, as it still displays the first one.

no all of the code is not there. i have a string of code that pulls from my sql so my page posts a table with clickable images that reloads into the same page. Now I am trying to make my header of the <div> change every time the page reloads with the next selection in the page. Everything on the page works, I just wana make the header change based on the selection of the page when it reloads. I unfortunately cant post the full code because it is for a company.

Here is what I have right now. I want the page to change the header when the page is reloaded based on what is selected. <h2> <% If tom = " " and jan = " " and jake= " " then response.write (" welcome") ElseIf tom <> " " and jan = " " and jake= " " then response.write ("hello") %> </h2> <% If tom = " " and jan = " " and jake= " " then SQL statement ElseIf tom <> " " and jan = " " and jake = " " then SQL statement End If SOME OTHER CODE Reload %>

ok so vb does not matter on the code end of the page? I was told by someone else that I had to use If Else Statements

i am using vbscript for coding

Hey guys new to ASP so my terminology may not be quite right. Looking to build a page that has a table that it pulls from SQL database. Every time you click on an image on the table i want the page to pull the variable and reload in the same page to a new variable. So it sort of drills down variables. Currently my page pulls from my database and displays images the way it needs to. Now i need to be able to click on the image and have the page reload into the same page with the variable selected. My database is set up already. this is currently the code I have to display the table with images SQL = "select type from resources group by type order by type" RSb.Open SQL,Conn Dim mytype,mr,mpic mr = 1 If rsb.eof then 'response.write "NOT FOUND" else do until rsb.eof mytype = trim(rsb("type")) mpic = mytype & ".JPG" If mr = 1 then response.write "<tr>" end if Response.write "<td><img src=""images/"& mpic &""" />" Response.write mpic & "</td>" If mr = 3 then mr = 0 response.write "</tr>" end if mr = mr + 1 rsb.movenext loop response.write "</table>" end if %>

This is currently the code I have to display the table with images SQL = "select type from resources group by type order by type" RSb.Open SQL,Conn Dim mytype,mr,mpic mr = 1 If rsb.eof then 'response.write "NOT FOUND" else do until rsb.eof mytype = trim(rsb("type")) mpic = mytype & ".JPG" If mr = 1 then response.write "<tr>" end if Response.write "<td><img src=""images/"& mpic &""" />" Response.write mpic & "</td>" If mr = 3 then mr = 0 response.write "</tr>" end if mr = mr + 1 rsb.movenext loop response.write "</table>" end if %>

Hey guys new to ASP so my terminology may not be quite right. Looking to build a page that has a table that it pulls from SQL database. Every time you click on an image on the table i want the page to pull the variable and reload in the same page to a new variable. So it sort of drills down variables. Currently my page pulls from my database and displays images the way it needs to. Now i need to be able to click on the image and have the page reload into the same page with the variable selected. My database is set up already.