CODEWITHSUNDEEP
phpmysqlselect
Marty
Marty

Reputation: 27

Basic php/mysql query struggles

I am frustrated and I am beginning to wonder if there is some catch with my hosting company that might be causing this issue. I have done this type of thing before (not with this hosting company) so I am at a loss. 

        <?php
    $q = "SELECT * FROM sunsetUsers";
    $r = @mysqli_query($dbh, $q);
    if ($r) {
        echo 'good job';
    } else {
        echo 'you suck';
    }?>

The connection info is being called in the header and it works. It will connect to the database and supply me with a good message when I tell it to. Yet, when I try to execute a simple query, I get nothing. No errors at all other than it tells me, "you suck." Heh...which is what it should do when the query fails. I am not trying to do anything with the data...I just want to ensure that the query executes with no problems.

Is there any other information I can give that might help here? This seems really simple to me...yet so confused here as to why this isn't working.

Upvotes: 0

Views: 46

Answers (1)

Ben Rowe
Ben Rowe

Reputation: 28721

You can see your mysql errors with mysql_error (for the purposes of learning):

if (!$r) {
  echo mysqli_error(); // display the last error detected
}

Also using the mysql_* & mysqli_* functions are a very old & insecure way of communicating with mysql. Look into pdo for a better way.

Upvotes: 5

Related Questions