?
Solved

insert xml data into mysql where record does not exist

Posted on 2011-05-11
23
Medium Priority
?
353 Views
Last Modified: 2013-12-12
Hi,

Can anyone provide an example of how to import the xml data into the contributors  table?
Trying to avoid indexing the columns, I will like to insert data into the table only when a similar record does not exist.
drop database if exists books;

create database books;

use books;

create table tblContributors
(
   ContributorID int unsigned not null auto_increment,
   ContributorRole char(3),
   NamesBeforeKey varchar(150),  
   KeyNames varchar(150),
   SuffixToKey varchar(150),
   LettersAfterNames varchar(250),
   primary key (ContributorID)
);


grant select, insert, update, delete
on books.*
to books@localhost identified by 'password';

Open in new window

<?php  

error_reporting(E_ALL);
echo "<pre>" . PHP_EOL;

// TEST DATA FROM THE POST AT EE
$xml = <<<EOXML
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE ONIXMessage SYSTEM "http://www.editeur.org/onix/2.1/03/reference/onix-international.dtd">
<ONIXMessage>
    <Header>
		<FromCompany>Elsevier Science and Technology</FromCompany>
		<FromPerson>Jim Darwin, 612-698-6123</FromPerson>
		<SentDate>20100219</SentDate>
		<DefaultCurrencyCode>USD</DefaultCurrencyCode>
	</Header>
	<Product>
		<RecordReference>1093123:10880222</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780123814128</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780123814128</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>DH</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>Student Solutions Manual, Partial Differential Equations &amp; Boundary Value Problems with Maple</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>George A.</NamesBeforeKey>
			<KeyNames>Articolo</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Rutgers University, New Brunswick, NJ, USA</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<BASICMainSubject>COM023000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>13</TextTypeCode>
			<Text>Dr. George A. Articolo has 35 years of teaching experience in physics and applied mathematics at Rutgers University, and has been a consultant for several government research laboratories and aerospace corporations. He has a Ph.D. in mathematical physics with degrees from Temple University and Rensselaer Polytechnic Institute.&lt;p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>5</NameCodeValue>
			<ImprintName>Academic Press</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20090801</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2009</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780123747327</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20090822</ExpectedShipDate>
			<PackQuantity>16</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>9.99</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>1057584:10579551</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781856178433</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781856178433</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>Working Guide to Drilling Equipment and Operations</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>Williams</NamesBeforeKey>
			<KeyNames>Lyons</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<IllustrationsNote>Approx. 224 illustrations</IllustrationsNote>
		<BASICMainSubject>SCI024000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>&lt;p&gt;Drilling technology has evolved in order to get at the increasingly harder to find oil, and in a more environmentally friendly way. Successful drilling operations require blending many technologies. Drilling equipment and procedures have a unique language that must be conquered in order to understand drilling operations. &lt;/p&gt;&lt;br&gt;&lt;p&gt;Working Guide to Drilling Equipment and Operations provides a fundamental, basic knowledge of the intricacies of drilling fluid, drilled solids management, drill bits, drill string design, directional drilling, cementing, casing, hydraulic optimization, and a discussion of predominant problems such as stuck pipe and lost circulation. Background information, such as: clay structure (needed to understand well bore instability and drilling fluids), discussion of pressure and pressure effects, the theory behind factors affecting drilling performance, and rock failure under pressure, are included to enhance the understanding of the drilling process and problems. &lt;/p&gt;
                                    &lt;br&gt;&lt;br&gt;&lt;ul&gt;&lt;br&gt;&lt;li&gt;Drilling and Production Hoisting Equipment&lt;/li&gt;&lt;br&gt;&lt;li&gt;Hoisting Tool Inspection and Maintenance Procedures&lt;/li&gt;&lt;br&gt;&lt;li&gt;Pump Performance Charts&lt;/li&gt;&lt;br&gt;&lt;li&gt;Rotary Table and Bushings&lt;/li&gt;&lt;br&gt;&lt;li&gt;Rig Maintenance of Drill Collars&lt;/li&gt;&lt;br&gt;&lt;li&gt;Drilling Bits and Downhole Tools&lt;/li&gt;&lt;br&gt;&lt;p&gt;&lt;/p&gt;&lt;/ul&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;p&gt;Chapter 1 Drilling Mud and Completion Systems &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 2 Drilling String: Composition and Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 3 Air and Gas Drilling &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 4 Directional Drilling &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 5 Selection of Drilling Practies &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 6 Well Pressure Control&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 7 Fishing Operations and Equipment&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 8 Casing and Casing String Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 9 Well Cementing &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 10 Tubing and Tubing String Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 11 Environmental Considerations&lt;/p&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>18</TextTypeCode>
			<Text>&lt;p&gt;Drilling technology has evolved in order to get at the increasingly harder to find oil, and in a more environmentally friendly way. Successful drilling operations require blending many technologies. Drilling equipment and procedures have a unique language that must be conquered in order to understand drilling operations. &lt;/p&gt;&lt;br&gt;&lt;p&gt;&lt;/p&gt;&lt;br&gt;&lt;p&gt;Working Guide to Drilling Equipment and Operations provides a fundamental, basic knowledge of the intricacies of drilling fluid, drilled solids management, drill bits, drill string design, directional drilling, cementing, casing, hydraulic optimization, and a discussion of predominant problems such as stuck pipe and lost circulation. Background information, such as: clay structure (needed to understand well bore instability and drilling fluids), discussion of pressure and pressure effects, the theory behind factors affecting drilling performance, and rock failure under pressure, are included to enhance the understanding of the drilling process and problems. &lt;/p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>71</NameCodeValue>
			<ImprintName>Gulf Professional Publishing</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20091001</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2010</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<Measure>
			<MeasureTypeCode>01</MeasureTypeCode>
			<Measurement>9</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<Measure>
			<MeasureTypeCode>02</MeasureTypeCode>
			<Measurement>6</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9781856178440</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20091022</ExpectedShipDate>
			<PackQuantity>18</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>99.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100780:100789</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1928994563</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781928994565</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781928994565</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Series>
			<TitleOfSeries>.NET Developers Series</TitleOfSeries>
		</Series>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>.NET Mobile Web Developers Guide</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<KeyNames>Syngress</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>520</NumberOfPages>
		<BASICMainSubject>COM051000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>Introducing Microsoft's flagship wireless development tool&lt;br&gt;The .NET Mobile Web Developer's Guide will provide readers with a solid guide to developing mobile applications using Microsoft technologies. The focus of this book is on using ASP.NET and the .NET mobile SDK. It provides an introduction to the .NET platform and goes into moderate details on ASP.NET to allow readers to start developing ASP.NET applications. In addition, this book will give the readers the insight to use the various Microsoft technologies for developing mobile applications.&lt;br&gt;This book assumes the readers have experience in developing web applications and are familiar with any one of the server-side technologies like ASP, JSP or PHP.
                                    &lt;br&gt;&lt;br&gt;The first book available on Microsoft's cornerstone wireless development tool&lt;br&gt;Best selling, high profile authors. Wei Meng Lee and Shelley Powers are frequent speakers at all of the major developer conferences have previously authored best selling books for O'Reilly &amp; Associates, Wrox Press, SAMS and Que&lt;br&gt;Comes with wallet-sized CD containing a printable HTML version of the book, all of the source code examples and demos of popular ASP .NET and .NET Mobile programming tools&lt;br&gt;Comprehensive Coverage of the .NET Mobile SDK and ASP.NET for Mobile Web developers</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20020302</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080481838</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>32</ProductAvailability>
			<ExpectedShipDate>20020323</ExpectedShipDate>
			<PackQuantity>12</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>51.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>112530:112619</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1856174670</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781856174671</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781856174671</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BB</ProductForm>
		<Series>
			<TitleOfSeries>World Pumps</TitleOfSeries>
		</Series>
		<Set>
			<TitleOfSet>Forsthoffer's Rotating Equipment Handbooks</TitleOfSet>
		</Set>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>1. Forsthoffer's Rotating Equipment Handbooks</TitleText>
			<Subtitle>Fundamentals of Rotating Equipment</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>William E</NamesBeforeKey>
			<KeyNames>Forsthoffer</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>President, Forsthoffer Associates Inc., Washington Crossing, PA USA</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>512</NumberOfPages>
		<BASICMainSubject>TEC009070</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>'Fundamentals of Rotating Equipment' is an overview of the main types of rotating machinery in industry, and covers such aspects as system dynamics, surge control, vibration and balancing, radial bearing design, performance parameters, rotor system design and operation, rotor axial (thrust) forces, performance objectives and mechanical restraints, auxiliary systems and seals.&lt;br&gt;&lt;br&gt;This book will enhance rotating equipment reliability and safety throughout the many industries where such equipment is vital to a successful business.&lt;br&gt;&lt;br&gt;Over recent years there have been substantial changes in those industries  which are concerned with the design, purchase and use of special purpose (ie critical, high-revenue) rotating equipment. Key personnel have been the victims of early retirement or have moved to other industries: contractors and end-users have reduced their technical staff and consequently have to learn complex material from scratch. &lt;br&gt;&lt;br&gt;As a result, many companies are finding that they are devoting unnecessary man hours to the discovery and explanation of basic principles, and having to explain these to clients who should already be aware of them. In addition, the lack of understanding by contractors and users of equipment characteristics and operating systems often results in a wrong fit and a costly reliability problem. &lt;br&gt;&lt;br&gt;The stakes can be high, and it against this background that this book has been published. It is the outcome of many years experience and is based on well-honed teaching material which is easily readable, understandable and actually enjoyable!&lt;br&gt;&lt;br&gt;This is a five volume set. The volumes are: &lt;br&gt;1. Fundamentals of Rotating Equipment &lt;br&gt;2. Pumps &lt;br&gt;3. Compressors &lt;br&gt;4. Auxiliary Systems&lt;br&gt;5. Reliability Optimization thru Component Condition Monitoring and Root Cause Analysis
                                    &lt;br&gt;&lt;br&gt;* A distillation of many years of on-site training by a well-known US Engineer who also operates in the Middle East.&lt;br&gt;* A Practical book written in a succinct style and well illustrated throughout.&lt;br&gt;* An overview of the main types of rotating machinery in industry.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>Rotating equipment overview; compressor characteristics; operation of a compressor in a system; pump types and applications; pump performance data; centrifugal pump hydraulic disturbances; pump mechanical design; mechanical seals; compressor types and applications; the concept of fluid head; performance relationships; surge (stall) and stonewall; the effect of a gas density change; turbo-compressor mechanical design overview; radial bearing design; rotar axial (thrust) forces; compressor seal system overview and types; reciprocating compressors major component functions; flexible coupling design, installation and operation; steam turbine function and types; steam turbine performance; steam turbine mechanical design overview; steam turbine inlet steam regulation; steam turbine control/ protection systems; steam turbine operation; gas turbine types and applications; gas turbine performance; gas turbine mechanical design; gas turbine support systems; gas turbine control and protection; lubrication system overview and types; monitoring reliability and component condition; conversions to metric system; index</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>68</NameCodeValue>
			<ImprintName>Elsevier Science</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20060123</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2005</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<Measure>
			<MeasureTypeCode>01</MeasureTypeCode>
			<Measurement>9.21</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<Measure>
			<MeasureTypeCode>02</MeasureTypeCode>
			<Measurement>6.125</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<RelatedProduct>
			<RelationCode>02</RelationCode>
			<ProductIdentifier>
				<ProductIDType>02</ProductIDType>
				<IDValue>1856174727</IDValue>
			</ProductIdentifier>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9781856174725</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080949321</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>32</ProductAvailability>
			<ExpectedShipDate>20060213</ExpectedShipDate>
			<PackQuantity>12</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>161</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100741:100747</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1931836590</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781931836593</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781931836593</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10 Cool Lego Mindstorm Dark Side Robots Transports and Creatures</TitleText>
			<Subtitle>Amazing Projects You Can Build in Under an Hour</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<KeyNames>Syngress</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>176</NumberOfPages>
		<BASICMainSubject>TEC037000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>LEGO MINDSTORMS let you design and program robots that can do just about anything!&lt;br&gt;The Dark Side Developer's Kit is targeted towards the young or novice LEGO MINDSTORMS designer, age 9 and up, although experienced MINDSTORMS fans will appreciate the unique possibilities offered by this kit as well. The Dark Side Developer's Kit includes special MINDSTORMS pieces that allow the user to create a host of Star Wars themed robots, creatures, and vehicles. It also comes with the Micro Scout, a mini-computer with 7 built-in programs, a motor, and a light sensor that brings the MINDSTORMS creations to life with a minimum of effort.&lt;br&gt;&lt;br&gt;10 Cool LEGO MINDSTORMS Dark Side Robots, Transports, and Creatures: Amazing Projects You Can Build in Under an Hour provides step-by-step instructions and detailed illustrations for users of all skill levels and proficiencies.
                                    &lt;br&gt;&lt;br&gt;A blend of the hugely popular LEGO and STAR WARS lines. Appealing to fans of both, this book will allow readers to build unique creations using the special parts found in the "LEGO MINDSTORMS: Dark Side Developer's Kit" that mimic the robots, vehicles and creatures found in the STAR WARS movies. &lt;br&gt;From out of the box to up and running in less than an hour. This book teaches users how to create 10 amazing projects, each in under an hour.&lt;br&gt;8-page color insert. An eight-page color insert illustrates the complete projects in full-detail.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>Chapter 1: Sith Stealth Infiltrator&lt;br&gt;Chapter 2: Imperial Devastator&lt;br&gt;Chapter 3: Bounty Hunter Droid&lt;br&gt;Chapter 4: Imperial AT-ST&lt;br&gt;Chapter 5: Dark Side Reconnaissance Droid&lt;br&gt;Chapter 6: Dark Side Battle-Trainer&lt;br&gt;Chapter 7: Trade Federation Land Transport&lt;br&gt;Chapter 8: Sith Scout Ship&lt;br&gt;Chapter 9: Imperial TIE Interceptor&lt;br&gt;Chapter 10: Trade Federation Security Droid</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>06</PublishingStatus>
		<PublicationDate>20020913</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080546292</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>OI</AvailabilityCode>
			<ProductAvailability>40</ProductAvailability>
			<ExpectedShipDate>20021004</ExpectedShipDate>
			<PackQuantity>34</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>25.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100811:100824</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1931836612</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781931836616</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781931836616</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10 Cool Lego Mindstorm Robotics Invention System 2 Projects</TitleText>
			<Subtitle>Amazing Projects You Can Build in Under an Hour</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<KeyNames>Syngress</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>176</NumberOfPages>
		<BASICMainSubject>TEC037000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>LEGO MINDSTORMS lets you design and program robots that can do just about anything!&lt;br&gt;The LEGO MINDSTORMS RIS 2.0 is the core set for all MINDSTORMS users, that lets users design and program working robots - limited only by their imagination. Initially designed for users 12 and up, LEGO MINDSTORMS has taken off with LEGO enthusiasts of all ages.  &lt;br&gt;10 Cool LEGO MINDSTORMS RIS 2.0 Projects: Amazing Projects You Can Build in Under an Hour provides step-by-step instructions and detailed illustrations for users of all skill levels and proficiencies.
                                    &lt;br&gt;&lt;br&gt;From out of the box to up and running in less than an hour. &lt;br&gt;8-page color insert. A color insert illustrates the complete projects in full-detail.&lt;br&gt;Specifically targeted at new users of the LEGO MINDSTORMS RIS 2.0.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>Chapter 1: There's a Mouse in House&lt;br&gt;Chapter 2: How to Build a Better Mouse Trap&lt;br&gt;Chapter 3: Trains...&lt;br&gt;Chapter 4:  Planes...&lt;br&gt;Chapter 5: And Automobiles...&lt;br&gt;Chapter 6: BattleTank with Treads and Turrets&lt;br&gt;Chapter 7: Chore-Doer 3000&lt;br&gt;Chapter 8: Arachnoid-what?  Building a Spider&lt;br&gt;Chapter 9: Making the Band: Building a Drummer&lt;br&gt;Chapter 10: Just Desserts: Building a Gumball Machine</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20021129</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080546308</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20021220</ExpectedShipDate>
			<PackQuantity>22</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>25.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100742:100748</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1931836604</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781931836609</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781931836609</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10 Cool Lego Mindstorm Ultimate Builders Projects</TitleText>
			<Subtitle>Amazing Projects You Can Build in Under an Hour</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>Mario</NamesBeforeKey>
			<KeyNames>Ferrari</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Author of bestselling "Building Robots with LEGO Mindstorms", Italy</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>176</NumberOfPages>
		<BASICMainSubject>TEC037000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>LEGO MINDSTORMS lets you design and program robots that can do just about anything!&lt;br&gt;You've just purchased the LEGO MINDSTORMS Ultimate Builder Kit. Now what? Overwhelmed by the creative possibilities? The Builder Kit is targeted towards those who want to become "master LEGO builders." &lt;br&gt;&lt;br&gt;10 Cool LEGO MINDSTORM Ultimate Builder Projects: Amazing Projects You Can Build in Under an Hour provides step-by-step instructions and detailed illustrations for users of all skill levels and proficiencies. This MINDSTORMS kit features many rare parts, a spare motor, a turntable, special gears, transparent beams, and even a pneumatics system-parts that can be confusing and that will be new to many LEGO builders. 10 Cool LEGO MINDSTORM Ultimate Builder Projects teaches readers how to incorporate these new features into their creations as they build 10 unique robots.
                                    &lt;br&gt;&lt;br&gt;From out of the box to up and running in less than an hour. This book teaches users how to create 10 amazing projects in under an hour.&lt;br&gt;8-page color insert. An eight-page color insert will illustrates the complete projects in full-detail.&lt;br&gt;Specifically targeted to both new users of the LEGO MINDSTORMS and experienced MINDSTORMS fans.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>13</TextTypeCode>
			<Text>Mario Ferrari received his first Lego box around 1964, when he was 4. Lego was his favorite toy for many years, until he thought he was too old to play with it. In 1998, the Lego Mindstorms RIS set gave him reason to again have Lego become his main addiction. Mario believes Lego is the closest thing to the perfect toy. He is Managing Director at EDIS, a leader in finishing and packaging solutions and promotional packaging. The advent of the MINDSTORMS product line represented for him the perfect opportunity to combine his interest in IT and robotics with his passion for LEGO bricks, which started during his early childhood. Mario has been a very active member of the online MINDSTORMS community from the beginning and has pushed LEGO robotics to its limits. Mario holds a bachelor's degree in Business Administration from the University of Turin and has always nourished a strong interest for physics, mathematics, and computer science. He is fluent in many programming languages and his background includes positions as an IT manager and as a project supervisor. Mario estimates he owns over 60,000 Lego pieces. Mario works in Modena, Italy, where he lives with his wife Anna and his children Sebastiano and Camilla.&lt;p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20021214</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080555157</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20030104</ExpectedShipDate>
			<PackQuantity>18</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>25.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>120947:127931</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>0444504761</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780444504760</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780444504760</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BB</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10&lt;SUP&gt;th&lt;/SUP&gt; European Conference on Mixing</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>H.E.A.</NamesBeforeKey>
			<KeyNames>van den Akker</KeyNames>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>J.J.</NamesBeforeKey>
			<KeyNames>Derksen</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Kramers Laboratorium voor Fysische Technologie, Delft University of Technology, Delft, The Netherlands</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>572</NumberOfPages>
		<BASICMainSubject>TEC009010</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>Traditionally, fluid mixing and the related multiphase contacting processes have always been regarded as an empirical technology. Many aspects of mixing, dispersing and contacting were related to power draw, but understanding of the phenomena was limited or qualitative at the most.&lt;br&gt;&lt;br&gt;In particular during the last decade, however, plant operation targets have tightened and product specifications have become stricter. The public awareness as to safety and environmental hygiene has increased. The drive towards larger degrees of sustainability in the process industries has urged for lower amounts of solvents and for higher yields and higher selectivities in chemical reactors. All this has resulted in a &lt;i&gt;market pull&lt;/i&gt;: the need for more detailed insights in flow phenomena and processes and for better verifiable design and operation methods.&lt;br&gt;&lt;br&gt;Developments in miniaturisation of sensors and circuits as well as in computer technology have rendered leaps possible in computer simulation and animation and in measuring and monitoring techniques. &lt;br&gt;&lt;br&gt;This volume encourages a leap forward in the field of mixing by the current, overwhelming wealth of sophisticated measuring and computational techniques. This leap may be made possible by modern instrumentation, signal and data analysis, field reconstruction algorithms, computational modelling techniques and numerical recipes. &lt;br&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;b&gt;Section headings:&lt;/b&gt; &lt;b&gt;Turbulence Characteristics in Stirred Tanks.&lt;/b&gt; (3 papers). &lt;b&gt;Measurements in Chemically Reacting Flows.&lt;/b&gt; (3 papers). &lt;b&gt;Modelling of Micro-Mixing.&lt;/b&gt; (6 papers). &lt;b&gt;Effects of Viscosity and Rheology on Mixing.&lt;/b&gt; (3 papers). &lt;b&gt;Slurry Systems.&lt;/b&gt; (2 papers). &lt;b&gt;Liquid-Liquid Dispersions.&lt;/b&gt; (6 papers). &lt;b&gt;Gas-Liquid Systems.&lt;/b&gt; (4 papers). &lt;b&gt;Particle Collisions in Crystallisation.&lt;/b&gt; (2 papers). &lt;b&gt;Advanced CFD.&lt;/b&gt; (3 papers). &lt;b&gt;Posters.&lt;/b&gt; (33 papers).&lt;br&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>68</NameCodeValue>
			<ImprintName>Elsevier Science</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>06</PublishingStatus>
		<PublicationDate>20000614</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2000</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080525792</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>OI</AvailabilityCode>
			<ProductAvailability>40</ProductAvailability>
			<ExpectedShipDate>20000705</ExpectedShipDate>
			<PackQuantity>16</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>340</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>1095034:10895161</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780240814254</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780240814254</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>100% Photoshop</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>Steve</NamesBeforeKey>
			<KeyNames>Caplin</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Graphic artist/illustrator, contributing editor for MacUser magazine and the best-selling author of How to Cheat in Photoshop</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>256</NumberOfPages>
		<BASICMainSubject>COM012000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>&lt;p&gt;Just when you think you have learned all that you could ever know about working in Photoshop, digital artist and photomontage king Steve Caplin comes along with yet another masterful method for creating incredible works of art in Photoshop. This time, he will show you how to create complete images, from start to finish, &lt;U&gt;entirely&lt;/U&gt; within the software program. No source material, photographs, or existing files from other software packages are needed, saving you valuable time and resources. The techniques you will learn in this ground-breaking new book will help you combine your artistic vision and skills with an understanding of how to manipulate the built-in Photoshop filters to produce impressive, eye-catching artwork.&lt;/p&gt;&lt;br&gt;&lt;p&gt;Each chapter opens with a complete double page illustration, created entirely in Photoshop. Then, carefully laid out step-by-step instructions show you how each element in the illustration is created, and how they are all combined in the end to make a convincing final image. Using Steve&apos;s proven methods for success, you will be able to produce images that reflect a more finely crafted, hand drawn approach, whether you are an artist for your own enjoyment or a working professional looking for a leg up on the competition. &lt;/p&gt;
                                    &lt;br&gt;&lt;br&gt;&lt;p&gt;*The only book of its kind that does not rely on any external images whatsoever -- each and every element is created directly in Photoshop &lt;/p&gt;&lt;br&gt;&lt;p&gt;*A chapter covering the basics of using specific filters and textures and a chapter providing a summary of common techniques and tools will help you brush up on your general Photoshop skills so you can move through the rest of the book successfully &lt;/p&gt;&lt;br&gt;&lt;p&gt;*Visit the book website at [url to come] for supplemental material to help you get started &lt;/p&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;p&gt;Chapter 1: Textures: Using Clouds, Noise, Blur, Fibers to create basic texture; Texture creation: paper, wood, stone, and metal; Chapter 2: Setting the Scene: Hallway -- door, light, glass, gold text, shadows, metal handle, layer masks; Chapter 3: The Great Outdoors: trees, grass, leaves (custom brush design), water and reflections, clouds, sky, mountains; Chapter 4: In the Attic:LPs, cardboard boxes, guitar, cork boards, beams, brick walls, assorted items; Chapter 5: To Boldly Go: Space scene with stars, planets, aurora, spaceship, alien; Chapter 6: Treasured Possessions: Desk drawer with jewelry, letters, sealing wax, pens, magnifying glass, pencils, rubber stamp, folder with coffee stains; Chapter 7: In the Lab: Mad scientist&apos;s laboratory with Bunsen burner, lab bottles, stone wall, lightning through window; Chapter 8: The Operation:&amp;nbsp;Operating theatre scene with close-up of opened body featuring internal organs, bone, skin texture, scalpels and clamps; Chapter 9: Fantasy Scene: Organic-looking synthetic scene with intertwining tentacles, texture generated background, H R Giger-style anatomical elements;&amp;nbsp;Chapter 10: Photoshop Reference: Quick start guide &lt;/p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>70</NameCodeValue>
			<ImprintName>Focal Press</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>02</PublishingStatus>
		<PublicationDate>20100601</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2010</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780240814261</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>NP</AvailabilityCode>
			<ProductAvailability>10</ProductAvailability>
			<ExpectedShipDate>20100622</ExpectedShipDate>
			<PackQuantity>24</PackQuantity>
			<Price>
				<PriceTypeCode>21</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>39.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>1092624:10872821</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780444534729</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780444534729</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BB</ProductForm>
		<Series>
			<TitleOfSeries>Computer Aided Chemical Engineering</TitleOfSeries>
			<NumberWithinSeries>27</NumberWithinSeries>
		</Series>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10th International Symposium on Process Systems Engineering - PSE2009</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Rita Maria</NamesBeforeKey>
			<KeyNames>de Brito Alves</KeyNames>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Claudio Augusto</NamesBeforeKey>
			<KeyNames>Oller do Nascimento</KeyNames>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Evaristo Chalbaud</NamesBeforeKey>
			<KeyNames>Biscaia</KeyNames>
			<SuffixToKey>Jr.</SuffixToKey>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<BASICMainSubject>SCI013000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>&lt;p&gt;This book contains the proceedings of the10th edition of a series of international symposia on Process Systems Engineering (PSE)&amp;nbsp;initiated in 1982. The special focus of PSE09 is how PSE methods can support sustainable resource systems and emerging technologies in the areas of green engineering.&lt;/p&gt;
                                    &lt;br&gt;&lt;br&gt;&lt;p&gt;* Contains fully searchable CD of all printed contributions&lt;/p&gt;&lt;br&gt;&lt;p&gt;* Focus on sustainable green engineering&lt;/p&gt;&lt;br&gt;&lt;p&gt;* 9 Plenary papers, 21 Keynote lectures by leading experts in the field&lt;/p&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;p&gt;&lt;b&gt;Part A&lt;/b&gt;&lt;/p&gt;&lt;br&gt;&lt;p&gt;Plenary lectures&lt;/p&gt;&lt;br&gt;&lt;p&gt;Keynote lectures&lt;/p&gt;&lt;br&gt;&lt;p&gt;Modelling, Supporting Methods and Tools&lt;/p&gt;&lt;br&gt;&lt;p&gt;Product and Process Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;&lt;b&gt;Part B&lt;/b&gt;&lt;/p&gt;&lt;br&gt;&lt;p&gt;Operations and Control&lt;/p&gt;&lt;br&gt;&lt;p&gt;Non-traditional Applications of Process Systems Engineering&lt;/p&gt;&lt;br&gt;&lt;p&gt;Business Decision Support&lt;/p&gt;&lt;br&gt;&lt;p&gt;Education in Process Systems Engineering&lt;/p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>109</NameCodeValue>
			<ImprintName>Elsevier</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20090903</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2009</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>01</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080963273</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780444534736</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>32</ProductAvailability>
			<ExpectedShipDate>20090924</ExpectedShipDate>
			<PackQuantity>1</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>575</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
</ONIXMessage>	
EOXML;

// LOAD IT INTO AN OBJECT
$obj = SimpleXML_Load_String($xml);

// ACTIVATE THIS TO VISUALIZE THE OBJECT
// var_dump($obj);

// SHOW HOW TO GET SOME OF THE INFORMATION OUT OF THE OBJECT
$h = (string)$obj->Header->FromCompany;
$h1 = (string)$obj->Header->FromPerson;
$h2 = (string)$obj->Header->SentDate;
$h3 = (string)$obj->Header->DefaultCurrencyCode;

echo PHP_EOL . $h;
echo PHP_EOL . $h1;
echo PHP_EOL . $h2;
echo PHP_EOL . $h3;

// SHOW HOW TO GET COUNTS OF DATA FIELDS
$k = count($obj->Product);
echo PHP_EOL . "$k PRODUCT LISTINGS";

// SHOW HOW TO ITERATE OVER THE ARRAY OF "Product" AND GET SOME DATA FIELDS
$n = 0;
foreach ($obj->Product as $p)
{

$con = mysqli_connect("localhost", "books", "password", "books");
/* check connection */
if (mysqli_connect_errno()) {
   printf("Connect failed: %s\n", mysqli_connect_error());
   exit();
}

    $n++;
    $t = (string)$p->Title->TitleText;
    $i = (string)$p->Imprint->ImprintName;
    $y = (string)$p->CopyrightStatement->CopyrightYear;
    $c = (string)$p->CopyrightStatement->CopyrightOwner->CopyrightOwnerIdentifier->IDValue;
    $m = (string)$p->SupplyDetail->Price->PriceAmount;
	
	$rr = (string)$p->RecordReference;
    $nt = (string)$p->NotificationType;
    $pf = (string)$p->ProductForm;
    $nop = (string)$p->NumberOfPages;
    $bms = (string)$p->BASICMainSubject;
   	$ac = (string)$p->AudienceCode;
    $pubn = (string)$p->PublisherName;
    $pubs = (string)$p->PublishingStatus;
    $pubd = (string)$p->PublicationDate;
	
	
	
    echo PHP_EOL;
    echo PHP_EOL . "LISTING NUMBER $n";
    echo PHP_EOL . $t;
    echo PHP_EOL . $i;
    echo PHP_EOL . "&copy;" . $y . ' ' .$c;
    echo PHP_EOL . '$' . $m;
		

    foreach ($p->ProductIdentifier as $pi)
    {
        // CAST AS STRING VARIABLES
        $ProductIDType = (string)$pi->ProductIDType;
        $IDValue       = (string)$pi->IDValue;
        
		// STORED IN THE ARRAY
 
        $pia[$ProductIDType==03] = $IDValue;	
    
    }	
	   
	// PRODUCT IDENTIFIERS - PRESENTED FROM THE ASSOCIATIVE ARRAY
    foreach ($pia as $ProductIDType => $IDValue)
    {
   	   $GTIN13 = $pia[$ProductIDType==03];
	} 
	   
	$pia1 = array();
    foreach ($p->ProductIdentifier as $pi1)
    {
        // CAST AS STRING VARIABLES
        $ProductIDType1 = (string)$pi1->ProductIDType;
        $IDValue1       = (string)$pi1->IDValue;
        
		// STORED IN THE ARRAY
 
        $pia1[$ProductIDType1] = $IDValue1;
    
    }	
	   
	// PRODUCT IDENTIFIERS - PRESENTED FROM THE ASSOCIATIVE ARRAY
    foreach ($pia1 as $ProductIDType1 => $IDValue1)
    {
	  		
		echo PHP_EOL . 'PIM: ' . $ProductIDType1 . ' ' . $IDValue1. ' ' . $GTIN13;
		
   



	 if ($ProductIDType1==02) {
               mysql_query("INSERT INTO tblIsbn10 (
			   ProductIDType, 
			   IDValue, 
			   Gtin13) 
			   
			   VALUES (
			   '$ProductIDType1', 
			   '$IDValue1', 
			   '$GTIN13') 
			   ");
			   
     }
	   
	   if ($ProductIDType1==03) {
               
			   mysql_query("INSERT INTO tblGtin13 (
			   ProductIDType, 
			   IDValue, 
			   Gtin13) 
			   
			   VALUES (
			   '$ProductIDType1', 
			   '$IDValue1', 
			   '$GTIN13') 
			   ");
			   
			    //INSERT DATA INTO PRODUCTS TABLE
			    mysql_query("INSERT INTO books (
				RecordReference, 
				NotificationType, 
				ProductIDTypeIDValue, 
				ProductFormCode, 
				NumberOfPages, 
				BASICMainSubject, 
                AudienceCode, 
				PublisherName, 
				PublishingStatus, 
				PublicationDate)

                VALUES (
		        '$rr', 
                '$nt', 
       	        '$IDValue',
                '$pf',
                '$nop', 
                '$bms',
                '$ac', 
                '$pubn', 
                '$pubs', 
                '$pubd') 
                ");    
	        } 
	 
	           if ($ProductIDType1==15) {
               mysql_query("INSERT INTO tblIsbn13 (
			   ProductIDType, 
			   IDValue, 
			   Gtin13) 
			   
			   VALUES (
			   '$ProductIDType1', 
			   '$IDValue1', 
			   '$GTIN13') 
			   ");

     }
	 
	 }
	 
       // CONTRIBUTOR  - EXTRACTED INTO AN ASSOCIATIVE ARRAY
       
        foreach ($p->Contributor as $co)
        {
           // CAST AS STRING VARIABLES
            $ContributorRole = (string)$co->ContributorRole;
            $NamesBeforeKey  = (string)$co->NamesBeforeKey;
            $KeyNames = (string)$co->KeyNames;
            $SuffixToKey = (string)$co->SuffixToKey;
			$LettersAfterNames = (string)$co->LettersAfterNames;	
     	 
	     echo PHP_EOL . 'CO: '  . ' ' . $ContributorRole . ' ' . $NamesBeforeKey. ' '. $KeyNames. ' '.   $SuffixToKey . ' '.   $LettersAfterNames . ' ' .$GTIN13; 

	$result5 = mysqli_query($con, "INSERT INTO tblContributors  (
            ContributorRole,
            NamesBeforeKey,
            KeyNames,
            SuffixToKey,
			LettersAfterNames)
                    

		   VALUES (
          '$ContributorRole',
		  '$NamesBeforeKey',
		  '$KeyNames', 
		  '$SuffixToKey',
		  '$LettersAfterNames')
		  ");
	 
	   
     
		
		

		
	}
mysqli_close($con);
    }

		 
?>

Open in new window

0
Comment
Question by:Honya
  • 10
  • 6
  • 5
21 Comments
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 35742425
If you use the INSERT INTO ... SELECT syntax, you can have a WHERE clause that checks NOT EXISTS (SELECT 1 FROM tblContributers WHERE ...) so if specific fields already exist then it won't insert.  If any of the keys are primary keys, you can use the ON DUPLICATE KEY syntax available in MySQL also.

http://dev.mysql.com/doc/refman/5.5/en/insert-on-duplicate.html

As far as an efficient way to do this, you can try sending the XML string to MySQL and using techniques exemplified in my Article here:
http://www.experts-exchange.com/Database/MySQL/A_3574-A-MySQL-Tidbit-In-line-XML-Parsing.html

The benefit is you can do the insert in one INSERT INTO ... SELECT statement and utilize whichever duplicate handling from above be it the WHERE NOT EXISTS or ON DUPLICATE KEY, etc.

See if the Article makes sense to you and is something you want to look into and we can discuss further as needed.  If you wish to do it on the PHP side of things, it may be to your benefit to have PHP topic area listed for the question.  

Kevin
0
 

Author Comment

by:Honya
ID: 35753470
I tried the INSERT INTO ... SELECT syntax however it seems that there is something that I am just not getting. I have attached a sample of what I have so far. Could you show where I have gone wrong?
Please note that the primary key, which is the only key,  is the ContributorID field which is an auto increment number.
<?php  

error_reporting(E_ALL);
echo "<pre>" . PHP_EOL;

// TEST DATA FROM THE POST AT EE
$xml = <<<EOXML
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE ONIXMessage SYSTEM "http://www.editeur.org/onix/2.1/03/reference/onix-international.dtd">
<ONIXMessage>
    <Header>
		<FromCompany>Elsevier Science and Technology</FromCompany>
		<FromPerson>Jim Darwin, 612-698-6123</FromPerson>
		<SentDate>20100219</SentDate>
		<DefaultCurrencyCode>USD</DefaultCurrencyCode>
	</Header>
	<Product>
		<RecordReference>1093123:10880222</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780123814128</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780123814128</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>DH</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>Student Solutions Manual, Partial Differential Equations &amp; Boundary Value Problems with Maple</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>George A.</NamesBeforeKey>
			<KeyNames>Articolo</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Rutgers University, New Brunswick, NJ, USA</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<BASICMainSubject>COM023000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>13</TextTypeCode>
			<Text>Dr. George A. Articolo has 35 years of teaching experience in physics and applied mathematics at Rutgers University, and has been a consultant for several government research laboratories and aerospace corporations. He has a Ph.D. in mathematical physics with degrees from Temple University and Rensselaer Polytechnic Institute.&lt;p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>5</NameCodeValue>
			<ImprintName>Academic Press</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20090801</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2009</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780123747327</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20090822</ExpectedShipDate>
			<PackQuantity>16</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>9.99</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>1057584:10579551</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781856178433</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781856178433</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>Working Guide to Drilling Equipment and Operations</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>Williams</NamesBeforeKey>
			<KeyNames>Lyons</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<IllustrationsNote>Approx. 224 illustrations</IllustrationsNote>
		<BASICMainSubject>SCI024000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>&lt;p&gt;Drilling technology has evolved in order to get at the increasingly harder to find oil, and in a more environmentally friendly way. Successful drilling operations require blending many technologies. Drilling equipment and procedures have a unique language that must be conquered in order to understand drilling operations. &lt;/p&gt;&lt;br&gt;&lt;p&gt;Working Guide to Drilling Equipment and Operations provides a fundamental, basic knowledge of the intricacies of drilling fluid, drilled solids management, drill bits, drill string design, directional drilling, cementing, casing, hydraulic optimization, and a discussion of predominant problems such as stuck pipe and lost circulation. Background information, such as: clay structure (needed to understand well bore instability and drilling fluids), discussion of pressure and pressure effects, the theory behind factors affecting drilling performance, and rock failure under pressure, are included to enhance the understanding of the drilling process and problems. &lt;/p&gt;
                                    &lt;br&gt;&lt;br&gt;&lt;ul&gt;&lt;br&gt;&lt;li&gt;Drilling and Production Hoisting Equipment&lt;/li&gt;&lt;br&gt;&lt;li&gt;Hoisting Tool Inspection and Maintenance Procedures&lt;/li&gt;&lt;br&gt;&lt;li&gt;Pump Performance Charts&lt;/li&gt;&lt;br&gt;&lt;li&gt;Rotary Table and Bushings&lt;/li&gt;&lt;br&gt;&lt;li&gt;Rig Maintenance of Drill Collars&lt;/li&gt;&lt;br&gt;&lt;li&gt;Drilling Bits and Downhole Tools&lt;/li&gt;&lt;br&gt;&lt;p&gt;&lt;/p&gt;&lt;/ul&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;p&gt;Chapter 1 Drilling Mud and Completion Systems &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 2 Drilling String: Composition and Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 3 Air and Gas Drilling &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 4 Directional Drilling &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 5 Selection of Drilling Practies &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 6 Well Pressure Control&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 7 Fishing Operations and Equipment&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 8 Casing and Casing String Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 9 Well Cementing &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 10 Tubing and Tubing String Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 11 Environmental Considerations&lt;/p&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>18</TextTypeCode>
			<Text>&lt;p&gt;Drilling technology has evolved in order to get at the increasingly harder to find oil, and in a more environmentally friendly way. Successful drilling operations require blending many technologies. Drilling equipment and procedures have a unique language that must be conquered in order to understand drilling operations. &lt;/p&gt;&lt;br&gt;&lt;p&gt;&lt;/p&gt;&lt;br&gt;&lt;p&gt;Working Guide to Drilling Equipment and Operations provides a fundamental, basic knowledge of the intricacies of drilling fluid, drilled solids management, drill bits, drill string design, directional drilling, cementing, casing, hydraulic optimization, and a discussion of predominant problems such as stuck pipe and lost circulation. Background information, such as: clay structure (needed to understand well bore instability and drilling fluids), discussion of pressure and pressure effects, the theory behind factors affecting drilling performance, and rock failure under pressure, are included to enhance the understanding of the drilling process and problems. &lt;/p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>71</NameCodeValue>
			<ImprintName>Gulf Professional Publishing</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20091001</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2010</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<Measure>
			<MeasureTypeCode>01</MeasureTypeCode>
			<Measurement>9</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<Measure>
			<MeasureTypeCode>02</MeasureTypeCode>
			<Measurement>6</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9781856178440</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20091022</ExpectedShipDate>
			<PackQuantity>18</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>99.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100780:100789</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1928994563</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781928994565</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781928994565</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Series>
			<TitleOfSeries>.NET Developers Series</TitleOfSeries>
		</Series>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>.NET Mobile Web Developers Guide</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<KeyNames>Syngress</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>520</NumberOfPages>
		<BASICMainSubject>COM051000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>Introducing Microsoft's flagship wireless development tool&lt;br&gt;The .NET Mobile Web Developer's Guide will provide readers with a solid guide to developing mobile applications using Microsoft technologies. The focus of this book is on using ASP.NET and the .NET mobile SDK. It provides an introduction to the .NET platform and goes into moderate details on ASP.NET to allow readers to start developing ASP.NET applications. In addition, this book will give the readers the insight to use the various Microsoft technologies for developing mobile applications.&lt;br&gt;This book assumes the readers have experience in developing web applications and are familiar with any one of the server-side technologies like ASP, JSP or PHP.
                                    &lt;br&gt;&lt;br&gt;The first book available on Microsoft's cornerstone wireless development tool&lt;br&gt;Best selling, high profile authors. Wei Meng Lee and Shelley Powers are frequent speakers at all of the major developer conferences have previously authored best selling books for O'Reilly &amp; Associates, Wrox Press, SAMS and Que&lt;br&gt;Comes with wallet-sized CD containing a printable HTML version of the book, all of the source code examples and demos of popular ASP .NET and .NET Mobile programming tools&lt;br&gt;Comprehensive Coverage of the .NET Mobile SDK and ASP.NET for Mobile Web developers</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20020302</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080481838</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>32</ProductAvailability>
			<ExpectedShipDate>20020323</ExpectedShipDate>
			<PackQuantity>12</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>51.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>112530:112619</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1856174670</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781856174671</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781856174671</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BB</ProductForm>
		<Series>
			<TitleOfSeries>World Pumps</TitleOfSeries>
		</Series>
		<Set>
			<TitleOfSet>Forsthoffer's Rotating Equipment Handbooks</TitleOfSet>
		</Set>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>1. Forsthoffer's Rotating Equipment Handbooks</TitleText>
			<Subtitle>Fundamentals of Rotating Equipment</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>William E</NamesBeforeKey>
			<KeyNames>Forsthoffer</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>President, Forsthoffer Associates Inc., Washington Crossing, PA USA</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>512</NumberOfPages>
		<BASICMainSubject>TEC009070</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>'Fundamentals of Rotating Equipment' is an overview of the main types of rotating machinery in industry, and covers such aspects as system dynamics, surge control, vibration and balancing, radial bearing design, performance parameters, rotor system design and operation, rotor axial (thrust) forces, performance objectives and mechanical restraints, auxiliary systems and seals.&lt;br&gt;&lt;br&gt;This book will enhance rotating equipment reliability and safety throughout the many industries where such equipment is vital to a successful business.&lt;br&gt;&lt;br&gt;Over recent years there have been substantial changes in those industries  which are concerned with the design, purchase and use of special purpose (ie critical, high-revenue) rotating equipment. Key personnel have been the victims of early retirement or have moved to other industries: contractors and end-users have reduced their technical staff and consequently have to learn complex material from scratch. &lt;br&gt;&lt;br&gt;As a result, many companies are finding that they are devoting unnecessary man hours to the discovery and explanation of basic principles, and having to explain these to clients who should already be aware of them. In addition, the lack of understanding by contractors and users of equipment characteristics and operating systems often results in a wrong fit and a costly reliability problem. &lt;br&gt;&lt;br&gt;The stakes can be high, and it against this background that this book has been published. It is the outcome of many years experience and is based on well-honed teaching material which is easily readable, understandable and actually enjoyable!&lt;br&gt;&lt;br&gt;This is a five volume set. The volumes are: &lt;br&gt;1. Fundamentals of Rotating Equipment &lt;br&gt;2. Pumps &lt;br&gt;3. Compressors &lt;br&gt;4. Auxiliary Systems&lt;br&gt;5. Reliability Optimization thru Component Condition Monitoring and Root Cause Analysis
                                    &lt;br&gt;&lt;br&gt;* A distillation of many years of on-site training by a well-known US Engineer who also operates in the Middle East.&lt;br&gt;* A Practical book written in a succinct style and well illustrated throughout.&lt;br&gt;* An overview of the main types of rotating machinery in industry.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>Rotating equipment overview; compressor characteristics; operation of a compressor in a system; pump types and applications; pump performance data; centrifugal pump hydraulic disturbances; pump mechanical design; mechanical seals; compressor types and applications; the concept of fluid head; performance relationships; surge (stall) and stonewall; the effect of a gas density change; turbo-compressor mechanical design overview; radial bearing design; rotar axial (thrust) forces; compressor seal system overview and types; reciprocating compressors major component functions; flexible coupling design, installation and operation; steam turbine function and types; steam turbine performance; steam turbine mechanical design overview; steam turbine inlet steam regulation; steam turbine control/ protection systems; steam turbine operation; gas turbine types and applications; gas turbine performance; gas turbine mechanical design; gas turbine support systems; gas turbine control and protection; lubrication system overview and types; monitoring reliability and component condition; conversions to metric system; index</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>68</NameCodeValue>
			<ImprintName>Elsevier Science</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20060123</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2005</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<Measure>
			<MeasureTypeCode>01</MeasureTypeCode>
			<Measurement>9.21</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<Measure>
			<MeasureTypeCode>02</MeasureTypeCode>
			<Measurement>6.125</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<RelatedProduct>
			<RelationCode>02</RelationCode>
			<ProductIdentifier>
				<ProductIDType>02</ProductIDType>
				<IDValue>1856174727</IDValue>
			</ProductIdentifier>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9781856174725</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080949321</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>32</ProductAvailability>
			<ExpectedShipDate>20060213</ExpectedShipDate>
			<PackQuantity>12</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>161</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100741:100747</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1931836590</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781931836593</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781931836593</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10 Cool Lego Mindstorm Dark Side Robots Transports and Creatures</TitleText>
			<Subtitle>Amazing Projects You Can Build in Under an Hour</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<KeyNames>Syngress</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>176</NumberOfPages>
		<BASICMainSubject>TEC037000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>LEGO MINDSTORMS let you design and program robots that can do just about anything!&lt;br&gt;The Dark Side Developer's Kit is targeted towards the young or novice LEGO MINDSTORMS designer, age 9 and up, although experienced MINDSTORMS fans will appreciate the unique possibilities offered by this kit as well. The Dark Side Developer's Kit includes special MINDSTORMS pieces that allow the user to create a host of Star Wars themed robots, creatures, and vehicles. It also comes with the Micro Scout, a mini-computer with 7 built-in programs, a motor, and a light sensor that brings the MINDSTORMS creations to life with a minimum of effort.&lt;br&gt;&lt;br&gt;10 Cool LEGO MINDSTORMS Dark Side Robots, Transports, and Creatures: Amazing Projects You Can Build in Under an Hour provides step-by-step instructions and detailed illustrations for users of all skill levels and proficiencies.
                                    &lt;br&gt;&lt;br&gt;A blend of the hugely popular LEGO and STAR WARS lines. Appealing to fans of both, this book will allow readers to build unique creations using the special parts found in the "LEGO MINDSTORMS: Dark Side Developer's Kit" that mimic the robots, vehicles and creatures found in the STAR WARS movies. &lt;br&gt;From out of the box to up and running in less than an hour. This book teaches users how to create 10 amazing projects, each in under an hour.&lt;br&gt;8-page color insert. An eight-page color insert illustrates the complete projects in full-detail.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>Chapter 1: Sith Stealth Infiltrator&lt;br&gt;Chapter 2: Imperial Devastator&lt;br&gt;Chapter 3: Bounty Hunter Droid&lt;br&gt;Chapter 4: Imperial AT-ST&lt;br&gt;Chapter 5: Dark Side Reconnaissance Droid&lt;br&gt;Chapter 6: Dark Side Battle-Trainer&lt;br&gt;Chapter 7: Trade Federation Land Transport&lt;br&gt;Chapter 8: Sith Scout Ship&lt;br&gt;Chapter 9: Imperial TIE Interceptor&lt;br&gt;Chapter 10: Trade Federation Security Droid</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>06</PublishingStatus>
		<PublicationDate>20020913</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080546292</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>OI</AvailabilityCode>
			<ProductAvailability>40</ProductAvailability>
			<ExpectedShipDate>20021004</ExpectedShipDate>
			<PackQuantity>34</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>25.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100811:100824</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1931836612</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781931836616</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781931836616</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10 Cool Lego Mindstorm Robotics Invention System 2 Projects</TitleText>
			<Subtitle>Amazing Projects You Can Build in Under an Hour</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<KeyNames>Syngress</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>176</NumberOfPages>
		<BASICMainSubject>TEC037000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>LEGO MINDSTORMS lets you design and program robots that can do just about anything!&lt;br&gt;The LEGO MINDSTORMS RIS 2.0 is the core set for all MINDSTORMS users, that lets users design and program working robots - limited only by their imagination. Initially designed for users 12 and up, LEGO MINDSTORMS has taken off with LEGO enthusiasts of all ages.  &lt;br&gt;10 Cool LEGO MINDSTORMS RIS 2.0 Projects: Amazing Projects You Can Build in Under an Hour provides step-by-step instructions and detailed illustrations for users of all skill levels and proficiencies.
                                    &lt;br&gt;&lt;br&gt;From out of the box to up and running in less than an hour. &lt;br&gt;8-page color insert. A color insert illustrates the complete projects in full-detail.&lt;br&gt;Specifically targeted at new users of the LEGO MINDSTORMS RIS 2.0.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>Chapter 1: There's a Mouse in House&lt;br&gt;Chapter 2: How to Build a Better Mouse Trap&lt;br&gt;Chapter 3: Trains...&lt;br&gt;Chapter 4:  Planes...&lt;br&gt;Chapter 5: And Automobiles...&lt;br&gt;Chapter 6: BattleTank with Treads and Turrets&lt;br&gt;Chapter 7: Chore-Doer 3000&lt;br&gt;Chapter 8: Arachnoid-what?  Building a Spider&lt;br&gt;Chapter 9: Making the Band: Building a Drummer&lt;br&gt;Chapter 10: Just Desserts: Building a Gumball Machine</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20021129</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080546308</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20021220</ExpectedShipDate>
			<PackQuantity>22</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>25.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100742:100748</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1931836604</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781931836609</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781931836609</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10 Cool Lego Mindstorm Ultimate Builders Projects</TitleText>
			<Subtitle>Amazing Projects You Can Build in Under an Hour</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>Mario</NamesBeforeKey>
			<KeyNames>Ferrari</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Author of bestselling "Building Robots with LEGO Mindstorms", Italy</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>176</NumberOfPages>
		<BASICMainSubject>TEC037000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>LEGO MINDSTORMS lets you design and program robots that can do just about anything!&lt;br&gt;You've just purchased the LEGO MINDSTORMS Ultimate Builder Kit. Now what? Overwhelmed by the creative possibilities? The Builder Kit is targeted towards those who want to become "master LEGO builders." &lt;br&gt;&lt;br&gt;10 Cool LEGO MINDSTORM Ultimate Builder Projects: Amazing Projects You Can Build in Under an Hour provides step-by-step instructions and detailed illustrations for users of all skill levels and proficiencies. This MINDSTORMS kit features many rare parts, a spare motor, a turntable, special gears, transparent beams, and even a pneumatics system-parts that can be confusing and that will be new to many LEGO builders. 10 Cool LEGO MINDSTORM Ultimate Builder Projects teaches readers how to incorporate these new features into their creations as they build 10 unique robots.
                                    &lt;br&gt;&lt;br&gt;From out of the box to up and running in less than an hour. This book teaches users how to create 10 amazing projects in under an hour.&lt;br&gt;8-page color insert. An eight-page color insert will illustrates the complete projects in full-detail.&lt;br&gt;Specifically targeted to both new users of the LEGO MINDSTORMS and experienced MINDSTORMS fans.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>13</TextTypeCode>
			<Text>Mario Ferrari received his first Lego box around 1964, when he was 4. Lego was his favorite toy for many years, until he thought he was too old to play with it. In 1998, the Lego Mindstorms RIS set gave him reason to again have Lego become his main addiction. Mario believes Lego is the closest thing to the perfect toy. He is Managing Director at EDIS, a leader in finishing and packaging solutions and promotional packaging. The advent of the MINDSTORMS product line represented for him the perfect opportunity to combine his interest in IT and robotics with his passion for LEGO bricks, which started during his early childhood. Mario has been a very active member of the online MINDSTORMS community from the beginning and has pushed LEGO robotics to its limits. Mario holds a bachelor's degree in Business Administration from the University of Turin and has always nourished a strong interest for physics, mathematics, and computer science. He is fluent in many programming languages and his background includes positions as an IT manager and as a project supervisor. Mario estimates he owns over 60,000 Lego pieces. Mario works in Modena, Italy, where he lives with his wife Anna and his children Sebastiano and Camilla.&lt;p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20021214</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080555157</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20030104</ExpectedShipDate>
			<PackQuantity>18</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>25.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>120947:127931</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>0444504761</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780444504760</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780444504760</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BB</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10&lt;SUP&gt;th&lt;/SUP&gt; European Conference on Mixing</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>H.E.A.</NamesBeforeKey>
			<KeyNames>van den Akker</KeyNames>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>J.J.</NamesBeforeKey>
			<KeyNames>Derksen</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Kramers Laboratorium voor Fysische Technologie, Delft University of Technology, Delft, The Netherlands</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>572</NumberOfPages>
		<BASICMainSubject>TEC009010</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>Traditionally, fluid mixing and the related multiphase contacting processes have always been regarded as an empirical technology. Many aspects of mixing, dispersing and contacting were related to power draw, but understanding of the phenomena was limited or qualitative at the most.&lt;br&gt;&lt;br&gt;In particular during the last decade, however, plant operation targets have tightened and product specifications have become stricter. The public awareness as to safety and environmental hygiene has increased. The drive towards larger degrees of sustainability in the process industries has urged for lower amounts of solvents and for higher yields and higher selectivities in chemical reactors. All this has resulted in a &lt;i&gt;market pull&lt;/i&gt;: the need for more detailed insights in flow phenomena and processes and for better verifiable design and operation methods.&lt;br&gt;&lt;br&gt;Developments in miniaturisation of sensors and circuits as well as in computer technology have rendered leaps possible in computer simulation and animation and in measuring and monitoring techniques. &lt;br&gt;&lt;br&gt;This volume encourages a leap forward in the field of mixing by the current, overwhelming wealth of sophisticated measuring and computational techniques. This leap may be made possible by modern instrumentation, signal and data analysis, field reconstruction algorithms, computational modelling techniques and numerical recipes. &lt;br&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;b&gt;Section headings:&lt;/b&gt; &lt;b&gt;Turbulence Characteristics in Stirred Tanks.&lt;/b&gt; (3 papers). &lt;b&gt;Measurements in Chemically Reacting Flows.&lt;/b&gt; (3 papers). &lt;b&gt;Modelling of Micro-Mixing.&lt;/b&gt; (6 papers). &lt;b&gt;Effects of Viscosity and Rheology on Mixing.&lt;/b&gt; (3 papers). &lt;b&gt;Slurry Systems.&lt;/b&gt; (2 papers). &lt;b&gt;Liquid-Liquid Dispersions.&lt;/b&gt; (6 papers). &lt;b&gt;Gas-Liquid Systems.&lt;/b&gt; (4 papers). &lt;b&gt;Particle Collisions in Crystallisation.&lt;/b&gt; (2 papers). &lt;b&gt;Advanced CFD.&lt;/b&gt; (3 papers). &lt;b&gt;Posters.&lt;/b&gt; (33 papers).&lt;br&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>68</NameCodeValue>
			<ImprintName>Elsevier Science</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>06</PublishingStatus>
		<PublicationDate>20000614</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2000</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080525792</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>OI</AvailabilityCode>
			<ProductAvailability>40</ProductAvailability>
			<ExpectedShipDate>20000705</ExpectedShipDate>
			<PackQuantity>16</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>340</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>1095034:10895161</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780240814254</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780240814254</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>100% Photoshop</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>Steve</NamesBeforeKey>
			<KeyNames>Caplin</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Graphic artist/illustrator, contributing editor for MacUser magazine and the best-selling author of How to Cheat in Photoshop</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>256</NumberOfPages>
		<BASICMainSubject>COM012000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>&lt;p&gt;Just when you think you have learned all that you could ever know about working in Photoshop, digital artist and photomontage king Steve Caplin comes along with yet another masterful method for creating incredible works of art in Photoshop. This time, he will show you how to create complete images, from start to finish, &lt;U&gt;entirely&lt;/U&gt; within the software program. No source material, photographs, or existing files from other software packages are needed, saving you valuable time and resources. The techniques you will learn in this ground-breaking new book will help you combine your artistic vision and skills with an understanding of how to manipulate the built-in Photoshop filters to produce impressive, eye-catching artwork.&lt;/p&gt;&lt;br&gt;&lt;p&gt;Each chapter opens with a complete double page illustration, created entirely in Photoshop. Then, carefully laid out step-by-step instructions show you how each element in the illustration is created, and how they are all combined in the end to make a convincing final image. Using Steve&apos;s proven methods for success, you will be able to produce images that reflect a more finely crafted, hand drawn approach, whether you are an artist for your own enjoyment or a working professional looking for a leg up on the competition. &lt;/p&gt;
                                    &lt;br&gt;&lt;br&gt;&lt;p&gt;*The only book of its kind that does not rely on any external images whatsoever -- each and every element is created directly in Photoshop &lt;/p&gt;&lt;br&gt;&lt;p&gt;*A chapter covering the basics of using specific filters and textures and a chapter providing a summary of common techniques and tools will help you brush up on your general Photoshop skills so you can move through the rest of the book successfully &lt;/p&gt;&lt;br&gt;&lt;p&gt;*Visit the book website at [url to come] for supplemental material to help you get started &lt;/p&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;p&gt;Chapter 1: Textures: Using Clouds, Noise, Blur, Fibers to create basic texture; Texture creation: paper, wood, stone, and metal; Chapter 2: Setting the Scene: Hallway -- door, light, glass, gold text, shadows, metal handle, layer masks; Chapter 3: The Great Outdoors: trees, grass, leaves (custom brush design), water and reflections, clouds, sky, mountains; Chapter 4: In the Attic:LPs, cardboard boxes, guitar, cork boards, beams, brick walls, assorted items; Chapter 5: To Boldly Go: Space scene with stars, planets, aurora, spaceship, alien; Chapter 6: Treasured Possessions: Desk drawer with jewelry, letters, sealing wax, pens, magnifying glass, pencils, rubber stamp, folder with coffee stains; Chapter 7: In the Lab: Mad scientist&apos;s laboratory with Bunsen burner, lab bottles, stone wall, lightning through window; Chapter 8: The Operation:&amp;nbsp;Operating theatre scene with close-up of opened body featuring internal organs, bone, skin texture, scalpels and clamps; Chapter 9: Fantasy Scene: Organic-looking synthetic scene with intertwining tentacles, texture generated background, H R Giger-style anatomical elements;&amp;nbsp;Chapter 10: Photoshop Reference: Quick start guide &lt;/p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>70</NameCodeValue>
			<ImprintName>Focal Press</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>02</PublishingStatus>
		<PublicationDate>20100601</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2010</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780240814261</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>NP</AvailabilityCode>
			<ProductAvailability>10</ProductAvailability>
			<ExpectedShipDate>20100622</ExpectedShipDate>
			<PackQuantity>24</PackQuantity>
			<Price>
				<PriceTypeCode>21</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>39.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>1092624:10872821</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780444534729</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780444534729</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BB</ProductForm>
		<Series>
			<TitleOfSeries>Computer Aided Chemical Engineering</TitleOfSeries>
			<NumberWithinSeries>27</NumberWithinSeries>
		</Series>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10th International Symposium on Process Systems Engineering - PSE2009</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Rita Maria</NamesBeforeKey>
			<KeyNames>de Brito Alves</KeyNames>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Claudio Augusto</NamesBeforeKey>
			<KeyNames>Oller do Nascimento</KeyNames>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Evaristo Chalbaud</NamesBeforeKey>
			<KeyNames>Biscaia</KeyNames>
			<SuffixToKey>Jr.</SuffixToKey>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<BASICMainSubject>SCI013000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>&lt;p&gt;This book contains the proceedings of the10th edition of a series of international symposia on Process Systems Engineering (PSE)&amp;nbsp;initiated in 1982. The special focus of PSE09 is how PSE methods can support sustainable resource systems and emerging technologies in the areas of green engineering.&lt;/p&gt;
                                    &lt;br&gt;&lt;br&gt;&lt;p&gt;* Contains fully searchable CD of all printed contributions&lt;/p&gt;&lt;br&gt;&lt;p&gt;* Focus on sustainable green engineering&lt;/p&gt;&lt;br&gt;&lt;p&gt;* 9 Plenary papers, 21 Keynote lectures by leading experts in the field&lt;/p&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;p&gt;&lt;b&gt;Part A&lt;/b&gt;&lt;/p&gt;&lt;br&gt;&lt;p&gt;Plenary lectures&lt;/p&gt;&lt;br&gt;&lt;p&gt;Keynote lectures&lt;/p&gt;&lt;br&gt;&lt;p&gt;Modelling, Supporting Methods and Tools&lt;/p&gt;&lt;br&gt;&lt;p&gt;Product and Process Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;&lt;b&gt;Part B&lt;/b&gt;&lt;/p&gt;&lt;br&gt;&lt;p&gt;Operations and Control&lt;/p&gt;&lt;br&gt;&lt;p&gt;Non-traditional Applications of Process Systems Engineering&lt;/p&gt;&lt;br&gt;&lt;p&gt;Business Decision Support&lt;/p&gt;&lt;br&gt;&lt;p&gt;Education in Process Systems Engineering&lt;/p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>109</NameCodeValue>
			<ImprintName>Elsevier</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20090903</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2009</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>01</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080963273</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780444534736</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>32</ProductAvailability>
			<ExpectedShipDate>20090924</ExpectedShipDate>
			<PackQuantity>1</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>575</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
</ONIXMessage>	
EOXML;

// LOAD IT INTO AN OBJECT
$obj = SimpleXML_Load_String($xml);

// ACTIVATE THIS TO VISUALIZE THE OBJECT
// var_dump($obj);

// SHOW HOW TO GET SOME OF THE INFORMATION OUT OF THE OBJECT
$h = (string)$obj->Header->FromCompany;
$h1 = (string)$obj->Header->FromPerson;
$h2 = (string)$obj->Header->SentDate;
$h3 = (string)$obj->Header->DefaultCurrencyCode;

echo PHP_EOL . $h;
echo PHP_EOL . $h1;
echo PHP_EOL . $h2;
echo PHP_EOL . $h3;

// SHOW HOW TO GET COUNTS OF DATA FIELDS
$k = count($obj->Product);
echo PHP_EOL . "$k PRODUCT LISTINGS";

// SHOW HOW TO ITERATE OVER THE ARRAY OF "Product" AND GET SOME DATA FIELDS
$n = 0;
foreach ($obj->Product as $p)
{

$con = mysqli_connect("localhost", "books", "password", "books");
/* check connection */
if (mysqli_connect_errno()) {
   printf("Connect failed: %s\n", mysqli_connect_error());
   exit();
}

    $n++;
    $t = (string)$p->Title->TitleText;
    $i = (string)$p->Imprint->ImprintName;
    $y = (string)$p->CopyrightStatement->CopyrightYear;
    $c = (string)$p->CopyrightStatement->CopyrightOwner->CopyrightOwnerIdentifier->IDValue;
    $m = (string)$p->SupplyDetail->Price->PriceAmount;
	
	$rr = (string)$p->RecordReference;
    $nt = (string)$p->NotificationType;
    $pf = (string)$p->ProductForm;
    $nop = (string)$p->NumberOfPages;
    $bms = (string)$p->BASICMainSubject;
   	$ac = (string)$p->AudienceCode;
    $pubn = (string)$p->PublisherName;
    $pubs = (string)$p->PublishingStatus;
    $pubd = (string)$p->PublicationDate;
	
	
	
    echo PHP_EOL;
    echo PHP_EOL . "LISTING NUMBER $n";
    echo PHP_EOL . $t;
    echo PHP_EOL . $i;
    echo PHP_EOL . "&copy;" . $y . ' ' .$c;
    echo PHP_EOL . '$' . $m;
		

    foreach ($p->ProductIdentifier as $pi)
    {
        // CAST AS STRING VARIABLES
        $ProductIDType = (string)$pi->ProductIDType;
        $IDValue       = (string)$pi->IDValue;
        
		// STORED IN THE ARRAY
 
        $pia[$ProductIDType==03] = $IDValue;	
    
    }	
	   
	// PRODUCT IDENTIFIERS - PRESENTED FROM THE ASSOCIATIVE ARRAY
    foreach ($pia as $ProductIDType => $IDValue)
    {
   	   $GTIN13 = $pia[$ProductIDType==03];
	} 
	   
	$pia1 = array();
    foreach ($p->ProductIdentifier as $pi1)
    {
        // CAST AS STRING VARIABLES
        $ProductIDType1 = (string)$pi1->ProductIDType;
        $IDValue1       = (string)$pi1->IDValue;
        
		// STORED IN THE ARRAY
 
        $pia1[$ProductIDType1] = $IDValue1;
    
    }	
	   
	// PRODUCT IDENTIFIERS - PRESENTED FROM THE ASSOCIATIVE ARRAY
    foreach ($pia1 as $ProductIDType1 => $IDValue1)
    {
	  		
		echo PHP_EOL . 'PIM: ' . $ProductIDType1 . ' ' . $IDValue1. ' ' . $GTIN13;
		
   



	 if ($ProductIDType1==02) {
               mysql_query("INSERT INTO tblIsbn10 (
			   ProductIDType, 
			   IDValue, 
			   Gtin13) 
			   
			   VALUES (
			   '$ProductIDType1', 
			   '$IDValue1', 
			   '$GTIN13') 
			   ");
			   
     }
	   
	   if ($ProductIDType1==03) {
               
			   mysql_query("INSERT INTO tblGtin13 (
			   ProductIDType, 
			   IDValue, 
			   Gtin13) 
			   
			   VALUES (
			   '$ProductIDType1', 
			   '$IDValue1', 
			   '$GTIN13') 
			   ");
			   
			    //INSERT DATA INTO PRODUCTS TABLE
			    mysql_query("INSERT INTO books (
				RecordReference, 
				NotificationType, 
				ProductIDTypeIDValue, 
				ProductFormCode, 
				NumberOfPages, 
				BASICMainSubject, 
                AudienceCode, 
				PublisherName, 
				PublishingStatus, 
				PublicationDate)

                VALUES (
		        '$rr', 
                '$nt', 
       	        '$IDValue',
                '$pf',
                '$nop', 
                '$bms',
                '$ac', 
                '$pubn', 
                '$pubs', 
                '$pubd') 
                ");    
	        } 
	 
	           if ($ProductIDType1==15) {
               mysql_query("INSERT INTO tblIsbn13 (
			   ProductIDType, 
			   IDValue, 
			   Gtin13) 
			   
			   VALUES (
			   '$ProductIDType1', 
			   '$IDValue1', 
			   '$GTIN13') 
			   ");

     }
	 
	 }
	 
       // CONTRIBUTOR  - EXTRACTED INTO AN ASSOCIATIVE ARRAY
       
        foreach ($p->Contributor as $co)
        {
           // CAST AS STRING VARIABLES
            $ContributorRole = (string)$co->ContributorRole;
            $NamesBeforeKey  = (string)$co->NamesBeforeKey;
            $KeyNames = (string)$co->KeyNames;
            $SuffixToKey = (string)$co->SuffixToKey;
			$LettersAfterNames = (string)$co->LettersAfterNames;	
     	 
	     echo PHP_EOL . 'CO: '  . ' ' . $ContributorRole . ' ' . $NamesBeforeKey. ' '. $KeyNames. ' '.   $SuffixToKey . ' '.   $LettersAfterNames . ' ' .$GTIN13; 

		 
		 $result5 = mysqli_query($con, "INSERT INTO tblContributors (
            ContributorRole,
            NamesBeforeKey,
            KeyNames,
            SuffixToKey,
			LettersAfterNames)
         SELECT *
             FROM DUAL
             WHERE ContributorRole = '$ContributorRole' and NamesBeforeKey = '$NamesBeforeKey' and KeyNames = '$KeyNames' and SuffixToKey = '$SuffixToKey' and LettersAfterNames = '$LettersAfterNames'"

		 
		 
	
		

		
	}
mysqli_close($con);
    }

		 
?>

Open in new window

0
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 35753863
It might be good to try it in MySQL first and then move to PHP code once you understand the SQL syntax without the extra markup needed to embed in PHP.

You can set variables in MySQL to respresent the values you are passing.

Is this your attempt at the INSERT INTO ... SELECT?
INSERT INTO tblContributors (
            ContributorRole,
            NamesBeforeKey,
            KeyNames,
            SuffixToKey,
			LettersAfterNames)
         SELECT *
             FROM DUAL
             WHERE ContributorRole = '$ContributorRole' and NamesBeforeKey = '$NamesBeforeKey' and KeyNames = '$KeyNames' and SuffixToKey = '$SuffixToKey' and LettersAfterNames = '$LettersAfterNames'

Open in new window


If so, I think you want:
INSERT INTO tblContributors (
            ContributorRole,
            NamesBeforeKey,
            KeyNames,
            SuffixToKey,
			LettersAfterNames)
         SELECT '$ContributorRole', '$NamesBeforeKey', '$KeyNames', '$SuffixToKey', '$LettersAfterNames'
         FROM DUAL
         WHERE NOT EXISTS (
            SELECT 1 
            FROM tblContributors 
            WHERE ContributorRole = '$ContributorRole'
            and NamesBeforeKey = '$NamesBeforeKey'
            and KeyNames = '$KeyNames'
            and SuffixToKey = '$SuffixToKey' 
           and LettersAfterNames = '$LettersAfterNames'
        )

Open in new window

0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:Honya
ID: 35760492
Concerning comment ID: 35753863, yes it was my attempt at the INSERT INTO ... SELECT, however  I was unable to import the data into the database using the script provided. Were you able to get it to work?
0
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 35762388
What is the error you are getting or please clarify what didn't work on the import when you tried with simple script above using variables for a single record.
0
 

Author Comment

by:Honya
ID: 35773123
When I try using the following script the data is parsed but nothing is imported into the database.
However I am not receiving any error messages.
You can try working with the following database.
<?php  

error_reporting(E_ALL);
echo "<pre>" . PHP_EOL;

// TEST DATA FROM THE POST AT EE
$xml = <<<EOXML
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE ONIXMessage SYSTEM "http://www.editeur.org/onix/2.1/03/reference/onix-international.dtd">
<ONIXMessage>
    <Header>
		<FromCompany>Elsevier Science and Technology</FromCompany>
		<FromPerson>Jim Darwin, 612-698-6123</FromPerson>
		<SentDate>20100219</SentDate>
		<DefaultCurrencyCode>USD</DefaultCurrencyCode>
	</Header>
	<Product>
		<RecordReference>1093123:10880222</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780123814128</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780123814128</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>DH</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>Student Solutions Manual, Partial Differential Equations &amp; Boundary Value Problems with Maple</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>George A.</NamesBeforeKey>
			<KeyNames>Articolo</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Rutgers University, New Brunswick, NJ, USA</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<BASICMainSubject>COM023000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>13</TextTypeCode>
			<Text>Dr. George A. Articolo has 35 years of teaching experience in physics and applied mathematics at Rutgers University, and has been a consultant for several government research laboratories and aerospace corporations. He has a Ph.D. in mathematical physics with degrees from Temple University and Rensselaer Polytechnic Institute.&lt;p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>5</NameCodeValue>
			<ImprintName>Academic Press</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20090801</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2009</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780123747327</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20090822</ExpectedShipDate>
			<PackQuantity>16</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>9.99</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>1057584:10579551</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781856178433</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781856178433</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>Working Guide to Drilling Equipment and Operations</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>Williams</NamesBeforeKey>
			<KeyNames>Lyons</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<IllustrationsNote>Approx. 224 illustrations</IllustrationsNote>
		<BASICMainSubject>SCI024000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>&lt;p&gt;Drilling technology has evolved in order to get at the increasingly harder to find oil, and in a more environmentally friendly way. Successful drilling operations require blending many technologies. Drilling equipment and procedures have a unique language that must be conquered in order to understand drilling operations. &lt;/p&gt;&lt;br&gt;&lt;p&gt;Working Guide to Drilling Equipment and Operations provides a fundamental, basic knowledge of the intricacies of drilling fluid, drilled solids management, drill bits, drill string design, directional drilling, cementing, casing, hydraulic optimization, and a discussion of predominant problems such as stuck pipe and lost circulation. Background information, such as: clay structure (needed to understand well bore instability and drilling fluids), discussion of pressure and pressure effects, the theory behind factors affecting drilling performance, and rock failure under pressure, are included to enhance the understanding of the drilling process and problems. &lt;/p&gt;
                                    &lt;br&gt;&lt;br&gt;&lt;ul&gt;&lt;br&gt;&lt;li&gt;Drilling and Production Hoisting Equipment&lt;/li&gt;&lt;br&gt;&lt;li&gt;Hoisting Tool Inspection and Maintenance Procedures&lt;/li&gt;&lt;br&gt;&lt;li&gt;Pump Performance Charts&lt;/li&gt;&lt;br&gt;&lt;li&gt;Rotary Table and Bushings&lt;/li&gt;&lt;br&gt;&lt;li&gt;Rig Maintenance of Drill Collars&lt;/li&gt;&lt;br&gt;&lt;li&gt;Drilling Bits and Downhole Tools&lt;/li&gt;&lt;br&gt;&lt;p&gt;&lt;/p&gt;&lt;/ul&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;p&gt;Chapter 1 Drilling Mud and Completion Systems &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 2 Drilling String: Composition and Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 3 Air and Gas Drilling &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 4 Directional Drilling &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 5 Selection of Drilling Practies &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 6 Well Pressure Control&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 7 Fishing Operations and Equipment&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 8 Casing and Casing String Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 9 Well Cementing &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 10 Tubing and Tubing String Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 11 Environmental Considerations&lt;/p&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>18</TextTypeCode>
			<Text>&lt;p&gt;Drilling technology has evolved in order to get at the increasingly harder to find oil, and in a more environmentally friendly way. Successful drilling operations require blending many technologies. Drilling equipment and procedures have a unique language that must be conquered in order to understand drilling operations. &lt;/p&gt;&lt;br&gt;&lt;p&gt;&lt;/p&gt;&lt;br&gt;&lt;p&gt;Working Guide to Drilling Equipment and Operations provides a fundamental, basic knowledge of the intricacies of drilling fluid, drilled solids management, drill bits, drill string design, directional drilling, cementing, casing, hydraulic optimization, and a discussion of predominant problems such as stuck pipe and lost circulation. Background information, such as: clay structure (needed to understand well bore instability and drilling fluids), discussion of pressure and pressure effects, the theory behind factors affecting drilling performance, and rock failure under pressure, are included to enhance the understanding of the drilling process and problems. &lt;/p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>71</NameCodeValue>
			<ImprintName>Gulf Professional Publishing</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20091001</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2010</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<Measure>
			<MeasureTypeCode>01</MeasureTypeCode>
			<Measurement>9</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<Measure>
			<MeasureTypeCode>02</MeasureTypeCode>
			<Measurement>6</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9781856178440</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20091022</ExpectedShipDate>
			<PackQuantity>18</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>99.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100780:100789</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1928994563</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781928994565</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781928994565</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Series>
			<TitleOfSeries>.NET Developers Series</TitleOfSeries>
		</Series>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>.NET Mobile Web Developers Guide</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<KeyNames>Syngress</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>520</NumberOfPages>
		<BASICMainSubject>COM051000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>Introducing Microsoft's flagship wireless development tool&lt;br&gt;The .NET Mobile Web Developer's Guide will provide readers with a solid guide to developing mobile applications using Microsoft technologies. The focus of this book is on using ASP.NET and the .NET mobile SDK. It provides an introduction to the .NET platform and goes into moderate details on ASP.NET to allow readers to start developing ASP.NET applications. In addition, this book will give the readers the insight to use the various Microsoft technologies for developing mobile applications.&lt;br&gt;This book assumes the readers have experience in developing web applications and are familiar with any one of the server-side technologies like ASP, JSP or PHP.
                                    &lt;br&gt;&lt;br&gt;The first book available on Microsoft's cornerstone wireless development tool&lt;br&gt;Best selling, high profile authors. Wei Meng Lee and Shelley Powers are frequent speakers at all of the major developer conferences have previously authored best selling books for O'Reilly &amp; Associates, Wrox Press, SAMS and Que&lt;br&gt;Comes with wallet-sized CD containing a printable HTML version of the book, all of the source code examples and demos of popular ASP .NET and .NET Mobile programming tools&lt;br&gt;Comprehensive Coverage of the .NET Mobile SDK and ASP.NET for Mobile Web developers</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20020302</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080481838</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>32</ProductAvailability>
			<ExpectedShipDate>20020323</ExpectedShipDate>
			<PackQuantity>12</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>51.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>112530:112619</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1856174670</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781856174671</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781856174671</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BB</ProductForm>
		<Series>
			<TitleOfSeries>World Pumps</TitleOfSeries>
		</Series>
		<Set>
			<TitleOfSet>Forsthoffer's Rotating Equipment Handbooks</TitleOfSet>
		</Set>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>1. Forsthoffer's Rotating Equipment Handbooks</TitleText>
			<Subtitle>Fundamentals of Rotating Equipment</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>William E</NamesBeforeKey>
			<KeyNames>Forsthoffer</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>President, Forsthoffer Associates Inc., Washington Crossing, PA USA</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>512</NumberOfPages>
		<BASICMainSubject>TEC009070</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>'Fundamentals of Rotating Equipment' is an overview of the main types of rotating machinery in industry, and covers such aspects as system dynamics, surge control, vibration and balancing, radial bearing design, performance parameters, rotor system design and operation, rotor axial (thrust) forces, performance objectives and mechanical restraints, auxiliary systems and seals.&lt;br&gt;&lt;br&gt;This book will enhance rotating equipment reliability and safety throughout the many industries where such equipment is vital to a successful business.&lt;br&gt;&lt;br&gt;Over recent years there have been substantial changes in those industries  which are concerned with the design, purchase and use of special purpose (ie critical, high-revenue) rotating equipment. Key personnel have been the victims of early retirement or have moved to other industries: contractors and end-users have reduced their technical staff and consequently have to learn complex material from scratch. &lt;br&gt;&lt;br&gt;As a result, many companies are finding that they are devoting unnecessary man hours to the discovery and explanation of basic principles, and having to explain these to clients who should already be aware of them. In addition, the lack of understanding by contractors and users of equipment characteristics and operating systems often results in a wrong fit and a costly reliability problem. &lt;br&gt;&lt;br&gt;The stakes can be high, and it against this background that this book has been published. It is the outcome of many years experience and is based on well-honed teaching material which is easily readable, understandable and actually enjoyable!&lt;br&gt;&lt;br&gt;This is a five volume set. The volumes are: &lt;br&gt;1. Fundamentals of Rotating Equipment &lt;br&gt;2. Pumps &lt;br&gt;3. Compressors &lt;br&gt;4. Auxiliary Systems&lt;br&gt;5. Reliability Optimization thru Component Condition Monitoring and Root Cause Analysis
                                    &lt;br&gt;&lt;br&gt;* A distillation of many years of on-site training by a well-known US Engineer who also operates in the Middle East.&lt;br&gt;* A Practical book written in a succinct style and well illustrated throughout.&lt;br&gt;* An overview of the main types of rotating machinery in industry.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>Rotating equipment overview; compressor characteristics; operation of a compressor in a system; pump types and applications; pump performance data; centrifugal pump hydraulic disturbances; pump mechanical design; mechanical seals; compressor types and applications; the concept of fluid head; performance relationships; surge (stall) and stonewall; the effect of a gas density change; turbo-compressor mechanical design overview; radial bearing design; rotar axial (thrust) forces; compressor seal system overview and types; reciprocating compressors major component functions; flexible coupling design, installation and operation; steam turbine function and types; steam turbine performance; steam turbine mechanical design overview; steam turbine inlet steam regulation; steam turbine control/ protection systems; steam turbine operation; gas turbine types and applications; gas turbine performance; gas turbine mechanical design; gas turbine support systems; gas turbine control and protection; lubrication system overview and types; monitoring reliability and component condition; conversions to metric system; index</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>68</NameCodeValue>
			<ImprintName>Elsevier Science</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20060123</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2005</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<Measure>
			<MeasureTypeCode>01</MeasureTypeCode>
			<Measurement>9.21</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<Measure>
			<MeasureTypeCode>02</MeasureTypeCode>
			<Measurement>6.125</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<RelatedProduct>
			<RelationCode>02</RelationCode>
			<ProductIdentifier>
				<ProductIDType>02</ProductIDType>
				<IDValue>1856174727</IDValue>
			</ProductIdentifier>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9781856174725</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080949321</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>32</ProductAvailability>
			<ExpectedShipDate>20060213</ExpectedShipDate>
			<PackQuantity>12</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>161</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100741:100747</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1931836590</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781931836593</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781931836593</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10 Cool Lego Mindstorm Dark Side Robots Transports and Creatures</TitleText>
			<Subtitle>Amazing Projects You Can Build in Under an Hour</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<KeyNames>Syngress</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>176</NumberOfPages>
		<BASICMainSubject>TEC037000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>LEGO MINDSTORMS let you design and program robots that can do just about anything!&lt;br&gt;The Dark Side Developer's Kit is targeted towards the young or novice LEGO MINDSTORMS designer, age 9 and up, although experienced MINDSTORMS fans will appreciate the unique possibilities offered by this kit as well. The Dark Side Developer's Kit includes special MINDSTORMS pieces that allow the user to create a host of Star Wars themed robots, creatures, and vehicles. It also comes with the Micro Scout, a mini-computer with 7 built-in programs, a motor, and a light sensor that brings the MINDSTORMS creations to life with a minimum of effort.&lt;br&gt;&lt;br&gt;10 Cool LEGO MINDSTORMS Dark Side Robots, Transports, and Creatures: Amazing Projects You Can Build in Under an Hour provides step-by-step instructions and detailed illustrations for users of all skill levels and proficiencies.
                                    &lt;br&gt;&lt;br&gt;A blend of the hugely popular LEGO and STAR WARS lines. Appealing to fans of both, this book will allow readers to build unique creations using the special parts found in the "LEGO MINDSTORMS: Dark Side Developer's Kit" that mimic the robots, vehicles and creatures found in the STAR WARS movies. &lt;br&gt;From out of the box to up and running in less than an hour. This book teaches users how to create 10 amazing projects, each in under an hour.&lt;br&gt;8-page color insert. An eight-page color insert illustrates the complete projects in full-detail.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>Chapter 1: Sith Stealth Infiltrator&lt;br&gt;Chapter 2: Imperial Devastator&lt;br&gt;Chapter 3: Bounty Hunter Droid&lt;br&gt;Chapter 4: Imperial AT-ST&lt;br&gt;Chapter 5: Dark Side Reconnaissance Droid&lt;br&gt;Chapter 6: Dark Side Battle-Trainer&lt;br&gt;Chapter 7: Trade Federation Land Transport&lt;br&gt;Chapter 8: Sith Scout Ship&lt;br&gt;Chapter 9: Imperial TIE Interceptor&lt;br&gt;Chapter 10: Trade Federation Security Droid</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>06</PublishingStatus>
		<PublicationDate>20020913</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080546292</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>OI</AvailabilityCode>
			<ProductAvailability>40</ProductAvailability>
			<ExpectedShipDate>20021004</ExpectedShipDate>
			<PackQuantity>34</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>25.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100811:100824</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1931836612</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781931836616</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781931836616</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10 Cool Lego Mindstorm Robotics Invention System 2 Projects</TitleText>
			<Subtitle>Amazing Projects You Can Build in Under an Hour</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<KeyNames>Syngress</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>176</NumberOfPages>
		<BASICMainSubject>TEC037000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>LEGO MINDSTORMS lets you design and program robots that can do just about anything!&lt;br&gt;The LEGO MINDSTORMS RIS 2.0 is the core set for all MINDSTORMS users, that lets users design and program working robots - limited only by their imagination. Initially designed for users 12 and up, LEGO MINDSTORMS has taken off with LEGO enthusiasts of all ages.  &lt;br&gt;10 Cool LEGO MINDSTORMS RIS 2.0 Projects: Amazing Projects You Can Build in Under an Hour provides step-by-step instructions and detailed illustrations for users of all skill levels and proficiencies.
                                    &lt;br&gt;&lt;br&gt;From out of the box to up and running in less than an hour. &lt;br&gt;8-page color insert. A color insert illustrates the complete projects in full-detail.&lt;br&gt;Specifically targeted at new users of the LEGO MINDSTORMS RIS 2.0.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>Chapter 1: There's a Mouse in House&lt;br&gt;Chapter 2: How to Build a Better Mouse Trap&lt;br&gt;Chapter 3: Trains...&lt;br&gt;Chapter 4:  Planes...&lt;br&gt;Chapter 5: And Automobiles...&lt;br&gt;Chapter 6: BattleTank with Treads and Turrets&lt;br&gt;Chapter 7: Chore-Doer 3000&lt;br&gt;Chapter 8: Arachnoid-what?  Building a Spider&lt;br&gt;Chapter 9: Making the Band: Building a Drummer&lt;br&gt;Chapter 10: Just Desserts: Building a Gumball Machine</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20021129</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080546308</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20021220</ExpectedShipDate>
			<PackQuantity>22</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>25.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100742:100748</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1931836604</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781931836609</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781931836609</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10 Cool Lego Mindstorm Ultimate Builders Projects</TitleText>
			<Subtitle>Amazing Projects You Can Build in Under an Hour</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>Mario</NamesBeforeKey>
			<KeyNames>Ferrari</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Author of bestselling "Building Robots with LEGO Mindstorms", Italy</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>176</NumberOfPages>
		<BASICMainSubject>TEC037000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>LEGO MINDSTORMS lets you design and program robots that can do just about anything!&lt;br&gt;You've just purchased the LEGO MINDSTORMS Ultimate Builder Kit. Now what? Overwhelmed by the creative possibilities? The Builder Kit is targeted towards those who want to become "master LEGO builders." &lt;br&gt;&lt;br&gt;10 Cool LEGO MINDSTORM Ultimate Builder Projects: Amazing Projects You Can Build in Under an Hour provides step-by-step instructions and detailed illustrations for users of all skill levels and proficiencies. This MINDSTORMS kit features many rare parts, a spare motor, a turntable, special gears, transparent beams, and even a pneumatics system-parts that can be confusing and that will be new to many LEGO builders. 10 Cool LEGO MINDSTORM Ultimate Builder Projects teaches readers how to incorporate these new features into their creations as they build 10 unique robots.
                                    &lt;br&gt;&lt;br&gt;From out of the box to up and running in less than an hour. This book teaches users how to create 10 amazing projects in under an hour.&lt;br&gt;8-page color insert. An eight-page color insert will illustrates the complete projects in full-detail.&lt;br&gt;Specifically targeted to both new users of the LEGO MINDSTORMS and experienced MINDSTORMS fans.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>13</TextTypeCode>
			<Text>Mario Ferrari received his first Lego box around 1964, when he was 4. Lego was his favorite toy for many years, until he thought he was too old to play with it. In 1998, the Lego Mindstorms RIS set gave him reason to again have Lego become his main addiction. Mario believes Lego is the closest thing to the perfect toy. He is Managing Director at EDIS, a leader in finishing and packaging solutions and promotional packaging. The advent of the MINDSTORMS product line represented for him the perfect opportunity to combine his interest in IT and robotics with his passion for LEGO bricks, which started during his early childhood. Mario has been a very active member of the online MINDSTORMS community from the beginning and has pushed LEGO robotics to its limits. Mario holds a bachelor's degree in Business Administration from the University of Turin and has always nourished a strong interest for physics, mathematics, and computer science. He is fluent in many programming languages and his background includes positions as an IT manager and as a project supervisor. Mario estimates he owns over 60,000 Lego pieces. Mario works in Modena, Italy, where he lives with his wife Anna and his children Sebastiano and Camilla.&lt;p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20021214</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080555157</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20030104</ExpectedShipDate>
			<PackQuantity>18</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>25.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>120947:127931</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>0444504761</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780444504760</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780444504760</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BB</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10&lt;SUP&gt;th&lt;/SUP&gt; European Conference on Mixing</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>H.E.A.</NamesBeforeKey>
			<KeyNames>van den Akker</KeyNames>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>J.J.</NamesBeforeKey>
			<KeyNames>Derksen</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Kramers Laboratorium voor Fysische Technologie, Delft University of Technology, Delft, The Netherlands</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>572</NumberOfPages>
		<BASICMainSubject>TEC009010</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>Traditionally, fluid mixing and the related multiphase contacting processes have always been regarded as an empirical technology. Many aspects of mixing, dispersing and contacting were related to power draw, but understanding of the phenomena was limited or qualitative at the most.&lt;br&gt;&lt;br&gt;In particular during the last decade, however, plant operation targets have tightened and product specifications have become stricter. The public awareness as to safety and environmental hygiene has increased. The drive towards larger degrees of sustainability in the process industries has urged for lower amounts of solvents and for higher yields and higher selectivities in chemical reactors. All this has resulted in a &lt;i&gt;market pull&lt;/i&gt;: the need for more detailed insights in flow phenomena and processes and for better verifiable design and operation methods.&lt;br&gt;&lt;br&gt;Developments in miniaturisation of sensors and circuits as well as in computer technology have rendered leaps possible in computer simulation and animation and in measuring and monitoring techniques. &lt;br&gt;&lt;br&gt;This volume encourages a leap forward in the field of mixing by the current, overwhelming wealth of sophisticated measuring and computational techniques. This leap may be made possible by modern instrumentation, signal and data analysis, field reconstruction algorithms, computational modelling techniques and numerical recipes. &lt;br&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;b&gt;Section headings:&lt;/b&gt; &lt;b&gt;Turbulence Characteristics in Stirred Tanks.&lt;/b&gt; (3 papers). &lt;b&gt;Measurements in Chemically Reacting Flows.&lt;/b&gt; (3 papers). &lt;b&gt;Modelling of Micro-Mixing.&lt;/b&gt; (6 papers). &lt;b&gt;Effects of Viscosity and Rheology on Mixing.&lt;/b&gt; (3 papers). &lt;b&gt;Slurry Systems.&lt;/b&gt; (2 papers). &lt;b&gt;Liquid-Liquid Dispersions.&lt;/b&gt; (6 papers). &lt;b&gt;Gas-Liquid Systems.&lt;/b&gt; (4 papers). &lt;b&gt;Particle Collisions in Crystallisation.&lt;/b&gt; (2 papers). &lt;b&gt;Advanced CFD.&lt;/b&gt; (3 papers). &lt;b&gt;Posters.&lt;/b&gt; (33 papers).&lt;br&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>68</NameCodeValue>
			<ImprintName>Elsevier Science</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>06</PublishingStatus>
		<PublicationDate>20000614</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2000</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080525792</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>OI</AvailabilityCode>
			<ProductAvailability>40</ProductAvailability>
			<ExpectedShipDate>20000705</ExpectedShipDate>
			<PackQuantity>16</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>340</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>1095034:10895161</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780240814254</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780240814254</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>100% Photoshop</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>Steve</NamesBeforeKey>
			<KeyNames>Caplin</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Graphic artist/illustrator, contributing editor for MacUser magazine and the best-selling author of How to Cheat in Photoshop</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>256</NumberOfPages>
		<BASICMainSubject>COM012000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>&lt;p&gt;Just when you think you have learned all that you could ever know about working in Photoshop, digital artist and photomontage king Steve Caplin comes along with yet another masterful method for creating incredible works of art in Photoshop. This time, he will show you how to create complete images, from start to finish, &lt;U&gt;entirely&lt;/U&gt; within the software program. No source material, photographs, or existing files from other software packages are needed, saving you valuable time and resources. The techniques you will learn in this ground-breaking new book will help you combine your artistic vision and skills with an understanding of how to manipulate the built-in Photoshop filters to produce impressive, eye-catching artwork.&lt;/p&gt;&lt;br&gt;&lt;p&gt;Each chapter opens with a complete double page illustration, created entirely in Photoshop. Then, carefully laid out step-by-step instructions show you how each element in the illustration is created, and how they are all combined in the end to make a convincing final image. Using Steve&apos;s proven methods for success, you will be able to produce images that reflect a more finely crafted, hand drawn approach, whether you are an artist for your own enjoyment or a working professional looking for a leg up on the competition. &lt;/p&gt;
                                    &lt;br&gt;&lt;br&gt;&lt;p&gt;*The only book of its kind that does not rely on any external images whatsoever -- each and every element is created directly in Photoshop &lt;/p&gt;&lt;br&gt;&lt;p&gt;*A chapter covering the basics of using specific filters and textures and a chapter providing a summary of common techniques and tools will help you brush up on your general Photoshop skills so you can move through the rest of the book successfully &lt;/p&gt;&lt;br&gt;&lt;p&gt;*Visit the book website at [url to come] for supplemental material to help you get started &lt;/p&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;p&gt;Chapter 1: Textures: Using Clouds, Noise, Blur, Fibers to create basic texture; Texture creation: paper, wood, stone, and metal; Chapter 2: Setting the Scene: Hallway -- door, light, glass, gold text, shadows, metal handle, layer masks; Chapter 3: The Great Outdoors: trees, grass, leaves (custom brush design), water and reflections, clouds, sky, mountains; Chapter 4: In the Attic:LPs, cardboard boxes, guitar, cork boards, beams, brick walls, assorted items; Chapter 5: To Boldly Go: Space scene with stars, planets, aurora, spaceship, alien; Chapter 6: Treasured Possessions: Desk drawer with jewelry, letters, sealing wax, pens, magnifying glass, pencils, rubber stamp, folder with coffee stains; Chapter 7: In the Lab: Mad scientist&apos;s laboratory with Bunsen burner, lab bottles, stone wall, lightning through window; Chapter 8: The Operation:&amp;nbsp;Operating theatre scene with close-up of opened body featuring internal organs, bone, skin texture, scalpels and clamps; Chapter 9: Fantasy Scene: Organic-looking synthetic scene with intertwining tentacles, texture generated background, H R Giger-style anatomical elements;&amp;nbsp;Chapter 10: Photoshop Reference: Quick start guide &lt;/p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>70</NameCodeValue>
			<ImprintName>Focal Press</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>02</PublishingStatus>
		<PublicationDate>20100601</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2010</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780240814261</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>NP</AvailabilityCode>
			<ProductAvailability>10</ProductAvailability>
			<ExpectedShipDate>20100622</ExpectedShipDate>
			<PackQuantity>24</PackQuantity>
			<Price>
				<PriceTypeCode>21</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>39.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>1092624:10872821</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780444534729</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780444534729</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BB</ProductForm>
		<Series>
			<TitleOfSeries>Computer Aided Chemical Engineering</TitleOfSeries>
			<NumberWithinSeries>27</NumberWithinSeries>
		</Series>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10th International Symposium on Process Systems Engineering - PSE2009</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Rita Maria</NamesBeforeKey>
			<KeyNames>de Brito Alves</KeyNames>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Claudio Augusto</NamesBeforeKey>
			<KeyNames>Oller do Nascimento</KeyNames>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Evaristo Chalbaud</NamesBeforeKey>
			<KeyNames>Biscaia</KeyNames>
			<SuffixToKey>Jr.</SuffixToKey>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<BASICMainSubject>SCI013000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>&lt;p&gt;This book contains the proceedings of the10th edition of a series of international symposia on Process Systems Engineering (PSE)&amp;nbsp;initiated in 1982. The special focus of PSE09 is how PSE methods can support sustainable resource systems and emerging technologies in the areas of green engineering.&lt;/p&gt;
                                    &lt;br&gt;&lt;br&gt;&lt;p&gt;* Contains fully searchable CD of all printed contributions&lt;/p&gt;&lt;br&gt;&lt;p&gt;* Focus on sustainable green engineering&lt;/p&gt;&lt;br&gt;&lt;p&gt;* 9 Plenary papers, 21 Keynote lectures by leading experts in the field&lt;/p&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;p&gt;&lt;b&gt;Part A&lt;/b&gt;&lt;/p&gt;&lt;br&gt;&lt;p&gt;Plenary lectures&lt;/p&gt;&lt;br&gt;&lt;p&gt;Keynote lectures&lt;/p&gt;&lt;br&gt;&lt;p&gt;Modelling, Supporting Methods and Tools&lt;/p&gt;&lt;br&gt;&lt;p&gt;Product and Process Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;&lt;b&gt;Part B&lt;/b&gt;&lt;/p&gt;&lt;br&gt;&lt;p&gt;Operations and Control&lt;/p&gt;&lt;br&gt;&lt;p&gt;Non-traditional Applications of Process Systems Engineering&lt;/p&gt;&lt;br&gt;&lt;p&gt;Business Decision Support&lt;/p&gt;&lt;br&gt;&lt;p&gt;Education in Process Systems Engineering&lt;/p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>109</NameCodeValue>
			<ImprintName>Elsevier</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20090903</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2009</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>01</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080963273</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780444534736</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>32</ProductAvailability>
			<ExpectedShipDate>20090924</ExpectedShipDate>
			<PackQuantity>1</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>575</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
</ONIXMessage>	
EOXML;

// LOAD IT INTO AN OBJECT
$obj = SimpleXML_Load_String($xml);

// ACTIVATE THIS TO VISUALIZE THE OBJECT
// var_dump($obj);

// SHOW HOW TO GET SOME OF THE INFORMATION OUT OF THE OBJECT
$h = (string)$obj->Header->FromCompany;
$h1 = (string)$obj->Header->FromPerson;
$h2 = (string)$obj->Header->SentDate;
$h3 = (string)$obj->Header->DefaultCurrencyCode;

echo PHP_EOL . $h;
echo PHP_EOL . $h1;
echo PHP_EOL . $h2;
echo PHP_EOL . $h3;

// SHOW HOW TO GET COUNTS OF DATA FIELDS
$k = count($obj->Product);
echo PHP_EOL . "$k PRODUCT LISTINGS";

// SHOW HOW TO ITERATE OVER THE ARRAY OF "Product" AND GET SOME DATA FIELDS
$n = 0;
foreach ($obj->Product as $p)
{

$con = mysqli_connect("localhost", "books", "password", "books");
/* check connection */
if (mysqli_connect_errno()) {
   printf("Connect failed: %s\n", mysqli_connect_error());
   exit();
}

    $n++;
    $t = (string)$p->Title->TitleText;
    $i = (string)$p->Imprint->ImprintName;
    $y = (string)$p->CopyrightStatement->CopyrightYear;
    $c = (string)$p->CopyrightStatement->CopyrightOwner->CopyrightOwnerIdentifier->IDValue;
    $m = (string)$p->SupplyDetail->Price->PriceAmount;
	
	$rr = (string)$p->RecordReference;
    $nt = (string)$p->NotificationType;
    $pf = (string)$p->ProductForm;
    $nop = (string)$p->NumberOfPages;
    $bms = (string)$p->BASICMainSubject;
   	$ac = (string)$p->AudienceCode;
    $pubn = (string)$p->PublisherName;
    $pubs = (string)$p->PublishingStatus;
    $pubd = (string)$p->PublicationDate;
	
	
	
    echo PHP_EOL;
    echo PHP_EOL . "LISTING NUMBER $n";
    echo PHP_EOL . $t;
    echo PHP_EOL . $i;
    echo PHP_EOL . "&copy;" . $y . ' ' .$c;
    echo PHP_EOL . '$' . $m;
		

    foreach ($p->ProductIdentifier as $pi)
    {
        // CAST AS STRING VARIABLES
        $ProductIDType = (string)$pi->ProductIDType;
        $IDValue       = (string)$pi->IDValue;
        
		// STORED IN THE ARRAY
 
        $pia[$ProductIDType==03] = $IDValue;	
    
    }	
	   
	// PRODUCT IDENTIFIERS - PRESENTED FROM THE ASSOCIATIVE ARRAY
    foreach ($pia as $ProductIDType => $IDValue)
    {
   	   $GTIN13 = $pia[$ProductIDType==03];
	} 
	   
	$pia1 = array();
    foreach ($p->ProductIdentifier as $pi1)
    {
        // CAST AS STRING VARIABLES
        $ProductIDType1 = (string)$pi1->ProductIDType;
        $IDValue1       = (string)$pi1->IDValue;
        
		// STORED IN THE ARRAY
 
        $pia1[$ProductIDType1] = $IDValue1;
    
    }	
	   
	// PRODUCT IDENTIFIERS - PRESENTED FROM THE ASSOCIATIVE ARRAY
    foreach ($pia1 as $ProductIDType1 => $IDValue1)
    {
	  		
		echo PHP_EOL . 'PIM: ' . $ProductIDType1 . ' ' . $IDValue1. ' ' . $GTIN13;
		
   



	 if ($ProductIDType1==02) {
               mysql_query("INSERT INTO tblIsbn10 (
			   ProductIDType, 
			   IDValue, 
			   Gtin13) 
			   
			   VALUES (
			   '$ProductIDType1', 
			   '$IDValue1', 
			   '$GTIN13') 
			   ");
			   
     }
	   
	   if ($ProductIDType1==03) {
               
			   mysql_query("INSERT INTO tblGtin13 (
			   ProductIDType, 
			   IDValue, 
			   Gtin13) 
			   
			   VALUES (
			   '$ProductIDType1', 
			   '$IDValue1', 
			   '$GTIN13') 
			   ");
			   
			    //INSERT DATA INTO PRODUCTS TABLE
			    mysql_query("INSERT INTO books (
				RecordReference, 
				NotificationType, 
				ProductIDTypeIDValue, 
				ProductFormCode, 
				NumberOfPages, 
				BASICMainSubject, 
                AudienceCode, 
				PublisherName, 
				PublishingStatus, 
				PublicationDate)

                VALUES (
		        '$rr', 
                '$nt', 
       	        '$IDValue',
                '$pf',
                '$nop', 
                '$bms',
                '$ac', 
                '$pubn', 
                '$pubs', 
                '$pubd') 
                ");    
	        } 
	 
	           if ($ProductIDType1==15) {
               mysql_query("INSERT INTO tblIsbn13 (
			   ProductIDType, 
			   IDValue, 
			   Gtin13) 
			   
			   VALUES (
			   '$ProductIDType1', 
			   '$IDValue1', 
			   '$GTIN13') 
			   ");

     }
	 
	 }
	 
       // CONTRIBUTOR  - EXTRACTED INTO AN ASSOCIATIVE ARRAY
       
        foreach ($p->Contributor as $co)
        {
           // CAST AS STRING VARIABLES
            $ContributorRole = (string)$co->ContributorRole;
            $NamesBeforeKey  = (string)$co->NamesBeforeKey;
            $KeyNames = (string)$co->KeyNames;
            $SuffixToKey = (string)$co->SuffixToKey;
			$LettersAfterNames = (string)$co->LettersAfterNames;	
			
			
		 
		 
		 $result5 = mysqli_query($con, "INSERT INTO tblContributors (
            ContributorRole,
            NamesBeforeKey,
            KeyNames,
            SuffixToKey,
			LettersAfterNames)
         SELECT '$ContributorRole', '$NamesBeforeKey', '$KeyNames', '$SuffixToKey', '$LettersAfterNames'
         FROM DUAL
         WHERE NOT EXISTS (
            SELECT 1 
            FROM tblContributors 
            WHERE ContributorRole = '$ContributorRole',
            and NamesBeforeKey = '$NamesBeforeKey',
            and KeyNames = '$KeyNames',
            and SuffixToKey = '$SuffixToKey', 
           and LettersAfterNames = '$LettersAfterNames'
        )
		  ");
		  

		
		
		
			}
mysqli_close($con);
    }

		 
?>

Open in new window

0
 

Author Comment

by:Honya
ID: 35773137
For database please see first code entry in question
0
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 35773688
Here is an example of how the insert with not exists clause would look in MySQL.  The code inside derived table x is XML parsing code I used to parse out the details of a trimmed down version of your XML.  The bigger XML is a little more complicated to parse due to multiple Contributors under one Product; however, since you are parsing that on the PHP side and only passing individual values as if you have one row of data this should work just fine.

set @xml = '<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE ONIXMessage SYSTEM "http://www.editeur.org/onix/2.1/03/reference/onix-international.dtd">
<ONIXMessage>
    <Header>
		<FromCompany>Elsevier Science and Technology</FromCompany>
		<FromPerson>Jim Darwin, 612-698-6123</FromPerson>
		<SentDate>20100219</SentDate>
		<DefaultCurrencyCode>USD</DefaultCurrencyCode>
	</Header>
	<Product>
		<RecordReference>1093123:10880222</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780123814128</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780123814128</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>DH</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>Student Solutions Manual, Partial Differential Equations &amp; Boundary Value Problems with Maple</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>George A.</NamesBeforeKey>
			<KeyNames>Articolo</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Rutgers University, New Brunswick, NJ, USA</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Rita Maria</NamesBeforeKey>
			<KeyNames>de Brito Alves</KeyNames>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Claudio Augusto</NamesBeforeKey>
			<KeyNames>Oller do Nascimento</KeyNames>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Evaristo Chalbaud</NamesBeforeKey>
			<KeyNames>Biscaia</KeyNames>
			<SuffixToKey>Jr.</SuffixToKey>
		</Contributor>
	</Product>
</ONIXMessage>';

insert into tblContributors(
   ContributorRole,
   NamesBeforeKey,
   KeyNames,
   SuffixToKey,
   LettersAfterNames
)
select ContributorRole, NamesBeforeKey, KeyNames, SuffixToKey, LettersAfterNames
from (
   select extractvalue(@xml, '//Contributor[$@rownum]/ContributorRole') as ContributorRole
        , extractvalue(@xml, '//Contributor[$@rownum]/NamesBeforeKey') as NamesBeforeKey
        , extractvalue(@xml, '//Contributor[$@rownum]/KeyNames') as KeyNames
        , extractvalue(@xml, '//Contributor[$@rownum]/SuffixToKey') as SuffixToKey
        , extractvalue(@xml, '//Contributor[$@rownum]/LettersAfterNames') as LettersAfterNames
   from util.numbers
   where n between 1 and extractvalue(@xml, 'count(//Contributor)')
   and @rownum:=n
) x
where not exists (
   select 1
   from tblContributors c
   where c.ContributorRole = x.ContributorRole
   and NamesBeforeKey = x.NamesBeforeKey
   and KeyNames = x.KeyNames
   and SuffixToKey = x.SuffixToKey
   and LettersAfterNames = x.LettersAfterNames
)
;

Open in new window


If that works for you, then what we need to check is that the variables you are using in PHP to store each element of the XML for a given Contributor actual has values.

Additionally, we need to validate that the query string being generated is what we want.  Therefore, I would echo the contents of the variables to page so you can debug what is going on.

Looking at your posts above again, it looks like you were doing that at one point -- what was the results?
0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 35860234
Trying to avoid indexing the columns, I will like to insert data into the table only when a similar record does not exist.

That is kind of a vague oxymoron.  Data fields are either identical or different.  When you get to the notion of "similar" you need to define the terms that identify similarity and that's not part of this conversation yet.  So let's assume that instead of "similar" you mean "duplicate."  Here is what I would do.  Index the columns with UNIQUE and start inserting the data.  When you hit a duplicate you will find that MySQL_Query() returns FALSE and throws error number 1062.  You can test for this in mysql_errno() and ignore it.
0
 

Author Comment

by:Honya
ID: 35862380
Concerning Comment ID 35860234.  Thank you very much for responding.
And you are correct, I am trying to prevent inserting duplicate records into the database table and not similar ones.

However, let me try to explain the problem I am having. There are other tables in the database where I am trying to perform a similar function , I am using mysql 5.0 however, in those tables, the some of the fields are bolb and text data types. When I  try indexing those columns with UNIQUE I keep getting an error message stating that the key is too large.

I believe that using a conditional insert statement should work, but I am getting trouble figuring out the syntax.

Using the data provided could you suggest an appropriate solution.

Best wishes
0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 35862519
Sure.  This is not 100% certain but it is pretty likely to work.  Add a column to the table that has the blob or text.  Make it varchar(32).  Take the md5() value from the blob or text string and store it in this column.  Then when you insert new data into the table, insert not only the data you want, but also the md5() value from the data.  Duplicate strings will create duplicate md5() values.
0
 

Author Comment

by:Honya
ID: 35928347
Is there another way of performing the required task without creating an additional column
0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 35930404
...without creating an additional column?

What possible reason could there be to avoid creating an additional column?  A gigabyte of storage costs less than a roll of toilet paper.  I'm sure you could find a way to avoid creating an additional column, but the solution you would build would be slower and more costly.  

An attempt to insert a duplicate into a a column marked UNIQUE with cause MySQL to throw error 1062.  You can trap this error.  An attempt to index a blob or text column has, as you have noticed, some risks and issues.  But MySQL is certain to be able to index a 32-byte mdr() string, and the risk of md5() string collisions is very, very small, somewhat less than the risk that you will come face-to-face with a person who has your identical DNA makeup.  The nature of UNIQUE columns makes the conditional INSERT statement work very well.  I have considered (but never tested) the idea of using REPLACE INTO in your situation.  I believe that better performance will come from using the md5() column and marking it UNIQUE.

Use ALTER TABLE to add the UNIQUE column, or just do it with phpMyAdmin.  Run a one-time script to SELECT the existing blobs or strings and make the md5() strings.  UPDATE each row to save the md5() strings in the UNIQUE column.  Then change your INSERT query.  Easy!
http://us2.php.net/manual/en/function.md5.php
0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 35930406
Sorry - typo alert.  mdr() should be read as md5()
0
 

Accepted Solution

by:
Honya earned 0 total points
ID: 36035528
The following is the solution I was searching for.
<?php  

error_reporting(E_ALL);
echo "<pre>" . PHP_EOL;

// TEST DATA FROM THE POST AT EE
$xml = <<<EOXML
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE ONIXMessage SYSTEM "http://www.editeur.org/onix/2.1/03/reference/onix-international.dtd">
<ONIXMessage>
    <Header>
		<FromCompany>Elsevier Science and Technology</FromCompany>
		<FromPerson>Jim Darwin, 612-698-6123</FromPerson>
		<SentDate>20100219</SentDate>
		<DefaultCurrencyCode>USD</DefaultCurrencyCode>
	</Header>
	<Product>
		<RecordReference>1093123:10880222</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780123814128</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780123814128</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>DH</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>Student Solutions Manual, Partial Differential Equations &amp; Boundary Value Problems with Maple</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>George A.</NamesBeforeKey>
			<KeyNames>Articolo</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Rutgers University, New Brunswick, NJ, USA</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<BASICMainSubject>COM023000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>13</TextTypeCode>
			<Text>Dr. George A. Articolo has 35 years of teaching experience in physics and applied mathematics at Rutgers University, and has been a consultant for several government research laboratories and aerospace corporations. He has a Ph.D. in mathematical physics with degrees from Temple University and Rensselaer Polytechnic Institute.&lt;p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>5</NameCodeValue>
			<ImprintName>Academic Press</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20090801</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2009</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780123747327</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20090822</ExpectedShipDate>
			<PackQuantity>16</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>9.99</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>1057584:10579551</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781856178433</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781856178433</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>Working Guide to Drilling Equipment and Operations</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>Williams</NamesBeforeKey>
			<KeyNames>Lyons</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<IllustrationsNote>Approx. 224 illustrations</IllustrationsNote>
		<BASICMainSubject>SCI024000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>&lt;p&gt;Drilling technology has evolved in order to get at the increasingly harder to find oil, and in a more environmentally friendly way. Successful drilling operations require blending many technologies. Drilling equipment and procedures have a unique language that must be conquered in order to understand drilling operations. &lt;/p&gt;&lt;br&gt;&lt;p&gt;Working Guide to Drilling Equipment and Operations provides a fundamental, basic knowledge of the intricacies of drilling fluid, drilled solids management, drill bits, drill string design, directional drilling, cementing, casing, hydraulic optimization, and a discussion of predominant problems such as stuck pipe and lost circulation. Background information, such as: clay structure (needed to understand well bore instability and drilling fluids), discussion of pressure and pressure effects, the theory behind factors affecting drilling performance, and rock failure under pressure, are included to enhance the understanding of the drilling process and problems. &lt;/p&gt;
                                    &lt;br&gt;&lt;br&gt;&lt;ul&gt;&lt;br&gt;&lt;li&gt;Drilling and Production Hoisting Equipment&lt;/li&gt;&lt;br&gt;&lt;li&gt;Hoisting Tool Inspection and Maintenance Procedures&lt;/li&gt;&lt;br&gt;&lt;li&gt;Pump Performance Charts&lt;/li&gt;&lt;br&gt;&lt;li&gt;Rotary Table and Bushings&lt;/li&gt;&lt;br&gt;&lt;li&gt;Rig Maintenance of Drill Collars&lt;/li&gt;&lt;br&gt;&lt;li&gt;Drilling Bits and Downhole Tools&lt;/li&gt;&lt;br&gt;&lt;p&gt;&lt;/p&gt;&lt;/ul&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;p&gt;Chapter 1 Drilling Mud and Completion Systems &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 2 Drilling String: Composition and Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 3 Air and Gas Drilling &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 4 Directional Drilling &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 5 Selection of Drilling Practies &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 6 Well Pressure Control&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 7 Fishing Operations and Equipment&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 8 Casing and Casing String Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 9 Well Cementing &lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 10 Tubing and Tubing String Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;Chapter 11 Environmental Considerations&lt;/p&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>18</TextTypeCode>
			<Text>&lt;p&gt;Drilling technology has evolved in order to get at the increasingly harder to find oil, and in a more environmentally friendly way. Successful drilling operations require blending many technologies. Drilling equipment and procedures have a unique language that must be conquered in order to understand drilling operations. &lt;/p&gt;&lt;br&gt;&lt;p&gt;&lt;/p&gt;&lt;br&gt;&lt;p&gt;Working Guide to Drilling Equipment and Operations provides a fundamental, basic knowledge of the intricacies of drilling fluid, drilled solids management, drill bits, drill string design, directional drilling, cementing, casing, hydraulic optimization, and a discussion of predominant problems such as stuck pipe and lost circulation. Background information, such as: clay structure (needed to understand well bore instability and drilling fluids), discussion of pressure and pressure effects, the theory behind factors affecting drilling performance, and rock failure under pressure, are included to enhance the understanding of the drilling process and problems. &lt;/p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>71</NameCodeValue>
			<ImprintName>Gulf Professional Publishing</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20091001</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2010</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<Measure>
			<MeasureTypeCode>01</MeasureTypeCode>
			<Measurement>9</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<Measure>
			<MeasureTypeCode>02</MeasureTypeCode>
			<Measurement>6</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9781856178440</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20091022</ExpectedShipDate>
			<PackQuantity>18</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>99.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100780:100789</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1928994563</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781928994565</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781928994565</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Series>
			<TitleOfSeries>.NET Developers Series</TitleOfSeries>
		</Series>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>.NET Mobile Web Developers Guide</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<KeyNames>Syngress</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>520</NumberOfPages>
		<BASICMainSubject>COM051000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>Introducing Microsoft's flagship wireless development tool&lt;br&gt;The .NET Mobile Web Developer's Guide will provide readers with a solid guide to developing mobile applications using Microsoft technologies. The focus of this book is on using ASP.NET and the .NET mobile SDK. It provides an introduction to the .NET platform and goes into moderate details on ASP.NET to allow readers to start developing ASP.NET applications. In addition, this book will give the readers the insight to use the various Microsoft technologies for developing mobile applications.&lt;br&gt;This book assumes the readers have experience in developing web applications and are familiar with any one of the server-side technologies like ASP, JSP or PHP.
                                    &lt;br&gt;&lt;br&gt;The first book available on Microsoft's cornerstone wireless development tool&lt;br&gt;Best selling, high profile authors. Wei Meng Lee and Shelley Powers are frequent speakers at all of the major developer conferences have previously authored best selling books for O'Reilly &amp; Associates, Wrox Press, SAMS and Que&lt;br&gt;Comes with wallet-sized CD containing a printable HTML version of the book, all of the source code examples and demos of popular ASP .NET and .NET Mobile programming tools&lt;br&gt;Comprehensive Coverage of the .NET Mobile SDK and ASP.NET for Mobile Web developers</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20020302</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080481838</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>32</ProductAvailability>
			<ExpectedShipDate>20020323</ExpectedShipDate>
			<PackQuantity>12</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>51.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>112530:112619</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1856174670</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781856174671</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781856174671</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BB</ProductForm>
		<Series>
			<TitleOfSeries>World Pumps</TitleOfSeries>
		</Series>
		<Set>
			<TitleOfSet>Forsthoffer's Rotating Equipment Handbooks</TitleOfSet>
		</Set>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>1. Forsthoffer's Rotating Equipment Handbooks</TitleText>
			<Subtitle>Fundamentals of Rotating Equipment</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>William E</NamesBeforeKey>
			<KeyNames>Forsthoffer</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>President, Forsthoffer Associates Inc., Washington Crossing, PA USA</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>512</NumberOfPages>
		<BASICMainSubject>TEC009070</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>'Fundamentals of Rotating Equipment' is an overview of the main types of rotating machinery in industry, and covers such aspects as system dynamics, surge control, vibration and balancing, radial bearing design, performance parameters, rotor system design and operation, rotor axial (thrust) forces, performance objectives and mechanical restraints, auxiliary systems and seals.&lt;br&gt;&lt;br&gt;This book will enhance rotating equipment reliability and safety throughout the many industries where such equipment is vital to a successful business.&lt;br&gt;&lt;br&gt;Over recent years there have been substantial changes in those industries  which are concerned with the design, purchase and use of special purpose (ie critical, high-revenue) rotating equipment. Key personnel have been the victims of early retirement or have moved to other industries: contractors and end-users have reduced their technical staff and consequently have to learn complex material from scratch. &lt;br&gt;&lt;br&gt;As a result, many companies are finding that they are devoting unnecessary man hours to the discovery and explanation of basic principles, and having to explain these to clients who should already be aware of them. In addition, the lack of understanding by contractors and users of equipment characteristics and operating systems often results in a wrong fit and a costly reliability problem. &lt;br&gt;&lt;br&gt;The stakes can be high, and it against this background that this book has been published. It is the outcome of many years experience and is based on well-honed teaching material which is easily readable, understandable and actually enjoyable!&lt;br&gt;&lt;br&gt;This is a five volume set. The volumes are: &lt;br&gt;1. Fundamentals of Rotating Equipment &lt;br&gt;2. Pumps &lt;br&gt;3. Compressors &lt;br&gt;4. Auxiliary Systems&lt;br&gt;5. Reliability Optimization thru Component Condition Monitoring and Root Cause Analysis
                                    &lt;br&gt;&lt;br&gt;* A distillation of many years of on-site training by a well-known US Engineer who also operates in the Middle East.&lt;br&gt;* A Practical book written in a succinct style and well illustrated throughout.&lt;br&gt;* An overview of the main types of rotating machinery in industry.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>Rotating equipment overview; compressor characteristics; operation of a compressor in a system; pump types and applications; pump performance data; centrifugal pump hydraulic disturbances; pump mechanical design; mechanical seals; compressor types and applications; the concept of fluid head; performance relationships; surge (stall) and stonewall; the effect of a gas density change; turbo-compressor mechanical design overview; radial bearing design; rotar axial (thrust) forces; compressor seal system overview and types; reciprocating compressors major component functions; flexible coupling design, installation and operation; steam turbine function and types; steam turbine performance; steam turbine mechanical design overview; steam turbine inlet steam regulation; steam turbine control/ protection systems; steam turbine operation; gas turbine types and applications; gas turbine performance; gas turbine mechanical design; gas turbine support systems; gas turbine control and protection; lubrication system overview and types; monitoring reliability and component condition; conversions to metric system; index</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>68</NameCodeValue>
			<ImprintName>Elsevier Science</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20060123</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2005</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<Measure>
			<MeasureTypeCode>01</MeasureTypeCode>
			<Measurement>9.21</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<Measure>
			<MeasureTypeCode>02</MeasureTypeCode>
			<Measurement>6.125</Measurement>
			<MeasureUnitCode>in</MeasureUnitCode>
		</Measure>
		<RelatedProduct>
			<RelationCode>02</RelationCode>
			<ProductIdentifier>
				<ProductIDType>02</ProductIDType>
				<IDValue>1856174727</IDValue>
			</ProductIdentifier>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9781856174725</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080949321</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>32</ProductAvailability>
			<ExpectedShipDate>20060213</ExpectedShipDate>
			<PackQuantity>12</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>161</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100741:100747</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1931836590</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781931836593</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781931836593</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10 Cool Lego Mindstorm Dark Side Robots Transports and Creatures</TitleText>
			<Subtitle>Amazing Projects You Can Build in Under an Hour</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<KeyNames>Syngress</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>176</NumberOfPages>
		<BASICMainSubject>TEC037000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>LEGO MINDSTORMS let you design and program robots that can do just about anything!&lt;br&gt;The Dark Side Developer's Kit is targeted towards the young or novice LEGO MINDSTORMS designer, age 9 and up, although experienced MINDSTORMS fans will appreciate the unique possibilities offered by this kit as well. The Dark Side Developer's Kit includes special MINDSTORMS pieces that allow the user to create a host of Star Wars themed robots, creatures, and vehicles. It also comes with the Micro Scout, a mini-computer with 7 built-in programs, a motor, and a light sensor that brings the MINDSTORMS creations to life with a minimum of effort.&lt;br&gt;&lt;br&gt;10 Cool LEGO MINDSTORMS Dark Side Robots, Transports, and Creatures: Amazing Projects You Can Build in Under an Hour provides step-by-step instructions and detailed illustrations for users of all skill levels and proficiencies.
                                    &lt;br&gt;&lt;br&gt;A blend of the hugely popular LEGO and STAR WARS lines. Appealing to fans of both, this book will allow readers to build unique creations using the special parts found in the "LEGO MINDSTORMS: Dark Side Developer's Kit" that mimic the robots, vehicles and creatures found in the STAR WARS movies. &lt;br&gt;From out of the box to up and running in less than an hour. This book teaches users how to create 10 amazing projects, each in under an hour.&lt;br&gt;8-page color insert. An eight-page color insert illustrates the complete projects in full-detail.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>Chapter 1: Sith Stealth Infiltrator&lt;br&gt;Chapter 2: Imperial Devastator&lt;br&gt;Chapter 3: Bounty Hunter Droid&lt;br&gt;Chapter 4: Imperial AT-ST&lt;br&gt;Chapter 5: Dark Side Reconnaissance Droid&lt;br&gt;Chapter 6: Dark Side Battle-Trainer&lt;br&gt;Chapter 7: Trade Federation Land Transport&lt;br&gt;Chapter 8: Sith Scout Ship&lt;br&gt;Chapter 9: Imperial TIE Interceptor&lt;br&gt;Chapter 10: Trade Federation Security Droid</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>06</PublishingStatus>
		<PublicationDate>20020913</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080546292</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>OI</AvailabilityCode>
			<ProductAvailability>40</ProductAvailability>
			<ExpectedShipDate>20021004</ExpectedShipDate>
			<PackQuantity>34</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>25.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100811:100824</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1931836612</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781931836616</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781931836616</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10 Cool Lego Mindstorm Robotics Invention System 2 Projects</TitleText>
			<Subtitle>Amazing Projects You Can Build in Under an Hour</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<KeyNames>Syngress</KeyNames>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>176</NumberOfPages>
		<BASICMainSubject>TEC037000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>LEGO MINDSTORMS lets you design and program robots that can do just about anything!&lt;br&gt;The LEGO MINDSTORMS RIS 2.0 is the core set for all MINDSTORMS users, that lets users design and program working robots - limited only by their imagination. Initially designed for users 12 and up, LEGO MINDSTORMS has taken off with LEGO enthusiasts of all ages.  &lt;br&gt;10 Cool LEGO MINDSTORMS RIS 2.0 Projects: Amazing Projects You Can Build in Under an Hour provides step-by-step instructions and detailed illustrations for users of all skill levels and proficiencies.
                                    &lt;br&gt;&lt;br&gt;From out of the box to up and running in less than an hour. &lt;br&gt;8-page color insert. A color insert illustrates the complete projects in full-detail.&lt;br&gt;Specifically targeted at new users of the LEGO MINDSTORMS RIS 2.0.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>Chapter 1: There's a Mouse in House&lt;br&gt;Chapter 2: How to Build a Better Mouse Trap&lt;br&gt;Chapter 3: Trains...&lt;br&gt;Chapter 4:  Planes...&lt;br&gt;Chapter 5: And Automobiles...&lt;br&gt;Chapter 6: BattleTank with Treads and Turrets&lt;br&gt;Chapter 7: Chore-Doer 3000&lt;br&gt;Chapter 8: Arachnoid-what?  Building a Spider&lt;br&gt;Chapter 9: Making the Band: Building a Drummer&lt;br&gt;Chapter 10: Just Desserts: Building a Gumball Machine</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20021129</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080546308</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20021220</ExpectedShipDate>
			<PackQuantity>22</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>25.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>100742:100748</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>1931836604</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9781931836609</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9781931836609</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10 Cool Lego Mindstorm Ultimate Builders Projects</TitleText>
			<Subtitle>Amazing Projects You Can Build in Under an Hour</Subtitle>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>Mario</NamesBeforeKey>
			<KeyNames>Ferrari</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Author of bestselling "Building Robots with LEGO Mindstorms", Italy</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>176</NumberOfPages>
		<BASICMainSubject>TEC037000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>LEGO MINDSTORMS lets you design and program robots that can do just about anything!&lt;br&gt;You've just purchased the LEGO MINDSTORMS Ultimate Builder Kit. Now what? Overwhelmed by the creative possibilities? The Builder Kit is targeted towards those who want to become "master LEGO builders." &lt;br&gt;&lt;br&gt;10 Cool LEGO MINDSTORM Ultimate Builder Projects: Amazing Projects You Can Build in Under an Hour provides step-by-step instructions and detailed illustrations for users of all skill levels and proficiencies. This MINDSTORMS kit features many rare parts, a spare motor, a turntable, special gears, transparent beams, and even a pneumatics system-parts that can be confusing and that will be new to many LEGO builders. 10 Cool LEGO MINDSTORM Ultimate Builder Projects teaches readers how to incorporate these new features into their creations as they build 10 unique robots.
                                    &lt;br&gt;&lt;br&gt;From out of the box to up and running in less than an hour. This book teaches users how to create 10 amazing projects in under an hour.&lt;br&gt;8-page color insert. An eight-page color insert will illustrates the complete projects in full-detail.&lt;br&gt;Specifically targeted to both new users of the LEGO MINDSTORMS and experienced MINDSTORMS fans.</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>13</TextTypeCode>
			<Text>Mario Ferrari received his first Lego box around 1964, when he was 4. Lego was his favorite toy for many years, until he thought he was too old to play with it. In 1998, the Lego Mindstorms RIS set gave him reason to again have Lego become his main addiction. Mario believes Lego is the closest thing to the perfect toy. He is Managing Director at EDIS, a leader in finishing and packaging solutions and promotional packaging. The advent of the MINDSTORMS product line represented for him the perfect opportunity to combine his interest in IT and robotics with his passion for LEGO bricks, which started during his early childhood. Mario has been a very active member of the online MINDSTORMS community from the beginning and has pushed LEGO robotics to its limits. Mario holds a bachelor's degree in Business Administration from the University of Turin and has always nourished a strong interest for physics, mathematics, and computer science. He is fluent in many programming languages and his background includes positions as an IT manager and as a project supervisor. Mario estimates he owns over 60,000 Lego pieces. Mario works in Modena, Italy, where he lives with his wife Anna and his children Sebastiano and Camilla.&lt;p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>76</NameCodeValue>
			<ImprintName>Syngress</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20021214</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2002</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080555157</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>20</ProductAvailability>
			<ExpectedShipDate>20030104</ExpectedShipDate>
			<PackQuantity>18</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>25.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>120947:127931</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>02</ProductIDType>
			<IDValue>0444504761</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780444504760</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780444504760</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BB</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10&lt;SUP&gt;th&lt;/SUP&gt; European Conference on Mixing</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>H.E.A.</NamesBeforeKey>
			<KeyNames>van den Akker</KeyNames>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>J.J.</NamesBeforeKey>
			<KeyNames>Derksen</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Kramers Laboratorium voor Fysische Technologie, Delft University of Technology, Delft, The Netherlands</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>572</NumberOfPages>
		<BASICMainSubject>TEC009010</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>Traditionally, fluid mixing and the related multiphase contacting processes have always been regarded as an empirical technology. Many aspects of mixing, dispersing and contacting were related to power draw, but understanding of the phenomena was limited or qualitative at the most.&lt;br&gt;&lt;br&gt;In particular during the last decade, however, plant operation targets have tightened and product specifications have become stricter. The public awareness as to safety and environmental hygiene has increased. The drive towards larger degrees of sustainability in the process industries has urged for lower amounts of solvents and for higher yields and higher selectivities in chemical reactors. All this has resulted in a &lt;i&gt;market pull&lt;/i&gt;: the need for more detailed insights in flow phenomena and processes and for better verifiable design and operation methods.&lt;br&gt;&lt;br&gt;Developments in miniaturisation of sensors and circuits as well as in computer technology have rendered leaps possible in computer simulation and animation and in measuring and monitoring techniques. &lt;br&gt;&lt;br&gt;This volume encourages a leap forward in the field of mixing by the current, overwhelming wealth of sophisticated measuring and computational techniques. This leap may be made possible by modern instrumentation, signal and data analysis, field reconstruction algorithms, computational modelling techniques and numerical recipes. &lt;br&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;b&gt;Section headings:&lt;/b&gt; &lt;b&gt;Turbulence Characteristics in Stirred Tanks.&lt;/b&gt; (3 papers). &lt;b&gt;Measurements in Chemically Reacting Flows.&lt;/b&gt; (3 papers). &lt;b&gt;Modelling of Micro-Mixing.&lt;/b&gt; (6 papers). &lt;b&gt;Effects of Viscosity and Rheology on Mixing.&lt;/b&gt; (3 papers). &lt;b&gt;Slurry Systems.&lt;/b&gt; (2 papers). &lt;b&gt;Liquid-Liquid Dispersions.&lt;/b&gt; (6 papers). &lt;b&gt;Gas-Liquid Systems.&lt;/b&gt; (4 papers). &lt;b&gt;Particle Collisions in Crystallisation.&lt;/b&gt; (2 papers). &lt;b&gt;Advanced CFD.&lt;/b&gt; (3 papers). &lt;b&gt;Posters.&lt;/b&gt; (33 papers).&lt;br&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>68</NameCodeValue>
			<ImprintName>Elsevier Science</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>06</PublishingStatus>
		<PublicationDate>20000614</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2000</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080525792</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>OI</AvailabilityCode>
			<ProductAvailability>40</ProductAvailability>
			<ExpectedShipDate>20000705</ExpectedShipDate>
			<PackQuantity>16</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>340</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>1095034:10895161</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780240814254</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780240814254</IDValue>
		</ProductIdentifier>
		<Barcode>03</Barcode>
		<ProductForm>BC</ProductForm>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>100% Photoshop</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>A01</ContributorRole>
			<NamesBeforeKey>Steve</NamesBeforeKey>
			<KeyNames>Caplin</KeyNames>
			<ProfessionalAffiliation>
				<Affiliation>Graphic artist/illustrator, contributing editor for MacUser magazine and the best-selling author of How to Cheat in Photoshop</Affiliation>
			</ProfessionalAffiliation>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<NumberOfPages>256</NumberOfPages>
		<BASICMainSubject>COM012000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>&lt;p&gt;Just when you think you have learned all that you could ever know about working in Photoshop, digital artist and photomontage king Steve Caplin comes along with yet another masterful method for creating incredible works of art in Photoshop. This time, he will show you how to create complete images, from start to finish, &lt;U&gt;entirely&lt;/U&gt; within the software program. No source material, photographs, or existing files from other software packages are needed, saving you valuable time and resources. The techniques you will learn in this ground-breaking new book will help you combine your artistic vision and skills with an understanding of how to manipulate the built-in Photoshop filters to produce impressive, eye-catching artwork.&lt;/p&gt;&lt;br&gt;&lt;p&gt;Each chapter opens with a complete double page illustration, created entirely in Photoshop. Then, carefully laid out step-by-step instructions show you how each element in the illustration is created, and how they are all combined in the end to make a convincing final image. Using Steve&apos;s proven methods for success, you will be able to produce images that reflect a more finely crafted, hand drawn approach, whether you are an artist for your own enjoyment or a working professional looking for a leg up on the competition. &lt;/p&gt;
                                    &lt;br&gt;&lt;br&gt;&lt;p&gt;*The only book of its kind that does not rely on any external images whatsoever -- each and every element is created directly in Photoshop &lt;/p&gt;&lt;br&gt;&lt;p&gt;*A chapter covering the basics of using specific filters and textures and a chapter providing a summary of common techniques and tools will help you brush up on your general Photoshop skills so you can move through the rest of the book successfully &lt;/p&gt;&lt;br&gt;&lt;p&gt;*Visit the book website at [url to come] for supplemental material to help you get started &lt;/p&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;p&gt;Chapter 1: Textures: Using Clouds, Noise, Blur, Fibers to create basic texture; Texture creation: paper, wood, stone, and metal; Chapter 2: Setting the Scene: Hallway -- door, light, glass, gold text, shadows, metal handle, layer masks; Chapter 3: The Great Outdoors: trees, grass, leaves (custom brush design), water and reflections, clouds, sky, mountains; Chapter 4: In the Attic:LPs, cardboard boxes, guitar, cork boards, beams, brick walls, assorted items; Chapter 5: To Boldly Go: Space scene with stars, planets, aurora, spaceship, alien; Chapter 6: Treasured Possessions: Desk drawer with jewelry, letters, sealing wax, pens, magnifying glass, pencils, rubber stamp, folder with coffee stains; Chapter 7: In the Lab: Mad scientist&apos;s laboratory with Bunsen burner, lab bottles, stone wall, lightning through window; Chapter 8: The Operation:&amp;nbsp;Operating theatre scene with close-up of opened body featuring internal organs, bone, skin texture, scalpels and clamps; Chapter 9: Fantasy Scene: Organic-looking synthetic scene with intertwining tentacles, texture generated background, H R Giger-style anatomical elements;&amp;nbsp;Chapter 10: Photoshop Reference: Quick start guide &lt;/p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>70</NameCodeValue>
			<ImprintName>Focal Press</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>02</PublishingStatus>
		<PublicationDate>20100601</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2010</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780240814261</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>NP</AvailabilityCode>
			<ProductAvailability>10</ProductAvailability>
			<ExpectedShipDate>20100622</ExpectedShipDate>
			<PackQuantity>24</PackQuantity>
			<Price>
				<PriceTypeCode>21</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>69</DiscountCode>
				</DiscountCoded>
				<PriceAmount>39.95</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
	<Product>
		<RecordReference>1092624:10872821</RecordReference>
		<NotificationType>03</NotificationType>
		<ProductIdentifier>
			<ProductIDType>03</ProductIDType>
			<IDValue>9780444534729</IDValue>
		</ProductIdentifier>
		<ProductIdentifier>
			<ProductIDType>15</ProductIDType>
			<IDValue>9780444534729</IDValue>
		</ProductIdentifier>
		<Barcode>02</Barcode>
		<ProductForm>BB</ProductForm>
		<Series>
			<TitleOfSeries>Computer Aided Chemical Engineering</TitleOfSeries>
			<NumberWithinSeries>27</NumberWithinSeries>
		</Series>
		<Title>
			<TitleType>01</TitleType>
			<TitleText>10th International Symposium on Process Systems Engineering - PSE2009</TitleText>
		</Title>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Rita Maria</NamesBeforeKey>
			<KeyNames>de Brito Alves</KeyNames>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Claudio Augusto</NamesBeforeKey>
			<KeyNames>Oller do Nascimento</KeyNames>
		</Contributor>
		<Contributor>
			<ContributorRole>B01</ContributorRole>
			<NamesBeforeKey>Evaristo Chalbaud</NamesBeforeKey>
			<KeyNames>Biscaia</KeyNames>
			<SuffixToKey>Jr.</SuffixToKey>
		</Contributor>
		<Language>
			<LanguageRole>01</LanguageRole>
			<LanguageCode>eng</LanguageCode>
		</Language>
		<BASICMainSubject>SCI013000</BASICMainSubject>
		<AudienceCode>06</AudienceCode>
		<OtherText>
			<TextTypeCode>01</TextTypeCode>
			<Text>&lt;p&gt;This book contains the proceedings of the10th edition of a series of international symposia on Process Systems Engineering (PSE)&amp;nbsp;initiated in 1982. The special focus of PSE09 is how PSE methods can support sustainable resource systems and emerging technologies in the areas of green engineering.&lt;/p&gt;
                                    &lt;br&gt;&lt;br&gt;&lt;p&gt;* Contains fully searchable CD of all printed contributions&lt;/p&gt;&lt;br&gt;&lt;p&gt;* Focus on sustainable green engineering&lt;/p&gt;&lt;br&gt;&lt;p&gt;* 9 Plenary papers, 21 Keynote lectures by leading experts in the field&lt;/p&gt;</Text>
		</OtherText>
		<OtherText>
			<TextTypeCode>04</TextTypeCode>
			<Text>&lt;p&gt;&lt;b&gt;Part A&lt;/b&gt;&lt;/p&gt;&lt;br&gt;&lt;p&gt;Plenary lectures&lt;/p&gt;&lt;br&gt;&lt;p&gt;Keynote lectures&lt;/p&gt;&lt;br&gt;&lt;p&gt;Modelling, Supporting Methods and Tools&lt;/p&gt;&lt;br&gt;&lt;p&gt;Product and Process Design&lt;/p&gt;&lt;br&gt;&lt;p&gt;&lt;b&gt;Part B&lt;/b&gt;&lt;/p&gt;&lt;br&gt;&lt;p&gt;Operations and Control&lt;/p&gt;&lt;br&gt;&lt;p&gt;Non-traditional Applications of Process Systems Engineering&lt;/p&gt;&lt;br&gt;&lt;p&gt;Business Decision Support&lt;/p&gt;&lt;br&gt;&lt;p&gt;Education in Process Systems Engineering&lt;/p&gt;</Text>
		</OtherText>
		<Imprint>
			<NameCodeType>02</NameCodeType>
			<NameCodeValue>109</NameCodeValue>
			<ImprintName>Elsevier</ImprintName>
		</Imprint>
		<PublisherName>Elsevier Science</PublisherName>
		<PublishingStatus>04</PublishingStatus>
		<PublicationDate>20090903</PublicationDate>
		<CopyrightStatement>
			<CopyrightYear>2009</CopyrightYear>
			<CopyrightOwner>
				<CopyrightOwnerIdentifier>
					<CopyrightOwnerIDType>02</CopyrightOwnerIDType>
					<IDValue>Elsevier Science</IDValue>
				</CopyrightOwnerIdentifier>
			</CopyrightOwner>
		</CopyrightStatement>
		<SalesRights>
			<SalesRightsType>01</SalesRightsType>
			<RightsTerritory>WORLD</RightsTerritory>
		</SalesRights>
		<RelatedProduct>
			<RelationCode>01</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780080963273</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<RelatedProduct>
			<RelationCode>06</RelationCode>
			<ProductIdentifier>
				<ProductIDType>03</ProductIDType>
				<IDValue>9780444534736</IDValue>
			</ProductIdentifier>
		</RelatedProduct>
		<SupplyDetail>
			<SupplierName>Elsevier Science</SupplierName>
			<AvailabilityCode>IP</AvailabilityCode>
			<ProductAvailability>32</ProductAvailability>
			<ExpectedShipDate>20090924</ExpectedShipDate>
			<PackQuantity>1</PackQuantity>
			<Price>
				<PriceTypeCode>01</PriceTypeCode>
				<DiscountCoded>
					<DiscountCodeType>02</DiscountCodeType>
					<DiscountCodeTypeName>EST</DiscountCodeTypeName>
					<DiscountCode>61</DiscountCode>
				</DiscountCoded>
				<PriceAmount>575</PriceAmount>
			</Price>
		</SupplyDetail>
	</Product>
</ONIXMessage>	
EOXML;



// INTERPRETS XML STRING INTO AN OBJECT
$obj = SimpleXML_Load_String($xml);

// ACTIVATE THIS TO VISUALIZE THE OBJECT
// var_dump($obj);

// SHOW HOW TO GET SOME OF THE INFORMATION OUT OF THE OBJECT
$hfc = (string)$obj->Header->FromCompany;
$hfp = (string)$obj->Header->FromPerson;
$hsd = (string)$obj->Header->SentDate;
$hdcc = (string)$obj->Header->DefaultCurrencyCode;

echo PHP_EOL . $hfc;
echo PHP_EOL . $hfp;
echo PHP_EOL . $hsd;
echo PHP_EOL . $hdcc;

// SHOW HOW TO GET COUNTS OF DATA FIELDS
$k = count($obj->Product);
echo PHP_EOL . "$k PRODUCT LISTINGS";

// SHOW HOW TO ITERATE OVER THE ARRAY OF "PRODUCT" AND GET SOME DATA FIELDS THEN CAST AS VARIABLES
$n = 0;
foreach ($obj->Product as $p)
{
$con = mysqli_connect("localhost", "root", "Jason01", "books");
if (mysqli_error($con))
  {
  printf("Could not connect:  %s\n", mysqli_connect_error());
  exit();
  }

    $n++;
    $t = (string)$p->Title->TitleText;
    $i = (string)$p->Imprint->ImprintName;
    $y = (string)$p->CopyrightStatement->CopyrightYear;
    $c = (string)$p->CopyrightStatement->CopyrightOwner->CopyrightOwnerIdentifier->IDValue;
    $m = (string)$p->SupplyDetail->Price->PriceAmount;
	
	$rr = (string)$p->RecordReference;
    $nt = (string)$p->NotificationType;
    $pf = (string)$p->ProductForm;
    $nop = (string)$p->NumberOfPages;
    $bms = (string)$p->BASICMainSubject;
   	$ac = (string)$p->AudienceCode;
    $pubn = (string)$p->PublisherName;
    $pubs = (string)$p->PublishingStatus;
    $pubd = (string)$p->PublicationDate;
	
		
    echo PHP_EOL;
    echo PHP_EOL . "LISTING NUMBER $n";
    echo PHP_EOL . $t;
    echo PHP_EOL . $i;
    echo PHP_EOL . "&copy;" . $y . ' ' .$c;
    echo PHP_EOL . '$' . $m;
	

    foreach ($p->ProductIdentifier as $pi)
    {
        // CAST AS STRING VARIABLES
        $ProductIDType = (string)$pi->ProductIDType;
        $IDValue       = (string)$pi->IDValue;
        
		// STORED IN THE ARRAY
		
        $pia[$ProductIDType==03] = $IDValue;	
       
    }	
	   
	// PRODUCT IDENTIFIERS - PRESENTED FROM THE ASSOCIATIVE ARRAY
    foreach ($pia as $ProductIDType => $IDValue)
    {
	   $GTIN13 = $pia[$ProductIDType==03];
	}
	   
 
	   
	$pia1 = array();
    foreach ($p->ProductIdentifier as $pi1)
    {
        // CAST AS STRING VARIABLES
        $ProductIDType1 = (string)$pi1->ProductIDType;
        $IDValue1       = (string)$pi1->IDValue;
        
		// STORED IN THE ARRAY
 
        $pia1[$ProductIDType1] = $IDValue1;
    
    }	
	   
	// PRODUCT IDENTIFIERS - PRESENTED FROM THE ASSOCIATIVE ARRAY
    foreach ($pia1 as $ProductIDType1 => $IDValue1)
    {
	
	
	  		
		echo PHP_EOL . 'PIM: ' . $ProductIDType1 . ' ' . $IDValue1. ' ' . $GTIN13;
		
//INSERT DATA INTO ISBN10 TABLE
              if ($ProductIDType1==02) {
               $result = mysqli_query($con, "INSERT INTO tblIsbn10 (
			   ProductIDType, 
			   Isbn10) 
			   
			   VALUES (
			   '$ProductIDType1', 
			   '$IDValue1') 
			   ");
			   
			  
               }
	           //INSERT DATA INTO GTIN13 TABLE
	           if ($ProductIDType1==03) {               
			   $result1 = mysqli_query($con, "INSERT INTO tblGtin13 (
			   ProductIDType, 
			   Gtin13) 
			   
			   VALUES (
			   '$ProductIDType1', 
			   '$IDValue1') 
			   ");
			   
			    //INSERT DATA INTO PRODUCTS TABLE
			    $result = mysqli_query($con, "INSERT INTO tblProducts (
				RecordReference, 
				NotificationType,
				Gtin13,
				ProductForm, 
				NumberOfPages, 
				BASICMainSubject, 
                AudienceCode, 
				PublisherName, 
				PublishingStatus, 
				PublicationDate)

                VALUES (
		        '$rr', 
                '$nt',
       	        '$IDValue',
                '$pf',
                '$nop', 
                '$bms',
                '$ac', 
                '$pubn', 
                '$pubs', 
                '$pubd') 
                "); 

                			
	            } 
			
			 if ($ProductIDType1==04) {
               $result2 = mysqli_query($con, "INSERT INTO tblUpc (
			   ProductIDType, 
			   Upc) 
			   
			   VALUES (
			   '$ProductIDType1', 
			   '$IDValue1') 
			   ");
			  

               }
	 
	           if ($ProductIDType1==14) {
               $result3 = mysqli_query($con, "INSERT INTO tblGtin14 (
			   ProductIDType, 
			   Gtin14) 
			   
			   VALUES (
			   '$ProductIDType1', 
			   '$IDValue1') 
			   ");
			  

                }
	 
	           if ($ProductIDType1==15) {
               $result4 = mysqli_query($con, "INSERT INTO tblIsbn13 (
			   ProductIDType, 
			   Isbn13) 
			   
			   VALUES (
			   '$ProductIDType1', 
			   '$IDValue1') 
			   ");
			  
                }
	 
	}
	 
        // CONTRIBUTOR  - EXTRACTED INTO AN ASSOCIATIVE ARRAY
        foreach ($p->Contributor as $co)
        {
            // CAST AS STRING VARIABLES
            $ContributorRole = mysqli_real_escape_string($con, (string)$co->ContributorRole);
            $NamesBeforeKey  = mysqli_real_escape_string($con, (string)$co->NamesBeforeKey);
            $KeyNames = mysqli_real_escape_string($con, (string)$co->KeyNames);
            $SuffixToKey = mysqli_real_escape_string($con, (string)$co->SuffixToKey);
			$LettersAfterNames	= mysqli_real_escape_string($con, (string)$co->LettersAfterNames);
			
			
		    echo PHP_EOL . 'CO: '  . ' ' . $ContributorRole . ' ' .$NamesBeforeKey. ' '. $KeyNames. ' '.   $SuffixToKey . ' ' .$LettersAfterNames. ' ' .$GTIN13; 
	 
	      
		  	$create = mysqli_query($con, "CREATE TEMPORARY TABLE temptblContributors
                     (
                      ContributorID int unsigned not null auto_increment,
                      ContributorRole char(3),
                      NamesBeforeKey varchar(150),  
                      KeyNames varchar(150),
                      SuffixToKey varchar(150),
                      LettersAfterNames varchar(350),
                      primary key (ContributorID))
					  ");			
				
			$resultc = mysqli_query($con, "INSERT INTO temptblContributors (
                      ContributorRole,
                      NamesBeforeKey,
                      KeyNames,
                      SuffixToKey,
			          LettersAfterNames)
                    

		              VALUES (
                     '$ContributorRole',
		             '$NamesBeforeKey',
		             '$KeyNames', 
		             '$SuffixToKey',
		             '$LettersAfterNames')
		             ");

		  
		  
		            $result5 =  mysqli_query($con, "INSERT INTO tblContributors (
                    ContributorRole,
                    NamesBeforeKey,
                    KeyNames,
                    SuffixToKey,
			        LettersAfterNames)           

		            SELECT
                    ContributorRole,
                    NamesBeforeKey,
                    KeyNames,
                    SuffixToKey,
			        LettersAfterNames
				
                    FROM 
	                temptblContributors
                    WHERE NOT EXISTS 
                    (SELECT * 
                    FROM 
	                tblContributors 
                    WHERE temptblContributors.ContributorRole = tblContributors.ContributorRole 
                    AND temptblContributors.NamesBeforeKey = tblContributors.NamesBeforeKey
                    AND temptblContributors.KeyNames = tblContributors.KeyNames
                    AND temptblContributors.SuffixToKey = tblContributors.SuffixToKey 
                    AND temptblContributors.LettersAfterNames = tblContributors.LettersAfterNames)
		            ");
		  
		            $drop = mysqli_query($con, "DROP TABLE temptblContributors");



			// GET CONTRIBUTOR DATA OUT OF DATABASE
			$sqlget = "SELECT * FROM tblContributors WHERE ContributorRole = '$ContributorRole' and NamesBeforeKey = '$NamesBeforeKey' and KeyNames = '$KeyNames' and SuffixToKey = '$SuffixToKey' and LettersAfterNames = '$LettersAfterNames'";
            $sqldata = mysqli_query($con, $sqlget) or die('error getting data');
		    
         	while ($row = mysqli_fetch_array($sqldata, MYSQLI_ASSOC)) {
				
			echo PHP_EOL . 'DBCO:' . ' ' .$row['ContributorID']. ' ' .$row['ContributorRole']. ' ' . $row['NamesBeforeKey']. ' ' . $row['KeyNames']. ' ' . $row['SuffixToKey'] . ' ' . $row['LettersAfterNames'];

		
}		
        
 

          }
		  
		  
mysqli_close($con);
    
}		 
?>

Open in new window

0
 

Author Closing Comment

by:Honya
ID: 36095882
The other solutions suggested did  not answer my specific request.
0
 

Author Comment

by:Honya
ID: 36035582
I found the solution elsewhere.
0
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 36035949
Glad you found that.  PHP supports DOM also, so you can use that to pull apart the XML on the PHP side.  Not my fortay, so glad after chatting with Ray, you were inspired to find the solution.

Best regards and happy coding,
Kevin
0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 36036886
@Honya, go ahead and close this if you want.  However the solution at ID:36035528 is technically incompetent.  If you ever have any meaningful load on your server, or if your data base grows to anything more than a small number of records this strategy will choke to death on its own crud.  I can not think of any circumstance where NOT EXISTS SELECT * is the right answer, especially since MySQL gives you the UNIQUE definition and you have seen the strategy that will enable you to use UNIQUE.

Good luck, I think you're going to need it! ~Ray
0
 

Author Comment

by:Honya
ID: 36043521
Hi Ray,
Concerning comment ID: 36036886, could you please provide an example of the solution that you suggested as well as some way to test which solution is better?
I believe that for a database with about 1000000 contributors, the solution that I found should work since I am dropping the temp. table each time the code is run to insert a contributor. However you have indicated otherwise. I will greatly appreciate it if you could provide what was requested above.

Best wishes
0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 36044944
You might want to post a question here at EE asking how to use EXPLAIN SELECT to learn what MySQL is doing with your queries.  It's not a question with an answer, it's a process and it has several paths.  Some of them make more sense, from a computer science perspective, than others.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
This article discusses how to implement server side field validation and display customized error messages to the client.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to count occurrences of each item in an array.
Suggested Courses
Course of the Month13 days, 14 hours left to enroll

755 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question