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

Open browser page depending on XML results
Hello,

I have some PHP code that sends webbased from data to an external url ( in the form of

Creating a custom API
I'm creating a site, and I need to create a basic API. Unfortunately I have no idea where to start.

mysql VARCHAR acting like INT
Hi, All.

I have a table that contains a varchar(10) column named weird_field. In this column

Changing color in GD via variable?
Hey guys, I'm new here. x)

I'm very much a noob when it comes to PHP, but I'm trying to learn

Loops and Classes
I am making a template system and everything seems to be going well up until I have to loop in a var

wav to mp3 + goDaddy
I need to convert wav files to mp3s. From what I have found so far one way to do it is to have my PH

Gerenate tabel in Php
I whant to generate a tabel takeing data from database like this one so the results to be display on

How to Create a Dynamic table
col1 col2 date1 date2 date3 date4..........
a b v1 v2 v3 v4

XML Grouping
I'm using xml_parse_into_struct to get all my elements, but now I need to group them. For example, h

Am I setting up my sites oldschool?
Ok,

When I create a site I open a basic template that I have created that consists of a css f