User Profile
Collapse
-
never mind I got around this issue by manually creating the tables, but now a new problem has arised, I cant seem to post anything. After i submit an article it will just seem like the page reloaded and all the fields are empty again. Whats going on here? -
ahh I think i seem to have found the issue. It seems the tables for the database are not being created.
When I put this into the mySQL query to create the tables:
Code:CREATE TABLE posts ( ID int(5) DEFAULT '0' NOT NULL auto_increment, TopicID int(5) DEFAULT '0' NOT NULL, Name varchar(50) NOT NULL, Email varchar(50) NOT NULL, Password varchar(50) NOT NULL, TimeStamp varchar(10)
Leave a comment:
-
Code:<?php require( './functions.php3'); showheader("Here are your Topics"); ?> <TABLE BORDER=0 WIDTH=100% CELLSPACING=3 CELLPADDING=5> <TR> <TD> <FONT COLOR="#000000" FACE="Arial,Verdana,Helvetica" size=-1> <b>Topics: </b> <BR> <P> <a href="add-topic.php3"><FONT
Leave a comment:
-
-
Would you by happen to know the general issue behind query's not being executed?
In my previous post the code written says that there is an issue on line 36. This is what the piece of code is on line 36.Code:while ($topic = mysql_fetch_array($topic_query)) {
Code:<?php $topic_query = mysql_query("SELECT * FROM topics ORDER BY ID"); while ($topic = mysql_fetch_array($topic_query))
Leave a comment:
-
Discussion Forums error
Hi I am new to the forums and I have one question I read through this tutorial:
Tutorial
and I get this error when I view the index.php3 file
Code:Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/[I]user[/I]/public_html/forum/index.php3 on line 36 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/[I]user[/I]/public_html/forum/index.php3
No activity results to display
Show More
Leave a comment: