Filter Results / Query

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
liamg1987
Forum Newbie
Posts: 1
Joined: Sun Jun 01, 2008 5:45 pm

Filter Results / Query

Post 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'";
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: Filter Results / Query

Post 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.
Post Reply