AndyB

Assuming this isn't a dedicated server you control, what does the host have to say? Just a question that one of the MySQL gurus can answer. What error message/erratic behaviour would a database generate when the MySQL server is tragically overloaded?

[!--quoteo(post=345398:date=Feb 13 2006, 11:25 AM:name=cmgmyr)--][div class=\'quotetop\']QUOTE(cmgmyr @ Feb 13 2006, 11:25 AM) [snapback]345398[/snapback][/div][div class=\'quotemain\'][!--quotec--] Where can I get free RSS feeds?[/quote] [a href=\"http://www.google.ca/search?hl=en&q=free+RSS+feeds&btnG=Google+Search&meta=\" target=\"_blank\"]192,000,000 suggestions[/a]

501 Not Implemented means "The server does not support the facility required". Something you're trying to do cannot be done.

Most likely culprit - old server php has register_globals OFF and new server has register_globals ON. You can check both easily by comparing the results of phpinfo() on each.

If it really matters .... who_where_when

This produces no errors and no warnings (for me). [code]<?php session_start(); error_reporting(E_ALL);// can be removed later if (isset($_GET['lang'])) {     $lang = $_GET['lang'];     $_SESSION['Language'] = $lang; } else {     if (isset($_SESSION['Language'])) {         $lang = $_SESSION['Language'];     } } if (!isset($lang)) {     $lang = "english"; // the default language } echo "We speak ". $lang. " here"; ?>[/code]

OK, glad that got you going. The code was a "quick'n'dirty" effort :) You're not actually seeing errors, you're seeing warning notices. Good to have while testing, but can always be turned off (later) by reducing the error_reporting level. If I have a minute this afternoon I'll amend that so it runs notice-free for you - or maybe some friendly soul will beat me to it.

It's not 100% clear what your code is trying to achieve, but I'll assume that somewhere in the URL is something like ?lang=french. Retrieving a URL-passed parameter needs only that you look at the $_GET array. Quick code that ought to be close: [code]<?php $lang = $_GET['lang']; if ($lang) {     if ($_SESSION['Language']!=$lang) {         $_SESSION['Language'] = $lang;     } }[/code]

Just curious. When you obviously have graphic talent, why are you using what is undoubtedly a copyrighted image (someone else's copyright) as the header to a site that appears to have nothing whatsover to do with the header image?

float

order by [b]defect_id[/b] I think you need to change 'serial no' to serial_no and order by that.

Depends on the set up ... maybe setting a session variable to ensure that the form is being accessed from your site.

[code]UPDATE yabbse_members SET personalText = 'Something Else' WHERE personalText = 'I Love Yabb!' [/code]

[code]UPDATE yabbse_members SET personalText = 'Something Else' [/code] That will change ALL records

Echo each query after constructing it. At least then you'll know exactly what the query is that isn't giving you what you want. Maybe that'll point the way.

At 800x600 resolution the navigation is totally unavailable. Scrollbars I can handle, but zero navigation???

What I do is this: One form to upload the image AND acquire the data I want to go into the database. If the image upload fails, then I don't write to the database. If the image upload is successful then I write to the database, use the mysql_last_insert (or whatever that function is) to determine the id of the database record I just inserted and then rename or move/rename the successfully uploaded image to match.

Let me insert some lateral thinking here. Given that it may not always possible to get the 'next' id value or that some code may return the wrong value for 'next', take a step back in your design and ask "why do I need to know/need to care about the 'real' value of the next auto-incremented id?". Assuming this isn't just a mental exercise, the answer to that question might set you on a better path for your design problem. Then again ... maybe it won't

I strongly suspect that this is a function of the operating system (the so-called 'theme') and nothing that can be changed by CSS for the browser.

I'd go for a loop as well .... but every five emails or so I'd add a brief sleep() so nothing overloaded.

No thanks. The way we all learn is by sharing knowledge. If you want to post some information about your database structure, and some information about what you want in the .csv file that will result from querying it and creating a text file, then everyone here can contribute to the solution you're working towards, and anyone who reads the thread (now or in future) will see how a particular problem was solved. That's what these forums are all about: shared problems, shared solutions.

If you want to USE MySQL on your local computer, you really don't have any option but to install it - along with something that'll let you use your local computer as a server. If you want to run php and MySQL and the GD library on your computer as if it were a server, then there's an 11.5 MB downloadable at www.firepages.com.au as a single package with a one-click installation. phpdev423 is perfect for all local development. I've installed it on Win NT, Win2K, and WinXP all without any problems whatsoever.

As far as I know, you can't create a true .xls file using php/MySQL. What you CAN do is generate a text file from the MySQL data. And then you can IMPORT that text file into Excel. Assuming you know how to get the data you want out of your database, you'll find all you need to know about creating a text file in the manual - check fwrite for that.

Cautionary note: I am entering dates in the .... format. But what about every other user of the form? I'd suggest user-proofing the data entry by having three date entry fields - day, month, year (dropdowns are nice and user-proof). Then it doesn't matter what date format the user thinks of using, since your form will always have the responses in the same format.

It might help if we knew the MySQL version number that works, the version number that fails, and the specific error you get when the script fails.