daniellambert

Humm, can you find out where you are in the array? so if i do something like.. // this is the code to find the next video $query = 'SELECT pairent_vid_ID from Video WHERE Video = vid2.avi'; $result = mysql_query($query) or die(mysql_error()); $row_data = mysql_fetch_assoc($result); $query = 'SELECT * FROM Video WHERE pairent_vid_ID = "'.$row_data['pairent_vid_ID'].'"; $result = mysql_query($query) or die(mysql_error()); while($row_data = mysql_fetch_assoc($result)) { if($row_data['Video'] == "vid2.avi") { $row_data = mysql_fetch_assoc($result); return $row_data['Video']; } }

Hi, I've got some frustration regarding a query im trying to do. I've got a video table that i want to try and get some results out ID Name Video usr_ID pairent_vid_ID Deleted created Duration 1 Test1 vid1.avi 22 0 N today 1:32:32 2 Test2 vid2.avi 22 1 N today 1:32:32 3 Test3 vid3.avi 22 1 N today 1:32:32 4 Test4 vid4.avi 22 0 N today 1:32:32 so, if im playing video ID2. How do i then find out the next video in line? when i've only selected video 2's detail. it seems like i need to run a few querys? Get parent ID of video 2 > get video 2 position > load next file and play.. any help would be lovely