Selecting Table

Community support
#1 

<?php include "db.php"; ?>
<?php

if(isset($_POST[‘submit’])){

$username = $_POST[‘username’];

$email = $_POST[‘email’];


$uquery = "SELECT * FROM users WHERE username = '$username'";
$equery = "SELECT * FROM users WHERE user_email = '$email'";

$uresult = mysqli_query($connection , $uquery) or die(mysqli_error($connection));
$eresult = mysqli_query($connection , $equery) or die(mysqli_error($connection));

$urows = mysqli_num_rows($uresult);
$erows = mysqli_num_rows($eresult);

if($urows == 1 && $erows == 1){
    echo "username & email exist <br>";
}elseif($erows == 1){
 echo "email exist";   
}elseif($urows == 1){
    echo "username exist <br>";
}else{
    echo "You can create account <br>";
}



}


?>
`Preformatted text`

This is my simple code. I got error like:
Table ‘id7214743_n1tech.users’ doesn’t exist

But, i have created the table named “users”. In localhost on pc, it runs perfectly but here, i get this error. Can anyone help me to solve this ?

#2

The table ‘users’ does not exist, just create it :slight_smile:
This clearly means you did not create one, or you did not select the database earlier.