How to handle data pulled fom xml? SOLVED

New Member Joined: Mar 18, 2004 Posts: 10

Not done much with xml. Working on a EQ2 roster script.

I am pulling the data from the xml fine, but not shure how to insert it into the database or sort it keeping the correct info in the correct rows.

I currently have it to where it lists it out like so:

Code:

  $txItem = $arItems[$i];


  $GuildID = ($txItem->xId);


  $GuildRank = ($txItem->xRank);


  $GuildName = ($txItem->xName);


  $GuildClass = ($txItem->xClass);


  $GuildLevel = ($txItem->xLevel);


  $GuildArtisanclass = ($txItem->xArtisanclass);


  $GuildArtisanlevel = ($txItem->xArtisanlevel);

I can then echo it out and keep it in the proper rows. But would like to make it so I can sort by $GuildRank or so on. Wouldnt bother me if I had to insert it into the database first then sort it, but still unsure how I can keep things with the same rows.

Any suggestions would be much appreciated.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

I'm not understanding. Once you have the data pulled you just write a MySQL INSERT statment like you would any other data. You loop through the data and write to the database after you have pulled a complete row.

Posted: Sun Dec 12, 2004 1:42 pm

I was not sure if it would insert the data in rows. I tried sorting it before echoing it on the page and it threw everything out of wack. I did throw an insert in instead of the echos and it does appear to stay consistant.

Was just trying to think things threw a little bit. Still walking on my sea legs so to speak, Thanks for the reply.

PS: I get this working would you be interested in checking the code for security issues?