[SOLVED] <SELECT> box how to select all (*)

[doa24uk]

hi guys,

 

Here is my query

 

$selectquery = "SELECT * FROM listings WHERE rtype = '$rtype' AND bed = '$bed' AND sleeps = '$sleeps' ";

 

my OPTION value is passing "*" to $bed therefore the query looks like this

 

$selectquery = "SELECT * FROM listings WHERE rtype = '$rtype' AND bed = * AND sleeps = '$sleeps' ";

 

However, thats not what I want, because that returns no results. I need it so that if * is selected then it selects all from the $beds column / removes the AND bed = '$bed' from the query.

 

How can I do this?

[NArc0t1c]

Well, I don't know exactly what you mean by select all from bad column, but here goes.

 

<?php
if ($bed == "*"){
$bed_add = ""; }
else {
$bed_add = " AND bed = " . $bed; }
/* the query */
$selectquery = "SELECT * FROM listings WHERE rtype = '$rtype'" . $bed_add ." AND sleeps = '$sleeps' ";
?>

[doa24uk]

Its a apartment script, so if the searcher isn't bothered how many bedrooms teh apartment has.

 

Here's my script so far (I need to do the same thing with $sleeps) - its erroring though, could you help me out?

 

if ($sleeps == "*"){
$sleeps_add = ""; }
else {
$sleeps_add = " AND sleeps = " . $sleeps; }
if ($bed == "*"){
$bed_add = ""; }
else {
$bed_add = " AND bed = " . $bed; }

$selectquery = "SELECT * FROM listings WHERE rtype = '$rtype'" . $bed_add . $sleeps_add .";

[NArc0t1c]

What error is it giving?

[doa24uk]

Parse error: syntax error, unexpected T_STRING on line 72

 

Which is the "Query Failed" line

 

$selectquery = "SELECT * FROM listings WHERE rtype = '$rtype'" . $bed_add . $sleeps_add .";
$result = mysql_query($selectquery);
or die ("Query failed");

[NArc0t1c]

$selectquery = "SELECT * FROM listings WHERE rtype = '$rtype'" . $bed_add . $sleeps_add .";
$result = mysql_query($selectquery) or die ("Query failed");

[doa24uk]

Sorry, that was my typo.

 

I've corrected the code to the one you provided and its still giving a T_STRING error.

 

Thanks for your patience!

 

DoA

[NArc0t1c]

<?php
if ($sleeps == "*"){
$sleeps_add = ""; }
else {
$sleeps_add = " AND sleeps = " . $sleeps; }
if ($bed == "*"){
$bed_add = ""; }
else {
$bed_add = " AND bed = " . $bed; }

$selectquery = "SELECT * FROM listings WHERE rtype = '$rtype'" . $bed_add . $sleeps_add;
?>