1
I have made a block that picks a random Mydownloads download from the database, however, when running this as a custom block, I get:
Parse error: parse error, unexpected T_VARIABLE in **server root path**/user/htdocs/modules/system/blocks/system_blocks.php(40) : eval()'d code on line 2
Here is the php scripted custom block that gives the error
Quote:
$result = mysql_query('USE **database name** SELECT title, url, logourl FROM **XOOPS table prefix**_games_downloads ORDER BY RAND() LIMIT 1')
$row = mysql_fetch_array('$result, MYSQL_ASSOC')
print <<
HTML;
Anyone know what's going wrong here?
Help appreciated
