Database operations

To fetch one result row

$sql = "SELECT * FROM {users} WHERE uid = %d";
$row = db_fetch_object(db_query($sql, 1));
if(!empty($row)){	
	print $row->name;
}

To iterate over a set

$sql = "SELECT name FROM {users} WHERE uid > %d";
$result = db_query($sql, 1);
while ( $row = db_fetch_object ($result) ) {
	print $row->name;
}