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@xxxxxxx <mailto:matt323@xxxxxxx>
Phone: (706)542-9538
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
