mysql_query returns just 1?

[phrosty]

Hello,

I'm kinda new to php so this may have an easy answer for it. here is my code I am having troubles with:

<?php
$email = 'hello';
$db = mysql_connect('localhost', 'test', 'test');
mysql_select_db('my_database',$db) or die (mysql_error());
$query = "INSERT INTO tblEmail (email) VALUES('$email')";
$result = mysql_query($query, $db) or die (mysql_error()) ;
echo $result;
mysql_free_result($result);
mysql_close($db);
?>

on the line where it says echo $result, it just shows 1 instead of rescource idenitfier #1 and then of course it gives me an error when i run it saying Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource. Everything is enter correctly into my database, its just the whole returning 1 thing that gets me. any help would be appritiated!

[tekky]

sometimes reading the manual proves resourceful [man]mysql_query/man

Return Values
For SELECT, SHOW, DESCRIBE or EXPLAIN statements, mysql_query() returns a resource on success, and FALSE on error.

For other type of SQL statements, UPDATE, DELETE, DROP, etc, mysql_query() returns TRUE on success and FALSE on error.

The returned result resource should be passed to mysql_fetch_array(), and other functions for dealing with result tables, to access the returned data.

(in this case, 1 being TRUE, 0 being FALSE)

[phrosty]

Wow thanks a lot, I don't know how I missed that one!