Error Question!

From: Date: Fri, 23 May 2008 17:42:28 +0000
Subject: Error Question!
Groups: php.windows 
Request: Send a blank email to php-windows+get-28909@lists.php.net to get a copy of this message
Hello Everyone, I keep getting this error: *Warning*: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in *C:\wamp\www\login\testroom\upload.php* on line *107, *for this particular area of code. Code: //Check to see what files they have uploaded in the past $projects = "select name, type, location, date_added from uploads where user_id = '" . $_SESSION['user_id'] . "' "; $projects_results = mysql_query($projects, $conn) or die(mysql_error()); //Create table for projects $display_block = '<table>
                           <tr>
                               <th>Project Name</th>
                               <th>Project Type</th>
                               <th>View Project</th>
                               <th>Project Created</th>
                           </tr>';
                             //Extract data to table
   while ($project_data = mysql_fetch_array($project_results))  * Error occurs here!*
{
       $project_name = $project_data['name'];
       $project_type = $project_data['type'];
       $project_link = $project_data['loction'];
       $project_date = $project_data['fmt_date_added'];
             //insert project data          $display_block .='
                           <tr>
                               <td class="heading">' . $project_name . '</td>
                               <td class="heading">' . $project_type . '</td>
                               <td class="heading"><a href="' . $project_link . '">View</a></td>
                               <td> class="heading">' . $project_date . '</td>
                           </tr>';
} //Close display block $display_block .='</table>'; Does anyone have any idea what is going on. I have used a similar code liek this before and it worked. I can output the mysql string to the browser and then copy and paste it to PHPmyadmin and do an sql query and it comes back with the correct results. I don't know what is up. Thanks! Matt G ** -- Matthew Gonzales IT Professional Specialist Enterprise Information Technology Services University of Georgia Email: matt323@uga.edu <mailto:matt323@uga.edu> Phone: (706)542-9538

« previous php.windows (#28909) next »