Strange error I know im missing somthing.

[Paragon]

anyone know whats wrong with this I get an error. on the last line. If I take it away I get an error on the 2nd to last.

I have an include config.php so I know it connects.

mysql_connect($host,$user,$pass) or die(mysql_error());
mysql_select_db($db) or die(mysql_error());
$add_all = "INSERT INTO $table VALUES('$uname','$ucomment','$ip','$time','','$imagecat')";
mysql_query($add_all) or die(mysql_error());

[laserlight]

What error do you get?

[Paragon]

none it just doesnt insert the data.

[laserlight]

Where are the variables coming from?

$uname, $ucomment etc

Could be that they contain null values.

[Paragon]

<?   

include('config.php');	
?>
<?
$host = "$dbhost"; 
$user = "$dbusername";
$pass = "$dbpassword";
$db = "$dbname";
$table = "COMMENT";
$show_all = "SELECT * FROM $table";

mysql_connect($host,$user,$pass) or die(mysql_error());
mysql_select_db($db)or die(mysql_error());
$result = mysql_query($show_all) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
$view_db .= "Poster: ".$row["uname"]."<br>";
$view_db .= "Comment: ".$row["ucomment"]."<br>";
$view_db .= "Time: ".$row["time"]."<br>";
$view_db .= "id: ".$row["id"]."<br><br>";
$view_db .= "Image: <img src=images/$row[imagecat]><BR><BR>";
}  

?>
<? 
$ip = getenv("REMOTE_ADDR");
$time = date("D M j"); 
$dirL = "http://shanksta.com/images/";
$absolute_path = "/home/shanksta/public_html/images/";


if(isset($_GET['commented']))
{ 

// Tell the user it has been submitted (optional) 

// Set global variables to easier names
$uname = $_GET['uname']; 
$ucomment = $_GET['ucomment']; 
$imagecat = $_GET['imagecat'];

// Connect to Mysql, select the correct database, and run teh query which adds the data gathered from the form into the database
mysql_connect($host,$user,$pass) or die(mysql_error());
mysql_select_db($db) or die(mysql_error());
$add_all = "INSERT INTO $table VALUES('$uname','$ucomment','$ip','$time','','$imagecat')";
mysql_query($add_all) or die(mysql_error());
}
else
{

// If the form has not been submitted, display it
?>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="24%" id="AutoNumber1" height="120">
  <tr>
    <td width="100%" height="19">
    <p align="center">The insane shout - BETA</td>
  </tr>
  <tr>
    <td width="100%" height="19"><? echo("$view_db"); ?></td>
  </tr>
  <tr>
    <td width="100%" height="80">
    <div align="center">
      <center>
      <form method="get" action="<? echo"$PHP_SELF"; ?>">
      <table border="0" cellpadding="0" style="border-collapse: collapse" width="95%" id="AutoNumber2" cellspacing="5">
        <tr>
          <td width="100%">
          <p align="center">Name : <input type="text" name="uname" size="16"></td>
        </tr>

  <?  

      echo "<select size=1 name=imagecat>";
  $dir = opendir($absolute_path);
    while($file = readdir($dir)) {
    if (($file != "..") and ($file != ".")) {

$list .= "<option value=$dirL/$file>$file</option>";
}
}
echo $list;
echo  "</select>";
    ?>
        <tr>
          <td width="100%">Comment : <textarea rows="1" name="ucomment" type="text" cols="13">
</textarea></td>
        </tr>
        <tr>
          <td width="100%">
          <p align="center">
<input type="submit" value="Post"></td>
        </tr>
      </table>
      </center>
    </div>
    </td>
  </tr>
</table>
</form> 
<?
}
?>

Thats the whole page.

[Paragon]

ok hahah I got it.