Jump to content

-*Phoenix*-

Members
  • Posts

    3
  • Joined

  • Last visited

-*Phoenix*-'s Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. Hi guys not sure whether this is in the right forum or not but here goes,Ok so im completely new to XML and ill admit i look at it and think to myself what the ....! Now ive created a database for a small RPG im helping develop and ive been asked to undertake this task using XML and DTD.Well anyway onto the problem ok so in my RPG the characters are refered to as avatars and when two avatars meet i want them to send a message to each other which will be displayed XML. I want this message to show certain fields from a table already created eg Name, Creation Date, Money, etc etc along with a small greeting message "hi friend" or whatever.Now ive got to design a DTD that describes the above message and then go on to create an XML instance document based on that.Now the instance document is not a problem i can simply use the DTD to create that but the DTD is where im drawing a blank.Ive read through the DTD tutorial on the site and am still none the wiser as to how i would create one based on my problem above.Can anyone give me any tips and tricks to creating DTD's!Cheers in advance guys!
  2. Oops sorry guys :)My bad i managed to fix it. Didnt mean to clutter the forums
  3. Ok so heres my problem ive built my DB and populated it with relevant data. Now thats where the problem begins i want to list the avatar names, strangths, species, hoard, email and gender for all the active users with an email beginning with an 'a'.Right so ive written my query exactly as below and i get the active ones with emails beginning with a but it lists every single avatar and other attributes in the avatar table not just the ones belonging to the users ive searched for! Why would it do that??I cant see any problem with my code but maybe you guys can.Thanks in advance! USE MMORPGSELECT DISTINCT u.Email, a.Avatar_Name, a.Strength, a.Hoard, a.Gender, s.Species_NameFROM RPG_User u, RPG_Avatar a, RPG_Species sWHERE u.Active = 1 AND u.Email LIKE 'a%'ORDER BY u.Email;
×
×
  • Create New...