ericp Posted April 8, 2013 Share Posted April 8, 2013 Hi all, Could you possibly help me with this issue? I coded (first I type every script, then copy-and-pasted due to the error insisted) the script 17.4 - forum.php Then I tested on the web browser. The error happed saying:'Unknown column " p.posted_on' in 'field list' " I captured this error by using the error handler die("Error: ".mysqli_error($dbc)); right after the $r = mysqli_query($dbc, $q); Note: I use the shared host at godaddy.com,PHP version: 5.3.21 OS: Linux domain: http://hiteachers.com/forum.php I look foward to hearing from your help. Regards, Eric Link to comment Share on other sites More sharing options...
Larry Posted April 8, 2013 Share Posted April 8, 2013 As the error says, you don't have a "posted_on" column. Yours is named "post_on". 1 Link to comment Share on other sites More sharing options...
Larry Posted April 8, 2013 Share Posted April 8, 2013 Also, you posted this in the wrong forum (for the wrong book). AND DO NOT DOUBLE-POST!!! Link to comment Share on other sites More sharing options...
ericp Posted April 9, 2013 Author Share Posted April 9, 2013 As the error says, you don't have a "posted_on" column. Yours is named "post_on". Thanks for the quick reply. The error is addressed... Eric P/S: 'Four eyes are always better than two eyes, right?' Link to comment Share on other sites More sharing options...
ericp Posted April 9, 2013 Author Share Posted April 9, 2013 Also, you posted this in the wrong forum (for the wrong book). AND DO NOT DOUBLE-POST!!! Sorry, larry, but I had posted this before I could search for the another one. Then I went back to delete this post intentionally. However, i don't know how to delete it. I also went to 'My content' in my account, but i couldn't either. Maybe, it's the first time i used your forum. Eric Link to comment Share on other sites More sharing options...
ericp Posted April 9, 2013 Author Share Posted April 9, 2013 Hi Larry, Can you direct me to the correct book so that i can post any other posts just in case? I use this book: Link to comment Share on other sites More sharing options...
Larry Posted April 9, 2013 Share Posted April 9, 2013 You're in the correct forum now. I moved this thread here. Link to comment Share on other sites More sharing options...
Recommended Posts