URGENT 'WHERE' with lists
3 posts by 2 authors in: Forums > CMS Builder
Last Post: January 2, 2009 (RSS)
By terryally - January 2, 2009
Happy New Year to all!
I have used the WHERE clause successfully in the past but I just got stumped trying to use it with a list.
I.E. I have a gender field with two checkboxes "Male" and "Female". So now I want to display records for males only and so I used 'where' => 'gender="Male"', but it displays nothing.
When I generate the code for a full listing it displays that particular field as:
Oddly enough when I do a search directly in the MYSQL database, I am getting nothing either.
Any ideas?
This is fairly urgent because I need to get this page up by tomorrow morning.
Thanks
Terry
I have used the WHERE clause successfully in the past but I just got stumped trying to use it with a list.
I.E. I have a gender field with two checkboxes "Male" and "Female". So now I want to display records for males only and so I used 'where' => 'gender="Male"', but it displays nothing.
When I generate the code for a full listing it displays that particular field as:
<?php echo join(', ', getListLabels('seeds_and_qualifiers', 'gender', $record['gender'])); ?>Oddly enough when I do a search directly in the MYSQL database, I am getting nothing either.
Any ideas?
This is fairly urgent because I need to get this page up by tomorrow morning.
Thanks
Terry
Re: [terryally] URGENT 'WHERE' with lists
By Dave - January 2, 2009
Hi Terry,
I'd switch your field to a single value list pulldown. Multiple checkbox fields are meant to store multiple values (eg: Male and Female) and they store it as tab delimited values.
If you switch back to a single value list pulldown it will be much easier. Let me know if that works for you.
I'd switch your field to a single value list pulldown. Multiple checkbox fields are meant to store multiple values (eg: Male and Female) and they store it as tab delimited values.
If you switch back to a single value list pulldown it will be much easier. Let me know if that works for you.
Dave Edis - Senior Developer
interactivetools.com
interactivetools.com
Re: [Dave] URGENT 'WHERE' with lists
By terryally - January 2, 2009
Hi Dave,
I've switched as recommended and it works.
I omitted to say that it was both checkboxes and radio buttons that the WHERE clause was not working.
Terry
I've switched as recommended and it works.
I omitted to say that it was both checkboxes and radio buttons that the WHERE clause was not working.
Terry