Re: php w/mysql backend. Getting a layout to work with the db selected info

[Bob Field]

Maybe this will help:

<?php
mysql_connect("server", "user", "password") or die ("Connect failed " . mysql_error());
$query = "SELECT something FROM yourdatabase";
$result = mysql_query($query) or die ("Invalid query: " . mysql_error() . " Whole query: " . $query);
$row = mysql_fetch_assoc($result)
if (!$row) die ("No results returned");
?>

At this point you have $row which is an array of values for the columns of the resultset from your query. Note this is only the first row of the resultset, if there are more rows you'll need to loop and call mysql_fetch_assoc() again.