Hey. I have yet another problem with MySQL. Basically, I have a website about poems and users can submit their own which then go into the database. However, I have a page which displays the title and the author but I want the title to be a link to the poem. How can I do this? Help is, like always, much apreciated
Here is the code I have
Here is the code I have
PHP:
$result = mysql_query( "SELECT id, title, author, date FROM poems" )
or die("SELECT Error: ".mysql_error());
$num_rows = mysql_num_rows($result);
echo "There are $num_rows poems.<P>";
echo "<table width=200 border=0>\n";
while ($get_info = mysql_fetch_row($result)){
echo "<tr>\n";
foreach ($get_info as $field)
echo "\t<td><font face=arial size=1/>$field</font></td>\n";
echo "</tr>\n";
}
echo "</table>\n";
Last edited:
