insert 'values'

[rahaiffi]

i try to insert data with value...first i have to insert data from user...

this is my coding....

$query = "INSERT INTO mohon VALUES ('','$nama','$bahagian','$tarikh','$masa','$namapengguna','$bil','$tujuan',
			'$tarikhprj','$destinasi','$jam','$minit','$waktu','$jam2','$minit2','$waktu2')";
			$result = mysql_db_query($dbname,$query);

i have 1 field(status) to insert with a value..how can i coding to insert data with a values.....

[jansky]

you might want to change to

$query="insert into mohon (fieldlisting,field1,field2,etcc) VALUES ('YOURVALUES','VALUES1','ETCC..')"
$result=mysql_query($query) or die (mysql_error());

in this case you may insert your value properly