By jarobinson1c on

This is a simple feature that I want to be able to use many times, detect if a record exists or not. I know how to do this in regular PHP and MySQL but not in Drupal's Database Abstraction Layer. There has been many times I wanted to do some PHP hacks but I'm trying to do things the Drupal way so future developers of my site don't have to learn Drupal and my hacks.

⋅ Categories: Drupal 6.x

Comments

nevets’s picture

nevets commented

db_query() take a SQL statement so you can use that to run a SELECT query.

jarobinson1c’s picture

jarobinson1c commented

This is what I have

    $count = db_result(db_query('SELECT * FROM {cdn_webfm_ext} WHERE uid = %d', $user->uid));

My understanding is this is supposed to return 0 because the table is empty or the record dose not exist. It returns nothing.

This returns "Resource id #109", what the heck?

$result = db_query('SELECT * FROM {cdn_webfm_ext} WHERE uid = %d', $user->uid);
jaypan’s picture

jaypan
Location Victoria, BC
commented

That's because the second one is a mysql result. It doesn't become a value until you use db_fetch_array() or db_fetch_object() to extract the data from the resource.

Anyways, to find if something exists, you can use this:

    $exists = db_result(db_query('SELECT 1 FROM {cdn_webfm_ext} WHERE uid = %d', $user->uid));

$exists will be true if the record exists, false if it doesn't.

Contact me to contract me for D7 -> D10/11 migrations.

jarobinson1c’s picture

jarobinson1c commented

Thanks! It worked.