davieboy Posted June 28, 2003 Share Posted June 28, 2003 Previous problem sorted I want to select data depending on two things so i select from the db (clients) then i want to display the data in the area (area) and then select the business. The area andbusiness are bth tables in the clients dataabse Can anyone help? is this is [php:1:4474af2f70] SELECT * FROM clients WHERE business = \'self\', WHERE area = \'south ayrshire\'\" [/php:1:4474af2f70] Link to comment https://forums.phpfreaks.com/topic/648-selecting-from-a-table-then-a-record/ Share on other sites More sharing options...
Nairb Posted June 28, 2003 Share Posted June 28, 2003 Just curious... Shouldn\'t it be: [php:1:fe23b0cc40] SELECT * FROM clients WHERE business = \'self\' AND area = \'south ayrshire\'\" [/php:1:fe23b0cc40] Link to comment https://forums.phpfreaks.com/topic/648-selecting-from-a-table-then-a-record/#findComment-2158 Share on other sites More sharing options...
davieboy Posted June 28, 2003 Author Share Posted June 28, 2003 thats where i went wrong I used and in lower case Cheers m8 Link to comment https://forums.phpfreaks.com/topic/648-selecting-from-a-table-then-a-record/#findComment-2159 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.