This cable can only be called as "floppy cable with connectors for 5.25 drives" or "old style floppy cable" AFAIK, I can't recall any special names for it, and yes, you can use a simpler one with two 3.5 connectors only,

In any case, if the drive is designated as drive A in the BIOS, it must be connected after the twist. In the picture you attached, the place of the 3.5 drive A is correct.

There is no standart (in general) in which way to connect the connector to a 3.5 floppy drive though, but it's a simple matter of trial and error, there are only two possibilities at the end.

Hint: If the drive led is illuminated as soon as the system is powered up and stays illuminated, then the cable is incorrectly connected, try the other way around.

I replaced the cable with a modern 1pc one and now the 3.5" floppy works OK.
- I think the old style 4pcs wire was faulty ?

I think the same as tayyare. Looks like an ordinary floppy cable from the late 80s/early 90s.
It should support two floppy drives, with either a modern or classic connector (edge connector).
If there''s a coloured cable (often red) on one side of the ribbon cable, then it is marking the side were the "1" pin of the floppy drives usually goes to.