Database Query the Drupal 6 Way

function 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
%s | String
%d | Integer
%b | Binary
%% | Inserts a literal % sign
%f | Float