This topic is locked

WHERE expression in Lookup wizard

10/8/2007 4:49:26 PM
PHPRunner General questions
S
solfer author

Hi,
Please bear with me, this is probably a very basic question, but I'm not advanced in PHP/MySQL usage!
I have created an Add and Edit page for a particular table (Table 1). One of the editable fields is for dates, which I need to populate from a separate table (Table 2).
E.g. for simplicities sake:

table1

id

name

date
table2

id

date

flag (tinyint)


Problem is, I only want dates from Table 2 to populate the dropdown list for Table 1 where table2.flag = 0, but if I use "flag=0" as the WHERE expression, it doesn't seem to work and ALL dates are output..?
Any help appreciated!
Sol

Alexey admin 10/9/2007

Hi,
your WHERE expression seems to be correct.

Please publish your project on Demo Account and send a link to it to support@xlinesoft.com

I'll find what's wrong with your project inspecting it there.
The Publish on Demo Account button is on the last tab in PHPRunner.

S
solfer author 10/9/2007

OK, thanks Alexey.