Forums

PHP

This topic is locked

submit search to results page

Posted 14 Dec 2006 00:25:39
1
has voted
14 Dec 2006 00:25:39 John Atchison posted:
HI,
I am moving my site over to PHP from ASP and having problems submitting form to results page.
I am using Dreamweaver v8 MySQL and PHP. I have set up a recordset (details below) which works perfectly when I enter the keywords but trying to get my form to work is driving me crazy. Any help would be appreciated I have tried searching the web and various forums but I am new to PHP and find it overwhelming.

Thanks
John

SELECT artistinfotbl.artistName, artistinfotbl.lastName,artistinfotbl.headDescription, MATCH (artistinfotbl.artistName, artistinfotbl.lastName) AGAINST ('keyword/s' IN BOOLEAN MODE) AS score
FROM artistinfotbl
WHERE MATCH (artistinfotbl.artistName, artistinfotbl.lastName) AGAINST ('keyword/s' IN BOOLEAN MODE)
ORDER BY score DESC

Replies

Replied 19 Dec 2006 17:58:22
19 Dec 2006 17:58:22 Roddy Dairion replied:
Do you get any error when submitting to the results page? If yes then what is it?
What are trying to submit and what result are you expecting?
Replied 19 Dec 2006 20:36:25
19 Dec 2006 20:36:25 John Atchison replied:
Hi Roddy,
I have managed to solve my problem. I did not have:
$searchstring = $_GET['keywords'];
and
$searchstring = mysql_escape_string($_GET["keywords"]);

in my code. I was relying on the recordset to do the work not realising what else is required. Learning the hard way! what fun.
Thanks for your reply

Regards

John

Reply to this topic