An Introduction to Database Normalization (part 2)

Thanks for your detailed article,hope you can provide us with another informational article. I would like to suggest an xml and php articles from you, i noticed from an excerp from you article:

"I’ve been messing around with XML and XSL transformations quite a bit lately, using my favorite scripting language, PHP, to create XML documents on-the-fly using data retrieved from a MySQL database. This is cool, because I can then use PHP 4.03’s new Sablotron extension to transform these XML documents into a format viewable within a PC, PDA or cellular phone WAP browser. "

Can you give us an article on this??
Thank you.

If not for the slow down load I would give the articles in your site very high marks.

Using a high speed connection the average download from your site is well over a minute.

just fyi
krr

Where are you connecting from, Mars? ;)

I've been reading Devshed for quite a while, and never have had a problem, and I connect from a 28.8 connection!

Keep in mind that just because you are unable to connect well with some site, this does not mean that it is the site's problem. It could very well be some problem found on the route your connection takes to reach the site.

/Gianni

point taken,
thanx
krr

dear sir ,
i would really like to thank you for the articles u have written on database normalisation,it was a great aid to me as i understaood the significance of the database manageability and flexibility,
i dont have words to express my filings but all i can say is GREAT

How can I create a subquery ?
Can you explain to me ?

I would like to vote in favour of an XML and XSL article the quality of the database normalisation one.

I would like to add another vote in favour of an XML and XSL article. Thanks for this article, was very helpfull.

I think no one would be able to explain creating sub-queries in mySQL to you, since it simply is (currently) not supported on mySQL.
<br>
Like the mySQL documentation states, most of the time you can get the same results by using joins.

Another vote for XML/XSL.

How can I create simple list and delete the database with php? Please answer me!

I want to design a database for a videostore. So, i must put it in first, second, and third normal form, by making use of diagrams.

[design a database in first, second and third normal form]

can someone provide a php sample to insert data in more than one table in one shot?
thankx in advance

Hi,
I was wondering why when you created your columns in your example project you showed a preference for the char type over the varchar?
thanks
-Loudi