can't get my query to work
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
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.