TalkPHP - View Single Post

DeMo · 11-03-2008, 05:26 PM

POINT is a undocumented (?) data type in MySQL.

Try this:

PHP Code:


			
$val = mysql_query("SELECT MAX(`point`) AS maxpoint FROM `points`");

while ($able = mysql_fetch_array($val))

    echo $able['maxpoint'] . "<br />";

Or an alternative would be this query:

PHP Code:


			
"SELECT `point` AS maxpoint FROM `points` ORDER BY `point` DESC LIMIT 1"

11-03-2008, 05:26 PM	#8 (permalink)
DeMo The Contributor Join Date: Jan 2008 Location: Brazil Posts: 77 Thanks: 14	POINT is a undocumented (?) data type in MySQL. Try this: PHP Code: $val = mysql_query("SELECT MAX(`point`) AS maxpoint FROM `points`"); while ($able = mysql_fetch_array($val)) echo $able['maxpoint'] . "<br />"; Or an alternative would be this query: PHP Code: "SELECT `point` AS maxpoint FROM `points` ORDER BY `point` DESC LIMIT 1"