MySQL Forums
Forum List  »  Newbie

can't get my query to work
Posted by: Zever Doosje
Date: May 29, 2005 11:52AM

Hello,

Can anybody tell me what it is I'm doing wrong?
This is one of the errors I keep getting:
You have an error in your SQL syntax near 'query AND leeftijd = "volwassen"; ' at line 1.query AND leeftijd = "volwassen";

this is a part of the php-page:

$rasgroep = $_POST['selectrasgroep'];
$sekse = $_POST['sekse'];
$leeftijd = $_POST['leeftijd'];
$anderekatten = $_POST['anderekatten'];
$kanbijhonden = $_POST['kanbijhonden'];
$kinderen = $_POST['kinderen'];
$binnenblijven = $_POST['binnenblijven'];
$buiten = $_POST['buiten'];


$query = " SELECT nr, naam, sekse ";
$query = query . " FROM kat ";
//rasgroep
if ($rasgroep != "alles") {
$query = query . " WHERE rasgroep = \"$rasgroep\"; ";
}

//sekse
if ($sekse != "maaktnietuit" ) {
$query = query . " AND sekse = \"$sekse\"; ";
}


//leeftijd
if ($leeftijd != "maaktnietuit" ) {
$query = query . " AND leeftijd = \"$leeftijd\"; ";
}


//anderekatten
if ($anderekatten != "maaktnietuit" ) {
$query = query . " AND anderekatten = \"$anderekatten\"; ";
}

//kanbijhonden
if ($kanbijhonden != "maaktnietuit" ) {
$query = query . " AND kanbijhonden = \"$kanbijhonden\"; ";
}

//kinderen
if ($kinderen != "maaktnietuit" ) {
$query = query . " AND kinderen = \"$kinderen\"; ";
}

//binnenblijven
if ($binnenblijven != "maaktnietuit" ) {
$query = query . " AND binnenblijven = \"$binnenblijven\"; ";
}

//buiten
if ($buiten != "maaktnietuit" ) {
$query = query . " AND buiten = \"$buiten\"; ";
}


Can anybody help me out?
Thanks

Options: ReplyQuote


Subject
Written By
Posted
can't get my query to work
May 29, 2005 11:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.