Got stuck with inner join in php/mysql, please help

Rebelfriik009 · July 19, 2015

hi everyboy;

1. mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given

2. Warning: Invalid argument supplied fo foreach()

i want to join quoteText with author name and email. Thanks

here are the tables

author table (id, name, email)

user_quotes table(id, City, quoteText)

Here are my code

<?php

if ($_SERVER["REQUEST_METHOD"]=="POST") {

$id_select = $_POST['id'];

$action = "DELETE FROM user_quotes WHERE id = '$id_select'";

$requet= mysqli_query($db_connection, $action);

}

$requete = "SELECT joke.id, quoteText, name, email FROM user_quotes INNER

JOIN author ON authorID = author.id";

$resultat = mysqli_query($db_connection, $requete);

while ($rows = mysqli_fetch_assoc($resultat)) {

$quotes []= array('id' =>$rows['id'], 'text' =>$rows['quoteText']

'name'=>$rows['name'], 'email'=>$rows['email']);}

?>

<body>

<?php foreach ($quotes as $quote):?>

<?php echo htmlspecialchars($quote['text'], ENT_QUOTES, 'UTF-8'); ?>

<?php echo htmlspecialchars($quote['name'], ENT_QUOTES, 'UTF-8'); ?>

<?php echo htmlspecialchars($quote['email'], ENT_QUOTES, 'UTF-8'); ?>

</p>

</form>

<?php endforeach; ?>

Ch0cu3r · July 19, 2015

Try changing joke.id in the query to just id

If the error still persists then change change $resultat = mysqli_query($db_connection, $requete); to be

 $resultat = mysqli_query($db_connection, $requete) or trigger_error('SQL Error: ' . $db_connection->error);

Recommended Posts