PHP/mySQL Date Format parse error

akkdio

Hi,

Hope someone can help out here. I get a parse error on this code... any clue?

mysql_select_db($database_DB_Card_Order, $DB_Card_Order);
$query_nx_co_date = "SELECT co_date.order_date, DATE_FORMAT(order_date, "%M %D, %Y") FROM co_date;"
$nx_co_date = mysql_query($query_nx_co_date, $DB_Card_Order) or die(mysql_error());
$row_nx_co_date = mysql_fetch_assoc($nx_co_date);
$totalRows_nx_co_date = mysql_num_rows($nx_co_date);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<?php echo $row_nx_co_date['DATE_FORMAT(order_date, "%M %D, %Y")']; ?>
</body>
</html>
<?php
mysql_free_result($nx_co_date);
?>

the error says it is on this line:$query_nx_co_date = "SELECT co_date.order_date, DATE_FORMAT(order_date, "%M %D, %Y") FROM co_date;"

servedchilled

At the end of the line.... FROM co_date;" should be FROM co_date";

The ; is in the wrong place!

Let us know if it still doesn't work!

bradgrafelman

Also, it might be easier to alias the DATE_FORMAT() part of your query so that you can use the aliased name in the associative array.

akkdio

Hi all,

Thanks for the suggestions but changes did not work. Here is a more complete code of the simple thing I am trying to do with the date format.

<?php require_once('../Connections/date_test2.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    

    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_date_test2, $date_test2);
$query_order_date2 = "SELECT order_date.order_date, DATE_FORMAT(order_date, "%M %D, %Y") FROM order_date ";
$order_date2 = mysql_query($query_order_date2, $date_test2) or die(mysql_error());
$row_order_date2 = mysql_fetch_assoc($order_date2);
$totalRows_order_date2 = mysql_num_rows($order_date2);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<?php echo $row_order_date2['order_date']; ?>
</body>
</html>
<?php
mysql_free_result($order_date2);
?>

This returns this error: Parse error: parse error, unexpected ',' in C:\Inetpub\vhosts\akkdio.com\httpdocs\test\php\Akkdio\order_date.php on line 33

akkdio

Brad...

I don't have the chops to do this... is it easy. I am not a very good programmer but am trying.

Andrew:queasy:

akkdio

I have created a simple version of my problem and listed the full code below: Moving the ; did not work. Thanks for any thoughts...

<?php require_once('../Connections/date_test2.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    

    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysql_select_db($database_date_test2, $date_test2);
$query_order_date2 = "SELECT order_date.order_date, DATE_FORMAT(order_date, "%M %D, %Y") FROM order_date ";
$order_date2 = mysql_query($query_order_date2, $date_test2) or die(mysql_error());
$row_order_date2 = mysql_fetch_assoc($order_date2);
$totalRows_order_date2 = mysql_num_rows($order_date2);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<?php echo $row_order_date2['order_date']; ?>
</body>
</html>
<?php
mysql_free_result($order_date2);
?>

bradgrafelman

Your problem, as the error message explains, is in this line:

$query_order_date2 = "SELECT order_date.order_date, DATE_FORMAT(order_date, "%M %D, %Y") FROM order_date ";

Notice how the syntax highlighter goes haywire? Specifically, around the "%M %D, %Y" part?

That's because you have unescaped quotes in that string. Since you're using double quotes as your string delimiter, you need to escape any double quotes that are to appear inside the string.

Don't know what I mean? Visit the manual page and read about what a [man]string[/man] is.

severeheadache

as bradgrafelman said,

change this:

$query_order_date2 = "SELECT order_date.order_date, DATE_FORMAT(order_date, "%M %D, %Y") FROM order_date ";

to this (change outer quotes to single quote):

$query_order_date2 = 'SELECT order_date.order_date, DATE_FORMAT(order_date, "%M %D, %Y") FROM order_date';

OR this (escape inner quotes):

$query_order_date2 = "SELECT order_date.order_date, DATE_FORMAT(order_date, \"%M %D, %Y\") FROM order_date";

What is happening is the PHP parser gets to "%M and it thinks that the quote there is ending the string you started at "SELECT. then it gets what it thinks is garbage %M %D ... means nothing to PHP and thus the error.

Notice the difference in the syntax highlighting between the original and changed code? Sometimes you can run this command line:

php -s [yourfile].php > [newfile].html

This will produce you a nice HTML file with syntax highlighting. You can then scan through it and see problems like this in the file if you are really stumped. A good PHP text editor will do this for you automagically (like my favorite EditPlus http://www.editplus.com)

Hope this helps.

Mike