Hi, im having trouble with a select statement it works fine at the moment, but i want to alter it so that it selects * from another table as well, i cant seem to get it work without it throwing errors, this is what I have at the moment:
[php]<?php
if (!empty($_REQUEST[‘term’])) {
$term = mysql_real_escape_string($_REQUEST[‘term’]);
$sql = “SELECT * FROM adrenaline WHERE title LIKE '%”.$term."%’";
$r_query = mysql_query($sql);
while ($row = mysql_fetch_array($r_query)){
echo '<br> <a href="../' . $row['description'] . '"> '. $row['title'] .'</a>';
}
}
?>[/php]
This is what Im looking for:
[php]$sql = “SELECT * FROM adrenaline “””+ hobby""" WHERE title LIKE ‘%".$term."%’"; [/php]
many thanks.