View Single Post
  #1 (permalink)  
Old June 3rd, 2006, 11:28 AM
Mitch Mitch is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: South Bend, Indiana, USA.
Posts: 149
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error but it works



I have a page that is generating the following errror and I can't figure out why, especially when I use the same code on another page (but different database) and it does not generate the error, but when I change the database reference i get it:
Code:
Warning: mysql_list_fields(): Unable to save MySQL query result in /usr/www/users/xyz/abc/123/list.php on line 9
But it does work, the only thing it does is populate a dropdown list and that works.

Here is the code:
Code:
<?
 require_once("bookmark_fns.php");
 do_html_header("");



$connection = mysql_pconnect("x", "y", "z"); 

$fields = mysql_list_fields("A", "B", $connection);

?> 


<form method="post" action="show_list.php">
<p align="center">
<select name="searchteam">

<?php
$query = mysql_query('select username from onmylist_user order by username') or die
(mysql_error());
while($row = mysql_fetch_array($query)) {
           echo("<option value=\"${row['username']}\">${row['username']}\n");
}
?>

</select>

<input type=submit value="Show A Persons People On My List">

</form>


<?
 do_html_footer();
?>
Mitch
__________________
Mitch
Reply With Quote