NameSilo

Mysql errors, PLEASE HELP

SpaceshipSpaceship
Watch
domainer50

domainer50

VIP Member
VIP
★ 15 ★
Impact
38
www.dailydrinker.com

Click one of the categories on the left or recipes in the center and you get many mysql errors. Whats going on>???
 
Reply
0
0 Like
0 Thanks
•••
The views expressed on this page by users and staff are their own, not those of NamePros.
AfternicAfternic
Sort by date Sort by points
Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/dailydri/public_html/category.php on line 25

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/dailydri/public_html/category.php on line 49
Click to expand...

Care to post the code for category.php?
 
Reply
0
0 Like
0 Thanks
•••
<?php include("rheader.php"); ?>

<?php

$letter = $_REQUEST['letter'];
$numeric = $_REQUEST['numeric'];

if ($letter) {

$sql = "select drinkid, title, date, rating from drinks where title like '$letter%' and status = 'L'";

} else {

$sql = "select drinkid, title, date, rating from drinks where categoryid = $catid and status = 'L'";

}

if ($numeric == "all") {
$sql = "select drinkid, title, date, rating from drinks where title REGEXP '^[1234567890]' and status = 'L'";
}



$result = mysql_query($sql ,$db);
$numrows = mysql_numrows($result);

$lastpage = false;

if ($pagenum == 0) {
$startrow = 0;
} else {
$startrow = 25 * $pagenum;
}

if ($numrows < $startrow + 25) {
$endrow = $numrows;
$lastpage = true;
}

if ($letter) {

$sql = "select drinkid, title, date, rating from drinks where title like '$letter%' and status = 'L' order by title limit $startrow,25";
$pagetitle = "Drinks starting in the letter '$letter'";

} else {

$sql = "select * from categories where categoryid = $catid";
$result = mysql_query($sql ,$db);
$row = mysql_fetch_row($result);
$pagetitle = $row[1];

$sql = "select drinkid, title, date, rating from drinks where categoryid = $catid and status = 'L' order by title limit $startrow,25";

}

if ($numeric == "all") {
$sql = "select drinkid, title, date, rating from drinks where title REGEXP '^[1234567890]' and status = 'L' order by title limit $startrow,25";
$pagetitle = "Drinks starting in numbers";
}


?>


<TD VALIGN=top width="60%" BGCOLOR="FFFFFF">

<TABLE BORDER=0 WIDTH=99% ALIGN=CENTER>
<TR>

<TD VALIGN=top>

<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100% BGCOLOR=000000>
<TR><TD align=center><FONT SIZE=2 FACE="Verdana,arial,helvetica" color=white><B><?php printf($pagetitle); ?></B></FONT></TD></tR>
</TABLE>

<FONT SIZE=2>

<center>
<br>

<table cellspacing=0 cellpadding=2 border=0>
<tr>
<th width=300 bgcolor=#CCCCCC align=center><FONT face=arial size=2>Drink</font></th>
<th width=85 bgcolor=#CCCCCC align=center><FONT face=arial size=2>Date Added</font></th>
<th width=75 bgcolor=#CCCCCC align=center><FONT face=arial size=2>Rating</font></th>
</tr>

<?php

$rowcolor = 1;

$result = mysql_query($sql ,$db);

if ($myrow = mysql_fetch_array($result)) {

do {

if ($rowcolor == 1) {
$rowcolorhex = "#ffffff";
$rowcolor = 0;
} else {
$rowcolorhex = "#EDEAB9";
$rowcolor = 1;
}


printf("<tr>");
printf("<td width=300 bgcolor=%s align=center><FONT face=arial size=2><a href=drink.php?drinkid=%s>%s</a></font></td>", $rowcolorhex, $myrow["drinkid"], $myrow["title"]);
printf("<td width=80 bgcolor=%s align=center><FONT face=arial size=2>%s</font></td>", $rowcolorhex, $myrow["date"]);
printf("<td width=75 bgcolor=%s><table bgcolor=%s border=0 cellspacing=0 cellpadding=0><tr>", $rowcolorhex, $rowcolorhex);

$onstars = round($myrow["rating"]);
$offstars = 5 - $onstars;

for ($i = 1; $i <= $onstars; $i++) {
printf("<td width=15 bgcolor=%s align=center valign=center><FONT face=arial size=2><img src=images/staron2.gif></font></td>", $rowcolorhex);
}

for ($f = 1; $f <= $offstars; $f++) {
printf("<td width=15 bgcolor=%s align=center valign=center><FONT face=arial size=2><img src=images/staroff2.gif></font></td>", $rowcolorhex);
}

printf("</tr></table></td>");
printf("</tr>");
} while ($myrow = mysql_fetch_array($result));

}

printf("<tr>");
if ($startrow > 0) {
printf("<td align=left><FONT face=arial size=2><a href=category.php?pagenum=%s&searchingred=%s&catid=%s&letter=%s>Previous Page</a></font></td>", $pagenum-1, $searchingred, $catid, $letter);
} else {
printf("<td> </td>");
}
printf("<td> </td>");
if ($lastpage == false) {
printf("<td align=left><FONT face=arial size=2><a href=category.php?pagenum=%s&searchingred=%s&catid=%s&letter=%s>Next Page</a></font></td>", $pagenum+1, $searchingred, $catid, $letter);
} else {
printf("<td> </td>");
}
printf("</tr>");

?>
</table>
</center>

</FONT>

</TD></TR></TABLE>

</TD>

<?php include("rfooter.php"); ?>
 
Reply
0
0 Like
0 Thanks
•••
Your SQL queries have a problem somewhere.

Change both instances of
$result = mysql_query($sql ,$db);
to
$result = mysql_query($sql ,$db) or die(mysql_error());

This will show you the error messages being returned from MySQL which will help troubleshoot.
 
Reply
0
0 Like
0 Thanks
•••
Post your SQL structure?
 
Reply
0
0 Like
0 Thanks
•••
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and status = 'L'' at line 1

is the new error. Does this mean the server does not support it???
 
Reply
0
0 Like
0 Thanks
•••
Try:

<?php include("rheader.php"); ?>

<?php

$letter = $_REQUEST['letter'];
$numeric = $_REQUEST['numeric'];

if ($letter) {

$sql = "select drinkid, title, date, rating from drinks where title like '".$letter."%' and status = 'L'";

} else {

$sql = "select drinkid, title, date, rating from drinks where categoryid = '".$catid."' and status = 'L'";

}

if ($numeric == "all") {
$sql = "select drinkid, title, date, rating from drinks where title REGEXP '^[1234567890]' and status = 'L'";
}



$result = mysql_query($sql ,$db);
$numrows = mysql_numrows($result);

$lastpage = false;

if ($pagenum == 0) {
$startrow = 0;
} else {
$startrow = 25 * $pagenum;
}

if ($numrows < $startrow + 25) {
$endrow = $numrows;
$lastpage = true;
}

if ($letter) {

$sql = "select drinkid, title, date, rating from drinks where title like '$letter%' and status = 'L' order by title limit $startrow,25";
$pagetitle = "Drinks starting in the letter '$letter'";

} else {

$sql = "select * from categories where categoryid = $catid";
$result = mysql_query($sql ,$db);
$row = mysql_fetch_row($result);
$pagetitle = $row[1];

$sql = "select drinkid, title, date, rating from drinks where categoryid = $catid and status = 'L' order by title limit $startrow,25";

}

if ($numeric == "all") {
$sql = "select drinkid, title, date, rating from drinks where title REGEXP '^[1234567890]' and status = 'L' order by title limit $startrow,25";
$pagetitle = "Drinks starting in numbers";
}


?>


<TD VALIGN=top width="60%" BGCOLOR="FFFFFF">

<TABLE BORDER=0 WIDTH=99% ALIGN=CENTER>
<TR>

<TD VALIGN=top>

<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100% BGCOLOR=000000>
<TR><TD align=center><FONT SIZE=2 FACE="Verdana,arial,helvetica" color=white><B><?php printf($pagetitle); ?></B></FONT></TD></tR>
</TABLE>

<FONT SIZE=2>

<center>
<br>

<table cellspacing=0 cellpadding=2 border=0>
<tr>
<th width=300 bgcolor=#CCCCCC align=center><FONT face=arial size=2>Drink</font></th>
<th width=85 bgcolor=#CCCCCC align=center><FONT face=arial size=2>Date Added</font></th>
<th width=75 bgcolor=#CCCCCC align=center><FONT face=arial size=2>Rating</font></th>
</tr>

<?php

$rowcolor = 1;

$result = mysql_query($sql ,$db);

if ($myrow = mysql_fetch_array($result)) {

do {

if ($rowcolor == 1) {
$rowcolorhex = "#ffffff";
$rowcolor = 0;
} else {
$rowcolorhex = "#EDEAB9";
$rowcolor = 1;
}


printf("<tr>");
printf("<td width=300 bgcolor=%s align=center><FONT face=arial size=2><a href=drink.php?drinkid=%s>%s</a></font></td>", $rowcolorhex, $myrow["drinkid"], $myrow["title"]);
printf("<td width=80 bgcolor=%s align=center><FONT face=arial size=2>%s</font></td>", $rowcolorhex, $myrow["date"]);
printf("<td width=75 bgcolor=%s><table bgcolor=%s border=0 cellspacing=0 cellpadding=0><tr>", $rowcolorhex, $rowcolorhex);

$onstars = round($myrow["rating"]);
$offstars = 5 - $onstars;

for ($i = 1; $i <= $onstars; $i++) {
printf("<td width=15 bgcolor=%s align=center valign=center><FONT face=arial size=2><img src=images/staron2.gif></font></td>", $rowcolorhex);
}

for ($f = 1; $f <= $offstars; $f++) {
printf("<td width=15 bgcolor=%s align=center valign=center><FONT face=arial size=2><img src=images/staroff2.gif></font></td>", $rowcolorhex);
}

printf("</tr></table></td>");
printf("</tr>");
} while ($myrow = mysql_fetch_array($result));

}

printf("<tr>");
if ($startrow > 0) {
printf("<td align=left><FONT face=arial size=2><a href=category.php?pagenum=%s&searchingred=%s&catid=%s&letter=%s>Previous Page</a></font></td>", $pagenum-1, $searchingred, $catid, $letter);
} else {
printf("<td> </td>");
}
printf("<td> </td>");
if ($lastpage == false) {
printf("<td align=left><FONT face=arial size=2><a href=category.php?pagenum=%s&searchingred=%s&catid=%s&letter=%s>Next Page</a></font></td>", $pagenum+1, $searchingred, $catid, $letter);
} else {
printf("<td> </td>");
}
printf("</tr>");

?>
</table>
</center>

</FONT>

</TD></TR></TABLE>

</TD>

<?php include("rfooter.php"); ?>
 
Reply
0
0 Like
0 Thanks
•••
Silly question, maybe, but are you sure that $db is initialised correctly?
 
Reply
0
0 Like
0 Thanks
•••
JRBHosting said:
Try:

<?php include("rheader.php"); ?>

<?php

$letter = $_REQUEST['letter'];
$numeric = $_REQUEST['numeric'];

if ($letter) {

$sql = "select drinkid, title, date, rating from drinks where title like '".$letter."%' and status = 'L'";

} else {

$sql = "select drinkid, title, date, rating from drinks where categoryid = '".$catid."' and status = 'L'";

}

if ($numeric == "all") {
$sql = "select drinkid, title, date, rating from drinks where title REGEXP '^[1234567890]' and status = 'L'";
}



$result = mysql_query($sql ,$db);
$numrows = mysql_numrows($result);

$lastpage = false;

if ($pagenum == 0) {
$startrow = 0;
} else {
$startrow = 25 * $pagenum;
}

if ($numrows < $startrow + 25) {
$endrow = $numrows;
$lastpage = true;
}

if ($letter) {

$sql = "select drinkid, title, date, rating from drinks where title like '$letter%' and status = 'L' order by title limit $startrow,25";
$pagetitle = "Drinks starting in the letter '$letter'";

} else {

$sql = "select * from categories where categoryid = $catid";
$result = mysql_query($sql ,$db);
$row = mysql_fetch_row($result);
$pagetitle = $row[1];

$sql = "select drinkid, title, date, rating from drinks where categoryid = $catid and status = 'L' order by title limit $startrow,25";

}

if ($numeric == "all") {
$sql = "select drinkid, title, date, rating from drinks where title REGEXP '^[1234567890]' and status = 'L' order by title limit $startrow,25";
$pagetitle = "Drinks starting in numbers";
}


?>


<TD VALIGN=top width="60%" BGCOLOR="FFFFFF">

<TABLE BORDER=0 WIDTH=99% ALIGN=CENTER>
<TR>

<TD VALIGN=top>

<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100% BGCOLOR=000000>
<TR><TD align=center><FONT SIZE=2 FACE="Verdana,arial,helvetica" color=white><B><?php printf($pagetitle); ?></B></FONT></TD></tR>
</TABLE>

<FONT SIZE=2>

<center>
<br>

<table cellspacing=0 cellpadding=2 border=0>
<tr>
<th width=300 bgcolor=#CCCCCC align=center><FONT face=arial size=2>Drink</font></th>
<th width=85 bgcolor=#CCCCCC align=center><FONT face=arial size=2>Date Added</font></th>
<th width=75 bgcolor=#CCCCCC align=center><FONT face=arial size=2>Rating</font></th>
</tr>

<?php

$rowcolor = 1;

$result = mysql_query($sql ,$db);

if ($myrow = mysql_fetch_array($result)) {

do {

if ($rowcolor == 1) {
$rowcolorhex = "#ffffff";
$rowcolor = 0;
} else {
$rowcolorhex = "#EDEAB9";
$rowcolor = 1;
}


printf("<tr>");
printf("<td width=300 bgcolor=%s align=center><FONT face=arial size=2><a href=drink.php?drinkid=%s>%s</a></font></td>", $rowcolorhex, $myrow["drinkid"], $myrow["title"]);
printf("<td width=80 bgcolor=%s align=center><FONT face=arial size=2>%s</font></td>", $rowcolorhex, $myrow["date"]);
printf("<td width=75 bgcolor=%s><table bgcolor=%s border=0 cellspacing=0 cellpadding=0><tr>", $rowcolorhex, $rowcolorhex);

$onstars = round($myrow["rating"]);
$offstars = 5 - $onstars;

for ($i = 1; $i <= $onstars; $i++) {
printf("<td width=15 bgcolor=%s align=center valign=center><FONT face=arial size=2><img src=images/staron2.gif></font></td>", $rowcolorhex);
}

for ($f = 1; $f <= $offstars; $f++) {
printf("<td width=15 bgcolor=%s align=center valign=center><FONT face=arial size=2><img src=images/staroff2.gif></font></td>", $rowcolorhex);
}

printf("</tr></table></td>");
printf("</tr>");
} while ($myrow = mysql_fetch_array($result));

}

printf("<tr>");
if ($startrow > 0) {
printf("<td align=left><FONT face=arial size=2><a href=category.php?pagenum=%s&searchingred=%s&catid=%s&letter=%s>Previous Page</a></font></td>", $pagenum-1, $searchingred, $catid, $letter);
} else {
printf("<td> </td>");
}
printf("<td> </td>");
if ($lastpage == false) {
printf("<td align=left><FONT face=arial size=2><a href=category.php?pagenum=%s&searchingred=%s&catid=%s&letter=%s>Next Page</a></font></td>", $pagenum+1, $searchingred, $catid, $letter);
} else {
printf("<td> </td>");
}
printf("</tr>");

?>
</table>
</center>

</FONT>

</TD></TR></TABLE>

</TD>

<?php include("rfooter.php"); ?>
Click to expand...


Still receiving errors.....
 
Reply
0
0 Like
0 Thanks
•••
What error(s)?
 
Reply
0
0 Like
0 Thanks
•••
$db doesn't seem to be a valid resource in your query make sure its set correctly. Heres the current errors:

Code: 
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/dailydri/public_html/category.php on line 49

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/dailydri/public_html/category.php on line 94
 
Reply
0
0 Like
0 Thanks
•••
Post the code for rheader.php please
 
Reply
0
0 Like
0 Thanks
•••
baxter said:
$db doesn't seem to be a valid resource in your query make sure its set correctly. Heres the current errors:

Code: 
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/dailydri/public_html/category.php on line 49

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/dailydri/public_html/category.php on line 94
Click to expand...

how do i set it correctly?
 
Reply
0
0 Like
0 Thanks
•••
Is this path ok? : /home/dailydri/public_html/category.php ???
 
Reply
0
0 Like
0 Thanks
•••
nomis135 said:
Is this path ok? : /home/dailydri/public_html/category.php ???
Click to expand...

Well heres the thing. In my smart FTP, it says

DailyDrinker.com

Then it lists everything.

So I think thats right....
 
Reply
0
0 Like
0 Thanks
•••
It's mysql_num_rows, not mysql_numrows.

That could be your problem? :red: :)

Find:
PHP: 
$numrows = mysql_numrows($result);
Replace with:
PHP: 
$numrows = mysql_num_rows($result);

Tell us how it goes. See if it works. :)
 
Reply
0
0 Like
0 Thanks
•••
Change
$result = mysql_query($sql ,$db);
To
$result = mysql_query($sql);

Any other instances where it has a mysql_query and a ,$db, do the same thing.
 
Reply
0
0 Like
0 Thanks
•••
I am helping him via PM, sorry guys ;)
 
Reply
0
0 Like
0 Thanks
•••
Log in or sign up to reply here.

  1. happinesscoin.com

    • Make Offer

  2. NobleMarket.pl

    • Inquire

  3. honsh.de

    • Make Offer

  4. ketodex.com

    • Make Offer

  5. nfy.xyz

    • Make Offer

  6. LookupDot.com

    • Make Offer

  7. metaassets.xyz

    • Make Offer

  8. PureIrrigation.com

    • Make Offer

  9. livefire.io

    • Make Offer

  10. momintals.com

    • Buy Now
    • $1,175

Similar threads

domainer50
Mysql errors, PLEASE HELP
5 replies
810 views
domainer50
domainer50
Tree
URGENT! Sudden MySQL Errors
4 replies
422 views
Tree
Tree
Ringr
MySQL errors?
2 replies
525 views
df-sean
D
A
Mysql backup
7 replies
721 views
stscac
stscac
domainabilities
Database transfer
1 reply
770 views
odditysoftware
odditysoftware
CatchedCatched

We're social

Escrow.com

New posts ➔

Spaceship

Auction activity ➔

Rexus Domain

How do you think a potential buyer first checks if your domain is for sale?

Polls of interest ➔

CryptoExchange.com

Hot this week ➔

Domain Recover

Community favorite ➔

CatchDoms

Hot this month ➔

Blog favorites

DomDB

  1. happinesscoin.com

    • Make Offer

  2. NobleMarket.pl

    • Inquire

  3. honsh.de

    • Make Offer

  4. ketodex.com

    • Make Offer

  5. nfy.xyz

    • Make Offer

  6. LookupDot.com

    • Make Offer

  7. metaassets.xyz

    • Make Offer

  8. PureIrrigation.com

    • Make Offer

  9. livefire.io

    • Make Offer

  10. momintals.com

    • Buy Now
    • $1,175
NameFit
  • The sidebar remains visible by scrolling at a speed relative to the page’s height.
Back