Re: i love php but php loves mysql and mysql hates me

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?

kkddrpg@xxxxxxxxx wrote:
the 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 :&nbsp;&nbsp;
<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.

this is not in the actual script but im sure this is where im going wrong<<<<<<

// Retrieve and print every record.
while ($row = mysql_fetch_array ($r)) {
print "<p><h3>{$row['1']}</h3>
{$row['2']}<br />
</p><hr />\n";
}

} else { // Query didn't run.

die ('<p>Could create the table because: <b>' . mysql_error() .
"</b>.
The query was $query.</p>");

} // End of query IF.

mysql_close(); // Close the database connection.
?>

could you please help me ive been debugging for days now and my head is
going to explode

-thank you, philip (kirewire.com, leetmachines.com, pealtech.com,
leetbargains.com)

.

Relevant Pages

  • PHP+informix -922, -25582 errors
    ... User apache ... I have simple script i.php with simple query to database: ... Unable to connect to Informix Database ...
    (alt.php)
  • Re: [PHP] Newbie question, Which way is best?
    ... When the form calls the script it passes all the parameters that the script ... SELECT query, as is, back to the same script with a way to change just the ... As a relative newbie my self I think I understand what you are trying to do. ... If potental attackers have access to your field names they can much easier try and insert stuff into your database. ...
    (php.general)
  • Re: Query Help
    ... > objects in any database. ... that parcitular script is executed, I somehow tought that it shouln't put it ... Unless I misunderstand your tables and query, ... I have seen execution plans where the subquery gets ...
    (microsoft.public.sqlserver.programming)
  • Re: Automatic Scheduled Import
    ... query to import the data I'd write a script using the DAO library to ... create and execute the query without using Access itself; ... trouble of installing Access on the server). ... >I have a database on a shared server. ...
    (microsoft.public.access.externaldata)
  • i love php but php loves mysql and mysql hates me
    ... the database looks like this ... // This script adds a entry to the database. ... // Execute the query. ... // This script retrieves header and body text from the database. ...
    (php.general)