How to select all entires in a column?

[gigabyt3r]

Hi, I was wondering how I can select all the different colours in a database if no specific colour is entered?

 

Here is my code;

 

//Colour Search Box
if($_POST['Colour'] != "") {
$Colour = $_POST['Colour'];
} else {
$Colour = "ALL COLOURS";
}

 

Thanks in advance

[Adam]

You just wouldn't specify a condition, for example:

 

$sql = "select * from colours";

if (isset($_POST['Colour']))
{
    $colour = mysql_real_escape_string($_POST['Colour']);
    $sql .= " where colour='{$colour}'";
}

// run query

[gigabyt3r]

You just wouldn't specify a condition, for example:

 

$sql = "select * from colours";

if (isset($_POST['Colour']))
{
    $colour = mysql_real_escape_string($_POST['Colour']);
    $sql .= " where colour='{$colour}'";
}

// run query

 

Thanks for the reply although im not sure how to implement is :S This is my query so far its quite big

 

$query_rsVehicle = "SELECT ID, `Vehicle Registration`, Make, Model, Color, Transmission, `Fuel Type`, Mileage, `Reg Year`, `Image Prefix`, `Key Point 1`, `Key Point 2`, `Key Point 3`, `Key Point 4` FROM vehicles WHERE Model LIKE \"%$Search%\" AND Wheelbase IN ('$Wheelbase') AND `Roof Height` IN ('$RoofHeight') AND Color LIKE ('$Colour')";   

[Adam]

Try this:

 

$colour_condition = '';
if (isset($_POST['Colour']))
{
    $colour = mysql_real_escape_string($_POST['Colour']);
    $colour_condition = "and Color='$colour'";
}

$query_rsVehicle = "SELECT ID, `Vehicle Registration`, Make, Model, Color, Transmission, `Fuel Type`, Mileage, `Reg Year`, `Image Prefix`, `Key Point 1`, `Key Point 2`, `Key Point 3`, `Key Point 4` FROM vehicles WHERE Model LIKE \"%$Search%\" AND Wheelbase IN ('$Wheelbase') AND `Roof Height` IN ('$RoofHeight') $colour_condition";