I have a problem:

Have a look at

http://216.74.101.27/test.php

Now, either it is not working because the name hasn't been transfered yet or i have something wrong.

I am just copying the article supplied at Sitepoint to test MySQL out:


<HTML><HEAD><TITLE> Our List of Jokes </TITLE><HEAD><BODY>

<?php
$cnx = mysql_connect( "216.74.101.27", "*****", "*****");
if (!$cnx) {
echo( "<P><B>Unable to connect to the database server at this time.</B></P>" );
exit();}


mysql_select_db("petesmc_articles", $cnx);
if (! @mysql_select_db("petesmc_articles") ) {
echo( "<P>Unable to locate the joke database at this time.</P>" );
exit();}

if (! @mysql_select_db("petesmc_articles") ) {
echo( "<P>Unable to locate the joke database at this time.</P>" );
exit(); }
?>

<P> Here are all the jokes in our database: </P><BLOCKQUOTE>

<?php // Request the text of all the jokes
$result = mysql_query("SELECT JokeText FROM petesmc_articles");
if (!$result) {
echo("<P>Error performing query: " . mysql_error() . "</P>");
exit(); }

// Display the text of each joke in a paragraph
while ( $row = mysql_fetch_array($result) ) {
echo("<P><table width=50% border=3 bordercolor=blue><tr><td>" . $row["JokeText"] . "</td></tr></table></P>"); }
?>

</BLOCKQUOTE></BODY></HTML>





Any ideas?