Results 1 to 8 of 8

Thread:

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    White awesomeness z0ne's Avatar
    Join Date: Feb:2002
    Location: o
    Posts: 13,331

    , ...
    PHP Code:
    <?php
    $host
    =""
    $user=""
    $pass=""
    $db=""
    $table="phpbb_topics"
    $laforums="7"
    $link=mysql_connect($host$user$pass); 
    $db=mysql_select_db($db); 
    $table="phpbb_topics"
    $query="SELECT * FROM $table ORDER BY topic_time DESC LIMIT 0,$laforums"
    $result=mysql_query($query$link); 
    while (
    $row=mysql_fetch_row($result)) { 
    echo 
    "<table width='275' border='0'>
      <tr>
        <td width='8'><img src='images/arrow.gif' width='8' height='7' align='middle'/></td>
        <td width='400'><a href='./forum/viewtopic.php?t=
    $row[0]' target='_blank'>$row[2]</a></td>
      </tr>
      <tr>
        <td></td>
        <td style='background-image:url(images/line_in.gif)'></td>
      </tr>
    </table>"


    ?>
    "" ?f=3

  2. #2
    Registered User Pa3KaTaH's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 3,851
    $query="SELECT * FROM $table WHERE ------f<>3 ORDER BY topic_time DESC LIMIT 0,$laforums";

    edit
    , 48 ...
    Last edited by Pa3KaTaH; 3rd July 2006 at 01:07.

  3. #3
    White awesomeness z0ne's Avatar
    Join Date: Feb:2002
    Location: o
    Posts: 13,331
    db-? -

  4. #4
    Registered User Pa3KaTaH's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 3,851
    , phpbb-


    edit
    , , - ,

    $query="SELECT * FROM $table WHERE cat_id<>3 ORDER BY topic_time DESC LIMIT 0,$laforums";
    Last edited by Pa3KaTaH; 3rd July 2006 at 01:19.

  5. #5
    White awesomeness z0ne's Avatar
    Join Date: Feb:2002
    Location: o
    Posts: 13,331

  6. #6
    Registered User Pa3KaTaH's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 3,851
    ... "f" . ...


    $query="SELECT * FROM $table WHERE forum_id<>3 ORDER BY topic_time DESC LIMIT 0,$laforums";
    ?
    Last edited by Pa3KaTaH; 3rd July 2006 at 01:28.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |