Current problems: I am not sure what this error means... It looks like my links are named correctly.
Is it because there is something there that doesn't match?
--------------------------------------------------------
Looks like I changed some things since the last time I had this error. I had to change the following line:
number_format((float)$row['Price'],2) to dbOut($row['ISBN']) since ISBN is no longer a float, but rather it is text. Now I'm facing this error:
So, the following error I encountered above is kind of linked to to top section of my list page, line 17-18. Originally, I modified it from
# SQL statement
$sql = "select MuffinName, MuffinID, Price from test_Muffins";
to this:
# SQL statement
$sql = "select BookID, Title, Author, ISBN, Description, MetaDescriptions, MetaKeywords from test_Books";
I'm not sure if I wrote this section of the book_list page right:
if(mysqli_num_rows($result) > 0)
{ #records exist - process
while($row = mysqli_fetch_assoc($result))
{ # process each row
echo '<div align="center"><a href="' . VIRTUAL_PATH . 'book_view.php?id=' . (int)$row['BookID'] . '">' . dbOut($row['Title']) . '</a>';
echo ' <i>Here with this ISBN:</i> <font color="red">$' . dbOut($row['ISBN']) . '</font></div>';
}
-------------------------------COMPLETED WORK------------------------------------
Looks like my List page is working finally! I just had the link to the subfolder wrong
# '../' works for a sub-folder. use './' for the root
require '../inc_0700/config_inc.php'; #provides configuration, pathing, error handling, db credentials
I had to update the extension... After I uploaded the pictures, my View page looks good to go as well!
Here is a link to my Descriptions page
Hourly Log:
6-05-2011-- 2 hours on writing sql statement & editing book_list & book_view php files
6-18-2011 -- 5 hours on troubleshooting


No comments:
Post a Comment