frankb3 - 3:58 pm on May 19, 2011 (gmt 0)

I have successfully connected mySQL db to my web site with a Filemaker front end. Lots of trial and error, but it's working.

I need some formatting help if possible.

-Combining the content of three data fields into one field in my resulting table.

-Have the first two fields reside on the first line, and the third field starting on the second line

-Stylize the text and color on the first two fields
-Stylize the table to be dotted apposed to solid.
(any on another note) how to accept photos into mySQL. That's not working.

Here's my code so far:

<?php
$con = mysql_connect (info));
}

mysql_select_db("my database", $con);

$result = mysql_query("SELECT * FROM my_table WHERE Class_Year='2001' AND Deceased='No' ORDER BY Last_Name ASC ");

echo "<table border='1'> <table style='dotted'> (dotted command isn't working)

<tr>
<th>Name</th>
<th>Bio</th>
</tr>";

while($row = mysql_fetch_array($result))
{
echo "<tr>";

echo "<td>" . $row['Directory_Listing_Name_Year'] . "</td>";
echo "<td>" . $row['Directory_Listing_03'] . "</td>";
echo "</tr>";
}
echo "</table>";

mysql_close($con);
?>