Help with "Parse error: syntax error, unexpected T_STRING"

kuni

I'm trying to build a page that will run a query so I won't have to log into My PHP Admin...I keep getting a T-String error and can't figure it out...help?

Thanks!

Kuni

<?php

require('../config/_config.php');

$sql1 = "SELECT DATE( expiresDate ) AS "Expires", description AS "Product", ProductID, COUNT( * ) AS "Num. Retailers"
FROM tblProdRetailer
LEFT JOIN tblProduct ON fProductID = ProductID
WHERE DATE( expiresDate ) > NOW( )
GROUP BY DATE( expiresDate ) , description
ORDER BY DATE( expiresDate ) , description
LIMIT 0 , 100";

$qry = $dao->prepare($sql1);
$qry->execute();
$qry->setFetchMode(PDO::FETCH_ASSOC);

$results1 = $qry->fetchALl();

$display .= '<table>';
$display .= '<tr>';
$display .= '<td style="padding: 5px;">Expires</td>';
$display .= '<td style="padding: 5px;">Product</td>';
$display .= '<td style="padding: 5px;">ProductID</td>';
$display .= '<td style="padding: 5px;">Num. Retailers</td>';
$display .= '</tr>';

foreach ($results1 as $row1)
{
$display .= '<tr>';

$display .= '<td style="padding: 5px;">'.sprintf('%06d', $row1['Expires']).'</td>';

$display .= '<td style="padding: 5px;">'.$row1['Product'].'</td>';
$display .= '<td style="padding: 5px;">'.$row1['ProductID'].'</td>';
$display .= '<td style="padding: 5px;" align="right">'.$row1['Num. Retailers'].'</td>';

$display .= '</tr>';
}
$display .= '</table>';

echo $display;

dagon

its the quoting in the sql query

kuni

So, do I need to delete them or use single quotes?

kuni

I figured it out!!!!!!! THANK YOU!!!

kuni

OK, one last thing...

The following code works, but the EXPIRES date is being displayed as "002010". I'd like to see it like "2010-09-04"

Any thoughts?

You guys rock.

kuni

oops, here it is:

<?php

$display = '';

require('../config/_config.php');

$sql1 = "SELECT DATE( expiresDate ) AS 'Expires', description AS 'Product', ProductID, COUNT( * ) AS 'Num. Retailers'
FROM tblProdRetailer
LEFT JOIN tblProduct ON fProductID = ProductID
WHERE DATE( expiresDate ) > NOW( )
GROUP BY DATE( expiresDate ) , description
ORDER BY DATE( expiresDate ) , description
LIMIT 0 , 1000";

$qry = $dao->prepare($sql1);
$qry->execute();
$qry->setFetchMode(PDO::FETCH_ASSOC);

$results1 = $qry->fetchALl();

foreach ($results1 as $row1)
{
$display .= '<tr>';

$display .= '</tr>';
}
$display .= '</table>';

echo $display;

nevvermind

When posting code, use [.PHP] and [./PHP] tags without the dots.
Drop the sprintf function and see what you get:

$display .= '<td style="padding: 5px;">' . $row1['Expires'] . '</td>';

kuni

Yep, that did it! Thank you!

$display .= '<td style="padding: 5px;">'.$row1['Expires'].'</td>';

nevvermind

If you're questions are answered, mark this thread resolved from thread tools at the top of the page.