displaying date different from default

[sprint10s]

im trying to change the date from default to Month Day, Year.  Basically the user fills out a form then i echo the results in a table but the date format that i got in my code didn't change the default date.  You can see what the output looks like at www.standridgemotorsports.com/jeremy_schedule1.php

below is the code.

 

thanks for any help.

 $result = mysql_query("SELECT *,DATE_FORMAT('h0237','%M-%d-%Y') FROM jos_jforms_72563 WHERE uid = 63 ORDER BY h0237 ASC");

echo "<table align='center' border='1'>
<tr>
<th>Date</th>
<th>Track</th>
<th>Description</th>
<th>Special Show</th>
<th>Race Type</th>
</tr>";

while($row = mysql_fetch_array($result))

  {
  echo "<tr>";
  echo "<td>" . $row['h0237'] . "</td>";//Date
  echo "<td>" . $row['h9ca9'] . "</td>";//Track
  echo "<td>" . $row['hf6a6'] . "</td>";//Description
  echo "<td>" . $row['h67d6'] . "</td>";//Special Show
  echo "<td>" . $row['heb76'] . "</td>";//Race Type
  echo "</tr>";
  }
echo "</table>";

 

[The Eagle]

If you want a 2 digit number of the date, you're going to have to make that capital M lowercased. If not it'll display 3 letters of that month.

 

 

Do not think you need them "%" either.

[sprint10s]

the 3 letters for the month is fine if i can just get it to display.

[The Eagle]

Can I see "h0237" ?

[sprint10s]

Sorry no offense just don't know if i trust giving remote access it but here is a pic of the tables

[/img]

 

 

[attachment deleted by admin]

[The Eagle]

You're able to change it in MySQL. Anyways, try removing %.

[sprint10s]

got rid of % and what should i change it to in Mysql

[PFMaBiSmAd]

A) Why are you using column names that don't convey the meaning of the column? That just makes writing code 10 times slower because you must keep looking-up and cross-referencing what they mean.

 

B) The DATE_FORMAT() term would need to be referenced as $row['DATE_FORMAT()'] if I remember correctly. You should use an alias name in the query, which is what you were shown in the solution in a previous thread on this same problem, which is why you should not keep starting new threads for the same problem. You would then reference the alias name $row['dt'] to access the formatted value.

 

C) There should be no single-quotes around the 'h0237' column name in the query as that would make it a string value instead of a column reference.

 

 

[sprint10s]

Sorry for the new post, that worked thank you so much for everyone's help, i think that was the biggest problem was i had the column in ' ' which turned it into a string.  Thanks again and sorry for the multiple post.