|"i deleted both partitions rebooted then got NTLDR missing"|
You should not have rebooted. You should have deleted all partitions, then repartitioned immediately, then formated & continued with the installation.
Double check your boot order setting in the BIOS. If you have a floppy drive, the order should be floppy, CD drive, HDD. The "PXE-E61 media test failure" means that the system checked these 3 devices & found that they're unbootable, so it moved on to a 4th option - attempting to boot off a network. You don't have a network, therefore you're getting the error message & the prompt to check the cable. Disable the network boot option.
Remember that you need to "press any key" to be able to boot off the XP disk. If you don't, the system will bypass the CD drive.