Hello,

I'm having a small problem getting my code to check for existing user names on my database. I have attached my PHP code that I'm having issues with and I was hoping that someone could see where I went wrong.


Thanks........

PHP Code:

    if (isset($_POST['submit'])) {
    
        include('mysql_connect_login.php');

$frm_ID = $_POST['username']; 

    $query = "SELECT username FROM users WHERE username= $frm_ID";
    $r = mysql_query ($query);
if (mysql_num_rows($r) == 0) {
    $sql_query = "insert into users (Name, username, password, transit) Values ('{$_POST['name']}', '{$_POST['username']}', '{$_POST['password']}', '{$_POST['transit']}')";
    //run it 
    $query_run = mysql_query($sql_query);
    $query_run;

} else {
header("location: inuse.php");
}


    mysql_close();
    header("location: updated.php");
} 


no single quotes around $frm_ID assuming it's that query that's failing.

I think on this part:

PHP Code:

$query_run = mysql_query($sql_query);
$query_run; 


you don't need the second line.

Thanks Phaedrus, you're right I didn't need the second line but that wasn't the solution. After some very tense moments I figured out that my stucture was a mess. Here is the working code,

PHP Code:

<?php


    if (isset($_POST['submit'])) { 
     
        include('mysql_connect_login.php'); 

$frm_ID = $_POST['username']; 

    $query = "SELECT username FROM users WHERE username= '$frm_ID'"; 
    $r = mysql_query ($query); 
if (mysql_num_rows($r) != 0) { 
    header("location: inuse.php"); 
    } else { 
    $sql_query = "insert into users (Name, username, password, transit) Values ('{$_POST['name']}', '{$_POST['username']}', '{$_POST['password']}', '{$_POST['transit']}')"; 
    //run it 
    $query_run = mysql_query($sql_query); 
    
    header("location: updated.php"); 
    mysql_close(); 
} 
}
            
        
        
?>

Thanks Everyone