Messages posted by: daveyjones1979

Still just writing the tables. I was hoping I could have say 10 columns in the table but only 3 or 4 that get taken to the web page. Is this possible?

I have a really good book for MySQL which is helping me write a form which will automatically put all info into the database with just a review option so all I do is change from a N to a Y and the info goes live. All I need to do now is figure out how to get certain fields from my table to appear on my webpage so that each company which is advertising appears in a different random order each time the page is refreshed.

I just can't find anything anywhere that has helped with the Java coding other than this site. By the way, much appreciated!

Thanks,

Hi,

I have sorted, well am working on sorting my MySQL Database which I think I've now got to grips with. The only bit I'm having trouble with is what code to use to pick up the data from the different tables in the database and put it in a different random order in the webpage (HTML) each time the page is opened.

I have bought two Java Books, a O'Rielly one and the O'Rielly Cookbook but just by reading the indexes and contents page its not obvious to me where to even start.

I would really appreciate a little help if possible.

Many thanks,

David

My server supports MySQL and they give me 10mb apparently.

So would I need to include a piece of code for each advert or just one on each page?

Thanks,

David

The majority of my site will require this code as I am making a new directory where ever page will have different companies advertising.

I have not put the data in any list yet. What is the best way? I have the whole Macromedia Studio MX Suite but to be honest I only use Dreamweaver for HTML sites and then Flash for simple things. Naver made a database in my life but I think it might be best to this time. I am hoping to have around 10,000 adverts within the first 2 years split among 200 sub headings.

Will I be able to include a web address in the information as below

ABC Limited
Tel: 023 XXX XXX
Web: www.ABC.com

but with the web address being a hyperlink?

Many thanks,

David

Hello,

Thanks very much for your help. My host says they support Java, Javascript (not sure on the difference but hey) and PHP4 version 4.2.2.

Do all browsers support Java?

Sorry, I'm not much of a techy. What's a bean?

Thanks,

David

I have just searched Google but I don't think this is quite what i'm looking for as this will only display one image at a time. What I am trying to do is the same as the results on www.yell.com (search for example websdesign in Liverpool) where everytime you return to the list of companies they are in a different order.

Thanks

Hi,

I am new to this and only used to HTML sites on Dreamweaver so the site I want to put it into has been created in HTML on Dreamweaver.

My host says they support Java and PHP but I'd heard that PHP is a lot more confusing than Java.

Thanks for helping by the way.

David

--------------------------------------------------------------------------------

Hi,

I've heard its possible to do this but not sure how or even what direction to start looking in.

I basically am making a directory of adverts for companies and to make it fair I want all to appear every time but in different orders. I would like the layout to look as follows:

ABC Limited
Tel: 023 XXX XXX
www.ABC.com

XYZ Limited
Tel: 023 XXX XXX
www.XYZ.com

CBA Limited
Tel: 023 XXX XXX
www.CBA.com

ZYX Limited
Tel: 023 XXX XXX
www.ZYX.com

With fonts in same font as ret of site (but I think I can do this already)

and someone mentioned using a Java form but they did not know what function to use.

I managed to get a very basic one where it lists them all one above the other and Tel and web on same line as name but as soon as I start putting in <br> everything just disappears.

The guy I spoke to said he'd heard of a way where I can make a form and assign a tag to each box then get each box to display one of the items with no repeats or duplicates and when not enough items box remains empty. But he said he hasn't done it in a while and can't remember what code he used.

Can anyone firstly let me know if this is possible or if there is a better way and secondly if they could point me in the right direction that would be amazing.

Thanks,

David