How to run a secondary query within a primary query inside a for each loop
How can I modify my code to allow me to run a second query in the for each
loop?
For now I have commented out the second query, as Im sure I need to make
some changes prior to removing the slashes.
<?php
$mysqli = new mysqli('LOGIN DETAILS HERE');
if ($mysqli->connect_error) {
die('Connect Error: ' . $mysqli->connect_error);
}
$query = "SELECT * FROM toptips WHERE userid = 2";
$result = $mysqli->query($query);
while($row = $result->fetch_array())
{ $rows[] = $row; }
foreach($rows as $row) {
$id = $row['id'];
echo $row['time'] . " " . $row['course'] . " - " . $row['horse'] . " "
. $row['description'] ."<br/>";
// second query here
// $query2 = "SELECT likes FROM Likes_table WHERE id = $id";
// $result = $mysqli->query($query2);
// while($row = $result->fetch_assoc()){
// echo $row['likes'] . '<br />';
// }
}
?>
No comments:
Post a Comment