need help inserting data

phpn00bf4life

<html>
<?php
//connect to the mysql
$db = mysql_connect("cwhq.net","admin123","****");

//select database
mysql_select_db("General",$db);


$sql = ("INSERT INTO shoutbox (name,website,comments) VALUES ('$name', '$website', '$comments');


$result = mysql_query($sql);

?>
<form method="post" action="http://icihost.cwhq.net/phptest/bt/shout.php">
  <input type="text" name="name" size="20" value="&lt;name&gt;" style="border-style: solid; border-width: 1"></p>
  <div style="width: 148; height: 9">
    <input type="text" name="website" size="20" value="&lt;website&gt;" style="border-style: solid; border-width: 1"></div>
  <p>
  <input type="text" name="comments" size="20" value="&lt;comments&gt;" style="border-style: solid; border-width: 1"></p>
  <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  <input type="submit" value="Shout" name="B1" style="border-style: solid; border-width: 1">
  </p>
  <p><font size="1">&lt;b&gt;bolded characters here&lt;/b&gt; will make characters bold</font></p>
  <p><font size="1">&lt;i&gt;will make italics here&lt;/i&gt;</font></p>
  <p><font size="1">&lt;u&gt;will make underlined words here&lt;/i&gt;</font></p>
</form>
</html>

what's in the hell is my error...i keep getting this error: Parse error: parse error, unexpected T_STRING in /www/htdocs/zp/phptest/bt/shout.php on line 18

fean0r

change

$sql = ("INSERT INTO shoutbox (name,website,comments) VALUES ('$name', '$website', '$comments');

$sql = ("INSERT INTO shoutbox (name,website,comments) VALUES ('$name', '$website', '$comments')");

phpn00bf4life

thank you...but it's still not inserting into the database is there something i should do about that, is there a error?

fean0r

Are you still getting that error msg?

also you should add some error checking code incase its not connecting to the database.

phpn00bf4life

ok i will :S no error message it just won't insert into the database

iTZKooPA

add this code after you try connecting to the database:


if (!$db) {
      die( '<p>Unable to connect to the ' .
           'database server at this time.</p>' );
    }

Just to make sure it is actually connecting to the database.