Date and time formats from mysql

jcgkiwi · #1 19-Jun-2005, 05:29

Hi,
This is my first post...
I am just starting out using php & mysql and am trying to display results containing date and time fields.
see www.jcgkiwi.net.nz
I have found lots of useful tips to JUST extract the date & time in the correct format, but how do you display it correctly when it is in the middle of other data???
here is my php...

PHP Code:


$query="SELECT * FROM stats";

$result=mysql_query($query);

echo "<p class=\"title\">2005 Papamoa VFB Stats<br></p>";

echo "<table class=\"tbl\"><tr><td class=\"stat\">Call #</td><td class=\"stat\">Date</td><td class=\"stat\">Time</td><td class=\"stat\">Appliances</td><td class=\"stat\">Address</td><td class=\"stat\">Call Description</td><td class=\"stat\">Details</td></tr>";

while($row = mysql_fetch_array($result))
{
    echo"<tr><td class=\"stat1\">" . $row[1] ."<br>". $row[2] . "</td><td class=\"stat1\">" . $row[3] . "</td><td class=\"stat1\">" . $row[4] . "</td><td class=\"stat1\">" . $row[5] . "</td><td class=\"stat\">" . $row[6] . "</td><td class=\"stat\">" . $row[7] . "</td><td class=\"stat\">" . $row[8] . "</td></tr>";
} 

echo "</table>";

Any help would be appreciated thanks.

JdS · #2 21-Jun-2005, 08:37

The are many ways you can do this, we discuss some of these ideas here: http://www.gidforums.com/t-6075.html.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: Get the date / time difference with PHP	admin	PHP Code Library	4	15-Nov-2006 23:43
Limit combo box and date time picker choice according to database created in folder	shinyhui	C++ Forum	0	22-Feb-2005 20:16
Limit combo box and date time picker choice according to database created in folder	shinyhui	MS Visual C++ / MFC Forum	0	22-Feb-2005 02:13
Re: Programming Techniques	WaltP	C Programming Language	0	09-Mar-2004 23:56