I have noticed that there are nearly 100x the number of posts here in the PHP forum, as opposed to the ASP forum, and my curiosity was aroused by this vast difference.
Does this mean that PHP is more popular than ASP?
Or that PHP is harder to learn than ASP, thus more people turn to the forums?
Or has the PHP forum been around longer?
Or is there another reason?
I have a database-driven site and it is possible for users to leave comments, which get written to the database. How do I make it so large comments can be added?I am getting this error message:
Microsoft JET Database Engine error'80040e21'
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
/wall2.asp, line 37
I have set the default field type in the database to be 'memo'and set the default text field size to 255 (the maximum allowed)
I have a simple address-script (its actually a guestbookscript that I changed a bit). Part of the code looks like this:
Code: ....
I have a database I built with Access with a Users_Table holding User_ID, User_Name, etc. A Posts_Table, with Post_Content, Post_ID, Post_DateandTime, Thread_ID (pointing to whichever thread the post is in from the Threads_Table), User_ID (pointing to the user who made the post in the Users_Table). Also a Threads_Table, with Thread_ID, and Thread_Title, etc.
I want to pull the Posts content, Post DateandTime, User who posted it, and thread title from the database (the page simply knows the ThreadID and the idea is to select all posts with that ThreadID). Could anyone help me create the SQL I need for this. I understand Inner Joins, and this would be the perfect place for them I would have thought, but I cannot get an inner join to work here. perhaps because this is an access created database,.
I understand that this forum uses some sort of cookie system to detect which threads have been read by users. I am trying to accomplish the same thing. My thought is to have a cookie with two keys: one with the last activity of the user, and the other with the posts that have been read.
Now, the only problem, is that I more than likely will need to update these reads threads based on a date/timeframe criteria, correct? Has anyone wrote one of these? In my threads table, I have a column named 'forumLastPostID' for each thread.