date from mysql
| From: | Hendråwan Rinäldi | Date: | Thu, 29 Aug 2002 11:29:21 +0000 |
| Subject: | date from mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-114494@lists.php.net to get a copy of this message | ||
i want Y (year format) printed on my php script (looping), i already tried
it but i got same Year format (ex 1978) in all row in my table
my loop script is:
$query = ("select * from table");
$result = mysql_query($query);
while ($row = mysql_fetch_row($result))
$number = mysql_numrows($result);
$i = 0;
while ($i < $number):
$date = mysql_result($result, $i,$date");
if ($i%2 == 0){
echo "<b>$date</b>";
if ($i%2 == 0){
echo "$date";
}
$i++;
ENDWHILE;