close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Setting dynamic links to a speciffic colour

Thread begun 9/17/2009 6:01 am by acaciasd344844 | Last modified 9/19/2009 7:02 am by office172461 | 3701 views | 6 replies |

acaciasd344844

Setting dynamic links to a speciffic colour

Hi,

I wonder if any one can help me? I use dataAssist and its a great extension to dreamweaver. Most of my pages are generated with some form of dataAssist code embed in it.

I have a php/mysql page that displays a list of house numbers, for example 1 to 10 that require work completing;

There is a case where some of these house numbers have already had the work completed, but will require inspection of the completed work.

Its been suggested to me that I should set the house numbers (font colour) to red or purple if they require inspection. This simple effect will visually inform the workers that they dont need to look at that record because the work has been completed. But, will inform the inspectors to look at the record and fill in the relevant details.

I am able to perform the search for property numbers, but depending on the sql code (inspect_property=1) set the property number to the correct colour otherwise leave it at the default colour.

here is the code
______________________________________________________________________

<?php echo $row_Recordsetdisplayproperties['cust_houseno']; ?></a>
<?php } while ($row_Recordsetdisplayproperties = mysql_fetch_assoc($Recordsetdisplayproperties)); ?>
______________________________________________________________________

Hope that helps, but if you need more information I am happy to oblige

thanks

John

Sign in to reply to this post

Jimmy Wu

Would it be easier to have 3 different searches set up? One that searches for all the properties that still need something done with them, one that searches for the properties that need work done and one that searches for the properties that need to be inspected? This way the workers and inspectors can just search for the ones that are relevant to their line of work instead of scanning through to find the ones they may not necessarily need to look at?

Sign in to reply to this post

acaciasd344844

Setting dynamic links to a speciffic colour

Thanks for your response Jimmy,

Yes I agree, thing is this thing runs on mobile PDA's and the like. The guys would have to keep running searches to find the different items. Here is a link to an image of the page so you can see what I mean.

schedulescreen.JPG

Its really a data collection system for mobile operatives, I gave the previous example just to be simplistic and get the message across.

If the property numbers could be coloured it would then provide a visual guide to what is going on.

Hope that helps


cheers


john

Sign in to reply to this post

acaciasd344844

Setting dynamic links to a speciffic colour

Just to add a little more detail,


you can see from the image that it shows the property number, the address and underneath that it says 'No Clean'. It is these property numbers that need to be colour coded. It will then save the guys clicking on each property to see what need doing. Some of these streets can have upto 30 properties on them, so colour coding seems to be the best way to go about things.

sorry to ramble on, hopefully you can see where I am coming from.


cheers again


john

Sign in to reply to this post

office172461

Just a thought

Would it be any easier to change the background color of the house number cell?

Sign in to reply to this post

acaciasd344844

Setting dynamic links to a speciffic colour

Yes office172461 that could work too,

Not sure how I would go about it though, would you happen to have any code examples that may help.

thanks for your response

john

Sign in to reply to this post

office172461

I haven't used it before but you might find something here:
http://www.tizag.com/cssT/background.php

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