This isn't working for me:
$query = mysql_query(" SELECT max(id) FROM chat_records "); while ($row = mysql_fetch_assoc($query)) { echo $row['id']; }
How can I get it to work?
Change your query to this:
SELECT max(id) AS id FROM chat_records