Check before inserting in DB ???

Posted on 16th Feb 2014 07:03 pm by admin

This is my code
---------------
if ( $_POST ['Submit'])
{{
$username = $_POST ['usernm'];
$userpassword = $_POST ['userpw'];
}
/*insert data from the form into the db table*/

$querypost = mysql_query ("INSERT INTO users (usernm, userpw) VALUES ('$username','$userpassword')");
}
?>

How do I check before inserting whether that username and password is already inserted. I have an id assigned to every entry.

Your Answer:

Login to answer

Other forums

Mouseover to edit (Ajax)
hi friends, can anyone help with the code behind to get this application working, please in VB (new

Working with Global Variables
hi, I'm not really sure why the following code is returning a "Call to a member function getBan

mysqli_fetch_assoc returns multiple arrays, how to return a single array
Hello, I am using mysqli_fetch_assoc which is returning multiple rows, so it looks like:

Code

Coding question?
Hey guys, I have a quick question. If I want to make a way for people to pay for health in my game,

News script
Hi ...

I am not sure if this is the rite place to post this but if its not sorry

i am

TimeStamp Column Problem...
I'm mad at my self and thinking I'm a little retarded. It just be some one mistake I'm missing here.

Batch Related Pricing
Hi, I need some clarity on the batch related pricing

For example the following are the b

Help with translating C code into assembler code
Hi im doing a project that moves a robot around a maze avoiding walls and need some help with conver

need a script for 3 pages
I have a customer who wants me to set up a site with a number of pages with the following requiremen

php - xml what is the best way to do this.
IN essence I want to have a script calling the info from the database.. I have no problem thus far,