Hi ben,
You are creating the same table each time you run the code which would throw an error the second time you run the code since the table is already there.
You have two choices here:
1. remove the table creation script and the call to create it since the table only needs to be created once.
2. handle the errors that can happen on running a query. ex.
$mysql_query_one = mysql_query("SELECT * FROM `comments`") or die(mysql_error());
bastien> Date: Thu, 3 Jan 2008 02:57:00 +0000> From: bastones@xxxxxxxxxxxxxx> To: php-db@xxxxxxxxxxxxx> Subject: PHP Beginners Help> > Hello, my name is Ben Stones. I am quite a beginner to PHP, and as a new> years resolution I am going to learn PHP (finally!)> > Cut to the chase I have created a basic looping script that would display> anything submitted in a form, on seperate lines; here is the PHP code:> > $con = mysql_connect("localhost","ben_test","------removed-----") or> die("con");> $db = mysql_select_db("ben_test") or die("db");> mysql_query("CREATE TABLE `comments` (messages varchar(255))");> $comments = $_POST['comment'];> $sql1 = mysql_query("INSERT INTO `comments` (`messages`) VALUES> ($comments)");> $mysql_query_one = mysql_query("SELECT * FROM `comments`");> while($rows=mysql_fetch_array($mysql_query_one)) {> echo $rows['messages'] . "[br /]";> }> > Everything went swell for the first half, and after I truncated the test> messages (or everything in the column, if you like), I tried doing one more> test run and upon clicking 'Submit', nothing would display except the> messages I added via phpMyAdmin.> > Hope someone could help me.> > PS: The password has been edited out of the preceding code as well as the> HTML code purposely for the mailing list.
_________________________________________________________________
Introducing the City @ Live! Take a tour!
http://getyourliveid.ca/?icid=LIVEIDENCA006
