Posted by "Tom Ray [Lists]" on 08/04/05 07:53

George-

Without seeing your code it's hard to say what the problem is. There
could be a typo, a missing quote or semi colon. The code snippet of the
review page would be helpful.

Now when you say it's entering "blanks" into the database, I'm assuming
you have a messageID field in the db that auto increments in some way,
and that you're seeing a new messageID generated and the remaining
fields are blank? If that's the case perhaps you're delcaring those
variables without data some where in your script. I would need to see
your code in order to tell you better.

Assuming everything is good, you need to pass your data from the check
message page to your submit page by POST so hidden fields would be good.
I'm also noticing that you're not escaping your data before you insert
it into the database. This could be bad as quotations, apostrophes, and
the such will cause your insert command to fail. Try this:

$username=mysql_escape_string($username);
$name=mysql_escape_string($name);
$message=mysql_escape_string($message);

mysql_query("INSERT INTO forum (user,name,message) VALUES ('$username',
'$name', '$message')") or die("Insert Failed");

You should have some debuging built into your script so you can see
where it errors out. Have you watched your mysql log file to see what
happens during your query? Do you actaully the query happen in the log
file? Or do you not have access to it?

Posting your code and any errors would help us figure out what the real
problem is.

George B wrote:

> I am coding a message board. I am about done. I have all the forms
> needed for the message. So it all works out. The user types in his
> name, message title, and the message itself. Then clicks submit. The
> Submit button takes him to the message check. The message check shows
> all the stuff the user entered. Then it has "echo" which says 'Is this
> correct'? And then there is a button. "Yes" When the user clicks yes
> it goes to another PHP file which runs the SQL query to put in the
> entereddata into the database
> $query = "INSERT INTO forum (user,name,message) VALUES
> ('$username','$name','$message')";
> $result = mysql_query($query);
>
> But see, the problem is that it is entering blanks into the DB. I
> think that is because the $username $name and $message are in the
> other file? I have no idea how to by-pass this problem. What should I do?
>

[Back to original message]