PHP Beginners Help
| From: | Ben Stones | Date: | Thu, 03 Jan 2008 02:57:00 +0000 |
| Subject: | PHP Beginners Help | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44469@lists.php.net to get a copy of this message | ||
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.