Mysqli query

[ecabrera]

i keep getting PHP Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given

 

i am new to mysqli

 

$get = $_GET['game'];
if(!empty($get)){

require "scripts/db.ini.php";

$select = "SELECT * FROM games WHERE game=`$get`";
$return = mysqli_query($db,$select);

$row = mysqli_fetch_assoc($return);
echo $row['game'];

}

Edited February 8, 2013 by ecabrera

[awjudd]

You have ticks in your query when I'm guessing they should be quotes.

 

// Current
$select = "SELECT * FROM games WHERE game=`$get`";

// Should be (if $get is a string)
$select = "SELECT * FROM games WHERE game='$get'";

// Should be (if $get is a int)
$select = "SELECT * FROM games WHERE game=$get";

 

Please note: you should either be validating the value in $_GET['game'], using an escape-string type function or database parameters. Otherwise there will be SQL injection.

 

~awjudd

Edited February 8, 2013 by awjudd

[Barand]

If you check for errors you will probably find that that the query fails. Put single quotes, not backticks (`) , around $get

[ecabrera]

Thanks so much works i didn't know i was using `