ansaurus

Question

Answer 1

+5 A:

It difficult to answer this question without knowing more about the replies table, but just looking at your query, then yes your query looks like it will.

Notorious2tall 2009-02-04 16:49:54

Answer 2

A:

$ssql = "SELECT count(*) AS num_replies FROM replies WHERE u_id = $uid"; $rres = mysql_query($ssql);

Nicholas

Nicholas Kreidberg 2009-02-04 16:52:17

The GROUP BY clause is unnecessary because the WHERE clause reduces the set that COUNT(*) is dealing with to just the records matching $uid.

Welbog 2009-02-04 16:54:19

Good point, comment edited. -- Thank you!

Nicholas Kreidberg 2009-02-04 16:59:31

So now your query is the same as his except it's counting * instead of u_id which makes absolutely no difference. I'm not sure why you bothered answering.

Welbog 2009-02-04 17:01:44

Actually, if u_id is nullable, then it *does* make a difference.

Rob 2009-02-04 17:04:31

If it's nullable, then it will be rejected by the WHERE condition.

Welbog 2009-02-04 17:06:15

Answer 3

A:

It will return the number of records in the table with that u_id. Doesn't matter what you put in the paretheses. You don't need any GROUP BY clause.

le dorfier 2009-02-04 16:52:52

Answer 4

+1 A:

Please, for the love of the internet, don't built an SQL query yourself. Use PDO.

Paul Tarjan 2009-10-15 02:41:07

ansaurus

tags:

views:

answers:

Question about a query

related questions