help with date

Anon

Ok, I've set up a my sql db and it has a date field yyyy-mm-dd

Actually, the field is the starting date of a course (the table consists out of a list of available courses and a lot of practical information)

When I search the database, we'll display the name of the course and the date. Now we're European based and we want the date in another format.

now how is this done in PHP or MYSQL? I want it to display the date in the format dd-mm-yyyy

Any suggestion will be more than welcome? Thanks in advance.

Anon

write a php function like this:

function convert_date($date){
$date_parts=$explode("-",$date);
$new_date="$date_parts[2].$date_parts[1].$date_parts[0]";
echo $new_date;
}

then run it:
convert_date($date_in_us_format);

and it will output:
dd.mm.yyyy

Anon

and how would one include this in this script?

<?php

	  mysql_connect (localhost, user, password);

	  mysql_select_db (db);


	  $result = mysql_query ("SELECT * FROM $usertable
	                           WHERE benaming LIKE '%$benaming%' AND locatie = '$plaats'
	                        ");

	  if ($row = mysql_fetch_array($result)) {


	  do {
	 		      print ("<tr><td>");
	 		      print ("<a href=\"http://www.cmo-mechelen.be/detail.php?id=$row[id]\" class=frontlinkred2>");
	 			  print $row["benaming"];
	 			  print ("</a>.");
	 			  print ("</td>");
	 			  print ("<td>");
	 			  print ("<div class=fronttext>");
	 			  print $row["startdatum"];
	 			  print ("</div>");
	 			  print ("</td>");
	 			  print ("<td>");
	 			  print ("<div class=fronttext>");
	 			  print $row["locatie"];
	 			  print ("</div>");
	 			  print ("</td>");


	 		  } while($row = mysql_fetch_array($result));

	 		  } else {print "<b>Sorry, geen records gevonden! Probeer het opnieuw met een ander trefwoord of surf per categorie.</b><br><br>";}

	  ?>

phlow

first you define the function at the top of the page. then replace the line

print $row["startdatum"];

with the lines:
$start_date=$row["startdatum"];
echo convert_date($start_date);

shoult work like that.

have phun,

Phlow