***แก้หัวข้อที่พิมพ์ผิดครับ ควรแก้ยังไงดีครับ Error have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
ควยแก้ยังไงดีครับ Error have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(end_date,'//') AS ndate from item where > now() order by item_id DESC L' at line 1
Code (PHP) <?php
session_start();
?>
<!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?php
include ("header.inc.php");
include ("dbconn.inc.php");
include("paging.inc.php");
$current_page = 1 ;
if (isset ($_GET['page'] )) {
$current_page = $_GET['page'];
}
$rows_per_page = 10;
$start_row = paging_start_row($current_page,$rows_per_page);
$sql = "select sql_calc_found_rows *, DATE FORMAT ('end_date','$d/$m/$y') AS ndate
from item where > now() order by item_id
DESC LIMIT $start_row,$rows_per_page;";
$result = mysql_query ($sql) or die(mysql_error());
$found_rows = mysql_query ("select found_rows ();");
$total_rows = mysql_result ($found_rows,0,0);
if (mysql_num_rows($result) == 0 ) {
echo "<p align='center'>ไม่พบรายการที่เปิดประมูล</p></body></html>";
exit;
}
echo "<table align='center'><tr bgcolor='#0000FF'><th width=50><รูปภาพ</th>";
echo "<th width=250><ชื่อรูปภาพ</th><th width=100>ราคาปัจจุบัน</th>";
echo "<th width=100><วันปิดประมูล</th></tr>";
while($data = mysql_fetch_array($result)) {
$id =$data ['item_id'];
$mysql = "SELECT MAX (offer) from bid where item_id = $id";
$r=mysql_query($sql);
$cur_price = mysql_result ($r,0,0);
if (empty($cur_price)) {
$cur_price=$data['starting_price'];
}
echo"<tr valign=top><td><img width=30 src=read_img.php?item_id=$id/></td>";
echo "<td><a href='item_detail.php?item_id=".$id."'>{".$data['item_name']."}</a></td>";
echo "<td align='center'>".$cur_price."</td><td align='center'>{".$data ['ndata']."}</td>";
echo "</tr>";
}
echo"<tr><td colspan=4 align=center>";
$page_range=5;
$qry_str="";
$total_pages=pading_total_pages($total_rows,$rows_per_page);
$pagenum= paging_pagenum($current_page,$total_pages,$page_range,$qry_str);
echo"หน้า".$pagenum;
echo"</td></tr></table>";
?>
</body>
</html>
Code (PHP) <?php
@mysql_connect("localhost","root","root") or die (mysql_error());
mysql_query ("create database Project;");
mysql_select_db("project");
$sql = "create table user (
user_id INT unsigned auto_increment primary key ,
login varchar(100) unique,
password varchar(20),
user_name varchar(50) unique);";
$mysql_query($sql) or die (mysql_error());
$sql="creata table item(
item_id INt unsigned auto_increment primary key,
user_id INt unsigned,
Item_name varchar(100),
description text,
starting_price MediumInt unsigned,
end_date date,
notified tinyint);";
$mysql_query($sql) or die (mysql_error());
$sql="create table bid (
bid_id INT unsigned auto_increment primary key,
item_id INT unsigned,
user_id INT unsigned,
offer int unsigned);";
$mysql_query($sql) or die (mysql_error());
$sql="create table img (
img_id INT UNsigned auto_increment primary key,
item_id INt unsigned,
type varchar(150),
content mediumblob);";
$mysql_query($sql) or die (mysql_error());
?>
Tag PHP, MySQL
ประวัติการแก้ไข
Date :
2013-02-03 11:28:18By :
opndangeloView :
1336Reply :
8
Date format syntax ไม่ถูกครับ แก้ตามนี้ดู(PHP) $sql = "select sql_calc_found_rows *, DATE FORMAT ('end_date','%d/%m/%y') AS ndate from item where > now() order by item_id DESC LIMIT $start_row,$rows_per_page";
อ่อ...แล้วก็แก้ชื่อกระทู้ด้วยครับ
ประวัติการแก้ไข
Date :
2013-02-03 11:49:46By :
mangkunzo
แล้วไมต้องมีคำหยาบด้วยครับ...รอ ท่านคุณ mr.win มาพิจารณาครับ.......
ประวัติการแก้ไข
Date :
2013-02-03 11:51:36By :
apisitp
ผมแนะนำก่อนตั้งกระทู้ควรตรวจสอบความถูกต้องก่อนนะ
Date :
2013-02-03 11:59:30By :
weaned
ขอโทษด้วยเช่นกัน ...
Date :
2013-02-03 12:14:57By :
apisitp
Server 04
Load balance : Server 04
