Also, you should consider using placeholders for the data that you're inserting into {user_profile_fields}. :)

db_query("INSERT INTO {user_profile_fields} (uid, username […]) VALUES (%d, '%s')", $uid, $username);

Regards, Todd

On 11 Jan 2012, at 16:13, robert mena wrote:

For some reason one of my queries is not executing. I've used the db_error() but I only get 0. I'd like to know how can I get the error message.

I am using drupal 6, MySQL.

$success = db_query("INSERT INTO {user_profile_fields} (uid, username, id_center, telephone, street, city, distt, country, zip) VALUES ('$uid', '$username', '$idcenter', '$telephone', '$street', '$city', '$district', '$country', '$zip')"); if(!$success) { // here I am using the $error = db_error(); }

Regards.

[ Drupal support list | http://lists.drupal.org/ ]

On Wed, Jan 11, 2012 at 4:13 PM, robert mena robert.mena@gmail.com wrote:

For some reason one of my queries is not executing.  I've used the db_error() but I only get 0.    I'd like to know how can I get the error message.

I am using drupal 6, MySQL.

$success = db_query("INSERT INTO {user_profile_fields} (uid, username, id_center, telephone, street, city, distt, country, zip) VALUES ('$uid', '$username', '$idcenter', '$telephone', '$street', '$city', '$district', '$country', '$zip')");  if(!$success) {     // here I am using the $error = db_error();  }

I've found that the return value isn't dependable to check for errors from db_query.

Something more like

$error = db_error(); if (!($row = db_fetch_object($success))) { // Do error routine. }

Might work for you.