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

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

Expand Messages
  • Anees
    Thanks Vijay i almost followed same method which u mentioned Anees Muhammed ... From: Vijay Srinivas To:
    Message 1 of 6 , Nov 21, 2007
    • 0 Attachment
      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.