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

SAP Logon Failed
I tried to login to SAP through MMC.

When i click start and give password.

it

ob_ dynamic content
i was wondering about the potential to use ob to create a <div then remove it when the page

drop-down with sub-category appear
Hello,

i know how to build a simple dro-down list, im looking for a code when im gonna choose

Remove letter from numeric textbox
I have a textbox that will search the employee database by entering in the employee ID and it will r

How can I Compare two xml documents?
Hi all,

I am doing a POC for my project and I am using XE database 10g version.

Send current URL in URL with a $_GET variable problem.
Hello community,

I have created a function that gets the current variable of a page, example:

explode() function problem maybe
Hi I'm having trouble searching my database. When I type two words in the search field it only searc

xApp Analytics in BI 7.0
Dear all,

I am trying to implement xApp Analytics in BI 7.0. After I installed the analyt

Number Format
Hi All,

I have number '000000000050085' I want to format it to 500.85 Can any one give me

2 things: enter doesn't work in IE & empty form
i have this search form that works well except for 2 things.

1) on IE when i hit enter instea