Hi, My database has a table called movies which has data like this: flick_name ,flick_cover, part_url flick_name is the name of the movie, the movie is cut into several pieces for faster downloads part_url is the full path to each of the pieces eg: home movie 1 ,a.gif, http://movieserver.com/scene1_1.wmv home movie 1 ,a.gif, http://movieserver.com/scene1_2.wmv home movie 1 ,a.gif, http://movieserver.com/scene1_3.wmv home movie 1 ,a.gif, http://movieserver.com/scene2_1.wmv home movie 1 ,a.gif, http://movieserver.com/scene2_2.wmv home movie 1 ,a.gif, http://movieserver.com/scene2_3.wmv etc I am trying to get it into this format: http://www.ezee.se/format.jpg The main problem I am having is that I cannot seem to get the part files to properly repeat inside the table.... one idea I came up with is to have a nested table for the part files....but even that is not working...I am getting all screwed up tables... Below is the exact code I have screwed around with, its a bit different coz i tried to simplify my problem when writing to the list...dont know if it helps but have a look at my code if you need to... Thanks in advance, Ryan <?php $hostt="localhost"; $userr=""; $passs=""; $db="movies"; $connected=mysql_connect("$hostt", "$userr", "$passs") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("$db"); $q=mysql_query("select * from csv_28814"); $num_rows = mysql_num_rows($q); $flick_name2=""; $once=0; for($i=0; $i < $num_rows; $i++) { $row = mysql_fetch_row($q); $flick_name = $row[0]; $part_url = $row[1]; $part_size = $row[2]; $time_length = $row[3]; $part_format = $row[4]; if($flick_name != $flick_name2) { echo "<table width='80%' bgcolor=gray border='0' cellspacing='0' cellpadding='0'> <tr> <td colspan='2'><strong><font size='+1'>Title</font></strong></td> <td width='40%'> </td> </tr> <tr> <td width='22%' align='center' valign='middle'>cover pic </td> <td colspan='2' nowrap><table width='100%' border='0' cellspacing='0' cellpadding='0'> <tr> <td width='81%'><strong>Scenes</strong></td> <td width='10%'><strong>Length</strong></td> <td width='9%'><strong>Format</strong></td> </tr> <tr> <td> </td> <td> </td> <td> </td> </tr> </table></td> </tr> </table><br>\n\n\n\n\n\n\n\n\n"; } $flick_name2 = $flick_name; } ?> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
