Filter Results / Query
Posted: Sun Jun 01, 2008 5:48 pm
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'];
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'";