Hi I am new to this list.
I am in need of some help or direction.
I am new to php and databases, so forgive me if my request seems too simple.

I am making a database if users and have had much success in getting it to work however, not all my data is getting shown once I try to display results. I am running an INSERT query that inputs data into the database from a form. But here is the hiccup. I am asigning the form data to a $variable.

Eg:  $Username = $_POST['Username'];

I then run $Username through some checks to make sure it's not an injection. After all that I want to insert it into the database. This works fine if I use:

$query = "INSERT INTO users (Username, UserEmail, etc)

VALUES ('".$_POST['Username']."', '".$_POST['UserEmail']."', etc)";

And it works if I use

VALUES ('".$Username."', '".$UserEmail."', etc)";

However I have some variables that are not posted from the form and in the first example, it does not insert those in the database.

In the second, it will insert them into the database, but when I go to display them it is saying there are no records to retrieve. ???? I looked at the database in phpMySql and they are there. It will only display them in the results page if they had been inserted using $_POST. Is this normal? What is the best way to $_POST a $Variable. Something like $_POST [$Username] (which doesn't work).

Any help would be greatly appreciated.

Design Drumm

Sent from losPhone

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to