Search Parameter ?

[fxcolin]

I'm pretty new to MySQL.
I recently installed php, MySQL, Apache on my PC. I'm also working with Dreamweaver Ultradev 4 and Phakt.

On my search page, I have 1 text box and 1 dropdown box.
When I submit the form if I leave the text box empty, it seems to pull the whole database. Also I have a similar problem with multiple pages. I have next and previous pages set up. I only have 4 records at the moment. I have set it so that only 2 records appear on the page. If I enter a search that pulls 3 records it will say found 2 of 3 records. When I click 'next', it will say 3 of 4 records, with the 4th. record being totally unrelated.

I think this is because when I click 'next' the text box becomes empty.

Can someone help with a suggestion, maybe an IF statement ??

Thanks alot.

http://www.chefmedia.ca

 

[DumTech]

What's your SQL query look like?

 

[fxcolin]

Hi Dumtech,

Here's what it looks like in the Recordset of Phakt
SQL:
SELECT *
FROM recipes INNER JOIN recipes_author USING (aid)
WHERE ingredients LIKE '%MMColParam%' OR ingredients2 LIKE '%MMColParam%' OR recipes.type LIKE '%MMColParam1%'

Variables:
Name Default Value Run Time Value
MMColParam % $HTTP_POST_VARS["word"]
MMColParam1 % $HTTP_POST_VARS["type"]

Basically I'm trying to pull from 2 tables 'recipes' and 'recipes_authors' where both contain 'aid'
MMColParam ("word&quot is the text field
MMColParam1 ("type&quot is the drop down

Incidently, if I choose from the dropdown and put something in the other text field, I will get records, but if I leave the text field empty, I get the whole database.

Is this enough info?

http://www.chefmedia.ca