Ahhh!!! php/my_sql... radio boxes and fields

[myraleen]

Ok...
There is a search page...
It has about five text boxes for the user to enter the data they are searching for.
At the bottom, there is two radio boxes, for OR and for AND, these radio boxes are named anyall.
One value is set to "or" one is set to "and".

Everything works great until I want to find more then one thing and use the boxes.

The OR, or the AND whichever is clicked, is appearing at the end of each statement in the where clause, even though the next field would be empty... so it won't find anything!!!

So I am getting this as the query:
SELEFT * FROM thisTable WHERE letter='A' OR name='marc' OR

I have the code set up like this:

$SELECT = "SELECT *";
$FROM = "FROM thisTable";
$WHERE = "WHERE ";

if(!isset($anyall) && $anyall == "") {
     $anyall = "";
}
if(isset($letter) && $letter != "") {
     $letter = strtoupper(trim($letter));
     $WHERE .= " letter = '$letter' $anyall";
}
if(isset($name) && $name != "") {
     $letter = strtoupper(trim($name));
     $WHERE .= " name = '$name' $anyall";
}
if(isset($home) && $home != "") {
     $letter = strtoupper(trim($home));
     $WHERE .= " home = '$home' $anyall";
}
$query = "$SELECT $FROM $WHERE";
}

Can someone help me figure out a good way to make it so that if the next search field is empty the $anyall will stop at the end of the last variable and not continue appearing in the statment?

[kevinsequeira]

i would re-write the code but a quick fix for your particular problem is to remove the last 3 chars of ure query.

$query = substr($query,-3);

will remove the last 3 chars which would ' OR' or 'AND'

reg
kevin

[myraleen]

that would work yup.. thought of it too after, but alas... already did the big stuff.

thank you!

I already did the rewrite of the code though and stuck em all into if's and else's.

But now i have another problem, buecause though there's nothing wrong with the code, it's not finding multiple ones with or and and...

just keeps telling me the line that says
$numrecs=mysql_query("$query"); is wrong.

argh
the joys of programming

[kevinsequeira]

well post ure code,

try echo $query to see if the query is properly formatted, and if it is try
mysql_query($query); without the "

reg
kevin