Php/SQL newbie seeks help :)

I’m trying to send back the last ID of my table to flash…

my php:

$connect = mysql_connect("localhost", "", "");
mysql_select_db("website", $connect);
$result = mysql_query("select count(*) from news")

But i don’t know how to make it put the result from the query into a variable that i can load with flash using something like

myData = new LoadVars();
myData.onLoad = function(succes) {
	if (succes) {
		_root.myid = "My last ID is:" + myData.??

can anyone help me??

TiA :toad: