i love php but php loves mysql and mysql hates me

i love php but php loves mysql and mysql hates me

Post by kkddrp » Mon, 20 Nov 2006 01:59:53


he database looks like this

the database is called
username_tpp (not really just using username as a sub)
the table is called
home
it has
field 1 : varchar(50) | latin1_swedish_ci | no attributes | null = no |
default = (nothing) | extra = (nothing) | action = primary key |
comments = h

field 2 : text | latin1_swedish_ci | no attributes | null = no |
default = (nothing) | extra = (nothing) | action = text | comments = b

all i am trying to achive is to have someone post what they want to
appear on their website on this page as in the header and the body of
their site (i will do xhtml formating to make it look nicer if the
script ever works)

<?php // update_site.php
// This script adds a entry to the database.

// Address error handling.
ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);

if (isset ($_POST['submit'])) { // Handle the form.

// Connect and select.
if ($dbc = @mysql_connect ('localhost', username', password)) {

if (!@mysql_select_db ('username_tpp')) {
die ('<p>Could not select the database because:
<b>' . mysql_error()
. '</b></p>');
}

} else {
die ('<p>Could not connect to MySQL because: <b>' .
mysql_error() .
'</b></p>');
}

// Define the query.
$query = "INSERT INTO home (1) VALUE ('{$_POST['header']}')";
"INSERT
INTO home (2) VALUE '{$_POST['body']}'";

// Execute the query.
if (@mysql_query ($query)) {
print '<p>The blog entry has been added.</p>';
} else {
print "<p>Could not add the entry because: <b>" .
mysql_error() .
"</b>. The query was $query.</p>";
}

mysql_close();

}

// Display the form.
?>
<form action="update_site.php" method="post">
<p>Page Header: <input type="text" name="header" size="40"
maxsize="100" /></p>
<p>Page Body :  
<textarea name="body" cols="40" rows="5"></textarea></p>
<input type="submit" name="submit" value="Update My Website" />
</form>

i get this error...

Could not add the entry because: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near '1) VALUE ('hello')' at line 1. The query was
INSERT INTO home (1) VALUE ('hello').

then i have another script that is not working
either which is:

this is the script for their home page that retirves the data that this
one posts into the table.

<?php // index.php
// This script retrieves header and body text from the database.

// Address error handing.
ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);

// Connect and select.
if ($dbc = @mysql_connect ('localhost', 'username', 'password')) {

if (!@mysql_select_db ('username_tpp')) {
die ('<p>Could select the database because: <b>' .
mysql_error() .
'</b></p>');
}

} else {

die ('<p>Could not connect to MySQL because: <b>' .
mysql_error() .
'</b></p>');

}

// Define the query.
$query = 'SELECT * FROM home';

if ($r = mysql_query ($query)) { // Run the query.


// Retrieve and print every record.
while ($row
 
 
 

i love php but php loves mysql and mysql hates me

Post by peterspr » Tue, 21 Nov 2006 08:44:20

gt; INSERT INTO home (1) VALUE ('hello').

May be a typo. Try something like:

insert into home (theColumnName) values ('hello')

What's the second error you were getting?

XXXX@XXXXX.COM wrote: