Forgot Password ??

PHP , ASP , ASP.NET, VB.NET, C#, Java , jQuery , Android , iOS , Windows Phone

	Registered : 109,037

HOME > PHP > PHP Forum > Warning: mysql_num_rows(): Warning: mysql_num_rows(): supplied argument is not a valid MySQL result

Warning: mysql_num_rows(): Warning: mysql_num_rows(): supplied argument is not a valid MySQL result

เริ่มหัวข้อใหม่

Guest

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/fhlinux202/j/jungleton.com/user/htdocs/phpauction/index.php on line 340
Database access error. Please contact the site administrator.

แก้ย้งไงดีคะ นี่คือ โค๊ดคะ ช่วยหน่อยเด้อ ค่ะ ขอบคุณคะ

<?

/*

Copyright (c), 1999, 2000 - phpauction.org

This program is free software; you can redistribute it and/or modify

it under the terms of the GNU General Public License as published by

the Free Software Foundation (version 2 or later).

This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

GNU General Public License for more details.

You should have received a copy of the GNU General Public License

along with this program; if not, write to the Free Software

Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.

*/

require('./includes/config.inc.php');

require('./includes/messages.inc.php');

require("./header.php");

/*

If subscription to information service requested

update INFO table

*/

$TPL_info_err = "";

if($user_email){

if(!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+([\.][a-z0-9-]+)+$",$user_email)){

$TPL_info_err = $ERR_028;

}else{

$query = "insert into info values(\"$user_email\")";

$result = mysql_query($query);

if(!$result){

$TPL_info_err = $ERR_001;

}else{

$TPL_info_err = $MSG_512;

}

}

}

/*

prepare data for templates/template

*/

/* prepare categories list for templates/template */

$TPL_categories_value = "";

$query = "select * from categories WHERE parent_id=0 order by sub_counter desc";

$result = mysql_query($query);

if(!$result)

{

$TPL_categories_value .= $ERR_001;

}

else

{

$num_cat = mysql_num_rows($result);

$i = 0;

$TPL_categories_value .= "<TABLE BORDER=0>\n";

while($i < $num_cat && $i < 23)

{

$cat_id = mysql_result($result,$i,"cat_id");

$cat_name = mysql_result($result,$i,"cat_name");

$sub_count = intval(mysql_result($result, $i, "sub_counter"));

$cat_colour = mysql_result($result, $i, "cat_colour");

$cat_image = mysql_result($result, $i, "cat_image");

# print $sub_count." ";

$cat_counter = (int)mysql_result($result, $i, "counter" );

if ($sub_count!=0)

$cat_counter = "(".$sub_count.")";

else

{

$cat_counter = "";

/*

if ($cat_counter!=0)

{

$count_string = "(".$cat_counter.")";

}

else

$count_string = "";

*/

}

$cat_url = "./browse.php?id=$cat_id&SESSION_ID=$sessionIDU";

$TPL_categories_value .= "<TR>\n<TD>";
if ( $cat_image != "")
{
$TPL_categories_value .= "<IMG SRC=\"$cat_image\">";
}
$TPL_categories_value .= "</TD>\n";

if ( $cat_colour != "")
{
$TPL_categories_value .= "<TD BGCOLOR=\"$cat_colour\">";
}
else
{
$TPL_categories_value .= "<TD>";
}

$TPL_categories_value .= "$std_font";

//$cat_name = ereg_replace ( " ", " ", $cat_name );

$TPL_categories_value .= " <A HREF=\"$cat_url\">$cat_name</A>"." $cat_counter"."</TD></TR>\n";

$i++;

}

$TPL_categories_value .= "</TABLE>\n";

$TPL_categories_value .= "<A HREF=\"browse.php?id=0&SESSION_ID=$sessionIDU\">$std_font$MSG_277 </A>";

}

/* get last created auctions */

$query = "select id,title,starts from auctions where closed='0' order by starts desc";

$result = mysql_query($query);

if ( $result )

$num_auction = mysql_num_rows($result);

else

$num_auction = 0;

$i = 0;

$bgcolor = "#FFFFFF";

$TPL_last_auctions_value = "";

while($i < $num_auction && $i < 6){

if($bgcolor == "#FFFFFF")

{

$bgcolor = "#EEEEEE";

}

else

{

$bgcolor = "#FFFFFF";

}

$title = mysql_result($result,$i,"title");

$id = mysql_result($result,$i,"id");

$date = mysql_result($result,$i,"starts");

$year = substr($date,0,4);

$month = substr($date,4,2);

$day = substr($date,6,2);

$hours = substr($date,8,2);

$minutes = substr($date,10,2);

$seconds = substr($date,12,2);

$TPL_last_auctions_value .=

"<TR BGCOLOR=\"$bgcolor\">".

"<TD WIDTH=\"150\" VALIGN=top ALIGN=LEFT>".

"$std_font".

ArrangeDate($day,$month,$year,$hours,$minutes).

"</TD>".

"<TD WIDTH=\"245\" VALIGN=top ALIGN=LEFT>".

"$std_font".

"<A HREF=\"./item.php?id=$id&SESSION_ID=$sessionIDU\">".stripslashes($title)."</A>".

"</TD>".

"</TR>";

$i++;

}

if($num_auction > 6)

{

$TPL_last_auctions_value .= "<TR ALIGN=RIGHT>".

"<TD></TD><TD>".

"<A HREF=\"./view_more_news.php?SESSION_ID=$sessionIDU\">$sml_font$MSG_233</A>...".

"</TD>".

"</TR>";

}

/* get ending soon auctions */

$TPL_ending_soon_value = "";

$now = date("YmdHis",time());

$query = "select ends,id,title from auctions where closed=\"0\" and
suspended=\"0\" order by ends";
$result = mysql_query($query);

$num_auction = mysql_num_rows($result);

$i = 0;

$bgcolor = "#FFFFFF";

while($i < $num_auction && $i < 6){

if($bgcolor == "#FFFFFF")

{

$bgcolor = "#EEEEEE";

}

else

{

$bgcolor = "#FFFFFF";

}

$title = mysql_result($result,$i,"title");

$id = mysql_result($result,$i,"id");

$ends = mysql_result($result,$i,"ends");

$year = intval(date("Y"));

$month = intval(date("m"));

$day = intval(date("d"));

$hours = intval(date("H"));

$minutes = intval(date("i"));

$seconds = intval(date("s"));

$ends_year = substr($ends,0,4);

$ends_month = substr($ends,4,2);

$ends_day = substr($ends,6,2);

$ends_hours = substr($ends,8,2);

$ends_minutes = substr($ends,10,2);

$ends_seconds = substr($ends,12,2);

$difference = intval(mktime($ends_hours,$ends_minutes,$ends_seconds,$ends_month,$ends_day,$ends_year)) - intval(mktime($hours,$minutes,$seconds,$month,$day,$year));

if ($difference > 0) {

$ends_string = intval($difference / 86400).$MSG_126;

$difference = $difference - (intval($difference / 86400)
* 86400);

$hours_difference = intval($difference / 3600);

if(strlen($hours_difference) == 1){

$hours_difference = "0".$hours_difference;

}

$ends_string .= $hours_difference.":";

$difference = $difference - ($hours_difference * 3600);

$minutes_difference = intval($difference / 60);

if(strlen($minutes_difference) == 1){

$minutes_difference = "0".$minutes_difference;

}

$ends_string .= $minutes_difference.":";

$difference = $difference - ($minutes_difference * 60);

$seconds_difference = $difference;

if(strlen($seconds_difference) == 1){

$seconds_difference = "0".$seconds_difference;

}

$ends_string .= $seconds_difference;

} else {

$ends_string = "$err_font$MSG_911";
}

$TPL_ending_soon_value .=

"<TR BGCOLOR=\"$bgcolor\">".

"<TD WIDTH=\"140\" VALIGN=top ALIGN=LEFT>".

"$std_font".$ends_string."".

"</TD>".

"<TD WIDTH=\"250\" VALIGN=top ALIGN=LEFT>".

"$std_font<A HREF=\"./item.php?id=$id&SESSION_ID=$sessionIDU\">".stripslashes($title)."</A>".

"</TD>".

"</TR>";

$i++;

}

if($num_auction > 6)

{

$TPL_ending_soon_value .= "<TR ALIGN=RIGHT>".

"<TD></TD><TD>".

"<A HREF=\"./view_more_ending.php?SESSION_ID=$sessionIDU\">$sml_font$MSG_233</A>...".

"</TD>".

"</TR>";

}

/* get higher bids */

$TPL_maximum_bids = "";

$query = "select auction,max(bid) as max_bid from bids group by auction order by max_bid desc";

$result = mysql_query($query);

if ($result)

$num_auction = mysql_num_rows($result);

else

$num_auction = 0;

$i = 0;
$j = 0;

$bgcolor = "#FFFFFF";

while($i < $num_auction && $j < 6)
{

$max_bid = mysql_result($result,$i,"max_bid");

$auction = mysql_result($result,$i,"auction");

//-- Get auction data

$query = "select title,closed,id from auctions where id=\"$auction\"";

$result_bid = mysql_query($query);

if(mysql_num_rows($result_bid) > 0)
{
$title = mysql_result($result_bid,0,"title");

$closed = mysql_result($result_bid,0,"closed");

$auc_id = mysql_result($result_bid,0,"id");
}

if($closed == "0"){

$TPL_maximum_bids .=

"<TR BGCOLOR=\"$bgcolor\">".

"<TD WIDTH=\"140\" VALIGN=top ALIGN=LEFT>".

"$std_font".

print_money($max_bid).

"</TD>".

"<TD ALIGN=LEFT WIDTH=\"240\">".

"$std_font".

"<A HREF=\"./item.php?id=".$auc_id."&SESSION_ID=$sessionIDU\">".stripslashes($title)."</A>".

"</TD>".

"</TR>";
$j++;
if($bgcolor == "#FFFFFF")

{

$bgcolor = "#EEEEEE";

}

else

{

$bgcolor = "#FFFFFF";

}

}

$i++;

}

if($num_auction > 6)

{

$TPL_maximum_bids .= "<TR ALIGN=RIGHT>".

"<TD></TD><TD>".

"<A HREF=\"./view_more_higher.php\">$sml_font$MSG_233</A>...".

"</TD>".

"</TR>";

}

// Build list of help topics
$query = "select topic from help order by topic;";
$result = mysql_query($query);
if (!$result){
print "$err_font $ERR_001 ";
require("./footer.php");
exit;
}
if (mysql_num_rows($result)) {
$TPL_helptopics = "<a href=\"help.php\">" . $MSG_919 . "</a> ";
$num_topics = mysql_num_rows($result);
$i = 0;
while(($i < $num_topics) && ($i < 5)){
$this_topic = mysql_result($result, $i, "topic");
if ($this_topic != "General") {
$TPL_helptopics .= "<a href=\"help.php?topic=";
$TPL_helptopics .= $this_topic;
$TPL_helptopics .= "\">";
$TPL_helptopics .= $this_topic;
$TPL_helptopics .= " ";
}
$i++;
}
} else {
$TPL_helptopics = "";
}

//-- Build news list
if($NEWS_BOX)
{
$query = "SELECT title,id from news where suspended=0 order by new_date limit $NEWS_TO_SHOW";
$res = mysql_query($query);
if(!$res)
{
$TPL_news_list = $ERR_001;
exit;
}

while($new = mysql_fetch_array($res))
{
$TPL_news_list .= "<big>ท</big>
$sml_font<A HREF=\"viewnew.php?id=$new[id]\">$new[title]</A> ";
}
}

require("./templates/template_index_php.html");

require('./footer.php');

?>

Tag : - - - -

Date : 28 ก.ค. 2548 23:37:52

By : พัชรี

View : 2491

Reply : 4

No. 1

Guest

ใครก็ได้ช่วยทีคะ ฅิดอยู่ฅรงนี้ไปไหนไม่ได้ จริงๆ

Date : 29 ก.ค. 2548 17:11:07

By : พัชรี

No. 2

Guest

ถ้า line 340
คือ $num_auction = mysql_num_rows($result);

Date : 29 ก.ค. 2548 17:44:29

By : พ้ชรี

No. 3

Guest

เช็คคำสั่ง mysql ตอน คิวรีให้ดี คำสั่งอาจผิดหลักไวยากรณ์ ไม่มีเวลาไล่โค้ดให้ ..

Date : 30 ก.ค. 2548 08:38:26

By : หำแหล่

No. 4

Guest

connect database หรือยัง หรือไม่ก้อ sql statement ผิดคะ ลองตรวจดูก่อนว่าพิมพ์ใส่ผิดฟิลด์หรือเปล่า
ลอง echo พวกตัวแปรดูนะคะ

Date : 9 พ.ค. 2549 19:07:07

By : กุ๊ก

ค้นหาข้อมูล

แสดงความคิดเห็น

Re : Warning: mysql_num_rows(): Warning: mysql_num_rows(): supplied argument is not a valid MySQL result

รายละเอียด

เพื่อความเรียบร้อยของข้อความ ควรจัดรูปแบบให้พอดีกับขนาดของหน้าจอ เพื่อง่ายต่อการอ่านและสบายตา และตรวจสอบภาษาไทยให้ถูกต้อง

อัพโหลดแทรกรูปภาพ

Notice

เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ
อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง

เพื่อความปลอดภัยและการตรวจสอบ กระทู้ที่แทรกไฟล์อัพโหลดไฟล์จากที่อื่น อาจจะถูกลบทิ้ง

โดย

อีเมล์

บวกค่าให้ถูก