Results 1 to 1 of 1

Thread: Display random images using php and mysql

  1. #1
    Join Date
    Apr 2009
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Display random images using php and mysql

    Hai,

    In a php page I want to display the images that are stored in mysql db ,and these images should not be static they should change dynamically .
    please cut and paste below code on dreamweaver on left side there is a sentense "What makes these sitters expecially great? Scroll over photos for more..." below that you have 4 images(new test2 test test ,actually here is tag but itis not displaying). these are coming from data base, after some delay in the place of these images new images should be displayed.
    code is

    HTML Code:
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
    <title>Sitter Socials - where parents & babysitters connect</title>
    <link href="css/ss.css" rel="stylesheet" type="text/css" />
    <link href="ss.css" rel="stylesheet" type="text/css" />
    <style type="text/css">
    <!--
    body {
    margin-left: 0px;
    margin-top: 0px;
    margin-right: 0px;
    margin-bottom: 0px;
    }
    
    -->
    </style>
    <script type="text/javascript" src="jquery-1.2.2.pack.js"></script>
    <script type="text/javascript" src="ajaxtooltip.js"></script>
    <style type="text/css">
    
    .ajaxtooltip{
    position: absolute; /*leave this alone*/
    display:block; /*leave this alone*/
    vertical-align:bottom;
    width: 300px;
    left: 0; /*leave this alone*/
    top: 0; /*leave this alone*/
    /*background: lightyellow;*/
    /*border: 2px solid gray;
    border-width: 1px 2px 2px 1px;*/
    padding: 0px;
    }
    
    </style>
    <link href="../ss.css" rel="stylesheet" type="text/css" />
    
    <link href="stylesheet_sitter.css" rel="stylesheet" type="text/css" />
    <script>
    function plus(){
    document.getElementById('one').style.display='';
    }
    function minus()
    {
    document.getElementById('one').style.display='none';
    
    }
    function plus2(){
    document.getElementById('two').style.display='';
    }
    function minus2()
    {
    document.getElementById('two').style.display='none';
    
    }
    function plus3(){
    document.getElementById('three').style.display='';
    }
    function minus3()
    {
    document.getElementById('three').style.display='none';
    
    }
    </script>
    </head>
    
    <body>
    
    <table width="100%" border="0" cellspacing="0" cellpadding="0" background="tblimg/bgrnd.gif">
    <tr>
    <td align="center">
    <table width="1000" border="0" cellspacing="0" cellpadding="0" background="tblimg/bgrnd.gif">
    <tr><td colspan="5"> </td></tr>
    
    <tr>
    <td align="right" valign="bottom"></td>
    <td align="left" valign="bottom"></td>
    <td width="100%" align="center" valign="bottom" background="tblimg/up03.gif"></td>
    <td align="right" valign="bottom"></td>
    <td align="left" valign="bottom"></td>
    </tr>
    <tr>
    <td align="right" valign="top"> </td>
    
    <td align="center" colspan="3">
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
    <td align="center" valign="top" bgcolor="FFFFFF">
    
    <!-- 11111111111111111111111 -->
    
    <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
    <tr>
    <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr><td colspan="4" align="center">
    
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
    <td width="15%"> </td>
    <td width="15%"> </td>
    </tr>
    </table>
    </td></tr>
    
    <tr>
    <td width="4" align="left" valign="top"> </td>
    <td width="413" align="left" valign="top">
    </td>
    
    <td width="20"> </td>
    <td width="541" align="left" valign="middle" class="plstxt">
    
    </td>
    </tr>
    </table></td>
    </tr>
    <tr>
    <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
    
    <td width="199" align="left" valign="top">
    
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
    
    <tr>
      <td align="left" valign="top">&nbsp;</td>
    </tr>
    <tr>
    
    <td align="center" valign="top" bgcolor="#AFBD21" class="atrate"><table width="100%" border="0" cellspacing="6" cellpadding="0">
    <tr>
    <td align="center" valign="top" class="serachinner">Meet your Social Director!</td>
    </tr>
    </table></td>
    </tr>
    <tr>
    <td align="center" valign="top" bgcolor="#904A2C" ><table width="100%" border="0" cellspacing="5" cellpadding="0">
    
    <tr>
    <td align="center" valign="top">
    </td>
    </tr>
    </table></td>
    </tr>
    <tr>
    <td align="left" valign="top"></td>
    </tr>
    
    <tr>
    <td height="32" align="center" valign="middle" bgcolor="#904A2C">
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr><td colspan="3" align="center" height="30"><span class="socialname">my events</span></td>
    </tr>
    </table>
    
    </td>
    </tr>
    
    <tr>
    <td align="left" valign="top"></td>
    </tr>
    <tr>
    <td height="32" align="" valign="middle" bgcolor="#904A2C">
    
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr><td class="socialname" align="center" height="25">about me</td></tr>
    <tr>
    
    <td align="justify">
    <div style="width:200px;" class="parentinertxt">
    425.... </div>
    </td>
    </tr>
    <tr><td height="5"></td></tr>
    </table>
    
    </td>
    
    </tr>
    <tr>
    <td align="left" valign="top"></td>
    </tr>
    <tr>
    <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
    <td width="98%" align="left" valign="top" background="images/tablepadding_bg_up.png"></td>
    <td width="2%" rowspan="3" align="left" valign="top" background="images/leftpaading_bg.png"></td>
    
    </tr>
    <tr>
    <td><table width="100%" border="0" cellspacing="0" cellpadding="2">
    
    <tr>
    <td align="center" valign="top"></td>
    </tr>
    <tr>
    <td align="center" valign="top" bgcolor="#904A2C"><span class="featurediner">What makes these sitters
    
    expecially great?
    Scroll over photos for more...</span></td>
    </tr>
    <tr>
    <td align="center" valign="top">
    
    <table border="0" width="98%" cellpadding="0" cellspacing="0" style="border:#996666 solid 1px;">
    <tr>
    
    <td valign="top">
    
    <table width="100%" border="0" cellpadding="0" cellspacing="0">
    <tr>
    <td height="89" valign="top"> </td>
    <td valign="top" align="left">
    <table border="0" cellpadding="3" cellspacing="3" bordercolor="#CCCCCC">
    
    <tr><td align=center valign=top><div align="center" style="vertical-align:bottom;"> [new] </div>
    </td><td align=center valign=top><div align="center" style="vertical-align:bottom;"> [test2] </div>
    
    </td></tr><td align=center valign=top><div align="center" style="vertical-align:bottom;"> [test] </div>
    </td><td align=center valign=top><div align="center" style="vertical-align:bottom;"> [test] </div>
    </td></tr>
    </table></td>
    <td valign="top"> </td>
    </tr>
    </table>
    
    </td>
    </tr>
    
    </table>
    
    </td>
    </tr>
    
    </table>
    </td>
    </tr>
    <tr>
    <td background="images/tablepadding_bg_up.png" style="background-repeat:repeat-x"></td>
    </tr>
    
    </table></td>
    </tr>
    <tr>
    <td height="5"></td>
    </tr>
    </table>
    
    </td>
    <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
    
    <td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
    <td width="83%" align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
    <tr>
    <td align="left" valign="top"></td>
    </tr>
    <tr>
      <td height="27" align="left" valign="top">&nbsp;</td>
    </tr>
    </table></td>
    <td align="center" valign="middle" class="menutxt"></td> <!--<td width="17%" align="left" valign="top"></td>-->
    </tr>
    
    <tr>
    <td colspan="2" align="left" valign="top" bgcolor="#E6EFBB"></td>
    </tr>
    <tr>
    <td colspan="2" align="left" valign="top" background="images/menu_d_padding.png" style="background-repeat:repeat-x"> </td>
    </tr>
    </table></td>
    </tr>
    <tr>
    
      <td align="left" valign="top">&nbsp;</td>
    </tr>
    </table></td>
    </tr>
    
    </table></td>
    </tr>
    <tr>
    
    <td align="left" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" id="footertable">
    <tr>
    <td align="center" valign="top"> </td>
    </tr>
    <tr>
    <td align="center" valign="top"> </td>
    </tr>
    </table></td>
    </tr>
    
    </table>
    
    </td>
    </tr>
    </table>
    </td>
    <td align="left" valign="top"> </td>
    </tr>
    
    <tr>
    <td align="right" valign="top"></td>
    <td align="left" valign="top"></td>
    <td align="center" valign="top" background="tblimg/down03.gif"></td>
    <td align="right" valign="top"></td>
    <td align="left" valign="top"></td>
    </tr>
    <tr><td colspan="5"> </td>
    </tr>
    
    </table>
    </td>
    </tr>
    </table>
    
    </body>
    </html>
    Last edited by Snookerman; 05-13-2009 at 01:37 PM. Reason: added [html] tags

Bookmarks

Posting Permissions

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