If a stored procedure is doing all the work for you and you just need to retrieve a single cell...
<?php
$db = sybase_connect("sybtest", "sa", "users");
$query = sybase_query("EXEC usp_get_id @username='$username'", $db);
$id = sybase_result($query,0,0);
echo $id;
?>
Simple.