Quotes'; $q = "select * from quote"; $r = mysqli_query($dbc, $q); echo '
'; while($row = mysqli_fetch_array($r)) { echo ''; //quote echo ""; //person $q2 = "select name from people where person_id='" . $row['person_id'] . "'"; $r2 = mysqli_query($dbc, $q2); while($row2 = mysqli_fetch_array($r2)) { echo ""; } //created by $q2 = "select user_name from users where user_id='" . $row['user_id'] . "'"; $r2 = mysqli_query($dbc, $q2); while($row2 = mysqli_fetch_array($r2)) { echo ""; } //date $c = Carbon::createFromTimestampUTC(strtotime( $row['creation_date'] . ' UTC')); echo ''; //del echo ''; echo ''; } echo '
Quote Person Created By Date Delete
" . $row['quote'] . "" . $row2['name'] . "" . $row2['user_name'] . "' . $c->format('l jS \of F Y') . ''; echo '
'; echo '
'; }