Hello Amigos!
My first time here at PHP Builder... "pat me on the back!"
On to my question...
Using DWMX, MYSQL, PHP, WINXP SP2, & WinAmp 😛
I have created a search page and a results page. In my results page my Primer reads as follows (done all through the advanced window of "record set" in DWMX04)
SELECT *FROM msds
WHERE ref Like '%q%' OR manufacturer Like '%q%' OR description Like '%q%' OR pdf Like '%q%'
ORDER BY ref ASC
Below in the same window I am asked to create a "variable". I have yet to find documentation that specifies all the aspects of this section of the process, hopefully someone can shed light.
I enter a varname, default value, run-time value:
qres, -1, $_GET['q']
What does the "-1" do?
Ok, now onto the main part of my question. This primer looks pretty good, no? Well, when i do a search, the search always returns the first 127 records... in fact, it returns whatever it wants. It never cross-checks the query string with the db to bring back the relevant results. Very frustrating. In ASP this is cake.
What am I doing wrong? If you need more code, let me know! If you need to see it live, let me know, it's currently on the testing server.
Aha,
-F
