Jump to content

Archived

This topic is now archived and is closed to further replies.

davieboy

Selecting from a table then a record

Recommended Posts

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]

Share this post


Link to post
Share on other sites

Just curious...

Shouldn\'t it be:

 

[php:1:fe23b0cc40]

SELECT * FROM clients WHERE business = \'self\' AND area = \'south ayrshire\'\"

[/php:1:fe23b0cc40]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.