Jump to content

need help with numbering rows then fetching data from those rows


sickness01

Recommended Posts

ok, im having some trouble right now, i have in .htaccess info being passed to a php file so i can have seo friendly links, so say site.com/Seitokai-Yakuindomo-Episode-1/2

the /2 is the video source i want it to display, so what i need to do is fetch the data from the database for that episode (done) number the rows (did that) now iwant to select the info from that specific source, this is what i got sofar

 

<?
$sourcez1 = mysql_query("SELECT * FROM sources WHERE episode='$info[id]' ORDER BY id DESC LIMIT 6");
$result2 = mysql_num_rows($sourcez1);
?>

 

thats part of the code, so i want it to fetch row 2 from $result2 or if the source is 3, row 3 and so on

 

can anyone help me with this?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.