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

split values
I have values that are returned to me in this format:

name=>test,age=>49

ASP.NET 2.0 - Enter Key - Default Submit Button
Hi,One of the most annoying things in developing web pages is handling the "Enter key" for form subm

How can use this array as a key?
Say I have this array for example:


print_r($array);

Prints:
Code: [Select]Array

UDP server recvfrom() always returns -1? :(
Hello all,
I am getting a very strange error in my code :( I am writing a server application in C

Parse XML
Good day,

I use oempro software and try to parse XMLReturn but it's not working for me, simpl

Preg_match question
I want to use preg_match to make sure a string is always 6 characters long and only contains 0-9 and

fopen() security
As i understood the usage of fopen() for it to function correctly the Dir you write to has to be rw

Upload simple problem
Really confused!! I run once and it worked, but when i tried today...it didn't work

Which par

How would I convert this into code using an if statement?
ES equals exam score m equals $mean s equals $total. I already coded my mean and total so I'm not g

Force download script not handling files with spaces properly
I have a regular old php force download script, uses this code:

Code: header("Cache-Cont