List,
Without getting into the specific problem the general debug path I'd
follow would be: -
1. Make sure you are actually connected to the database, you say it's
the admin area? Does the admin area login with different details? try
eching the result of a "select NOW()" right at the start of the admin area.
2. Make sure the SQL works, echo the $x just before it gets sent to the
database and then past it into the MySQL command line.
3. Make sure all the variables used in the query (not relevant to you)
and database connection ($db) are set and that you're using the right
result set ($r) in this case.
From the error I'd say you've got either 1 or 2, can't be much more
specific with the information I'm afraid. Are "begdate" and "enddate"
ambiguous?
Regards,
Phil
> Hello,
>
> I'm running f.a.m.p, f =freebsd 4.7 and mysql is 3.23.52.
>
> Anyway, I inherited a website from someone else's server(I don't know
> what they we're running) but the admin section of the website
> generates this error iin the apache error log when trying to login( on
> the screen just takes you back to login saying invalid:
>
> <snip>
> [Tue Oct 17 19:10:08 2006] [error] PHP Warning: mysql_query():
> supplied argument is not a valid MySQL-Link resource in
> /usr/local/apache/website/incoming/_includes/_page-specialeventsnav.php
> on line 16
> [Tue Oct 17 19:10:08 2006] [error] PHP Warning: mysql_fetch_array():
> supplied argument is not a valid MySQL result resource in
> /usr/local/apache/website/incoming/_includes/_page-specialeventsnav.php
> on line 17
> [Tue Oct 17 19:10:08 2006] [error] PHP Warning: mysql_num_rows():
> supplied argument is not a valid MySQL result resource in
> /usr/local/apache/website/incoming/_includes/_page-specialeventsnav.php
> on line 20
> <end snip>
>
>
> code in question:
>
> <script language="javascript">
> <!--
> function focus(urlstring) {
>
> window.open(urlstring,"adFOCUS","width=700,height=580,scrollbars=yes,toolbar=no,location=no,resizable=no");
>
>
> }
> //-->
> </script>
>
> <div id="mainnav">
> <table width="180" border="0" cellpadding="0" cellspacing="0">
> <tr><td align='left'><img src='_elements/spacer-blank.gif' height='1'
>
> width='180' border='0'></td></tr>
> <tr><td align='center'><font class='section'><u>Special
> Events</u></font><br><br></td></tr>
> <tr><td align="center">
> <? $x = "SELECT page_contents.title,page_contents.id FROM
> page_contents,page_sections WHERE page_contents.pagename =
> page_sections.pagename AND page_contents.display != 'N' AND
> page_sections.publicurl = '/specialevents.php' AND begdate <= Now()
> AND enddate > Now() ORDER BY rand() LIMIT 6";
> $r = mysql_query($x,$db);
> while ($re = mysql_fetch_array($r)) {
> print "<a class=\"sideoff\"
>
> href=\"javascript:focus('http://www.website.com/viewevents.php?rid=$re[id]')\">$re[title]</a><br><br>\n";
>
>
> }
> $rcount = mysql_num_rows($r);
> if (($rcount == 6)) {
> print "<a class=\"sideoff\"
>
> href='http://www.website.com/specialevents.php'>continued...</a><br><br>\n";
>
>
> }
> ?>
> </td>
> </tr></table>
> </div>
>
>
> Any and all help is much appreciated, thanks.
>
