Hello all.
I have PHP Query:
PHP Code:
$query = "(select movieid,namehe,nameen,poster,plot,imdb,janer, 'moviesdb' as movies FROM moviesdb where nameen like '%$keyword%' or namehe like '%$keyword%')
UNION
(select gameid,namehe,nameen,poster,plot,rating,janer, 'gamesdb' as movies FROM gamesdb where nameen like '%$keyword%' or namehe like '%$keyword%')";
and this line:
PHP Code:
while($row = mysql_fetch_array($result)){
and when I use $row['imdb'] (from movie tables) it works, but when I Use
$row['rating'] from games table, its not.
why?