mysql - PHP prepared statement loop JOIN query not working -

mysql - PHP prepared statement loop JOIN query not working -

i trying gather variables query output them using $stmt->bind_result() not getting rows returned in search.

i not sure going wrong here?

$tag = trim($_get['tag']); $stmt = $mysqli->prepare('select trips.trip_id trips bring together tags on trips.post_id = tags.post_id tag = ?'); $stmt->bind_param('s', $tag); $stmt->execute(); $stmt->bind_result($id); while ($stmt->fetch()) { echo $id; }

php mysql sql join