close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

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

Thread began 4/15/2013 11:01 am by iainmacdonald331081 | Last modified 4/15/2013 3:42 pm by iainmacdonald331081 | 429 views | 9 replies |

iainmacdonald331081

Correctly displaying menu drop down value when it could be one of two, eg 'Kenya' or 'kenya'

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.

Sign in to reply to this post

CraigRBeta Tester

Change the data ?

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

Sign in to reply to this post

iainmacdonald331081

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'.

Sign in to reply to this post

CraigRBeta Tester

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 !

Sign in to reply to this post

iainmacdonald331081

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?

Sign in to reply to this post

CraigRBeta Tester

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

Sign in to reply to this post

iainmacdonald331081

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.

Sign in to reply to this post

CraigRBeta Tester

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

Sign in to reply to this post

iainmacdonald331081

Thanks Craig - appreciate you helping out.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...