i have change my code and when i ran it, its like just nothins happen.
im confuse w/c part of my code where i put the strtotime function in printing the result and i just put it in line 13. is it possible to put it in line 56? by the way thanks for the idea!..
<?php
$con = mysql_connect("localhost","pbclub","theclub");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("pinkbox", $con);
$dbirth = '0000-00-00';
date("F j, Y", strtotime($dbirth));
$query="SELECT * FROM club_members order by idno asc";
$result=@mysql_query($query);
$amount = mysql_num_rows($result);
mysql_close($con);
mysql_connect("localhost","pbclub","theclub") or die ("cannot connect to database");
?>
<html>
<head></head>
<body bgcolor="pink">
<br><br>
<font face=arial narrow size=1 color=white><a href="welcomeadmin.php">ADMIN </a> |
<a href="register.php">REGISTER </a> |
<font face=arial narrow size=1 color=white><a href="logout.php">LOGOUT </a>
</font><br><br>
<table width="900" cellpadding="0" cellspacing="0" align="center" border="1">
<tr>
<td colspan="7"align=center bgcolor="ea418f"><font face=arial size=3 color=fdcde7><b>PINKBOX CLUB MEMBERS</b></font></td>
</tr>
<tr>
<td bgcolor=silver align=center style=border-left: 0px style=border-bottom: 0px><font face=arial size=2>BRANCH CODE</font></td>
<td bgcolor=silver align=center style=border-left: 0px style=border-bottom: 0px><font face=arial size=2>IDNO</font></td>
<td bgcolor=silver align=center style=border-left: 0px style=border-bottom: 0px><font face=arial size=2>NAME</font></td>
<td bgcolor=silver align=center style=border-left: 0px style=border-bottom: 0px><font face=arial size=2>DATE OR BIRTH</font></td>
<td bgcolor=silver align=center style=border-left: 0px style=border-bottom: 0px><font face=arial size=2>DATE REGISTERED</font></td>
<td bgcolor=silver align=center style=border-left: 0px style=border-bottom: 0px><font face=arial size=2>CONTACT NUMBER</font></td>
<td bgcolor=silver align=center style=border-left: 0px style=border-bottom: 0px><font face=arial size=2>EMAIL</font></td>
</tr>
<?php
while($row=@mysql_fetch_array($result)) {
print("
<tr>
<td align=center style=border-left: 0px style=border-bottom: 0px><font color=7a1243 face=arial size=2>$row[bcode]</font></td>
<td align=center style=border-left: 0px style=border-bottom: 0px><font color=7a1243 face=arial size=2>$row[idno]</font></td>
<td align=left style=border-left: 0px style=border-bottom: 0px><font color=7a1243 face=arial size=2>$row[name]</font></td>
<td align=left style=border-left: 0px style=border-bottom: 0px><font color=7a1243 face=arial size=2>$row[dbirth]</font></td>
<td align=left style=border-left: 0px style=border-bottom: 0px><font color=7a1243 face=arial size=2>$row[reg_date]</font></td>
<td align=left style=border-left: 0px style=border-bottom: 0px><font color=7a1243 face=arial size=2>$row[contact_num]</font></td>
<td align=left style=border-left: 0px style=border-bottom: 0px><font color=7a1243 face=arial size=2>$row[email]</font></td>
</tr>
");
}
echo " <table border=1 width=900 align=center>
<tr>
<td align=right bgcolor=silver><font face='arial' color='7a1243' size='1'> <b>".$amount." member(s) </b></font></td>
</tr>
</table>
";
?>
</table>
</body>
</html>
11 Jan, 2008 - 10:12 PM
im confuse w/c part of my code where i put the strtotime function in printing the result and i just put it in line 13. is it possible to put it in line 56? by the way thanks for the idea!.. 
| 