Playlist Thingy

[RaythMistwalker]

Ok I Tried your code and echo'd $ltr and returned the following echos:

Letter: 0

Query: SELECT * FROM songlist WHERE (songtype='S') AND (status=0) AND SUBSTRING(artist,1,1) BETWEEN 0 AND 9 ORDER BY artist ASC, title ASC

Where: WHERE (songtype='S') AND (status=0) AND SUBSTRING(artist,1,1) BETWEEN 0 AND 9

On Letter A:

Letter: A

Query: SELECT * FROM songlist WHERE (songtype='S') AND (status=0) AND SUBSTRING(artist,1,1) BETWEEN 0 AND 9 ORDER BY artist ASC, title ASC

Where: WHERE (songtype='S') AND (status=0) AND SUBSTRING(artist,1,1) BETWEEN 0 AND 9

 

I took out the bit that says

&& $ltr != ""

since this is negated when the page loads did the same thing. Then i changed the

if ($ltr == 0)

to

if ($ltr == '0')

 

The first result displayed every song no matter what and always returned the same query.

After changing 0 to '0' i get the following echo's:

Letter: 0

Query: SELECT * FROM songlist WHERE (songtype='S') AND (status=0) AND SUBSTRING(artist,1,1) BETWEEN 0 AND 9 ORDER BY artist ASC, title ASC

Where: WHERE (songtype='S') AND (status=0) AND SUBSTRING(artist,1,1) BETWEEN 0 AND 9

Displays all songs on the 0 page.

Letter: A

Query: SELECT * FROM songlist WHERE (songtype='S') AND (status=0) AND artist like 'A%' ORDER BY artist ASC, title ASC

Where: WHERE (songtype='S') AND (status=0) AND artist like 'A%'

 

im completely confused now and really cant seem to get that single page working.

[jl5501]

Ok, we can see from the echos, that we are now running the correct queries for the correct conditions

 

So there must be an error in the 0 one, I cannot see it now but will check

[jl5501]

aha

 

Same as 0 vs '0' the titles are in a string field so the numbers need to be treated as strings

 

AND SUBSTRING(artist,1,1) BETWEEN '0' AND '9' 

[RaythMistwalker]

Thanks so much for all your help it works now

[jl5501]

Great, sorry it took so long