It took me a long time to figure this one out, so I'm going to post it in case someone else runs into this problem.

PROBLEM: When you insert a CD or DVD, SuSE 9.3 mounts it in /media/<VOLUME_LABEL_OF_DISK>. This looks cool until you want to create a symlink to it. The mounting point changes every time you put a new disk in. This becomes a real problem when using wine, where you need a symlink to the mounted drive in the dosdevices folder.

SOLUTION: Save the following script as /usr/share/hal/fdi/95userpolicy/cddcd.fdi
Code:
<?xml version="1.0" encoding="ISO-8859-1"?> <!-- -*- SGML -*- -->

<deviceinfo version="0.2">
 <device>

 <!-- Mount CD/DVD-rom drives as /media/dvd and CD/DVD Writers as /media/dvdrecorder
      instead of as /media/<<VOLUME_NAME>> -->

  <match key="@info.parent:storage.drive_type" string="cdrom">
     <match key="@info.parent:storage.policy.desired_mount_point" string="cdrom">
       <merge key="volume.policy.desired_mount_point" type="string">dvd</merge>
     </match>
     <match key="@info.parent:storage.policy.desired_mount_point" string="cdrecorder">
       <merge key="volume.policy.desired_mount_point" type="string">dvdrecorder</merge>
     </match>
   </match>

 </device>
</deviceinfo>
Reboot your computer. After that your disk will always be mounted on /media/<TYPE_OF_YOUR_DRIVE>.