function get_remote_ip()
{
if (!empty($_SERVER["HTTP_CDN_SRC_IP"]) )
{
if (!empty($_SERVER["HTTP_CLIENT_IP"]) )
{
$ip = $_SERVER["HTTP_CLIENT_IP"];
sql之left join、right join、inner join的区别转自http://www.cnblogs.com/pcjim/articles/799302.html
left join(左联接) 返回包括左表中的所有记录和右表中联结字段相等的记录
right join(右联接) 返回包括右表中的所有记录和左表中联结字段相等的记录
<UL>
<?php
$result = db_query("select n.nid from {term_node} tn, {node} n where tn.nid = n.nid and tn.tid = 14 ORDER BY nid DESC LIMIT 0,10");
var str = "a.php/keyword/地方";
geturl=encodeURI(str);
$("#xuanze").load(geturl);
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
node.module的1798行
$result = db_query_range("SELECT n.nid FROM {node} n LEFT JOIN {search_dataset} d ON d.type = 'node' AND d.sid = n.nid WHERE n.type = 'news' or n.type = 'life' or n.type = 'og' and d.sid IS NULL OR d.reindex <> 0 ORDER BY d.reindex ASC, n.nid ASC", 0, $limit);
while ($node = db_fetch_object($result)) {
print_r($node);
//exit();
_node_index_node($node);
}
