Welcome Guest, Not a member yet? Register   Sign In
Problem With WHERE Clause
#3

[eluser]james182[/eluser]
SO what is happening is the shape is not staying as defined and the colours and clarity aren't showing what is defined.

I should only see data that's colour is only D,E,F,G and clarity VVS1, VVS2 and the stone shape Princess.
But i'm not!


POST:
Code:
certi all
cla VVS1-VVS2-
col D-E-F-G-
cut all
flou all
maxprice 100000
maxval 5
minprice 100
minval 0.01
pg 1
polish all
scat_id
shape Princess
sym all

Results:
Code:
Array (
[0] => Array (
[id] => 1
[stone] => CD1002/(
-385R
)
[carat] => 0.39
[certification_type] => GIA
[shape] => Asscher
[colour] => F
[clarity] => VS1
[cut] =>
[polish] => VG
[symmetry] => G
[fluorescence] => N
[cert_no] => 12873565
[note] => 4.16X4.15X2.75
[cost] => 1700.00
[discount] => 34
)
[1] => Array (
[id] => 2
[stone] => CD4186/(
-319R
)
[carat] => 2.01
[certification_type] => GIA
[shape] => Marquise
[colour] => G
[clarity] => VS2
[cut] =>
[polish] => G
[symmetry] => G
[fluorescence] => STR
[cert_no] => 11475928
[note] => 12.98x6.15x4.26
[cost] => 11800.00
[discount] => 38
)
[2] => Array (
[id] => 3
[stone] => CD5063/(
-299R
)
[carat] => 1.71
[certification_type] => GIA
[shape] => Emerald
[colour] => G
[clarity] => VVS2
[cut] =>
[polish] => G
[symmetry] => G
[fluorescence] => N
[cert_no] => 11527700
[note] => 7.48x6.25x4.20
[cost] => 9600.00
[discount] => 28
)
[3] => Array (
[id] => 4
[stone] => CD5406/(
-186R
)
[carat] => 0.18
[certification_type] => HRD
[shape] => Emerald
[colour] => E
[clarity] => VVS1
[cut] =>
[polish] => G
[symmetry] =>
[fluorescence] => N
[cert_no] => 20023393259
[note] => 4.03x3.03x1.58
[cost] => 1360.00
[discount] => 15
)
[4] => Array (
[id] => 5
[stone] => CD5661/-196R
[carat] => 0.25
[certification_type] => HRD
[shape] => Oval
[colour] => F
[clarity] => VVS1
[cut] =>
[polish] =>
[symmetry] => G
[fluorescence] => N
[cert_no] => 25016220
[note] => 4.55X3.56X2.40
[cost] => 1750.00
[discount] => 15
)
[5] => Array (
[id] => 6
[stone] => CD6107/(
-214R
)
[carat] => 0.19
[certification_type] => HRD
[shape] => Emerald
[colour] => F
[clarity] => VS2
[cut] =>
[polish] => G
[symmetry] =>
[fluorescence] =>
[cert_no] => 20020599710
[note] => 4.18x2.72x1.87
[cost] => 1160.00
[discount] => 23
)


Messages In This Thread
Problem With WHERE Clause - by El Forum - 06-22-2012, 01:47 AM
Problem With WHERE Clause - by El Forum - 06-22-2012, 01:53 AM
Problem With WHERE Clause - by El Forum - 06-22-2012, 02:10 AM
Problem With WHERE Clause - by El Forum - 06-22-2012, 02:39 AM
Problem With WHERE Clause - by El Forum - 06-22-2012, 03:22 AM
Problem With WHERE Clause - by El Forum - 06-22-2012, 03:43 AM
Problem With WHERE Clause - by El Forum - 06-22-2012, 04:10 AM
Problem With WHERE Clause - by El Forum - 06-22-2012, 04:21 AM
Problem With WHERE Clause - by El Forum - 06-22-2012, 06:55 AM
Problem With WHERE Clause - by El Forum - 06-22-2012, 06:50 PM
Problem With WHERE Clause - by El Forum - 06-22-2012, 10:34 PM
Problem With WHERE Clause - by El Forum - 06-22-2012, 10:38 PM
Problem With WHERE Clause - by El Forum - 06-22-2012, 10:50 PM
Problem With WHERE Clause - by El Forum - 06-22-2012, 10:56 PM
Problem With WHERE Clause - by El Forum - 06-22-2012, 11:13 PM
Problem With WHERE Clause - by El Forum - 06-22-2012, 11:16 PM
Problem With WHERE Clause - by El Forum - 06-23-2012, 02:12 AM



Theme © iAndrew 2016 - Forum software by © MyBB