2 beginners questions

[astoller]

I am struggling with 2 basic questions:

$country_array = enum_options(‘usercountry’, $link_id);
When I run this script, I get undefined function enum_options

Inserting values into a mysql table called user
$result = mysql_query ( “INSERT INTO user (userid) VALUES (‘sphinx’)”);
This adds userid ok.

But if I type
$result = mysql_query ( “INSERT INTO user (userid,usercountry) VALUES (‘sphinx’),(‘Scotland’)”);
I do not get Scotland added to the database.

Help please!

[run2web]

Do you have a function named enum_options? If you do, then for some reason it isn't finding it. If you don't then that is why you are getting the error, it is looking for it.

[sglane]

About your second question. From what I gather, you want a row in your database that has the userid of sphinx and the usercountry of Scotland. If that is the case, take out the ),( betweek sphinx and scotland.

Also, if you have userid to be distinct, make sure there is no other sphinx in the table before you do that insert.

Hope this helps.