Display random images using php and mysql [Archive]

ganu

05-13-2009, 01:26 PM

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

<!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">

</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">



<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"> </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"> </td>
</tr>
</table></td>
<td align="center" valign="middle" class="menutxt"></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"> </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>