inserting data to database?

[Lynux]

Whould anyone have any idea why this is not inserting anything to my database? I am positive the database connection is correct. here is my code.
==========================
<?php
$db = mysql_connect(&quot;localhost&quot;, &quot;root&quot;
mysql_select_db(&quot;SLIP&quot;,$db);
if (list($key, $val) = each($result))
{
$query .= &quot;mysql_query(\&quot;INSERT INTO user_competencies (com_ID, score) VALUES ($key, $val)\&quot;,$db); &quot;;
}
?>
==============================
when I echo $query I get:
mysql_query(&quot;INSERT INTO user_competencies (com_ID, score) VALUES (81, 0)&quot;,Resource id #1);
mysql_query(&quot;INSERT INTO user_competencies (com_ID, score) VALUES (82, 1)&quot;,Resource id #1);
mysql_query(&quot;INSERT INTO user_competencies (com_ID, score) VALUES (83, 2)&quot;,Resource id #1);
mysql_query(&quot;INSERT INTO user_competencies (com_ID, score) VALUES (84, 3)&quot;,Resource id #1);
mysql_query(&quot;INSERT INTO user_competencies (com_ID, score) VALUES (85, 4)&quot;,Resource id #1);
=============================

Is there something I am not doing?
Any help would be greately appreciated !

Thanks in advance!

=================================
Imagination is more important than knowledge.
(A.E.)

 

[piti]

hi
the problem is, that you are only assigning your code to the variable $query and not running it

this should work
<?php
$db = mysql_connect(&quot;localhost&quot;, &quot;root&quot;
mysql_select_db(&quot;SLIP&quot;,$db);
if (list($key, $val) = each($result))
{
mysql_query(&quot;INSERT INTO user_competencies (com_ID, score) VALUES ($key, $val)&quot;,$db);
}
?>