ozone1

thank a lot for the help it worked sorry to bother again how to i add number next to my results like below 1. name 1 2. name 2 3. 4. so on......

Hi guys i need a little help to list data in different coloured rows i need to list 1st name in <td class="alt1"> 2nd name in <td class="alt2"> and so on currently it is listing only in <td class="alt1"> here is my code any help really appreciated <?php $result[0] = mysql_query("SELECT * FROM videos ORDER BY viewtoday DESC LIMIT 10"); for($i=0;$i<count($result);$i++) { echo ''; while($row=mysql_fetch_array($result[$i])) { $id = $row['id']; $cat = $row['cat']; $title = $row['title']; $numviews = $row['viewtoday']; $max_length = 25; $title = ( strlen($title) > $max_length ? substr($title,0,$max_length)."..." : $title ); echo '<table class="listOfShows listOfShowsFirst"><tr> <td class="alt1"> <a href="videos.php?id=' . $id . '">'. $title . '</a> </td> </tr>'; } } ?> </table></td></table>/php]

thanks rajiv for responding i dnt know much about php it will be really helpful if you can correct the code for me please

Hi guys i need a little help i want to delete multiple rows from mysql with checkbox. Here is my code everything is listing but delete function is not working please have a look at my code and tell me where i went wrong i am a noob in php. please thanks <?php require('../config.php'); include('header.php'); ?> <table width="800" border="0" cellspacing="1" cellpadding="0"> <tr> <td><form name="form1" method="post" action="report.php"> <table width="800" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC"> <tr> <td bgcolor="#FFFFFF"> </td> <td colspan="4" bgcolor="#FFFFFF"><strong>Delete multiple rows in mysql</strong> </td> </tr> <tr> <td align="center" bgcolor="#FFFFFF">ID</td> <td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td> <td align="center" bgcolor="#FFFFFF"><strong>Title</strong></td> <td align="center" bgcolor="#FFFFFF"><strong>Comment</strong></td> <td align="center" bgcolor="#FFFFFF"><strong>IP</strong></td> </tr> <?php $result = mysql_query("SELECT * FROM report ORDER BY id"); while($row = mysql_fetch_array($result)) { $id = $row['id']; $email = $row['email']; $link = $row['link']; $comment = $row['comment']; $ip = $row['ip']; ?> <tr> <td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $row['id']; ?>"></td> <td bgcolor="#FFFFFF"><? echo $row['email']; ?></td> <td bgcolor="#FFFFFF"><? echo $row['link']; ?></td> <td bgcolor="#FFFFFF"><? echo $row['comment']; ?></td> <td bgcolor="#FFFFFF"><? echo $row['ip']; ?></td> </tr> <?php } ?> <tr> <td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td> </tr> <? // Check if delete button active, start this if($delete){ for($i=0;$i<$count;$i++){ $del_id = $checkbox[$i]; $sql = "DELETE FROM report WHERE id='$del_id'"; $result = mysql_query($sql); } // if successful redirect to report.php if($result){ echo "<meta http-equiv=\"refresh\" content=\"0;URL=report.php\">"; } } mysql_close(); ?> </table> </form> </td> </tr> </table> in config.php i have this <?php $user = 'my_user'; $pass = 'my_pass'; $host = 'localhost'; $db = 'my_db'; @mysql_connect($host,$user,$pass) or die(mysql_error()); @mysql_select_db($db) or die(mysql_error()); ?>

Hello guys i need some help to show some data from multiple tables. I have two tables videos and vids in videos i have id category view title in vids i have id video_id views title code ok what i want is to show most viewed videos (from vids table) of current day on my index page from a particular category (on videos table) i made a code and its shows videos from all categories i just want videos from category 14 <?php $result[0] = mysql_query("SELECT vids. * FROM vids, videos WHERE videos.category='14' ORDER BY id DESC LIMIT 10"); for($i=0;$i<count($result);$i++) { echo '<td style="width:190px;font-size:12px;text-align:left;" valign="top">'; while($row=mysql_fetch_array($result[$i])) { $id = $row['id']; $cat = $row['cat']; $title = $row['title']; $numviews = $row['views']; $max_length = 30; $title = ( strlen($title) > $max_length ? substr($title,0,$max_length)."..." : $title ); echo '<li><a href="videos.php?id=' . $id . '" class="forceRight">'. $title . '<a class="numbers">' . $numviews . ' views</a></a></li>'; } } ?> and right now there are 0 views for all videos but still its appearing according to id on my index page i want it to show empty space if the view count is zero Any help much appreciated !!! Thanks

hi guys i added a new field named "host" in mysql database to the show the name of the host where my videos are hosted i want to make youtube.com as default for all my videos how do i do that? help me please thanks edit: sorry wrong section

I dont get you i will explain bit more clear basically there are "view counts" ( ie, number of times a video is viewed) on my video page im having problem with some of my members they purposely click the video they submitted to increase the popularity of the video ( say after submission he clicked the video 100 times so that it will come top in the list ) so i want to restrict it if he watch it with same ip address 100 or 10000 times it should show only 1 view count (from him) on my video page. im not good in php can you please tell me step by step what to do thanks

Hi guys i have a video site and there are "view counts" for each video but i want to restrict it per ip address. Currently if i click a particular video 10 times the view count increases by 10 but i want it to show 1 view per ip address no matter how many times i click. could anyone please help me with this? this is the code i have in my video page mysql_query("UPDATE videos SET view = view+1 WHERE id = '$id'"); Any help really appreciated Thanks !!!