Search options

I'm working on a comment system for the news updates on my site. In doing so, I want the article, let's say it is 1.php, to have a table in the comments database called 1.

The table is $commenttable. However, when I tried writing a comment, I get an error message, which says something about the syntax on this line. I'm guessing the problem is a $commenttable. Any ideas or something that stands out? I can't figure out what the error is. The page is at http://gamesource.biz/news/1.php.

mysql_query("INSERT INTO $commenttable SET name = '$name', comment ='$comment', time = '$time', email = '$email', ip = '$ip'") or die(mysql_error());

I'd like to create an RSS feed for my site so that readers can get their gaming news and articles easily, like what RSS and Atom feeds should do. I've Googled, Wikipedia'd, the whole schabang, and still don't quite understand how to implement one onto a website. I have a feed reader, and get feeds daily, but I don't know how to make an RSS feed. Any help on the concept would be appreciated.

Hi, I can't figure out how to get rid of this certain SQL syntax error when going to userlist.php.

Now, I've found Line 157, but I can't make out any syntax error, although I'm a newbie when it comes to SQL syntax. Line 157 is:

$result = $db->query('SELECT u.id, u.username, u.title, u.num_posts, u.registered, g.g_id, g.g_user_title, g.g_color FROM '.$db->prefix.'users AS u LEFT JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id WHERE u.id>1'.(!empty($where_sql) ? ' AND '.implode(' AND ', $where_sql) : '').'ORDER BY '.$sort_by.' '.$sort_dir.' LIMIT '.$start_from.', 50') or error('Unable to fetch user list', __FILE__, __LINE__, $db->error());

Because the error mentions the "near 'BY username ASC LIMIT 0, 50'" I'm guessing the error is near the only BY I see, along with the 50, so that's why that area is below as well. All help is appreciated. Thanks in advance.

'ORDER BY '.$sort_by.' '.$sort_dir.' LIMIT '.$start_from.', 50')