Correctly displaying menu drop down value when it could be one of two

Basically I have a table where the country field was originally populated with a capital letter, eg Kenya. But now they really need to be all lower case as they will form part of a URL. eg www.safariawards.com/country/propertyname/

So at the moment the code in the Select Box on my update page looks like:

<option value="kenya" <?php if (!(strcmp("kenya", $row_WADAlodges['Country']))) {echo "selected=\"selected\"";} ?>>Kenya</option>

Which is fine for any that have been changed from 'Kenya' to 'kenya'. But for any that are still in the table as 'Kenya', the select box isn't displaying the correct country, presumably because it is case sensitive. So will always show the firs option in the list, in this case Botswana.

So my question is, is it possible to display 'Kenya' here if the field is populated with either 'Kenya' or 'kenya'?

I tried:

<option value="kenya" <?php if (!(strcmp("kenya" or "Kenya", $row_WADAlodges['Country']))) {echo "selected=\"selected\"";} ?>>Kenya</option>

But that doesn't seem to work.

Thanks.

Hi Ian, don't know your circumstances, but I would be tempted to run an update query using mysql lower() function to update the data in the table.
Once you fix the root cause, you should be good to go

Thanks Craig - I've never really made global changes. I use phpMyAdmin, so assume I just go to the SQL tab, but wouldn't know the syntax to use.

In plain English (if you can translate!), its basically:

Find all instances of 'Kenya' in TABLE lodges FIELD country and change to 'kenya'.

In phpmyadmin, select your database and go to the sql tab,

if the table is called 'lodges' and the field is called 'country', try...

UPDATE lodges SET country = lower(country) WHERE country = 'Kenya'

(Use the where clause if you only want to update instances of Kenya.)

take a backup of the table first, just in case !

Thanks Craig - it will be for each record, so assume I just leave off the WHERE clause:

UPDATE lodges SET country = lower(country)

With the backup, is that something I can do in SQL as well, eg something like BACKUP lodges or COPY lodges?

Rather than export it out?

thats it, just leave off the WHERE clause.

if you don't want to back up the full database, then you can make a copy of the table.

probably the easiest way in phpmysql, is via the 'operations' tab

select the table you want to copy, then click 'operations' - here you can move, copy or rename the table

Thanks Craig - worked a treat.

One thing while you're there - what would the syntax be to make a global change from one string to another?

Useful for future reference, plus I have now changed South Africa to south africa, but it really needs to be southafrica.

for the space in 'south africa', try this...

UPDATE lodges SET country = REPLACE(country,' ','')

which replaces all instances of a space with an empty string

the global change thing ? ...depends what you want. here is a good resource to explain mysql functions

http://www.w3resource.com/mysql/string-functions/mysql-replace-function.php

Thanks Craig - appreciate you helping out.