Hi, I have a MySql database that contains a 'motels' table. One of the fields in the table is 'breakfast_available' and this contains an integer (1 for yes, 0 for no) The other field in this table is 'conference_facilities' which also stores an integer value 1 or 0 like the other field above.
I would like to setup one MySql query that will display this number of motels have breakfast available (breakfast_available = 1) and this number of motels provide conference facilities (conference_facilities = 1) --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
