# Won't insert data into database

**URL:** <https://forum.kirupa.com/t/wont-insert-data-into-database/216384>\
**Category:** Uncategorized\
**Created:** [February 16, 2007, 1:22am UTC](https://forum.kirupa.com/t/wont-insert-data-into-database/216384 "2007-02-16T01:22:47Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Flash\_Man1](https://avatars.discourse-cdn.com/v4/letter/f/8797f3/32.png) [@Flash\_Man1](https://forum.kirupa.com/u/Flash_Man1)\
**Post date:** [February 16, 2007, 1:22am UTC](https://forum.kirupa.com/t/wont-insert-data-into-database/216384/1 "2007-02-16T01:22:47Z")

</div>

hey all,

i’m trying to add my “name” and “email” into my database if the email is NOT already in there.

yet my code isn’t working for some reason here it is:

```php
$sql = "SELECT * FROM mytable WHERE email = '$email'";
$result = mysql_query( $sql );

if( mysql_num_rows($result) == 0 ) {

 
    $sql = "INSERT INTO mytable (`name`, `email`) VALUES ('$name', '$email')";
    $result = mysql_query( $sql ) or die('Could not add user');
}  
?>

```

Cheers in advance 🙂