pclfw

And if you continue with this level of [B]self[/B]motivation you aren't going to finish the year. If you ask a specific question the people here will gladly reply. And you will get the benefit of years of experience. If you ask for your college work to be done for you …

Wow, the Country list begins with ths USA and Canada, the rest of us have to be in alphabetical order. Who'd thunk it?

Perhaps it would be easier to split this select into a number of smaller SELECTs each satisfying a seperate case (received, etc.) Then use the UNION operator to join the whole mess together. Also, split the lines up. Seperate the code so that you can actually read each join and …

Just use `SELECT * FROM Hospitals WHERE city_id = $input ` This will return all of thew rows where the CITY_ID is the same as the input value.

Try Google. I found the whole set in about 5 seconds.

And your question is...?

You really should go to www.php.net and look at the function definitions. The PHP site is one of the best available for learning the language. Even on a cursary look at you code there a major structural problems.

SELECT * FROM property, personal, spouse WHERE property.id=personal.id AND property.id=spouse.id

Have a look at https://developer.mozilla.org/en-US/docs/Web/HTML/Element/option

"MAKE" a motherboard??????

I am not an Oricle DBA, but in MS SQL the WHERE clause needs to be very specific before it actually fetches directly via the index. I see no reason to expect that Oricle is any different.

The MySQL documentation has your answer (I've just been reading it.)

have a look at http://en.wikipedia.org/wiki/Database_normalization

Ever thought about using the DB itself? Set the username and emailaddress as a concatonated unique index and try the insert. If you have a duplicate the insert will fail. This is a much faster way of ensuring uniqueness.

So, have you had a look at the manual yet?

Well now my go. I have done something very very similar. No you cannot have the code. It is MUCH MORE FUN it you work it out for your self. For a start something that the previous posters forgot, what happens if more than one matching row is found (i.e. …

it2051229 You forgot "EXPENSIVE" "That means you're going to read EXPENSIVE thick books." And lots and lots of them. And you'll need to buy them for your self because of all of the notes you'll write in the margins.

Don't forget that using 'REQUIRE' will ensure that the file is included as the parser looks for 'REQUIRE's prior to parseing the file. Thus 'REQUIRE'd files are allways included. However the 'INCLUDE' may be avoided via programming. i.e. $language = 'english'; if $language = "french" { include_once '.\french_file.php'; } else …

Also consider MS Access. You can split off the data tables & views from the GUI and have local (LAN) access into the data. MS SQL Server Express will drive a DB upto 1GB in size. It won't be fast, but it will be cheap.

Write a function that takes a date value, (use whatever input format that you want) as input and gives your YYYYMM as output. Output the data in YYYYMM format. Not only will it be search-able, it was also be sortable. Use that function where ever you need to convert a …

I was asked a question a few days ago that I cannot easily answer. "Why don't we put all of our small application databases into a single database?" Well, There's nothing really stopping us. All of our small apps were developed in house so we don't have any problems with …

[QUOTE=;][/QUOTE] It isn't possible for the client side javascript to access another domain. <<<<SOLUTION DELETED BY AUTHOR>>>> However this really doesn't sound like something that I would like to happen to any of my data. Sounds a lot like cross site scripting to me.

[QUOTE=;][/QUOTE] Try setting the focus of one of the new tabs elements to true.

[QUOTE=;][/QUOTE] Change line 29 so that this button doesn't submit the page. Use the ONCLICK method to call the required javascript to send the data and display a message to the user. The form can then be reset or another page loaded from within the same script.

[QUOTE=;][/QUOTE] If the query runs correctly within MySQL but not within PHP then I would suggest that the problem lies within your PHP code. Which you haven't given us.

[QUOTE=;][/QUOTE] Your function loadXMLDoc() needs to validate its inputs BEFORE trying to create and call the XML request.

I have never used the WAMP server. But I have installed Apache 2.2, MySQL & PHP onto an XP machine and a LINUX (debian) box. The Linux machine was a whole load easier to install. :) Let me know if you want a quick rundown of the steps to take, …

Views work VERY well in MS SQL and can do some very detailed and complex discrimination and manipulation. Have a good look at Books-On-Line and play with them for a while.

XML has a huge overhead in the textual naming of the entities. Also it is not meant to be humad readable, it is a transport medium. Store the data in a database, the DB overheads will be trivial compared to XML and the disk use will be much less.