Jump to content
Larry Ullman's Book Forums

Chapter 13 - Could not retrieve data because

Recommended Posts



I am having this issue (screenshot attached). I am able to add quotes to the database and see them in the database when logging in to phpMyAdmin, but for some reason I am getting this error on the View Quotes page: 



All Quotes

Could not retrieve the data because:
Unknown column 'id' in 'field list'.

The query being run was: SELECT id, quote, source, favorite FROM quotes ORDER BY date_entered DESC


Is there a reason for this? 


This is the code that I am using for the View All Quotes page:

<?php // Script 13.8 - view_quotes.php
/* This script lists every quote. */

// Include the header:
define('TITLE', 'View All Quotes');

print '<h2>All Quotes</h2>';

// Restrict access to administrators only:
if (!is_administrator()) {
	print '<h2>Access Denied!</h2><p class="error">You do not have permission to access this page.</p>';

// Need the database connection:

// Define the query:
$query = 'SELECT id, quote, source, favorite FROM quotes ORDER BY date_entered DESC';

// Run the query:
if ($result = mysqli_query($dbc, $query)) {
	// Retireve the returned records:
	while ($row == mysqli_fetch_array($result)) {
		// Print the record:
		print "<div><blockquote>{$row['quote']}</blockquote>- {$row['source']}\n";
		// Is this a favorite?
		if ($row['favorite'] == 1) {
			print ' <strong>Favorite!</strong>';
		// Add administrative links: 
		print "<p><b>Quote Admin:</b> <a href=\"edit_quote.php?id={$row['id']}\">Edit</a> <->
		<a href=\"delete_quote.php?id={$row['id']}\">Delete</a></p></div>\n";
	} // End of while loop.
} else { // Query didn't run.
	print '<p class="error">Could not retrieve the data because:<br>' . mysqli_error($dbc) . '.</p><p>The query being run was: ' . $query . '</p>';
} // End of query IF.

mysqli_close($dbc); // Close the connection.

include('includes/footer.php'); // Include the footer.


I also attached a screenshot of my file directory, and of the added quotes on phpmyadmin site, not sure if that helps. 


As far as the folder being named "includes" instead of "templates," that was the Professor's call. She wanted us to name that folder that way.


Any clarification will be greatly appreciated! 

error ch 13.JPG

file structure.JPG

added quotes on phpmyadmin.JPG

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...