quick mysql help.

[EKINdesigns]

Ok...So i have two tables.  Invites and Users

 

In the invites table i have the user id which refers to the users table.

 

in the users table i have the users email address and their total invitations.

 

I need to order the invitations by the users total invitations and display their email.

 

Thanks in advance.

[paul2463]

I think this should work

$query = "SELECT invites, email FROM Invites(LEFT JOIN Users ON Invites.userID= Users.userID) ORDER BY users.totalinvites DESC";

[EKINdesigns]

i changed the query to this:

 

SELECT `reciever_id` FROM `invites`(LEFT JOIN `users` ON `invites`.`reciever_id`=`users`.`id`) ORDER BY `users`.`sent_invites` DESC

 

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 '(LEFT JOIN `users` ON `invites`.`reciever_id`=`users`.`id`) ORDER BY `users`.`se' at line 1

[paul2463]

see if this one works, the opening bracket was in the wrong place, I have also removed the single ticks around the dot notation of table/column codes

$query = "SELECT `reciever_id` FROM (`invites`LEFT JOIN `users` ON `invites.reciever_id`=`users.id`) ORDER BY `users.sent_invites` DESC";