Hi I am having a small issue with the following code, and I have no idea why it is not working
I am trying to show the data inside tbl_radio_now_playing.radio_now_playing_song But I also need to show the station name that is in tbl_radio_now_playing.radio_station_name
<?php
$sql = "SELECT tbl_radio_now_playing.radio_station_id,
tbl_radio_now_playing.radio_now_playing_song,
tbl_radio_station.radio_station_id,
tbl_radio_station.radio_station_name
FROM tbl_radio_station JOIN tbl_radio_now_playing
ON tbl_radio_now_playing.radio_station_id = tbl_radio_station.radio_station_id
WHERE tbl_radio_now_playing.radio_now_playing_song LIKE '%$q%'";
$result = mysql_query($sql) or die ("Error Searching");
$row = mysql_fetch_assoc($result);
extract ($row);
print $radio_now_playing_song;
print $radio_station_name;
?>
Hi Russell, Have a go
Hi Russell,
Have a go with;
<?php$sql = "SELECT
tbl_radio_now_playing.radio_station_id,
tbl_radio_now_playing.radio_now_playing_song,
tbl_radio_station.radio_station_name
FROM
tbl_radio_now_playing,
tbl_radio_station
WHERE
tbl_radio_now_playing.radio_station_id = tbl_radio_station.radio_station_id
AND
tbl_radio_now_playing.radio_now_playing_song LIKE '%$q%'";
?>
Cheers!
David.