Selecting rows

[mickeymouse]

I'm trying to select rows and also asking how many rows selected. Neither work.
Here is my code. Can you tell me what's wrong or direct me to the appropriate documentation.

I have not been able to find anything in the documentation concerning the selection so I'm doing it as I did it under Version 5.x where it worked beautifully.

For the row count, I believe I'm doing it exactly like the documentation says, but it doesn.t work. I get the following error msg:
Warning: Attempt to read property "num_rows" on bool in C:\xampp\htdocs\HA_LogInCheck.php on line 80


$results=mysqli_query($link, "SELECT * FROM 'hauser' WHERE `userid`='$UserID' ||perid`='$UserID' ");
$AffectedRows = $results->num_rows;

[Altrea]

check your syntax. you have at least one error in using backticks.
use backticks for every identifier (database name, table names, column names) and single quotes for strings.

[Nobbie]

it as I did it under Version 5.x where it worked beautifully.

No, that is impossible:

Code: Select all

$results=mysqli_query($link, "SELECT * FROM 'hauser' WHERE `userid`='$UserID' ||perid`='$UserID' ");

The single quotes at 'hauser' are wrong in every MySQL version, its simply a syntax error. You cannot apply a string as table name.