Re: Query with DISTINCT - logic?

[P. Boomer]

Thanks for your help.

This returns no results:

$query = ('SELECT * FROM `demo` WHERE `IDENTIFIER` = '.'"'.$12345.'" ORDER BY `STREET ADDRESS CITY` GROUP BY `PHONE NUMBER`\G');

This works, but obviously only returns the unordered records:

$query = ('SELECT * FROM `demo` WHERE `IDENTIFIER` = '.'"'.$12345.'" GROUP BY `PHONE NUMBER`');

But if I add the \G, it returns nothing.

My problem is that if I use the PHP syntax that I've found on the Web for stating multiple conditions in a query, it never seems to work.