Private messageing mysql isnt working?

[pirateben]

so im all the way to video 10 and i dont get why im getting this error
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 'MAX(`conversation_messages`.`message_date`) > `conversations_members`.`conversat' at line 4
here the code i have for that part
[syntax=sql] MAX(`conversation_messages`.`message_date`) AS `conversation_last_reply`
MAX(`conversation_messages`.`message_date`) > `conversations_members`.`conversation_last_view` AS `conversation_unread`
[/syntax]
the first line works but why dosnt the second i check the nameing 10 time or something lol it should be the same right? i dont get it

[Temor]

Could you post the entire SQL statement and not just a part of it?

[pirateben]

ya just the > part dosnt work

[Temor]

I don't think I understand your answer...

I think you've missed a comma on the first line.

[syntax=sql] MAX(`conversation_messages`.`message_date`) AS `conversation_last_reply`,
MAX(`conversation_messages`.`message_date`) > `conversations_members`.`conversation_last_view` AS `conversation_unread`[/syntax]

Like so.

[pirateben]

thanks so much i didnt think you used , in mysql in between lines only on like. select from valuse (x,x,x) i would of been looking forever for something i missed spelled or something


also vary new to this all