Page 1 of 1

Filter Results / Query

Posted: Sun Jun 01, 2008 5:48 pm
by liamg1987
Hey everybody, im having trouble filtering results and showing them in my dynamic table, the results im trying to filter are saved messages and Im trying to filter them to show messages to there correct user;

Heres my query, in the notion $user = $_SESSION['kt_login_id'];

Code: Select all

$query_rsmessages_saved1 = "SELECT messages_saved.messages_saved_id, messages_saved.messages_saved_member_id, messages_saved.messages_saved_datetime, messages_saved.messages_saved_reciever, messages_saved.messages_saved_sender, messages_saved.messages_saved_subject FROM messages_saved WHERE {$NXTFilter_rsmessages_saved1} ORDER BY {$NXTSort_rsmessages_saved1} AND messages_saved_member_id = '$user'";

Re: Filter Results / Query

Posted: Sun Jun 01, 2008 7:54 pm
by califdon
What is {$NXTFilter_rsmessages_saved1} ? What values may it have? If it's not a boolean, your WHERE syntax is incomplete, and if it is, your ORDER BY syntax doesn't make any sense. Oh, and please do yourself and everybody else a favor and format your SQL so it isn't so hard to read.