speaking for debian: look in /etc/network/interfaces, there you will find something like
Code:
auto eth0
iface eth0 inet dhcp
or something along that line
remove (or comment out) the first line, to read
Code:
#auto eth0
iface eth0 inet dhcp
for mandrake: i have no idea where that file is located, a guess would be /etc/sys/net or something like that
you could grep for 'auto eth0' or or read some man pages or something like that...