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.
--
Jason
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
