Loading ...
Sorry, an error occurred while loading the content.
 

Re: [bang-phpug] Random record from latest 10 entries...

Expand Messages
  • Anees
    Hi, Thanks for ur response Anoop But i need only one record as a result!!! Not 10 Anees Muhammed ... From: From Anoop To:
    Message 1 of 6 , Nov 20, 2007
      Hi,
      Thanks for ur response Anoop
      But i need only one record as a result!!! Not 10


      Anees Muhammed
      ___________


      ----- Original Message ----
      From: From Anoop <anoop_leo@...>
      To: bang-phpug@yahoogroups.com
      Sent: Tuesday, November 20, 2007 8:35:20 PM
      Subject: Re: [bang-phpug] Random record from latest 10 entries...














      Hi Anees,



      You can get it through query only. For example:-



      SELECT q.q_id FROM test_questions q order by RAND() LIMIT 10



      You will get 10 random records from the above query.



      Regards,

      Anoop



      Anees <anees_muhd@yahoo. com> wrote: HI



      I need to show a random image from Data base,

      and it should be from the latest 10 records



      How can i get it by executing only ONE query?

      Please help me



      Regards

      Anees Muhammed

      ___________



      ____________ _________ _________ _________ _________ _________ _

      Never miss a thing. Make Yahoo your home page.

      http://www.yahoo com/r/hs



      [Non-text portions of this message have been removed]











      ------------ --------- --------- ---

      5, 50, 500, 5000 - Store N number of mails in your inbox. Click here.



      [Non-text portions of this message have been removed]














      <!--

      #ygrp-mkp{
      border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;}
      #ygrp-mkp hr{
      border:1px solid #d8d8d8;}
      #ygrp-mkp #hd{
      color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;}
      #ygrp-mkp #ads{
      margin-bottom:10px;}
      #ygrp-mkp .ad{
      padding:0 0;}
      #ygrp-mkp .ad a{
      color:#0000ff;text-decoration:none;}
      -->



      <!--

      #ygrp-sponsor #ygrp-lc{
      font-family:Arial;}
      #ygrp-sponsor #ygrp-lc #hd{
      margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
      #ygrp-sponsor #ygrp-lc .ad{
      margin-bottom:10px;padding:0 0;}
      -->



      <!--

      #ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
      #ygrp-mlmsg table {font-size:inherit;font:100%;}
      #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;}
      #ygrp-mlmsg pre, code {font:115% monospace;}
      #ygrp-mlmsg * {line-height:1.22em;}
      #ygrp-text{
      font-family:Georgia;
      }
      #ygrp-text p{
      margin:0 0 1em 0;}
      #ygrp-tpmsgs{
      font-family:Arial;
      clear:both;}
      #ygrp-vitnav{
      padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
      #ygrp-vitnav a{
      padding:0 1px;}
      #ygrp-actbar{
      clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
      #ygrp-actbar .left{
      float:left;white-space:nowrap;}
      .bld{font-weight:bold;}
      #ygrp-grft{
      font-family:Verdana;font-size:77%;padding:15px 0;}
      #ygrp-ft{
      font-family:verdana;font-size:77%;border-top:1px solid #666;
      padding:5px 0;
      }
      #ygrp-mlmsg #logo{
      padding-bottom:10px;}

      #ygrp-vital{
      background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
      #ygrp-vital #vithd{
      font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
      #ygrp-vital ul{
      padding:0;margin:2px 0;}
      #ygrp-vital ul li{
      list-style-type:none;clear:both;border:1px solid #e0ecee;
      }
      #ygrp-vital ul li .ct{
      font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
      #ygrp-vital ul li .cat{
      font-weight:bold;}
      #ygrp-vital a{
      text-decoration:none;}

      #ygrp-vital a:hover{
      text-decoration:underline;}

      #ygrp-sponsor #hd{
      color:#999;font-size:77%;}
      #ygrp-sponsor #ov{
      padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
      #ygrp-sponsor #ov ul{
      padding:0 0 0 8px;margin:0;}
      #ygrp-sponsor #ov li{
      list-style-type:square;padding:6px 0;font-size:77%;}
      #ygrp-sponsor #ov li a{
      text-decoration:none;font-size:130%;}
      #ygrp-sponsor #nc{
      background-color:#eee;margin-bottom:20px;padding:0 8px;}
      #ygrp-sponsor .ad{
      padding:8px 0;}
      #ygrp-sponsor .ad #hd1{
      font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
      #ygrp-sponsor .ad a{
      text-decoration:none;}
      #ygrp-sponsor .ad a:hover{
      text-decoration:underline;}
      #ygrp-sponsor .ad p{
      margin:0;}
      o{font-size:0;}
      .MsoNormal{
      margin:0 0 0 0;}
      #ygrp-text tt{
      font-size:120%;}
      blockquote{margin:0 0 0 4px;}
      .replbq{margin:4;}
      -->








      ____________________________________________________________________________________
      Get easy, one-click access to your favorites.
      Make Yahoo! your homepage.
      http://www.yahoo.com/r/hs

      [Non-text portions of this message have been removed]
    • Anees
      Hi I got the result This is the one somebody suggested, but ending with an error in My Sql SELECT * FROM my_table ORDER BY id DESC LIMIT ((RAND() * 10) - 1),1
      Message 2 of 6 , Nov 20, 2007
        Hi
        I got the result

        This is the one somebody suggested, but ending with an error in My Sql
        SELECT * FROM my_table ORDER BY id DESC LIMIT ((RAND() * 10) - 1),1


        so i went for


        $rnd_num = rand(0,9);
        $get_rnd_pic = "SELECT * FROM my_table ORDER BY id DESC LIMIT ".$rnd_num.",1";

        Thanks guys....

        Anees Muhammed
        ___________




        I need to show a random image from Data base,



        and it should be from the latest 10 records



        How can i get it by executing only ONE query?











        ____________________________________________________________________________________
        Be a better sports nut! Let your teams follow you
        with Yahoo Mobile. Try it now. http://mobile.yahoo.com/sports;_ylt=At9_qDKvtAbMuh1G1SQtBI7ntAcJ

        [Non-text portions of this message have been removed]
      • Vijay Srinivas
        Well Anees, if the date when the images are stored is mentioned, then it is like this. $ImgNo=rand(0,9); $rsSelImage=mysql_query( SELECT img FROM imgTable
        Message 3 of 6 , Nov 21, 2007
          Well Anees, if the date when the images are stored is
          mentioned, then it is like this.

          $ImgNo=rand(0,9);
          $rsSelImage=mysql_query("SELECT img FROM imgTable
          ORDER BY date_created LIMIT $ImgNo, 1", $con);
          $ArrSelImage=mysql_fetch_array($rsSelImage);
          print "<img src=\"".$ArrSelImage['img']."\"></img>";

          Hope this works.
          --- Anees <anees_muhd@...> wrote:

          > HI
          >
          > I need to show a random image from Data base,
          > and it should be from the latest 10 records
          >
          > How can i get it by executing only ONE query?
          > Please help me
          >
          > Regards
          > Anees Muhammed
          > ___________
          >
          >
          >
          >
          >
          >
          >
          ____________________________________________________________________________________
          > Never miss a thing. Make Yahoo your home page.
          > http://www.yahoo.com/r/hs
          >
          > [Non-text portions of this message have been
          > removed]
          >
          >



          ____________________________________________________________________________________
          Be a better pen pal.
          Text or chat with friends inside Yahoo! Mail. See how. http://overview.mail.yahoo.com/
        • Anees
          Thanks Vijay i almost followed same method which u mentioned Anees Muhammed ... From: Vijay Srinivas To:
          Message 4 of 6 , Nov 21, 2007
            Thanks Vijay
            i almost followed same method which u mentioned


            Anees Muhammed
            ___________


            ----- Original Message ----
            From: Vijay Srinivas <vijay_srini_2000@...>
            To: bang-phpug@yahoogroups.com
            Sent: Thursday, November 22, 2007 12:47:00 AM
            Subject: Re: [bang-phpug] Random record from latest 10 entries...














            Well Anees, if the date when the images are stored is

            mentioned, then it is like this.



            $ImgNo=rand( 0,9);

            $rsSelImage= mysql_query( "SELECT img FROM imgTable

            ORDER BY date_created LIMIT $ImgNo, 1", $con);

            $ArrSelImage= mysql_fetch_ array($rsSelImag e);

            print "<img src=\"".$ArrSelImag e['img']. "\"></img> ";



            Hope this works.

            --- Anees <anees_muhd@yahoo. com> wrote:



            > HI

            >

            > I need to show a random image from Data base,

            > and it should be from the latest 10 records

            >

            > How can i get it by executing only ONE query?

            > Please help me

            >

            > Regards

            > Anees Muhammed

            > ___________

            >

            >

            >

            >

            >

            >

            >

            ____________ _________ _________ _________ _________ _________ _

            > Never miss a thing. Make Yahoo your home page.

            > http://www.yahoo. com/r/hs

            >

            > [Non-text portions of this message have been

            > removed]

            >

            >



            ____________ _________ _________ _________ _________ _________ _

            Be a better pen pal.

            Text or chat with friends inside Yahoo! Mail. See how. http://overview. mail.yahoo. com/












            <!--

            #ygrp-mkp{
            border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;}
            #ygrp-mkp hr{
            border:1px solid #d8d8d8;}
            #ygrp-mkp #hd{
            color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;}
            #ygrp-mkp #ads{
            margin-bottom:10px;}
            #ygrp-mkp .ad{
            padding:0 0;}
            #ygrp-mkp .ad a{
            color:#0000ff;text-decoration:none;}
            -->



            <!--

            #ygrp-sponsor #ygrp-lc{
            font-family:Arial;}
            #ygrp-sponsor #ygrp-lc #hd{
            margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
            #ygrp-sponsor #ygrp-lc .ad{
            margin-bottom:10px;padding:0 0;}
            -->



            <!--

            #ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
            #ygrp-mlmsg table {font-size:inherit;font:100%;}
            #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;}
            #ygrp-mlmsg pre, code {font:115% monospace;}
            #ygrp-mlmsg * {line-height:1.22em;}
            #ygrp-text{
            font-family:Georgia;
            }
            #ygrp-text p{
            margin:0 0 1em 0;}
            #ygrp-tpmsgs{
            font-family:Arial;
            clear:both;}
            #ygrp-vitnav{
            padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
            #ygrp-vitnav a{
            padding:0 1px;}
            #ygrp-actbar{
            clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
            #ygrp-actbar .left{
            float:left;white-space:nowrap;}
            .bld{font-weight:bold;}
            #ygrp-grft{
            font-family:Verdana;font-size:77%;padding:15px 0;}
            #ygrp-ft{
            font-family:verdana;font-size:77%;border-top:1px solid #666;
            padding:5px 0;
            }
            #ygrp-mlmsg #logo{
            padding-bottom:10px;}

            #ygrp-vital{
            background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
            #ygrp-vital #vithd{
            font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
            #ygrp-vital ul{
            padding:0;margin:2px 0;}
            #ygrp-vital ul li{
            list-style-type:none;clear:both;border:1px solid #e0ecee;
            }
            #ygrp-vital ul li .ct{
            font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
            #ygrp-vital ul li .cat{
            font-weight:bold;}
            #ygrp-vital a{
            text-decoration:none;}

            #ygrp-vital a:hover{
            text-decoration:underline;}

            #ygrp-sponsor #hd{
            color:#999;font-size:77%;}
            #ygrp-sponsor #ov{
            padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
            #ygrp-sponsor #ov ul{
            padding:0 0 0 8px;margin:0;}
            #ygrp-sponsor #ov li{
            list-style-type:square;padding:6px 0;font-size:77%;}
            #ygrp-sponsor #ov li a{
            text-decoration:none;font-size:130%;}
            #ygrp-sponsor #nc{
            background-color:#eee;margin-bottom:20px;padding:0 8px;}
            #ygrp-sponsor .ad{
            padding:8px 0;}
            #ygrp-sponsor .ad #hd1{
            font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
            #ygrp-sponsor .ad a{
            text-decoration:none;}
            #ygrp-sponsor .ad a:hover{
            text-decoration:underline;}
            #ygrp-sponsor .ad p{
            margin:0;}
            o{font-size:0;}
            .MsoNormal{
            margin:0 0 0 0;}
            #ygrp-text tt{
            font-size:120%;}
            blockquote{margin:0 0 0 4px;}
            .replbq{margin:4;}
            -->








            ____________________________________________________________________________________
            Never miss a thing. Make Yahoo your home page.
            http://www.yahoo.com/r/hs

            [Non-text portions of this message have been removed]
          Your message has been successfully submitted and would be delivered to recipients shortly.