MySql Select question

[benwalsh]

can any one tell me what may be wrong with this script I have written, excerpt following:

[PHP]if($set ="yes"){ $query.="online = 'y'"; }
if($lab !=""){ $query.=" AND Lab= '$lab'"; }
if($parcel !=""){ $query.=" AND Parcel = '$parcel'"; }
if($shape !=""){ $query.=" AND Shape = '$shape'"; }
if($color !=""){ $query.=" AND Color = '$color'"; }
if($clarity !=""){ $query.=" AND Clarity = '$clarity'"; }
if($depth !=""){ $query.=" AND Depth = '$depth'"; }
if($size !=""){ $query.=" AND Size = '$size'"; }
if($polish !=""){ $query.=" AND Polish = '$polish'"; }
if($culet !=""){ $query.=" AND Culet = '$culet'"; }
if($fluorescence !=""){ $query.=" AND Fluorescence = '$fluorescence'"; }
if($symmetry !=""){ $query.=" AND Symmetry = '$symmetry'"; }
$query .= " AND Weight BETWEEN '$weight_sm' AND '$weight_big'";

$result = mysql_query("SELECT * FROM diamonds WHERE $query ORDER BY $orderby LIMIT $startrow, $limit")

or die(mysql_error());
[/PHP]

Wieght is all that is working for me?

TIA Ben

[khalidbaloch]

can any one tell me what may be wrong with this script I have written, excerpt following:

[PHP]if($set ="yes"){ $query.="online = 'y'"; }
if($lab !=""){ $query.=" AND Lab= '$lab'"; }
if($parcel !=""){ $query.=" AND Parcel = '$parcel'"; }
if($shape !=""){ $query.=" AND Shape = '$shape'"; }
if($color !=""){ $query.=" AND Color = '$color'"; }
if($clarity !=""){ $query.=" AND Clarity = '$clarity'"; }
if($depth !=""){ $query.=" AND Depth = '$depth'"; }
if($size !=""){ $query.=" AND Size = '$size'"; }
if($polish !=""){ $query.=" AND Polish = '$polish'"; }
if($culet !=""){ $query.=" AND Culet = '$culet'"; }
if($fluorescence !=""){ $query.=" AND Fluorescence = '$fluorescence'"; }
if($symmetry !=""){ $query.=" AND Symmetry = '$symmetry'"; }
$query .= " AND Weight BETWEEN '$weight_sm' AND '$weight_big'";

$result = mysql_query("SELECT * FROM diamonds WHERE $query ORDER BY $orderby LIMIT $startrow, $limit")

or die(mysql_error());
[/PHP]

Wieght is all that is working for me?

TIA Ben

what is the problem ?

[subash]

Hi,

I think from your code - you may not able to get the online value on certain cases. Its because you have used

[PHP] if($set ="yes"){ $query.="online = 'y'"; } [/PHP]

So always the value has set to "yes"


You need to change this as

[PHP] if($set =="yes"){ $query.="online = 'y'"; } [/PHP]

Are you clear with the comments? - Write back to me

Subash :)