CODEWITHSUNDEEP
phpdatabase
Rambo
Rambo

Reputation: 21

PHP read database Table length

I have problem with reading Length of table,

i want make it like this :-

if length < 10

    echo "length is less than 10"

else

    echo "length is more than 10"

this is my code

$sql1= mysql_query("SELECT * FROM `account` WHERE `username` = '$username'");
if(mysql_fetch_lengths($sql1) < 10) {
    echo ("length less than 10");
    exit();
} else {
    echo ("length more than 10");
    exit();
}

Any help ?

Upvotes: 2

Views: 2194

Answers (2)

Emiliano Sangoi
Emiliano Sangoi

Reputation: 921

Another way is:

<?php           
    $query = "SELECT COUNT(*) AS num FROM `account` WHERE `username` = '$username'";
    $sql1= mysqli_query($conn, $query);

    if( ! $sql1 ) {
        //query ok      
        $row = mysqli_fetch_assoc( $sql1 );                     
        if( $row['num'] < 10 ) {
            $msg = "length less than 10";
        }else {
            $msg = "length more than 10";
        }
        echo $msg;              
    }       
    exit();            
?>

Upvotes: 1

volkinc
volkinc

Reputation: 2128

I thinks you want use mysql_num_rows()

$sql1= mysql_query("SELECT * FROM `account` WHERE `username` = '$username'");
if(mysql_num_rows($sql1) < 10) {
    echo ("length less than 10");
    exit();
} else {
    echo ("length more than 10");
    exit();
}

Upvotes: 0

Related Questions