Hi group,
I am in need of assistance with a database and php query we are trying to
achieve.
Basically we are have a form where one field searches a field in the mysql
database and the other searches for keywords using the MATCH query.
What we need to do is for the user to be able to enter a date or keyword and
for it to query the database. Is it possible to do alternate queries based
upon what the user is entering. So we would like to be able to do a sql
elseif statement, but I am unsure if this is possible.
Here is out current code:
$sql= "SELECT *, MATCH (auction, email, website) AGAINST ('$keywords') AS
score FROM ukcalendars WHERE date = '$date' HAVING score != 0 ORDER BY score
ASC LIMIT $limitvalue1, $limit";
But we need to be able to also do:
$sql= "SELECT * FROM ukcalendars WHERE date = '$date' LIMIT $limitvalue1,
$limit";
But I am unsure how I can achieve this, if at all possible.
With thanks
barry Zimmerman
www.bzdpltd.co.uk
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php