$dblink = @pg_connect("host=$host port=$port dbname=$database user=$username password=$password") or die("unsuccessfully!");$sql = "select distinct fb_bacode,fb_bamodel,fb_babrand from tblb_battery where fclasscode='1' order by rand()"; $result = pg_query($dblink, $sql);while($row = pg_fetch_array($result)) { print "<li><a href=http://localhost/laptop-battery/LaptopBattery.php/$row[2]/$row[0]/$row[1]/>$row[2] $row[1] Battery</a> - $row[2] $row[1] Laptop Replacement Battery</li>"; } 出错信息: arning: pg_query() [function.pg-query]: Query failed: ERROR: function rand() does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. in D:\test.php on line 11Warning: pg_fetch_array() expects parameter 1 to be resource, boolean given in D:\test.php on line 13
lisoon((水翡草芥--突然想去扫街)):select distinct fb_bacode,fb_bamodel,fb_babrand from tblb_battery where fclasscode=1 order by random() limit 10这样写还是出错
$link = @pg_connect("host=$host port=$port dbname=$database user=$username password=$password") or die("unsuccessfully!");$sql = "select distinct fb_bacode,fb_bamodel,fb_babrand from tblb_battery where fclasscode=1 order by random() limit 10"; $result = pg_query($sql); while($row = pg_fetch_array($result)) { print "<a href=/laptop-battery/LaptopBattery.php/$row[2]/$row[0]/$row[1]/>$row[2] $row[1]</a><br>"; }Warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in D:\test.php on line 11Warning: pg_fetch_array() expects parameter 1 to be resource, boolean given in D:\test.php on line 12
$result = pg_query($dblink, $sql);while($row = pg_fetch_array($result))
{
print "<li><a href=http://localhost/laptop-battery/LaptopBattery.php/$row[2]/$row[0]/$row[1]/>$row[2] $row[1] Battery</a> - $row[2] $row[1] Laptop Replacement Battery</li>";
}
出错信息:
arning: pg_query() [function.pg-query]: Query failed: ERROR: function rand() does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. in D:\test.php on line 11Warning: pg_fetch_array() expects parameter 1 to be resource, boolean given in D:\test.php on line 13
$result = pg_query($sql);
while($row = pg_fetch_array($result))
{
print "<a href=/laptop-battery/LaptopBattery.php/$row[2]/$row[0]/$row[1]/>$row[2] $row[1]</a><br>";
}Warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in D:\test.php on line 11Warning: pg_fetch_array() expects parameter 1 to be resource, boolean given in D:\test.php on line 12