SearchRecent postsThe Random ToolboxDrupal 7 Setting up variables for use in a template (preprocess and process functions) Rendering Drupal 7 fields (the right way) Linux Secure Copy (scp) command Restrict Free Shipping in Magento Quickbooks Text Connection Ticket Cross-Site Request Forgery (CSRF) jQuery Events: MouseOver / MouseOut vs. MouseEnter / MouseLeave Monthly archive
|
Database Query the Drupal 6 Wayfunction referral_get_user($uid) { $referral_uid = FALSE; $result = db_query('SELECT referral_uid FROM {referral} WHERE uid = %d', $uid); while ($data = db_fetch_object($result)) { $referral_uid = $data->referral_uid; } return $referral_uid; } $nodeSrc = 'node/45'; $result = db_query("SELECT dst FROM {url_alias} u WHERE src = '%s'", $nodeSrc); while ($data = db_fetch_object($result)) { echo $data->dst; } Placeholder | Meaning |