[RESOLVED] stopping the same result from displaying more than once

[jarg]

Hi all,

I am running a search query in mysql using the LIKE command, to retrieve information from a database.

It is the case that there are several values that are duplicates. Is there any way to filter these?

Thanks in advance.
James

[leatherback]

you could use the distinct keyword in your query?

[jarg]

thanks for that, works like a charm now!!

[jarg]

while im here, does anyone know how to stop autocomplete from filling in text boxes.

have tried putting "autocomplete = "off"" into the <input>tag but that doesnt work.

thanks,
James

[leatherback]

hm.. That is according to microsoft the way to do it.
http://msdn.microsoft.com/en-us/library/ms533032(VS.85).aspx

[jarg]

thanks for that, like i have said that is what i tired. is being used in Safari and Firefox so guess thats why its not working.
Thanks for the input though.
James

[jarg]

turns out i was being a bit stupid yesterday. the autocomplete = off does work, i just applied it to the wrong text box!
Thanks,
James