Select top row of MySQL query

[rfighter]

Hi,

 

How can I select the top row of a MySQL query, without changing this select syntax:

 

$newq = mysql_query("SELECT * FROM threadread WHERE userid = '$logged[id]' AND threadid = '$threadid' ORDER BY readtime DESC");

 

Thanks!

[MasterACE14]

what do you mean by 'top row' ?

[rfighter]

The first row of the result of that select.

[MasterACE14]

I'm still not completely sure what you mean. But maybe your looking for 'LIMIT'

 

<?php
$newq = mysql_query("SELECT * FROM threadread WHERE userid = '$logged[id]' AND threadid =    '$threadid' ORDER BY readtime DESC LIMIT 10");

[rfighter]

I'm still not completely sure what you mean. But maybe your looking for 'LIMIT'

 

<?php
$newq = mysql_query("SELECT * FROM threadread WHERE userid = '$logged[id]' AND threadid =    '$threadid' ORDER BY readtime DESC LIMIT 10");

 

I would use that, and that is what I mean, but I also need to do a num_rows, to check if there are no results, and using a num_rows with a LIMIT returns a T_Variable error, so is there any other way please?

[.josh]

post the code where you're trying to do num_rows because the query string is valid (except for the fact that you said you want just 1, not 10, so it would be "...desc limit 1")

[rfighter]

post the code where you're trying to do num_rows because the query string is valid (except for the fact that you said you want just 1, not 10, so it would be "...desc limit 1")

 

		$newq = mysql_query("SELECT * FROM threadread WHERE userid = '$logged[id]' AND threadid = 	'$threadid' ORDER BY readtime DESC LIMIT 0,1");

	$numrows = mysql_num_rows($newq);

	$newarray = $mysql_fetch_array($newq);

 

The error now is: Fatal error: Call to undefined function: () in /home/xxx/public_html/newposts.php on line 44

 

 

Line 44 is "$newarray = $mysql_fetch_array...."

 

EDIT: I realise what's wrong. I put a $ in front of mysql_fetch_array

[.josh]

well the only error I see there is you forgot the ; at the end of your fetch_array ...