Philip Mather wrote:
> 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.
Yes and how do I do what you mention(I'm technically sound but a sql
novice)?
>
> 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.
Again, I don't know how to do this? I assume at the sql 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
Thanks
>> 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.
>>
>
