[Resolved] newb help

[wanted420]

The

if ($result['username']) {
$num_rows_user = mysql_num_rows($result);
}

    if ($result['email']) {
       $num_rows_email = mysql_num_rows($result);
    }

are returning false even though the username is already there. I did an echo $result['username']; and it doesnt return nothing. Here is the code:

<?php
    if (isset($_POST['submit'])) {  

 include "db.php"; 

    $username = trim($_POST['username']);
    $password = trim($_POST['password']);
    $password2 = trim($_POST['password2']);
    $sec_phrase = trim($_POST['sec_phrase']);
    $first_name = trim($_POST['first_name']);
    $last_name = trim($_POST['last_name']);
    $address = trim($_POST['address']);
    $city = trim($_POST['city']);
    $state = trim($_POST['state']);
    $email = trim($_POST['email']);
    $phone = trim($_POST['phone']);
    $major = trim($_POST['major']);

    $check = "SELECT username,email FROM members WHERE username = '$username' OR email = '$email'"; 
    $result = mysql_query($check);

    if ($result['username']) {
       $num_rows_user = mysql_num_rows($result);
    }  

    if ($result['email']) {
       $num_rows_email = mysql_num_rows($result);
    }

[mrhappiness]

$result = mysql_query($check);
$num_rows_user =mysql_num_rows($result);
echo $num_rows_user;

you mixed up mysql_query and its return value and mysql_fetch_* and its return value...

[TheDefender]

In other words, you need to get the values into an array before you do your IF statements...

$check = "SELECT username,email FROM members WHERE username = '$username' OR email = '$email'";  

$result = mysql_query($check); 

// Add this line
$row = mysql_fetch_array($result);

// Change these lines
if ($row['username']) { 
  $num_rows_user = mysql_num_rows($result); 
}   

if ($row['email']) { 
  $num_rows_email = mysql_num_rows($result); 
} 

[mrhappiness]

but why would he want to fetch first and afterwards count the entries he got?

[TheDefender]

I don't know what he's coding... I am just providing a solution to what he's doing 😉

[wanted420]

It a register page and i am just checking to make sure the username or email have not been registered already.