Member Avatar for leprakhauns

<form action="php.php?b=<?php echo $b; ?>" method="post">

Enter your news/rumor:
<input type="text" name="name" />
Enter your news/rumor:
<input type="text" name="website" />
Enter your news/rumor:
<input type="text" name="comment" />
<input type="submit" />
</form><br />

then on php.php:

$t=$_GET["b"];
mysql_connect("db.lepslair.com", "username", "my password");
mysql_select_db("lepslair");
mysql_query("INSERT INTO nonmembers($name, $website, $comment)) VALUES(name, website, post_text) ");

I'm not getting any errors thrown at me, but the database doesn't retain any of the information.

  • 2 Contributors
  • 2 Replies
  • 134 Views
  • 16 Hours Discussion Span
  • Latest Post Latest Post by leprakhauns
Member Avatar for sarahk

this line

mysql_query("INSERT INTO nonmembers($name, $website, $comment)) VALUES(name, website, post_text) ");

should read

mysql_query("INSERT INTO nonmembers (name, website, post_text) VALUES ('$name', '$website', '$comment')");

or to be really good

$sql = "INSERT INTO `nonmembers` (`name`, `website`, `post_text`) VALUES ('{$name}', '{$website}', '{$comment}');
mysql_query($sql) or die(mysql_error() . '<br>' . $sql);
Member Avatar for leprakhauns

LMAO I should have known that, thanks for pointing it out. It works now thanks a lot.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.