النتائج 1 إلى 2 من 2

الموضوع: مشكلة إستخراج بيانات القاعدة من جدولين

  1. #1
    عضو جديد
    تاريخ التسجيل
    Sep 2012
    المشاركات
    11

    مشكلة إستخراج بيانات القاعدة من جدولين



    لدي مشكلة في إستخراج بيانات القاعدة من جدولين واضافتهم في ملف php

    هذا بالنسبة عندي لم استطيع ان اعمل تكرار روابط اخرى وجلبها من القاعدة حيث استطيع جلب مباريات وتتكرر عادي
    golofans


    في حالة تواجد اكثر من رابط لكل مباراة راح يكون على شكل في القاعدة
    id = 1
    video_id = 2
    embed = code embed

    id = 2
    video_id = 2
    embed = code embed2

    id =3
    video_id = 2
    embed = code embed

    وهذا مثال اريد اعمل مثله : يعني كل مباراة لديها روابط مواقع اخرى و نوع و اسم .. الخ

    ROJADIRECTA





    الكود التالي كامل من يستطيع ان يعدل عليه


    كود:
    <!-- saved from url=(0013)about:internet -->
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
    <html dir="ltr">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
    <meta http-equiv="Content-Style-Type" content="text/css">
    
    <title>Rojadirecta</title>
    <meta name="description" content="Rojadirecta. World's biggest sports  streams index (El mayor ?ndice de emisiones deportivas por  Internet).">
    
    <meta http-equiv="Cache-Control" content="max-age=200">
    
    <meta http-equiv="refresh" content="300">
    
    
    <link rel="stylesheet" href="http://www.Rojadirecta.me/static/index.css" type="text/css">
    <link rel="shortcut icon" href="http://www.Rojadirecta.me/static/favicon.ico" >
                     
    <script type="text/javascript" src="http://www.Rojadirecta.me/static/lingua.js"></script>
    <script type="text/javascript" src="http://www.Rojadirecta.me/static/switchmenu.js"></script>
    <script type="text/javascript" src="http://www.Rojadirecta.me/static/smallscripts120.js"></script>
    
    </head>
    
    
    <body link="#006699" vlink="#5493b4" onload="guardaHorario();dT();">
    
    <script type="text/javascript" src="http://www.Rojadirecta.me/static/buscarpagina.js"></script>
    
    <a name="top"></a>
    <table class="mainwindow" cellspacing="0" cellpadding="0">
    <tr>
    <td>
    
    <table width="100%" cellpadding="0" cellspacing="0">
    <tr>
    <td valign="top" height="100%">
    
    
    <table width="100%" cellspacing="0" cellpadding="0">
    <tr>
    <td class="title">
    <div id="Layer1" style="position:relative; width:5px; height:5px; z-index:1; top:-52px">
      <div id="Layer2" style="position:absolute; width:131px; height:131px; z-index:2; left:0px; top:0px">
       <a href="http://www.Rojadirecta.me"><img  src="http://www.Rojadirecta.me/static/roja.jpg" width="130" height="130"  border="0" alt="Rojadirecta"></a>
      </div>
    
      <div id="Layer3" style="position:absolute; width:550px;  height:70px; z-index:2; left: 159px; top: 19px; background-image:  url(http://www.Rojadirecta.me/static/logo.gif); border: 1px none  #000000;"></div>
      <div id="Layer4" style="position:absolute; width:120px;  height:600px; z-index:1; left: 780px; top: 19px; border: 0px none  #000000;">      </div>
    </div>
    </td>
    </tr>
    <tr>
    <td class="subtitle">
    
    <table width="100%" cellpadding="0" cellspacing="0">
    
    <tr>
    <td width="101">&nbsp;</td>
    <td class="small">
    <div align="right">
    
            <a href="http://forum.Rojadirecta.es/"><span  class="es">Foros</span><span  class="en">Forums</span></a> :: <a  href="http://forum.Rojadirecta.es/forumdisplay.php?15">
            <span class="es">Partidos en descarga</span><span class="en">Download matches</span></a>
            :: <a  href="http://forum.Rojadirecta.es/forumdisplay.php?21"><span  class="es">Res?menes</span><span  class="en">Highlights</span></a> ::
            <a  href="http://forum.Rojadirecta.es/forumdisplay.php?16">Videos</a>  :: <a href="http://forum.Rojadirecta.es/search.php">
            <span class="es">Buscar</span><span class="en">Search</span></a>
    
            ::
            <b><a href="novatos.htm"><span  class="es">Novatos</span></a><span class="en"><a   href="how-to-watch-sport-events-for-free-on-the-Internet.htm">Beginner</a></span></b>  ::
            <a  href="http://www.Rojadirecta.me/aplicaciones.htm"><span  class="es">Tutoriales</span><span  class="en">Tutorials</span></a>::
            <a href="aplicaciones.htm"><span  class="es">Descargar programas</span><span  class="en">Download software</span></a> ::
            <b><span class="es"><a href="#"  onClick="crearCookie('language','en',30); window.location.reload( true  );">English</a></span>
            <span class="en"><a href="#"  onClick="crearCookie('language','es',30); window.location.reload( true  );">Espa?ol</a></span></b>&nbsp;&nbsp;&nbsp;
    
    </div>
    </td>
    </tr>
    </table>
    
    </td>
    </tr>
    </table>
    
    <table width="100%" align="center">
      <tr>
        <td align="center">
    <!--publicidad-->
    
    <NOSCRIPT>
    <font face="Arial" size="2"><b>Tu navegador no tiene  habilitado JavaScript y por ello est? p?gina no se mostrar?  adecuadamente
     <br><i>Your browser does not have JavaScript enabled.  Therefore this page is not going to be showed properly</i>
    </b></font>
    </NOSCRIPT>
    
    
    
    
    <table border="0" width="90%" cellspacing="0" cellpadding="0" id="tablefullmatches">
                <tr>
                    <td bgcolor="#d20808">
                    <p align="left"><font color="#FFFFFF" face="Arial" size="2">&nbsp;&nbsp;
                    <b><span class="es">Nueva entrada en nuestro  blog:</span><span class="en">New post in our  blog:</span></b>
                    </font></p>
                    </td>
                </tr>
                <tr>
                    <td bgcolor="#D5D8E0">
                    <font size="2">        
    
                    <span class="es">                        
    El Gobierno de Estados Unidos retira la demanda contra los dominios de  Rojadirecta y la Corte ordena devolverlos (<a target="_blank"  href="http://blog.Rojadirecta.me/2012/08/30/estados-unidos-retira-demanda-contra-dominios-de-Rojadirecta-y-la-corte-ordena-devolverlos/">+  info</a>)
    
    </span>
    
    <span class="en">
    The U.S. Government withdraws complaint against the Rojadirecta domains  and the Court orders their return (<a target="_blank"  href="http://blog.Rojadirecta.me/2012/08/30/us-government-withdraws-lawsuit-against-Rojadirecta-domains-and-court-orders-their-return/">+  info</a>)
    
    </span>
                    </font>
                    </td>
                </tr>
                </table>
    
                
    
    
    
    <!---<SCRIPT TYPE="text/javascript" LANGUAGE="Javascript" SRC="cgi-bin/a.pl"></SCRIPT>-->
    
        </td>
      </tr>
    </table>
    
    <table border="0" width="765" id="table1">
        <tr>
            <td width="416" valign="top">
    <div class="tvinternet">
    <table border="0" cellspacing="0" cellpadding="0" id="table4646t" width="100%" STYLE="height:45px;">
        <tr>
            <td>
                <font color="#FFFFFF">&nbsp;<span  class="es">Hoy en <b>TV por  Internet</b></span><span class="en">Today on  <b>Internet TV</b></span></font>
            </td>
            <td width="226" valign="top">
                <span class="fuente2"><a href="javascript:popUp('conversor-horario',532,435)"><span  class="husohorario"></span></a><input type="radio"   name="formato" value="24H" checked  onClick="horaHuso(globalhuso,this.value);">24H<input type="radio"  name="formato" value="AMPM"  onClick="horaHuso(globalhuso,this.value);">AM/PM &nbsp;<span  id="tP"></span></span>
                <br>
                <div id="buscar">
                    <span id="minhapesquisa"></span>
                    <button id="performSearch"><span  class="es">Buscar</span><span  class="en">Search</span></button>
                </div>
            </td>
        </tr>
    </table>
    
    </div>
    
    
    
    
      <?php
      
      
        //connection au serveur:
        $cnx = mysql_connect( "localhost", "kious_media", "dz87772" ) ;
     
        //sélection de la base de données:
        $db = mysql_select_db( "mourin_media1" ) ;
     
        //requête SQL:
        $sql = "SELECT DISTINCT livetv_events.id, livetv_events.time,  livetv_events.title, livetv_events.description, livetv_events.sport,  livetv_events_embeds.id, livetv_events_embeds.event_id,  livetv_events_embeds.link, livetv_events_embeds.p2p,  livetv_events_embeds.name, livetv_events_embeds.lang,  livetv_events_embeds.type, livetv_events_embeds.kbps FROM  livetv_events,livetv_events_embeds
    WHERE livetv_events.id = livetv_events_embeds.event_id ORDER BY livetv_events.time" ;
     
        //exécution de la requête:
        $requete = mysql_query( $sql, $cnx ) ;
     
        //affichage des données:
    
    echo "
    <div id=\"masterdiv\">
    <div id=\"agendadiv\" class=\"scrollagenda\">
    
    <!--<div class=\"menutitle\"  onclick=\"SwitchMenu('sub')\"><span class=\"t\"><span  class=\"t\"><center><b><img  src=\"http://www.Rojadirecta.me/static/flechaup.gif\">&nbsp;&nbsp;&nbsp;&nbsp;  Desplegar determinados eventos del d?a ya emitidos   &nbsp;&nbsp;&nbsp;&nbsp;<img  src=\"http://www.Rojadirecta.me/static/flechaup.gif\"></b></center></div>
    <span class=\"submenu\" id=\"sub\">
    </span>-->
    ";
                        
            while( $result = mysql_fetch_object( $requete ) )
        {
        
        $caption=$result->id;
    
    if ( $curr_artiste != $result->event_id ){
    
    $curr_artiste = $result->id; 
           echo(
    "
    <span class=".$result->id.">
    <!--04:30--><div class=\"menutitle\"  onclick=\"SwitchMenu('sub".$result->id."');sorter=new  table.sorter('sorter');sorter.init('taboastreams".$result->id."',4);\">".$result->title."  ".$result->time."</span>"
    );
    echo "
    </div> <!--".$result->id."->id-->
    <span class=\"submenu\" id=\"sub".$result->id."\">
    <table class=\"taboastreams\" id=\"taboastreams".$result->id."\" border=\"0\" cellpadding=\"1\" cellspacing=\"1\">
      <tbody>
      
        <tr>
          <td>P2P</td>
          <td><span class=\"es\">Nombre</span><span class=\"en\">Name</span></td>
          <td><span class=\"es\">Idioma</span><span class=\"en\">Lang</span></td>
          <td><span class=\"es\">Tipo</span><span class=\"en\">Type</span></td>
          <td>Kbps</td>
          <td>Play</td>c
        </tr>
            
    
    <tr>
          <td>".$result->p2p."</td>
          <td>".$result->name."</td>
          <td>".$result->lang."</td>
          <td>".$result->type."</td>
          <td>".$result->kbps."</td>
          <td><b><a rel=\"nonfollow\"  href=\"".$result->link."\" target=\"_blank\"><span  class=\"es\">Ver</span><span  class=\"en\">Watch</span></a></b></td>
        </tr>
           
      </tbody>
    </table>
    </span>
    </span>
                ";
    }    
    }                
    
    ?>
                <div class="menutitle"><br></div>                            
    <div class="proxemi"> 
    
    <script type="text/javascript">
    var tamanoAgenda=372;
    function moreEvents(){
        tamanoAgenda+=372;
        document.getElementById('agendadiv').style.height = tamanoAgenda +'px';
    }
    </script>
    
    <center>
        <span class="es"><iframe scrolling="no" frameborder="0"  allowtransparency="true" style="border:none; overflow:hidden;  width:70px; height:18px;"  src="http://www.facebook.com/plugins/like.php?href=http%3A%2F%2Fwww.facebook.com%2FRojadirecta&amp;layout=standard&amp;show_faces=false&amp;locale=es_ES&amp;width=450&amp;action=like&amp;colorscheme=light&amp;height=18"></iframe></span><span  class="en" style="display: none;"><iframe scrolling="no"  frameborder="0" allowtransparency="true" style="border:none;  overflow:hidden; width:45px; height:18px;"  src="http://www.facebook.com/plugins/like.php?href=http%3A%2F%2Fwww.facebook.com%2FRojadirecta&amp;layout=standard&amp;show_faces=false&amp;locale=en_US&amp;width=450&amp;action=like&amp;colorscheme=light&amp;height=18"></iframe></span>   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  <span class="mobile"><span class="es"><input  type="submit" value="Mostrar los eventos siguientes"  onClick="moreEvents();"></span><span class="en"><input  type="submit" value="Show the next events"  onClick="moreEvents();"></span>   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span>   <a href="http://www.twitter.com/Rojadirecta"  target="_blank"><img height="20" border="0" alt="Rojadirecta on  Twitter"  src="http://twitter-badges.s3.amazonaws.com/twitter-b.png"></a>
    </center>
    
    </div>
    
    </div>
    <!-- Banner eventual izq -->
    <!-- Fin banner -->
    
    <!-- temp -->
    <!-- temp -->
    
            </td>
    
            <td>&nbsp;</td>
            
            <td width="325" valign="top">
    
    <!-- Destacamos -->
    <!-- Fin destacamos -->
    
    <!--<table border="0" width="325" cellspacing="0" cellpadding="0" id="tablefullmatches">
                <tr>
                    <td bgcolor="#d20808">
                    <p align="left"><font color="#FFFFFF" face="Arial" size="2">&nbsp;&nbsp;
                    <b><span class="es">Cambio horario en  Europa</span><span class="en">Time change in  Europe</span></b>
                    </font></p>
                    </td>
                </tr>
                <tr>
                    <td bgcolor="#D5D8E0">
                        <div class="cuadroagenda">
                            <div class="dark"><span  class="es">Recordatorio: Desde la pasada madrugada es una hora menos  en Europa</span><span class="en">Remember: Daylight Saving  ended this last night in Europe, now is one hour  less</span></div>
                        </div>
                    </td>
                </tr>
                </table>
    
    <br>-->
    
    
    <!--<table border="0" width="325" cellspacing="0" cellpadding="0" id="tablefullmatches">
                <tr>
                    <td bgcolor="#d20808">
                    <p align="left"><font color="#FFFFFF" face="Arial" size="2">&nbsp;&nbsp;
                    <b><span class="es">Acceso al  foro</span><span class="en">Access to the  forum</span></b>
                    </font></p>
                    </td>
                </tr>
                <tr>
                    <td bgcolor="#D5D8E0">
                        <div class="cuadroagenda">
                            <div class="dark"><span  class="es">Acceso al foro reestablecido. En caso de no poder acceder  todav?a, se recomienda eliminar la caché, cerrar y abrir el navegador o  como m?nimo <a href="http://forum.Rojadirecta.es/?">clicar  aqu?</a></span><span class="en">Forum problems fixed.  If you still can not access the forum, you must delete your browser's  cache, close and open the browser or at least to <a  href="http://forum.Rojadirecta.es/?">click  here</a></span></div>
                        </div>
                    </td>
                </tr>
                </table>
    
    <br>-->
    
    <!--
    <center><span class="es"><iframe  src="http://www.facebook.com/plugins/like.php?href=http%3A%2F%2Fwww.facebook.com%2FRojadirecta&amp;layout=standard&amp;show_faces=false&amp;locale=es_ES&amp;width=450&amp;action=like&amp;colorscheme=light&amp;height=18"  scrolling="no" frameborder="0" style="border:none; overflow:hidden;  width:70px; height:18px;"  allowTransparency="true"></iframe></span><span  class="en"><iframe  src="http://www.facebook.com/plugins/like.php?href=http%3A%2F%2Fwww.facebook.com%2FRojadirecta&amp;layout=standard&amp;show_faces=false&amp;locale=en_US&amp;width=450&amp;action=like&amp;colorscheme=light&amp;height=18"  scrolling="no" frameborder="0" style="border:none; overflow:hidden;  width:45px; height:18px;"  allowTransparency="true"></iframe></span>   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  <a target="_blank"  href="http://www.twitter.com/Rojadirecta"><img  src="http://twitter-badges.s3.amazonaws.com/twitter-b.png" height="20"  border="0" alt="Rojadirecta on Twitter"/></a></center>
    <br><br>
    -->
    
    <table border="0" width="325" cellspacing="0" cellpadding="0" id="tablefullmatches">
                <tr>
                    <td bgcolor="#d20808">
                    <p align="left"><font color="#FFFFFF" face="Arial" size="2">&nbsp;&nbsp;
                    <span class="es">?ltimos <b>partidos </b>en<b> descarga</b></span>
                    <span class="en"><b>Download</b> last full <b>matches</b></span>
                    </font></p>
                    </td>
                </tr>
                <tr>
                    <td style="white-space:nowrap; overflow:hidden;" bgcolor="#D5D8E0">
                        <div class="cuadroagenda">
                            <div class="dark"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?178016">MOTOR -   Moto3 G.P. Rep?blica Checa 2012 (Circ...</a></div>
                            <div class="light"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?178014">NFL  2012-2013 / PS / Week 4 / 30.08.2012 / Oak...</a></div> 
                            <div class="dark"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?178011">MLB Regular  Season  New York Mets @ Philadelph...</a></div>
                            <div class="light"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?178010">MLB Regular  Season  San Francisco Giants @ Hou...</a></div>
                            <div class="dark"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?178009">MLB Regular  Season  Boston Red Sox @ Los Angel...</a></div>
                            <div class="light"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?178008">NCAA  Football 2012 Week 01 South Carolina at V...</a></div>
                            <div class="dark"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?178006">NFL  Preseason  Denver Broncos @ Arizona Cardin...</a></div>
                            <div class="light"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?"></a></div>
                        </div>
                    </td>
                </tr>
                </table>
    
    <br>
            <table border="0" width="325" cellspacing="0" cellpadding="0" id="tablehighlights">
                <tr>
                    <td bgcolor="#d20808">
                    <p align="left"><font color="#FFFFFF" face="Arial" size="2">&nbsp;&nbsp;
                    <span class="es">?ltimos <b>videores?menes</b> / <b>goles</b></span>
                    <span class="en">Last <b>video highlights</b></span>
                    </font></p>
                    </td>
                </tr>
                <tr>
                    <td style="white-space:nowrap; overflow:hidden;" bgcolor="#e7e8ed">
                        <div class="cuadroagenda">
                        <div class="dark"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?178018">iTalia Serie  A : Round 1 All Goals</a></div> 
                            <div class="light"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?178017">Europa  League (qual): Rapid Wien - PAOK Thessa...</a></div>
                            <div class="dark"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?178015">Ir?n Persian  Gulf Cup: Sepahan - Fajr Sepasi (...</a></div>
                            <div class="light"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?178013">CONCACAF  Champions League: CD Olimpia - Housto...</a></div>
                            <div class="dark"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?178012">TENIS WTA US  OPEN 2012 - US OPEN 2012 - Ana Iv...</a></div>
                            <div class="light"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?178007">UEFA Europa  League play-offs: FC Twente (Ned) ...</a></div>
                            <div class="dark"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?178005">UEFA Europa  League play-offs: Newcastle United...</a></div>
    <!--                        <div class="light"><a  rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?178001">UEFA Europa  League play-offs: FK Partizan (Srb...</a></div>
                
                            <div class="dark"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?178000">UEFA Europa  L. play-offs: Girondins de Bordeau...</a></div>
                        <div class="light"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?177998">UEFA Europa  League play-offs: Videoton FC (Hun...</a></div>
                        <div class="dark"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?177996">UEFA Europa  League play-offs: Club Brugge KV (...</a></div>
                            <div class="light"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?177993">UEFA Europa  League play-offs: FC Steaua Bucure...</a></div>
    -->
    <!--                            <div class="dark"><a  rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?177992">UEFA Europa  League play-offs: APOEL FC (Cyp) -...</a></div>
                            <div class="light"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?177989">TENIS WTA US  OPEN 2012 - US OPEN 2012 - Kerber...</a></div>
                            <div class="dark"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?177987">UEFA Europa  League play-offs: HJK Helsinki (Fi...</a></div>
                                <div class="light"><a  rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?"></a></div>-->
                    </div>
                    </td>
                </tr>
                </table>
    
    <br>
    
    <!--
                <table border="0" width="325" cellspacing="0" cellpadding="0" id="tablevideos">
                <tr>
                    <td bgcolor="#d20808">
                    <p align="left"><font color="#FFFFFF" face="Arial" size="2">&nbsp;&nbsp;
                    <span class="es">?ltimos <b>videos</b></span>
                    <span class="en">Last <b>videos</b></span>
                    </font></p>
                    </td>
                </tr>
                <tr>
                    <td bgcolor="#D5D8E0">
                        <div class="cuadroagenda">
                    <div class="dark"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?177946">UEFA  Champions League - Draw</a></div>
                    <div class="light"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?177938">Real  madrid-barcelona           vuelta super...</a></div>
                            <div class="dark"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?177937">Real  madrid-barcelona           vuelta super...</a></div>
                <div class="light"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?"></a></div>
                        </div>
                    </td>
                </tr>
                </table>
    -->
    
    <!--
        <br>
        <table align="center" border="0" width="325" cellspacing="0" cellpadding="0" id="tabledebates">
                <tr>
                    <td bgcolor="#d20808">
                    <p align="left"><font color="#FFFFFF" face="Arial" size="2">&nbsp;&nbsp;&nbsp;
                    ?ltimos <b>debates</b></font></p>
                    </td>
                </tr>
                <tr>
                    <td bgcolor="#e7e8ed">
                        <div class="cuadroagenda">
                    <div class="dark"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?177941">El Gobierno  de Estados Unidos retira la demand...</a></div>
                    <div class="light"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?177928">Sorteo fase  de grupos Champions League 2013</a></div>
                        <div class="dark"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?177853">Capriles el  verdugo de chavez en las eleccione...</a></div>
                        <div class="light"><a rel="nonfollow"  href="http://forum.Rojadirecta.es/showthread.php?177832">Supercopa  (vuelta) Real Madrid - Barcelona</a></div>
                        </div>
                    </td>
                </tr>
                </table>
    -->
    
    <div style="overflow:hidden; height:153px">
        <iframe  src="http://www.facebook.com/plugins/likebox.php?href=http%3A%2F%2Fwww.facebook.com%2FRojadirecta&amp;width=325&amp;colorscheme=light&amp;show_faces=true&amp;stream=false&amp;header=false&amp;height=176"  scrolling="no" frameborder="0" style="border:none; overflow:hidden;  width:325px; height:176px;" allowTransparency="true"></iframe>
        <a target="_blank" href="http://www.facebook.com/Rojadirecta"  style="position: relative; left: 7px; top: -90px;"><div  style="height: 66px; width: 280px;  background-color:#FFFFFF;  layer-background-color:#FFFFFF; filter:alpha(opacity=10);   opacity:0.1;"></div></a>
    </div>
    
    <!--<span class="codespain">-->
    
    <!--
    <div style="overflow:hidden; height:110px">
    <script src="http://widgets.twimg.com/j/2/widget.js"></script>
    <script>
    new TWTR.Widget({
      version: 2,
      type: 'search',
      search: 'from:Rojadirecta since:2011-08-05',
      interval: 6000,
      title: '<a href="http://www.twitter.com/Rojadirecta">@Rojadirecta</a>',
      subject: '',
      width: 325,
      height: 120,
      theme: {
        shell: {
          background: '#d20808',
          color: '#ffffff'
        },
        tweets: {
          background: '#ffffff',
          color: '#444444',
          links: '#d20808'
        }
      },
      features: {
        scrollbar: false,
        loop: true,
        live: true,
        hashtags: true,
        timestamp: true,
        avatars: true,
        toptweets: true,
        behavior: 'default'
      }
    }).render().start();
    </script>
    </div>
    <br>
    -->
    <!--</span>-->
    
    
    <span class="es">
    <script type="text/javascript">
    var myDate = new Date();
    //document.write(myDate.getTimezoneOffset());
    huso = myDate.getTimezoneOffset();
    if (   ( (huso == -60) || (huso == -120) ) && (language == 'es') )    {
    var country='Spain';
    }
    
    else {
    document.write('<center><span class="es"><iframe  src="http:\/\/www.facebook.com\/plugins\/like.php?href=http%3A%2F%2Fwww.facebook.com%2FRojadirecta&amp;layout=standard&amp;show_faces=false&amp;locale=es_ES&amp;width=450&amp;action=like&amp;colorscheme=light&amp;height=18"  scrolling="no" frameborder="0" style="border:none; overflow:hidden;  width:70px; height:18px;"  allowTransparency="true"><\/iframe><\/span><span  class="en"><iframe  src="http:\/\/www.facebook.com\/plugins\/like.php?href=http%3A%2F%2Fwww.facebook.com%2FRojadirecta&amp;layout=standard&amp;show_faces=false&amp;locale=en_US&amp;width=450&amp;action=like&amp;colorscheme=light&amp;height=18"  scrolling="no" frameborder="0" style="border:none; overflow:hidden;  width:45px; height:18px;"  allowTransparency="true"><\/iframe><\/span>   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  <a target="_blank"  href="http:\/\/www.twitter.com\/Rojadirecta"><img  src="http:\/\/twitter-badges.s3.amazonaws.com\/twitter-b.png"  height="20" border="0" alt="Rojadirecta on  Twitter"\/><\/a><\/center>');
    document.write('<br><br>');
    }
    
    </script>
    </span>
    
    
    
    <!-- Banner eventual dcha-->
    <!-- Fin Banner-->
            </td>
        </tr>
    </table>
    
    
    
    </td>
    </tr>
    <tr>
    <td valign="bottom">
    <!-- Banner inf aqu?-->
    <table width="100%" align="center">
    
      <tr>
        <td align="center">
        </td>
      </tr>
    </table>
    
    <table width="100%" cellpadding="0" cellspacing="0">
    <tr>
    <td class="subtitle">
    <div align="center">
    
    <a rel="license"  href="http://creativecommons.org/licenses/by-nc-sa/3.0/"><img  alt="Creative Commons License" style="border-width:0"  src="http://www.Rojadirecta.me/static/cc.png"  /></a><br><a href="javascript:popUpscroll('/contactar',434,148)"><span  class="es">Contactar</span><span  class="en">Contact</span></a> - <a title="Clica para  abrir" target="_blank" href="/legal"><span class="es">Amenazas  legales</span><span class="en">Legal  threats</span></a> - <a rel="license"  href="http://creativecommons.org/licenses/by-nc-sa/3.0/"><span  class="es">Licencia </span>CC<span class="en">  License</span></a> - <span class="codespain"><a  href="javascript:popUpscroll('/legal/aviso/',675,525)">Aviso  Legal</a> -</span> <span class="es"><a  href="http://blog.Rojadirecta.es/">Blog de  Rojadirecta</a></span><span class="en"><a  href="http://blog.Rojadirecta.es/">Rojadirecta's  Blog</a></span> - <span class="es"><a  href="http://www.facebook.com/Rojadirecta">Rojadirecta en  Facebook</a></span><span class="en"><a  href="http://www.facebook.com/Rojadirecta">Rojadirecta on  Facebook</a></span> - <span class="es"><a  href="http://twitter.com/Rojadirecta">Rojadirecta en  Twitter</a></span><span class="en"><a  href="http://twitter.com/Rojadirecta">Rojadirecta on  Twitter</a></span> - <a href="http://www.Rojadirecta.me/"  rel="cc:attributionURL">Rojadirecta</a>
    </div>
    </td>
    </tr>
    </table>
    
    </td>
    
    
    <!-- P?gina generada a las 22:43:2 -->
    
    </tr>
    </table>
    
    </td>
    </tr>
    </table>
    
    
    <script type="text/javascript" language="JavaScript">
    
    var ie = (document.all) ? true : false;
    var elements = (ie) ? document.all : document.getElementsByTagName('span');
    if ( (language=='es') || (language=='ca') ||  (language=='gl') || (language=='eu') ) {
            for (i=0; i<elements.length; i++){
                if (elements[i].className=='en'){
                elements[i].style.display="none"
                }
            }
    document.getElementById('minhapesquisa').innerHTML = '<input type="text" id="searchInput" value="US Open">';
    }
    //else if (language=='en') {  }
    else {
          for (i=0; i<elements.length; i++){
            if (elements[i].className=='es'){
            elements[i].style.display="none"
            }
          }
    document.getElementById('minhapesquisa').innerHTML = '<input type="text" id="searchInput" value="US Open">';
    }
    
    if (country=='Spain') {
            for (i=0; i<elements.length; i++){
                if (elements[i].className=='codemundo'){
                elements[i].style.display="none"
                }
            }
    }
    else {
          for (i=0; i<elements.length; i++){
            if (elements[i].className=='codespain'){
            elements[i].style.display="none"
            }
          }
    }
    
    
    if  (!navigator.userAgent.match(/android|avantgo|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge  |maemo|midp|mmp|opera m(ob|in)i|palm(  os)?|phone|ipad|ipod|tablet|mobile|skyfire|p(ixi|re)\/|plucker|pocket|psp|symbian|treo|up\.(browser|link)|vodafone|wap|windows  (ce|phone)|xda|xiino/i)) {
            for (i=0; i<elements.length; i++){
                if (elements[i].className=='mobile'){
                elements[i].style.display="none"
                }
            }
    }
    
    
    </script>
    
    
    <script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
    </script>
    <script type="text/javascript">
    _uacct = "UA-190107-1";
    urchinTracker();
    </script>
    
    </body>
    
    </html>
    ]







  2. #2
    عضو سوبر نشيط
    تاريخ التسجيل
    Apr 2010
    المشاركات
    709


    انت تريد تكرار الروابط ؟ اذن قم بحذف DISTINCT من استعلام sql !!





    __________________
    تصميم و برمجة : سرعة و إتقان.
    للاتصال : codezigner@gmail.com





ضوابط المشاركة

  • لا تستطيع إضافة مواضيع جديدة
  • لا تستطيع الرد على المواضيع
  • لا تستطيع إرفاق ملفات
  • لا تستطيع تعديل مشاركاتك
  •  

أضف موقعك هنا| اخبار السيارات | حراج | شقق للايجار في الكويت | بيوت للبيع في الكويت | دليل الكويت العقاري | مقروء | شركة كشف تسربات المياه | شركة عزل اسطح بالرياض | عزل فوم بالرياض| عزل اسطح بالرياض | كشف تسربات المياة بالرياض | شركة عزل اسطح بالرياض