July 21st, 2000, 01:04 AM
Hi! I'm kinda a bit of a newbie with mysql but I've managed to get it working okayish on my pc (win98). I am having problems when trying to get a list of cities from a field in one of my tables. I try the following:
SELECT DISTINCT city FROM table1
and mysql just seems to shut itself down after hitting me with a dialog that says something about "test signal", have i missed some vital configuration???
Thanks in advance
July 21st, 2000, 11:51 AM
Are you doing this from the command line? what version of mysql are you using?
i haven't heard of an error like that before. if no one here can answer you, you might want to send the question to firstname.lastname@example.org. The developers monitor that list and they might be able to provide some more insight. be sure to tell them you're not subscribed to the list, so they will email you answers directly.
July 25th, 2000, 11:55 AM
I tried it from a php I did and when it didn't work I tried it from the command line but with the same results