This is my code...
Expand|Select|Wrap|Line Numbers
- function getNewestTutorials() {
- require 'database.php';
- $q = "SELECT id, imagePath, titleOfTutorial, descriptionOfTutorial, tutorialBy FROM dogs ORDER BY id desc LIMIT 6";
- $result = $mysqli->query($q) or die(mysqli_error($mysqli));
- if($result) {
- while($row = $result->fetch_object()) {
- $id = $row->id;
- $imagePath = $row->imagePath;
- $titleOfTutorial = $row->titleOfTutorial;
- $descriptionOfTutorial = $row->descriptionOfTutorial;
- $tutorialBy = $row->tutorialBy;
- print '<div id="pictureOfTopicAndTitle"> <!-- start pictureOfTopicAndTitle -->
- <div id="pictureOfTopic">
- <a href="view_tutorial.php?id=' . $id . '">
- <img src="' . $imagePath . '" width="200" height="200">
- </a>
- </div>
- <div id="titleAndContent">
- <h2>' . $titleOfTutorial . '</h2>
- <p>' . $descriptionOfTutorial . '</p>
- <div id="nameComments">
- <p>Tutorial by ' . $tutorialBy . ', Comments 56</p>
- </div>
- </div>
- </div> <!-- end pictureOfTopicAndTitle Div -->';
- }
- }
- }