�� sql

tech · 10-05-2008, 07:25 PM

��

��

��

----------------------

table -> users

id
name

----------------------

table -> comment

id
iduser
name
messege

----------------------

��

sms · 10-05-2008, 09:16 PM

��

select id,name from users

��

��

select count(id) as total from comment where iduser=$id

��

��

tech · 10-05-2008, 09:47 PM

��

�� sms ��

�� 10000 �� 10000 �� ... ��

��

ahmedwali · 12:08 AM

��
��

�� PHP:

  SELECT comment.iduser,users.*,COUNT( * ) AS total FROM users, comment 
WHERE users.id = comment.iduser GROUP BY comment.iduser ORDER BY users.id

tech · 10-05-2008, 11:58 PM

��

��

��

�� loop �� users ��
select * from users

�� count �� id

ahmedwali · 02:32 AM

��

�� PHP:

  $select=mysql_query("SELECT comment.iduser,users.*, COUNT( comment.iduser ) AS total FROM users LEFT JOIN COMMENT ON users.id = comment.iduser  GROUP BY comment.iduser");
while($Row=mysql_fetch_array($select)){
extract($Row);
echo $user."=".$total."<br>";
}

tech · 11-05-2008, 02:19 AM

��

�� users ��

ahmedwali · 11-05-2008, 02:25 AM

��

��:

�� count �� id

�� users �� users ��
�� load ��

tech · 11-05-2008, 05:52 PM

�� ahmedwali ��

�� user �� 0 ��

�� lood