poop (mysql) *RESOLVED*

**morrowasted** · Sep 18th, 2003, 07:54 PM

PHP:
--------------------------------------------------------------------------------

<?php
$username = "morrowasted";
$password = "[edited]";
$hostname = "localhost";
$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
print "Connected to MySQL<br>";
$selected = mysql_select_db("www",$dbh)
or die("Could not select first_test");
if (mysql_query("insert into people values('4','$name1','$post1')")) {
print "successfully inserted record";
}
else {
print "Failed to insert record";
}
mysql_close($dbh);

mysql_close($dbh);

?>

--------------------------------------------------------------------------------

PHP:
--------------------------------------------------------------------------------

<?php
$username = "morrowasted";
$password = "[edited]";
$hostname = "localhost";
$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
$selected = mysql_select_db("www",$dbh)
or die("Could not select first_test");
$result = mysql_query("SELECT id, name,post FROM people");
while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
echo "<div style='background:black;font:10pt;color:white'>";
echo "<center>";
print " Name:".$row{'name'}." <br>Comment:
".$row{'post'}."<br><br>";
echo "</center>";
print "</div>";

}

mysql_close($dbh);
?>

--------------------------------------------------------------------------------

PHP:
--------------------------------------------------------------------------------

<html>
<title> Post Comment </title>
</head>
<body bgcolor=black>
<form action="test.php" method="get">
Name: <input type="text" name="name1" value="Enter Username"><br>
Comment: <input type="text" name="post1" value="comment" size="20"><br>
<input type="submit" value="Post">
</form>

--------------------------------------------------------------------------------

everything works except im getting my "Failed to insert record" error (its not inserting it).

**The Hobo** · Sep 18th, 2003, 07:58 PM

Code:

mysql_query("insert into people values('4','$name1','$post1')")

I believe you need to specify field names? Such as:

Code:

mysql_query("INSERT INTO people (id, name, post) VALUES ('4','$name1','$post1')")

Not sure, though. The BEST way to find out what's going on is to do this:

Code:

$result = mysql_query("INSERT INTO people (id, name, post) VALUES ('4','$name1','$post1')") 
   or die(mysql_error());

if ($result) {
    //do your cool stuff here...
} else {
    //echo failed...
}

Then the error will tell you exactly what's not right.

**morrowasted** · Sep 18th, 2003, 08:07 PM

thanks!

**The Hobo** · Sep 18th, 2003, 08:25 PM

Was I right about the field names, or was it something else?

**morrowasted** · Sep 18th, 2003, 08:59 PM

yeah, it was the field names.

**phpman** · Sep 19th, 2003, 05:54 PM

you don't need field names. but you must have all of the values for every field in that table. by default it will add to all, unless you specify fieldnames.

**morrowasted** · Sep 19th, 2003, 11:39 PM

Originally posted by phpman
you don't need field names. but you must have all of the values for every field in that table. by default it will add to all, unless you specify fieldnames.

well, it works, so thats all that matters right now

Thread: poop (mysql) RESOLVED

Thread Tools

Display