View Single Post
Old 01-31-2008, 01:18 AM  
wpkings
Registered User
 
wpkings's Avatar
 
Join Date: Jan 2008
Posts: 98
And obviously the result limit is set with LIMIT:
Code:
$ex_sql = mysql_query( "select lyric_id, lyric_artist, lyric_title from lyrics where approved='1' order by lyric_id desc limit 20");
So you could just change that LIMIT 20 to LIMIT 40 etc

And yes, like mr.K mentioned...
Code:
<lyrics><![CDATA[' . $mysql_array['lyric_text']) . ']]></lyrics>
But there might be a better way.

The other part with the random lyrics isn't hard but I'd probably give you the wrong code if I tried now, so that can wait until tomorrow
wpkings is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote