oohrogerpalmer

I've watched the video and pretty sure I can do that - but I am a bit lost in the technical aspects of jquery. Thanks for the advice.

Sorry, I realised when I read it back it wasn't very clear. I have two images of this park. One is an aerial photo of it, and the other is a line drawn plan that identifies separate areas like the play park, the toilets etc. I'm trying to initially show the aerial picture and then when the mouse moves over the picture, the line drawn plan view fades into view over the aerial view. (I've seen this referred to as 'crossfading'). Hope this explains it better.

Hi. I'm designing a website and have a image on the homepage of a overhead view of a park. I also have a plan view of the park, which is much clearer. I'd like to be able to offer the users the option to view either the overhead view, or the plan view, but I'd like to fade in so that the link between the two is obvious, either by clicking the image or button. I thought this might be a simple html code but my investigations have scared me a bit. It seems I will have to do this using either flash or jquery, which means learning something new. Does anyone know which would be most appropriate for this, and if this is the only/best way to do this? Also any REALLY basic tutorials on either would be wonderful, as I don't have the faintest idea what either are (for example are they free?)

I'm using a form to populate the MySQL database. Is there a way I can put a space into those fields by default so if the person who completes the form doesn't enter any data, it will add space by automatically?

Hi I have a .php page that shows a table populated by a database. In Chrome the table looks fine, but in IE (8) & Mozilla any blank cells have no borders, which makes reading the info a bit tricky. I'm sure it's something simple, but I can't find any reference to this specific problem. The page is http://www.dunwoodpark.com/groups.php, and the code I'm using is : <?php mysql_connect(localhost, "*******", "********") or die(mysql_error()); mysql_select_db("*******") or die(mysql_error()); $result = mysql_query('SELECT org, website, position, Title, firstname, Surname, date FROM Dunwood WHERE `org`!="" AND `org`!="NULL" '); echo " Organisation Website Position Title Firstname Surname Date ";while($row = mysql_fetch_array($result)) { echo " echo " " . $row['org'] . ""; echo " " . $row['website'] . ""; echo " " . $row['position'] . ""; echo " " . $row['Title'] . ""; echo " " . $row['firstname'] . ""; echo " " . $row['Surname'] . ""; echo " " . $row['date'] . ""; echo " "; } echo " ";mysql_close(); ?>

You're both right. I shut my computer down and started it up and it worked exactly as you said. Sorry about that.

Also the php include did work. Good to know for my future endeavours.

Hello again sir. I'm going to upload the pages and see if it still does it - been driving me bonkers all afternoon. http://www.hamberie.com/dunwoodtest/index.html. It's very rough, but the "Home" navigation above the "Back to Top" text at the bottom keeps showing brown instead of green like the rest of the buttons. Sorry that took so long to reply, the kitten thinks that when I push her away it's because she's not trying hard enough to be noticed. See if it does it for you too. Thanks again for the help yesterday. Brilliant stuff.

Hello I've created a css page that provides a format for hyperlinked text in my html files. It works great for internal links but for the site navigation, the text is going straight to a:visited format. I tested it out by putting two lines next to each other and viewing it in the browser. Home Back to Top The "Back to top" text was green- color:#228b22 (my a:link colour) but the text "Home" was brown - color:#964514 (my a:visited colour) I changed the bit "index.html" to "#top" and had another look in the browser> Both showed as the link colour. Has anyone experienced this before or is there something special about site navigation that makes the text behave differently compared to the internal links? I've been trying stuff out all afternoon but don't really want to move on until I know whats happening. If you need any more info I'm happy to post whatever might be useful. Thanks in advance - also apologies if this should be in a different forum, but I am using a css.

Your a genius. Brilliant - works a treat. thanks for all the perserverance, and if it is anything like as difficult typing with your kittne s it is for me, even more thanks.

Ah. Sorry about that. I'll get on wih that and see how thing s pan out; Many many thanks

I'll do that tomorrow. I hope it works 'cos php.includes seem like the bee's knees. I'm losing hope on my csv table. What do you advise is the best way to get data out a 70 field table out of mySQL table and onto my home comps spreadsheet? Apologies for being so defeates and slightly pathetic.

I'll get in touch with the support and ask the question. Is it unusual for a provider to not allow this aspect of php - seems like one of the fundamental benefits of php to me.

This is a professional web hosting - I pay a fee once a year to www.web-mania.com. I've been working through stephans tutorials because I want to use css and php includes in the future. I was under the impression that this was the way forward - not least of all because of the reasons you noted. Is there anyway I can activate this part of the php functionality? I'm happy to try anything - simplicity is the key, so whatever is easy to operate, rather than easy to create. If you could point me towards an alternative and I'll inordinately screw it up and end up back here..Once again thanks for the patience.

just cos I was looking at it - under the same heading, and in fact the next line down it says.. allow_url_include Off Off Does this mean that php.includes wont work with my server? My intention is to redesign my site and use them to simplify the site, but if it's a none starter I'll not worry about it.

The version it comes back with is php version5.2.8 I've had a good look for the info you asked for and it is exactly as you said - both 'on'. Also deleted the page now too. I need to put this information into a spreadsheet that will then use almost all of the info to generate an invoice. Most of the info is simply used as a mailmerge for the address but I have made a few functions that use the 'date of arrival' and 'date of departure' to quote a price. This is so that my parents can use the spreadsheet to generate invoices without having to type all the info and/or download it by accessing the server, the thought of which frankly terrifies me. It's bound to be my ineptness, but I appreciate your endurance.

I created the export.csv and uploaded it but got this response. Warning: fopen(export.csv) [function.fopen]: failed to open stream: Permission denied in /home/www/hamberiO/privpage1.php on line 8 Unable to open file for writing The part in [function.fopen] was a hyperlink that tried to take me to a page http://www.hamberie.com/function.fopen? Does this help? cos I know a kitten who likes both the mouse and the sound the keyboard makes doesn't.

Fighting a kitten for domination of the keyboard, but managed it. Got this message. Warning: fopen(export.csv) [function.fopen]: failed to open stream: Permission denied in /home/www/hamberiO/privpage1.php on line 8 Unable to open file for writing

Hello falkencreative I'm sorry but I don't know what this bit means - can you post the PHP code for the uniqid() function? (used to create the file name) Are you asking me to send you something I created - I haven't done that and if I am meant to, that is probably why this is not working. I use web-mania as my service provider. I can't even depend on electricity to stay on here, let alone broadband. When you run it, does it save a file to your computer or does it do something else?

Hello again. I've managed to created the form that both sends data to my SQL and a quick email too, and got it in a working format - my webpage is www.hamberie.com, and I've managed to get the booking form working and populating the database really well. I'm stuck on the last part of trying to publish/retrieve the data from the mySQL database onto my home pc. As the table is over 70 fields long, I think I need a solution that just downloads a csv file rather than publish's the data in a huge table on a web page. Then I can just import it directly into my spreadsheet. I tried to find a solution and found this bit of code that apparently can export the table into a csv file, but I can't get it to work, and to be honest I don't know where I would put this bit of code either? <?php mysql_connect(localhost, "myusername", "password") or die(mysql_error()); mysql_select_db("mydatabase") or die(mysql_error()); // this bit obviously opens the database $result = mysql_query('SELECT * FROM Booking') or die(mysql_error()); //this bit gets all (*) the data from the table, but the rest is just beyond me $file = uniqid().'.csv'; $fh = fopen($file, 'w') or die("Unable to open file for writing"); while($row = mysql_fetch_row($result)) { fputcsv($fh, $row); } fclose($fh); header('Content-Type: text/csv'); readfile($file); exit; ?> I just saved it as a php page and ran it but the following error came up Warning: fopen(4a7855ae56ebf.csv) [function.fopen]: failed to open stream: Permission denied in /home/www/hamberiO/privpage1.php on line 8 Unable to open file for writing This is the first bit I've tried to do without really understanding it, so it's probably a stupid error on my part. Any and all help greatly appreciated.

Brilliant. I'll take a really good look tomorrow and see if I can get through it. Really appreciate the help, guidance and advice.

Very colourful. Certainly don't understand the code but seems very simple.

Thanks for that. That looks exactly like what I'm after - still a bit scary but seems do-able. Just one quick question - I didn't recognise this bit. header('Location: main.php'); I've not seen this bit of code before - does it just take you to the page - in this case main.php, and in my case echo_of_my_database.php or is something else? Many thanks again.

Much obliged falkencreative. Didn't understand most of the password stuff but I'll give it another go tomorrow morning - this is France and we imbibe after five. I am only wanting to see the latest info sent to the database, so when I get an email saying that someone has sent a booking form, I and only I will visit my password protected page and retrieve the new info and copy it to my home database/spreadsheet for further manipulation. The way you describe above seems to be a little beyond my abilities right now, but having said that I want this info to be pretty secure. I'll have a look at .htaccess files. Many thanks for taking the time.

Is there a limit to the number of fields you can use. My form isn't huge but I have just counted up and there wil be 71 fields which seems a lot but I don't see how to reduce this because of the nature of the form. All very small pieces of information, and I hope the mySQL can handle it, but the php is going to start looking a bit busy. Does it affect the php if I breakup the lines just to make it easier to edit and understand. eg. "VALUES ('NULL','$title', '$namefirst', '$surname', '$ad1','$ad2','$ad3','$ad4','$postcode','$telephone','$email','$ad1', '$arrivaldate','$departuredate','$adults','$teens','$kids','$babies', '$termsread')") or die( " Unable to select table "); ....or perhaps there is a more logical way of doing it? Just while your here, I really want to put that info onto a secure webpage only I can access but I don't know how to password protect a page- is it done via php or by the server-provider? or something else? Many thanks once again