num_rows < 1) { header("Location: /projects"); } $info = $temp->fetch_assoc(); //Select tags about project $query = "SELECT tag.name AS name FROM tag, tagged, project WHERE tag.id = tagged.`tag-id` AND project.id = tagged.`project-id` AND project.uid = '$uid' ORDER BY tag.name ASC"; $tags = ExecQuery($query); //Select media from project $query = "SELECT project.uid, media.type, media.name, media.file FROM media, project WHERE project.id = media.`project-id` AND project.uid = '$uid' ORDER BY media.type ASC"; $media = ExecQuery($query); //Select files from project $query = "SELECT file.uid, file.name, file.file FROM file, project WHERE project.id = file.`project-id` AND project.uid = '$uid' ORDER BY file.name ASC"; $files = ExecQuery($query); ?>

Project Description

Project Details

Date:
Language:
Grade:

Code

num_rows > 0) { ?>

Tags

num_rows > 0) { ?>
fetch_assoc()) { $type = $row['type']; if($type == "image") { ?>
<?php echo $row['name']; ?>
<?php echo $row['name']; ?>
<?php echo $row['name']; ?>
num_rows > 0) { ?>