Query/confusion

[scatfly]

I am getting this error:
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/xxxxx/public_html/login.php on line 164
Couldn't execute select query.

from this code:

$sql = "SELECT loginname FROM member 
         WHERE loginname = '$loginname'";  
$result = mysql_query($con,$sql) // <-- Line 164
             or die("Couldn't execute select query.");
$num = mysql_num_rows($result);                 
if ($num > 0)                                    
{
    $message_new = "$loginname already used. 
    Select another User Name.";
    include("index.php");
    exit();
 }
 

A connection to the DB was established earlier, I am just using this to make sure the new user is not using an existing name.

[scatfly]

is the "include" statement wrong? im not sure if the index.php belongs there

[Atli]

Hi.

It looks like you switched the parameters for the mysql_query() function.

// Should be
mysql_query($SQL, $connection);
 
// Rather than
mysql_query($connection, $SQL);
 

The mysqli_query() function, however, takes the parameters in reverse order.