View Single Post
Old 01-31-2008, 01:22 AM  
Jace
FBOP Class Of 2013
 
Industry Role:
Join Date: Jan 2004
Location: bumfuck, ky
Posts: 35,562
Quote:
Originally Posted by wpkings View Post
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
yeah, i figured out the amount of articles pulled, that was easy

now I just need to figure out how to get the lyrics to show up too
Jace is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote