Php/SQL newbie seeks help :)

programming
1

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

my php:


<?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.load("http://localhost:8080/id.php");
myData.onLoad = function(succes) {
	if (succes) {
		_root.myid = "My last ID is:" + myData.??
		trace(_root.myid);

can anyone help me??

TiA :toad: