Whats the difference?

Schwalbach

Ok guys,

I just updated to a new server, and am wondering why this is happening..

If I use this, I get an erro saying it is not a valid mysql resource whenever I use numrows.

$sql = "SELECT * FROM check WHERE var='$var'";
$result = mysql_query($sql);
$numrows = mysql_numrows($result);

But When I use this, it works fine

  $sql = 'SELECT * '
        . ' FROM `check`' . " WHERE var='$var'";

Could anyone tell me what the difference is?

petitduc

If your $result is not a valid resource, presumably it is because your query failed and $result is null.
Try to get an explicit error message by :

mysql_query($sql) or die("Query failed ".mysql_error());

so we can help you better.

Schwalbach

Hey,

I am just saying what is the difference between the two? They are the exact same, but only one works. There has to be a difference I am missing?

I am talking about the query, the select part are the things changed

Sxooter

Nope, they're not exactly the same. In one you're quoting the tablename check. Maybe that's the issue? Just guessing.

petitduc

I am just saying what is the difference between the two? They are the exact same, but only one works. There has to be a difference I am missing?

I have no friggin idea what difference the quotes make.
This is why I suggested you to display an error message. The error message will tell you the difference.