[ajs]

I want to to have the code sort everything by name where all the dates match up, but the date is entered in the db like 5/01/05 and the code seems to gets stuck on the /, how do you get around that ?

Here's what I had

$query="SELECT * FROM title ORDER BY name WHERE date LIKE 5/%";

[NeverMind]

you have to put them in quotes:

Code:

$query="SELECT * FROM title ORDER BY name WHERE date LIKE '5/%'";