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

FPDF Help
I've been playing with the FPDF module. I was building a form and rolling right along and then sudde

Why does first ever HttpSendRequest take longer?
I promise this isn't as simple as it sounds. I'm wondering why the the first ever call to HttpSendRe

PHP not creating file.
Its supposed to create a .ini file in the /scriptfiles/users/ with the name they entered into the fi

Need Successful Return
Hello I am currently working a form here, and I have everything figured out except when I click the

IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying

Images outside webroot
Im hopeing someone can help me with this because i cant figure it out.I have setup an ASP.NET websit

FTP Programs
Here is a list of commonly suggested FTP Programs to use:

FileZilla
SmartFTP
CuteFTP

search query in mysql in php problem
my search query wont work, i know, that my codes are correct.please help

Code: [Select]&l

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

Share admin accross websites
I'm using .net memberships and roles in one of my sites, but I need to be able to share logins and p