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] Quote 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] Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.