hondaman

Hi guys, nice forum. I have been playing on and off with php for awhile now but have never encountered the problem I have now and I would like to see if anyone can help me. I am currently getting a used vehicle feed sent to me by a provider which updates my database daily. Problem is, it is not indexed nor do the tables have what i consider "real relationships". Anywho... The problem I have is that in one table... vehicles, currently gives me the options for each vehicle using THEIR coding system which oddly enough uses upper and lower case letters as the unique id for the options table. ie. (Options Table) ID DESC ----- ------------------ TA Power Windows Ta Power Door Locks RA Keyless Entry Ra etc..... My question is, how can I tell my query to only select the value that matches the correct case??? I am using the query below to no avail. $thisOptionID = "Ta"; $fq = "SELECT DISTINCT id, desc FROM options WHERE id = '$thisOptionID'"; $fr = mysql_query($fq) or die("Error in Option Select Query: ".mysql_error()); $fi = mysql_fetch_array($fr); What it gives me back is Power Windows when I want it to give me Power Door Locks. Please help.