hi,
mysql_query("$command",$mysqlHandle);
should actually be
mysql_query($command,$mysqlHandle);
it works for me. i did not understand rest ur code. but i think should do
it.
try this and get back if still facing problems.
regards,
-shiva
"Keith Spiller" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello,
>
> Does anyone know what would cause this message?
>
> Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result
> resource in c:\program files\easyphp\www\bod-rse\bod\menu.php3 on line
49...
>
> Here is the code:
>
> <?
> $command = "SELECT * FROM central_fakepaths WHERE menu != '0' ORDER BY
menu
> ASC";
> $result = mysql_query("$command",$mysqlHandle);
> $path_directory=explode("/", $HTTP_SERVER_VARS["REQUEST_URI"]);
>
> while ($myrow = mysql_fetch_row($result))
> {
> $count++;
>
> If ($path_directory[1]=="$devsite") { $path = $myrow[9]; $target =
> $myrow[10]; }
> else { $path = $myrow[7]; $target =
> $myrow[3]; }
>
> If ($myrow[5] != $count)
> { echo "<img src=\"images/menu-line.gif\" width=\"139\"
> height=\"7\"><br>\n";
> $count++;
> }
>
> // IF MENU VALUE == COMMITTEES
> if ($myrow[2] == "Committees")
> {
>
> echo "<font face=Verdana size=1><img src='images/menu-line.gif'
> width=139 height=7><BR>
> <a href='.' target='_top'>Committees</a><BR>
> <img src='images/menu-line.gif' width=139 height=7><BR>";
>
> $currdate = date("Y-m",time());
> $cdate = explode("-" , $currdate);
> $cyear = $cdate[0];
> $cmonth = $cdate[1];
>
> if ($cmonth >=7 AND $cmonth <=12) $fyear = $cyear + 1;
> else $fyear = $cyear;
> $fyear2 = $fyear - 1;
> $syear = "$fyear2 - $fyear";
>
> $commandw = "SELECT menuname, type, active, name FROM bod_board_boards
> WHERE type='committee' AND active='1' ORDER BY name ASC";
> $resultw = mysql_query("$commandw",$mysqlHandle);
> while ($myroww = mysql_fetch_row($resultw))
> {
> if ($myroww[0] !="")
> {
> echo " <a href='committees.php?bord=$bord&comm=$myroww[3]'
> target='_top'>$myroww[0]</a><BR>";
> }
> }
>
> //echo " <a href='?bord=$bord' target='_top'>What They
Do</a>";
> }
>
> else
> {
> echo " <a href='$path' target='$target'>$myrow[2]</a><br>\n";
> }
> }
>
> ?>
>
>
> Any help would be unendingly appreciated...
>
>
> Keith
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
