Multiple WHERE clauses

[WatsonN]

Is there a way to have multiple WHERE statements in a mysql .

 

Like:

SELECT * FROM YBK_Ads WHERE UID = '{$_GET['UID']}' and WHERE delete = '0'

 

That doesn't work but is it possible

[Alex]

You don't need the second "WHERE".

 

SELECT * FROM YBK_Ads WHERE UID = '{$_GET['UID']}' and delete = '0'

[WatsonN]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delete = '0'' at line 1

 

I used what you said and I got that

[roopurt18]

DELETE is a reserved word.  Surround it with backticks: `

SELECT * FROM `YBK_Ads` WHERE `UID` = '{$_GET['UID']}' and `delete` = '0'

[WatsonN]

Works perfectly Thank Ya much

[WatsonN]

One more quick question. Could I put the WHERE clause in this, or would it break it?

SELECT y.*,COUNT(ads.UID) AS posts FROM YBK_Login AS y LEFT JOIN YBK_Ads AS ads ON ads.UID=y.ID GROUP BY y.ID

 

[roopurt18]

Yes.

 

SELECT 
    y.*,
    COUNT(ads.UID) AS posts 
FROM YBK_Login AS y 
LEFT JOIN YBK_Ads AS ads ON ads.UID=y.ID 
WHERE ...
GROUP BY y.ID

 

Notice how the use of white space makes the query logic easier to follow?

[WatsonN]

It sure does.

 

I used

SELECT 
    y.*,
    COUNT(ads.UID) AS posts 
FROM YBK_Login AS y 
LEFT JOIN YBK_Ads AS ads ON ads.UID=y.ID 
WHERE `delete` = '0'
GROUP BY y.ID

And any field that was 0 was not displayed

[jcbones]

You will have to add the table name to any column when using a join query.

 

SELECT 
    y.*,
    COUNT(ads.UID) AS posts 
FROM YBK_Login AS y 
LEFT JOIN YBK_Ads AS ads ON ads.UID=y.ID 
WHERE ads.`delete` = '0'
GROUP BY y.ID

[WatsonN]

That still pulls all rows with 0 as their value out.

[roopurt18]

And any field that was 0 was not displayed

That still pulls all rows with 0 as their value out.

So which is it?

[WatsonN]

Any field that is 0

[Zane]

Perhaps take 0 out of quotes?

[WatsonN]

Nope, even out of quotes it still does the same thing

[Zane]

Try an INNER JOIN instead... and if the delete column is varchar, put the quotes back.  I should have asked that to begin with.

 

Alternatively, you could try an OUTER JOIN, but I would try INNER first.

[WatsonN]

I fixed it by creating a new user and posting all deleted posts to that user so they don't show up under other people.

 

I will keep looking at this and if I find something I will post back.

 

But, for now SOLVED! Because the original problem was solved.

 

Thank yall so much for the help