mysql + select + top ???

teddmcload

i can select the data from database using top like that:

select top 5 title, news_date where active='1'

but i cann't write the data to the web page?

i tried to use

while ($row=mysql_fetch_array($result)) {
echo ...
...
...
}

but it didn't work. it says

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource

what must i do?

LordShryku

you must show us your code. I'ts blowing up on mysql_fetch_object(), but you're not showing us where you call that

teddmcload

here is the codes...

<?
dbconn();
$sql = "SELECT TOP 5 shortid, sdate, title FROM shortly WHERE active='1' ORDER BY shortid DESC";
$result = mysql_db_query("portal", $sql);

while ($row = mysql_fetch_object($result)) {
echo $row[shortid] . $row[title];
echo "<br>";
}
?>

LordShryku

and what does it say when you use mysql_fetch_array instead of mysql_fetch_object?

teddmcload

it says

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource

any idea?

LordShryku

Then you're editing the wrong page, or it's not taking the edit. If it still sees mysql_fetch_object AFTER you've changed it, something is wrong.

teddmcload

problem continues

i am using mysql 3.23.53

but i found that the source of this error is relation with "top".

what must be the select string?

if i delete the "top 5" from sql string i works !!!

LordShryku

Well searching through the Mysql site, I don't see any metion of this. What are you trying to get? How do you expect to get "Top 5"? Did you just want to pull the first 5 records?

teddmcload

nearly.

i want to select some data which is like below.

there are an active columns and shortid. the criters are active=1. and also i want to order by short id desc. i select some data from database. but i want first of them.

the sql string like is this:

$sql = "SELECT * FROM shortly WHERE active='1' ORDER BY shortid DESC";

but i select lots of data. i want just first of them. how can i get and how can i write them to the web page?

LordShryku

Okay, to just get the first five, change your SQL to

SELECT *
FROM shortly
WHERE active='1'
ORDER BY shortid DESC
LIMIT 5

To write it to the page, search the forums. Already been answered a million times

teddmcload

thank u very much