[OpenLayers-Users] PHP/postgreSQL tab delimited text issues.

[MATTHEW J PURDY]

Hey, 
I'm trying to dynamically load points/markers using php and the openLayer.text method. 

I'm having trouble getting anything to display, and I think it might be aformatting thing. 

does anybody have an example of this? here is what I'm doing 

the php.
:

<?php

header('Content-Type: text/plain');

echo "point    title    description    icon\n";
$db_conn = pg_connect ("host=xxxxxx port=xxxxx dbname=xxxx user=xxxxxx password=xxxxxx");

$qu = pg_exec ($db_conn, "SELECT xxxxx.* from xxxx order by xxxxx.row_id asc;");

while ($data = pg_fetch_object ($qu)) {
srand((double)microtime()*1000000);
$value = (rand(0,100)*.95);
$num = $data->short_name;
$x = $data->fixed_latitude;
$y = $data->fixed_longitude;
$measuring = 'water_level';

echo "$x,-$y   $num   <span class='loc'>Location: $data->long_name</span><br/><span class='meas'>Measurement: $measuring</span><br/><span class='val'>Value: $value</span><br/><span class='t'>Time:12:00:00</span><br/>   icon_buoy.gif\n";

}
?>

implemented here in the html.
var newl = new OpenLayers.Layer.Text( "Water", {location: "ol2.php"} );
            newl.setVisibility(false);
		map.addLayer(newl);

thanks.