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

Code error with Index.php
Error: Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/runevid/public_

Array becomes unset by itself?
Hi,

I have a bit of experience with PHP but not extensive. It seems I cannot store any items

Help to integrate whois Domain Details to website
Hi,

can i know is their any php script r methods to add domain details to my website.

Help with lottery style system?
I'm working on a currency system for forums and it is going to have a type of lottery system built i

Multiple upload and Resize
I would like some help on my script I have the for my index.php

////

<html&

PHP login form help (Done Most of It)
Hi i am having a problem, when i try logging in it is always saying "Invalid Login" im not

Registration
ok so i have a site where people can register and login which works now thanks to someone on here th

Better Method of a Member Cloud
I assume most people know how tag clouds work, where the tags most used are bigger and the least use

Include ("Absolute Path") of a file?
I'm not sure what I'm doing wrong. I am writing my php code in the same directory of the file that

str_replace help
Hey there,

I'm a PHP newb, I'm having troubles with the str_replace function. I want to clean