I have a database and have made the php page so that it appears as a web page, but there is something kind of screwy with the resulting html page.
At the top of the page, starting at the left, and scrolling really far to the right, is tons of the "<" character. It looks like "<<<<<<<<<<<" only 100 times longer, lol.
My php code is below, and would be really thankful if anyone could tell me how to get rid of the carrot sign.
<?
//connect to database using the mysql_connect function()
//This is your host and then your username and then finally your password
$db = mysql_connect("localhost","username","password");
//The function mysql_select_db() sets the current
//database to the one specified in this case "test"
mysql_select_db("bioimages" ,$db);
//mysql_query() execute the specified MySQL query in this case
//we are are storing this in the variable $sql
$sql = mysql_query("SELECT * FROM herbplants order by 'Scientific Name'" ,$db);
//now we wil start producing a table
echo ("<table border ='1'>");
//this part displays our headings
echo ("<tr><td>Picture</td><td>Scientific Name</td><td>Common Name</td><td>Family Name</td><td>Page Number in Guide</td><td>Start Bloom</td><td>Stop Bloom</td><td>Origin</td><td>Synonyms</td></tr>");
//the mysql_fetch_row() function fetches the next row in the resultset
//and stores this in an array , in this case $tablerows
while ($tablerows = mysql_fetch_row($sql))
{
//we now finish our table off by inserting values into each
//column . $tablerows[1] is equivalent to our url field and
//$tablerows[2] is the description field
echo("<tr><td><img src=\"$tablerows[9]\"><td><i><a href=\"$tablerows[10]\">$tablerows[1]</a></i></td><td>$tablerows[2]</td><td>$tablerows[3]</td><td>$tablerows[4]</td><td>$tablerows[5]</td><td>$tablerows[6]</td><td>$tablerows[7]</td><td>$tablerows[8]</td><</tr> ");
}
echo "</table>";
//close database (good practice)
mysql_close($db);
?>
