php/mysql

[Gaz 13]

Any wizards of this language out there that can help me with an issue?

Wondering if you can help?

I am currently working on a script that allows an admin to upload a file to the server. When the file uploads it takes information from the form and stores it in the database, to later allow users who have permissions to download it.

I have managed to make the form:

Select File To Upload


 File






Select Users Who Can Download The File



<?php
$useruploadids = mysql_query("SELECT member_id, firstname, lastname FROM members");
while ($row = mysql_fetch_assoc($useruploadids)) {
    $user_id = $row['userid'];
    $firstname = $row['firstname'];
    $lastname = $row['lastname'];
?>
"><?php echo $firstname ?><?php echo $lastname     ?>
<?php } ?>

[Shadow 0]

Seen SQL years ago so it's kind of rusty, but I think there might be something wrong with the INSERT query. Other than that no idea.