i want the max

[yolop]

$select_winner = mysql_query("SELECT  max(vote), userid,text FROM poll order by vote  ");

$read_winner = mysql_fetch_array($select_winner);

$text = $read_winner['text'];

echo $text;

 

but error

 

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

 

why??

[Mchl]

But what you want to get?

'text' is mysql reserved word. You should enclose it in `` in your queries

Change

$select_winner = mysql_query("SELECT  max(vote), userid,text FROM poll order by vote  ");

to

$select_winner = mysql_query("SELECT  max(vote), userid,`text` FROM poll order by vote  ") or die(mysql_error());

 

this will show any other mysql error messages.

[xtopolis]

Using MAX() in a query requires the GROUP BY clause.

http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html

 

So you could group by .. userid maybe?  Don't know what result set you're aiming for.

$select_winner = mysql_query("SELECT MAX(vote), userid, `text` FROM poll GROUP BY userid ORDER BY vote");

 

Also, like Mchl said, text is a reserved word, so I would rename the column.