I am editing the New Links tpl to make sure that new lyrics submissions I make are NOT included in the New Links page.
I have successfully made another toplist for new sounds to take out lyrics on the index of http://audiofiles.org, and also made a toplist for lyrics only, that takes out sounds.
I used the same IF statement, but get this error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/audio25/public_html/index/databases/mysql.php on line 19
Comments on Toplist Error
Member
Usergroup: Customer
Joined: Mar 01, 2007
Total Topics: 14
Total Comments: 19
I am editing the New Links tpl to make sure that new lyrics submissions I make are NOT included in the New Links page.
I have successfully made another toplist for new sounds to take out lyrics on the index of http://audiofiles.org, and also made a toplist for lyrics only, that takes out sounds.
I used the same IF statement, but get this error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/audio25/public_html/index/databases/mysql.php on line 19
The statement we are looking at specifically is:
<CONFIG>links,time,20,descending,time> {SINCE},ISREGSOUND = "1"</CONFIG>
Where ISREGSOUND = "1" determines if the entry is a sound or not. If it is, then display. Else, do not.
I am sure this is conflicting with something I don't know about, because this statement works on my index.
Suggestion?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Commas are term separators in toplists, not allowed in mysql conditions, so that's illegal. The condition should be
time > {SINCE} and isregsound = 1