[Daniel Francis]

Hi Steve

That makes perfect sense and having the page refresh it’s order once per hour is absolutely fine! Could I perhaps suggest that this is mentioned in the order_by page where you describe the code. I think it’s useful to know.

Keep up the good work!

[Daniel Francis]

I did a bit of digging and found this simple bit of code which did it!

alter table people modify name VARCHAR(35) ;

I modified it to:

alter table wp_connections modify department VARCHAR(1000) ;

So now all I need to do is be able to change the word from ‘Work Phone’ and ‘Work Fax’ to something that relates to a business and not an individual or member of public.

Thanks for your help so far.

:-)

[Daniel Francis]

I have just checked the MySQL database for Connections and specifically the Department column and I cannot find any limitation on the number of characters that can be entered?!

[Daniel Francis]

I also want to change how the title for Work Phone appears. When I have chosen for it to be listed as an organisation, they wouldn’t list their phone number as Work Phone and Fax number as Work Fax. It would be something like ‘Phone number’, ‘Main Switchboard’, or simply ‘Tel’. The options at the moment only really cater for an individual or a family not an organisation.

How can I change this please?!

[Author]

Posts