Help with query

mattastic

Hi,

Could anybody tell me how the "%s" works when formatting values?

I need to format the date too, to something more readable.

Can anyone explain how this works aswell?

If someone could point me a tutorial that would be great.

Thanks

My code is attached

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

  echo "<table >\n";
  echo "<tr><td>Title</td><td>description</td><td>Start date</td><td>End date</td></tr>\n";
  do {
   printf("<tr><td>%s\n</td>", $myrow["eventtitle"]);
     printf("<td>%s\n</td>", $myrow["eventdescription"]);
	    printf("<td>%s\n</td>", $myrow["startdate"]);
	 printf("<td>%s\n</td></tr>", $myrow["enddate"]);

  } while ($myrow = mysql_fetch_array($result));
	echo "</table>\n";
} else {
	echo "Sorry, no records were found!";	

}

Rodney_H_

I believe in your example, "%s" tells the printf() function to treat the argument, "$myrow['eventtitle']" for example, as a string. So, there is no formatting that is happening in your example, but "%s" is acting like a space-holder.

Here is a tutorial that I remember off the top of my head: http://codewalkers.com/tutorials/45/10.html, although googling it will certainly produce many more results for you. And, you may wish to read the manual on it.

edit PS. How is your date currently formatted, and how would you like it to look??

mattastic

Thanks for your reply.

My date is stored in my db as 2005-01-01 00:00:00, but I would like it to read 1/1/2005, or something similar so it is more readable.

Currently I use:

date("d-m-y",$myrow["startdate"])

but whatever the date, all I get is 01-01-70

Rodney_H_

I think something like this might work for you:

<?php
// current date stored in db
$date = '2005-11-27 11:09:24 am';

// convert to unix timestamp
$date =  strtotime($date);

// reformat timestamp however you want
$date = date('n/j/Y', $date);

echo $date; // 11/27/2005
?>

mattastic

Thanks again for your reply.

Do you know how to add 1 month to a given date?

I guess you use mktime(), but I'm not sure how.

Thanks