Problem With WHERE Clause

Problem With WHERE Clause

El Forum
Guest

#13

06-22-2012, 10:50 PM

[eluser]jmadsen[/eluser]
1) check that the carat datatypes are not causing problems. You are comparing to strings in your query, but it seems like those would be floats.

2) Go into your db query tool (such as phpmyadmin) and just remove parts of the where clause one by one until you get data, then investigate why that last removed condition might not be working correctly

3) If it all seems correct still, post all the data for a single diamond that you THINK should be found in that query, but is not. Your query looks correct, but we have no way to know without seeing your data

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