how to insert data to database?

[endazi]

i have a problem here with my data which i can add or delete table which containing values for input.. so how can i insert all this data to database?

[Nicolas_firefly]

in MySQL you can :

mysql_query("insert into [tablename] values ('[fieldvars]....)");

[endazi]

i've tried that way.. but failed..any other way that u woluld like to suggest?

[piersk]

Can you type here the code that you tried after reading Nicolas.firefly's suggestion? Cos thats the way that you SHOULD do it, so Id like to see what you tried.

[endazi]

still failed.. can i e-mail u for a detail?

[piersk]

You wrote:

$result = mysql_query ($query,$connection );

If that has been copied and pasted exactly]/b] from your code, then there shouldnt be a space after $connection.
Try:

$result = mysql_query ($query,$connection);

[endazi]

can i e-mail you for a detail?..

[piersk]

sure, feel free

[endazi]

what's your e-mail?

[piersk]

cs11pk_at_surrey.ac.uk

[endazi]

tq,, i've sent that mail to u..but fail mail daemon.. can u just simply type your email again...

[piersk]

replace the at with the @ symbol

[endazi]

got my mail?

[piersk]

Yup, got it, ill have a look and get back to you...

[endazi]

ok tq.. i'll check tomorrow..