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.

Well at least you said the most important word towards the each of this request. REQUIREMENTS. If you don't know what you want to do you have no hope of doing it. Sit down with a pen & paper and write down all of the requirements that you think are …

You include ROOM_PRICE in the ROOMS table and the ROOM_TYPE table. It should only appear in one of these. The choice is yours. ROOM gives precise control over room pricing, ROOM_TYPE gives easier maintenance when chaning room prices.

How fragmented are the indexes? DBCC REINDEX is your friend. Fragmented disks, these can also kill performance. Are the disks nearly full? How full is the Db? can you archive records to reduce the number of rows in the table(s)

And have you tried looking in BOOKS ONLINE? If you don't have a copy then you can use the version on the Microsoft web site. Search for ALTER TABLE

Have you tried [CODE] SELECT count(*)*1.0/ (SELECT count(*) FROM events_may_2010 WHERE convert(varchar,call_date,112)= convert(varchar,GETDATE(),112) AND call_status IN ('1110', '1199', '1002') )*100 FROM events_may_2010 WHERE convert(varchar,call_date,112)= convert(varchar,GETDATE(),112) AND call_status IN ('1110') GROUP BY agent ORDER BY agent [/CODE]

You can do this by having a sub-query which uses a RIGHT join to link PERSON and MENU (I don't think that MEAL is relevant here.) Then SELECT DISTINCT from the resultant data set all of the PREFERENCE.PERSON where the linked MENU.DISH is not NULL. There, that may help. :)

This sounds like a very ambitious project for someone who doesn't understand the complexities of the question they've asked. You might wish to google 'Data Normalisation', followed by 'data optimisation'. When you understand those two fields you might wish to reframe your question. Or you might wish to buy in …

One of the many possible answers is to use AJAX to send the email data back to your server and then have a server side script format and sent the email. You have a couple of advantages in doing it this way, you can revalidate the sent values, and you …

Surely it is more usual to clear both the username and password fields without giving any indication as to which was in error.

Well for starters you seem to have 4 values in the VALUES clause but only three columns in the INSERT clause. The named values in the line [CODE]if($_SESSION[usedmemory] < $_SESSION[allocatedmemory])[/CODE] should be quoted. See [URL]http://uk3.php.net/manual/en/language.variables.predefined.php[/URL]

Which DBMS are you using?

The code that you're using should work, [CODE] <?php // code to get final grades //$sqlquery2 = "SELECT max($Totalmark) $fname, $surname FROM details"; //$results2 = mysql_query($sqlquery2); [/CODE] If you inserted the missing comma between max($Totalmark) and $fname. Might be worth a try.

You may be having a slight problem with terminology & functionality. SQL (Structured Query Language) is a language that OTHER systems (PHP / C / C++ / Java / Basic) can use to interrogate a database. This is a 'backend' language and doesn't normally have any user interaction. The language …

How do I put this. When your user clicks on the SUBMIT button, well, PHP has bin and gone and has nothing to do with the page any more. PHP runs on the SERVER. Javascript runs on the CLIENT in the clients BROWSER. Now that should be hint enough for …

Unfortunately your tables don't relate very well. As your IMAGES table has the columns | id | image | thumb | category | relation_id | date | then, ideally, your GALLERY table should have | id | title | category | relation_id | date | Well actually the GALLERY table …

Have you tried using urlencode() on the title?

The statement you refer to is meaningless without context. Which book? Subject? Etc. You then go on to site an example which only has meaning within its own scope. The data you use isn't normalised. Was the original example referring to normalised, hierarchical data? Need more details please.

Two question on this one, 1) Shouldn't the strings within the $_SESSION[] markers be single quoted? 2) Aren't these SESSION variables? i.e. they give the information relevant to that particular session and not the total memory used. So USEDMEMORY should always be less than ALLOCATEDMEMORY.

The last time I implemented a multilanguage website (English, French, Dutch) the varying language elements were held as meta data. Where data items were in different languages then these too had the language PK as part of their PK. To add another language a complete set of the language elements …

before you try to work out what the DB structure looks like you should define your requirements. Then, and only then, can you reduce your data into 3FN or Object tables. These alone will provide you with your DB structure.