[RESOLVED] Query failed

[ausgezeichnete]

i got this error when am doing this
and cantfind the problem

<?php session_start();
require "forum.inc.php";
if(!$logged_userID){
fail("not logged","true");
}
setup_page("Great Debate","Topic for debate");
$thread_per_page=12;
if(!$thread_list_offset){$thread_list_offset=1;}
$thread_list_offset +=$increment * $thread_per_page;
session_register("thread_list_offset");
	$conn=mysqli_connect("localhost","root","","forum");
		$query=mysqli_query($conn,
		"select thread.title,thread.threadID ,MAX(posts.dateposted) as latest 
		from thread ,posts where thread.threadID =posts.threadID
		group by thread.threadID order by desc
		limit" .($thread_list_offset-1).",".$thread_per_page  );
		if(!$query){
			fail("Query failed","true");
			echo mysqli_error($conn);
			}

[Piranha]

ausgezeichnete wrote:

i got this error when am doing this
and cantfind the problem

What error do you get? It is better to post errors, then it is possible to check only what the error says. Also mark what row the error is in.

[ausgezeichnete]

i only got that:

Query failed

[ausgezeichnete]

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 'desc limit 0,12' at line 3
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in D:\wamp\www\Forum\forummain.php on line 22

usermahaLogout

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in D:\wamp\www\Forum\forummain.php on line 28
Thread title Last Post on..

[rincewind456]

You should be using [man]mysqli_error/man if you want to get a useful error report.

You need to specify what the limit is, like

LIMIT 0,10

[ausgezeichnete]

am specifying it here as

.($thread_list_offset-1).",".$thread_per_page

[ausgezeichnete]

when its like that it works
$query=mysqli_query($conn,
"select thread.title,thread.threadID ,MAX(posts.dateposted) as latest
from thread ,posts where thread.threadID =posts.threadID
group by thread.threadID " );

[ausgezeichnete]

so the problem is in the rest of sql statement i guess

[rincewind456]

You haven't stated what you want to

ORDER BY

For example

ORDER BY thread.threadID DESC

[ausgezeichnete]

i have stated it as
order by desc

[ausgezeichnete]

ok i will try it by field name

[ausgezeichnete]

$query=mysqli_query($conn,
"select thread.title,thread.threadID ,MAX(posts.dateposted) as latest
from thread ,posts where thread.threadID =posts.threadID
group by thread.threadID order by latest desc limit"
.($thread_list_offset-1).",".$thread_per_page );

and i got that:
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 'limit0,12' at line 3

[ausgezeichnete]

thnxxxxxx it workeddd noww

[bradgrafelman]

Don't forget to mark this thread resolved.