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

problem with php mysql query
Hi guy's...

I'm totally lost here..because don't have any idea how to make a query for grab r

Need help making a blockquote and line items conditional
I have some code I bought a few years ago that allows my clients to update content on their site usi

empty() error
Why does

Code: empty($USER_ID = $_SESSION["USER_ID"])
create this error...

Seperate team from score
I am writing a site that does a NFL Pick 'em type application and I have a feed that gives me the sc

PHP and MySQL on intranet?
Is it possible to use both these on an intranet network?

Solution Manager BPR
Does the SolMan-BPR-ARIS-Integration (http://www.ids-scheer.com/en/ARIS/ARIS_Platform/ARIS_Business_

How to form a xml form table with a single sql statement..?
Hi everyone,
I don't know if this is going to be a duplicate thread but i couldn't

dynamic table with forms
I have a table that is populated with mysql data and in teh first column there is a raido button tha

Mail form doesn't send Russian/Cyrillic characters correctly?
When someone enters foreign characters (like Cyrillic text, and Japanese/Chinese probably gives the

Schedule editor
Hi,

I have a question related to Schedule editor.
If we schedule a BLS for every 30