query

[JD_]

i have the following to pull the relevant data from the db and put it into tables however i get an error i dont know mysql queries that well so i just copied it from another script and modified it for the 3 fields i need to pull data from. the reason its named $queryf etc so it dosent clash with other thigns on my site. any help appreciated.

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/virtual/site88/fst/var/www/html/configlist.php on line 5

<?
        /* this query will get all info */
        $queryf = "SELECT uname,filez,filedes, FROM members ORDER BY uname DESC";
    $resultf = mysql_query ($queryf);
    while ($row = mysql_fetch_assoc ($resultf)) {

    $unamef = $row['uname'];        
    $filezf = $row['filez'];
	$filedesf = $row['filedes'];  

    /* display the data */
   echo"<table width=100% border=0 cellpadding=0 cellspacing=0>
  <tr> 
    <td width=185 height=19 valign=top bgcolor=#0066CC><font color=#FFFFFF><strong>$unamef</strong></font></td>
    <td width=100% valign=top bgcolor=#0066FF><font color=#FFFFFF><strong>$filedesf</strong></font></td>
    <td width=179 valign=top bgcolor=#0099FF><strong><font color=#FFFFFF>$filez</font></strong></td>
  </tr>
  <tr> 
    <td height=14></td>
    <td></td>
    <td></td>
    <td></td>
  </tr>
  <tr> 
    <td height=1><img src=../spacer.gif alt= width=185 height=1></td>
    <td></td>
    <td><img src=../spacer.gif alt= width=179 height=1></td>
    <td><img src=../spacer.gif alt= width=155 height=1></td>
  </tr>
</table>";
    }

?>

[hi-liter]

try changing:

$resultf = mysql_query ($queryf);

to

$resultf = mysql_query ($queryf) or die('SQL Query Failed');

and see if the query is ok, if it give you messg; SQL Query Failed, then you know if your sql statement is no good, and that indeed that is the issue...or not.

hth

[JD_]

thx was my query incorrect db field names :/