if dont know how many columns in a table

[Dakkar]

I have a problem about mysql

if i dont know how many columns are there in a table
for example i only want to write datas into 4 columns and the rest of them will be entered their default datas is this possible?

i tried something like this but it didnt work

@mysql_query("insert into pvp.bnet values('$sonuc','$u_name','$sonuc','$sifre','$mail')");

Thanks

[devinemke]

use this syntax and simply leave out the default fields:

INSET INTO table SET 
field1 = 'value1',
field2 = 'value2',
field3 = 'value3'

[Dakkar]

I made my code like this

@mysql_query("insert into pvp.bnet set uid='$sonuc',acct_username='$u_name',acct_userid='$sonuc',acct_passhash1='$sifre',acct_email='$mail')");

but its not entering the datas to mysql

[devinemke]

mysql_query("INSERT INTO pvp.bnet SET 
uid = '$sonuc', 
acct_username = '$u_name', 
acct_userid = '$sonuc', 
acct_passhash1 = '$sifre',
acct_email = '$mail'") or exit(mysql_error());

[Dakkar]

Thanks