I want to cry

[sunit_modi]

Guys please help :-<

the following has been giving me hassle for the last 3 hours:

<?

if (!($db_select=mysql_connect("localhost","******","******"))) {
echo "error1";
} else {
echo "<br >selected ";
}

if (!($db_connect=mysql_select_db("example_forum_db"))) {
echo "error2";
} else {
echo "<br >connected";
}

$counter=0;

$query="SELECT * FROM FORUM_MESSAGES WHERE MY_PARENT=0 ORDER BY ID DESC LIMIT $counter,50;";

$topic_query = mysql_db_query($db_connect,$query);

if (!($topic_query)) {
echo "<br>error3";
} else {
echo "<br>executed";
}

?>

Basically everything is fine upto the last if statement giving me the indication that there is something wrong with the SQL statement.

I tried the statement in the mysql command prompt and it word with absolute values i.e. 0, but not when i run the script.

I am starting to loose the will to live......

Any thoughts

Sunit

[diego25]

$topic_query = mysql_db_query($db_connect,$query);

should be:

$topic_query = mysql_db_query($db_select,$query);

or you can reverse the variables in the top...that's what happens when you misname variables.

Diego

[FlipinMonkeyPie]

what error are you getting?

btw..

$counter=0; 

should be

$counter="0"; 

i think

[sunit_modi]

I dont believe it

I have sat here for nearly 4 hrs.
The reason i am sitting here is because i did not put the connection details of the database in the funcition, instead i left them outside by accident.

Im an IDIOT. Some please shoot me and put me out my crap existence.

Sunit

:o :o :o :o :o

[sunit_modi]

now i got all that sorted out I shave the following error.

Fatal error: Call to undefined function: add_new_topic() in c:\apache\htdocs\test_forum\add_topic.php on line 36

i really dont get this one. Basically the file function.php does have the function add_new_topic().

what is going on.

Im basically trying to build a discussion forum for a uni project.
I have the tutorial from

http://www.learnground.com/learning_php_forum_2.php

and have been told it really good example.
If anyone else has done this and found all the same errors please let me know just so i can make the changes without going through a tripple heart bypass before it gets working.

Many Thanks

Sunit

[FlipinMonkeyPie]

try making sure that the path to the file is correct and that it is opening the file... make sure to have double backslashes.

[sunit_modi]

basically its getting called in the following section of code:

<?php

require("functions.php");
if ($action=="do_it")
	{
	if ($topicname=="" or $name=="" or $email=="" or $post=="") //if any of the fields are empty
		{
		echo "<CENTER><B>Oops! You Must Fill in all fields before proceeding!</B></CENTER>";
		showfooter();	//needed to finish the layout of the page
		exit;
		}
	if (!eregi("^([a-z0-9_]|\\-|\\.)+@(([a-z0-9_]|\\-)+\\.)+[a-z]{2,4}$", $email))	//validating the email address
		{
		echo "<CENTER><B>Please go back and fill in a VALID e-mail address</B></CENTER>";
		showfooter();
		exit;
		}

//**************************
// here is the call
add_new_topic();
//**************************
echo "<CENTER>Your topic was added. Go to the <A HREF='index.php'>main page</A></CENTER>";
showfooter();
exit;
}
else

etc etc etc

have no idea, i tried the back slashes and everything for the path to the required file and no joy, the file is local in the directory anyway so i have no idea what wrong.

Sunit

[sunit_modi]

how do i check to see if it is opening?

[FlipinMonkeyPie]

it will give you an error

can you attach the functions.php file so i can look at it? see if the function isnt there or what.

[FlipinMonkeyPie]

im going to bed for tonight its 2:30 am, ill do this tomorrow

[sunit_modi]

Sorry, popped out for breakfast.... Mc Donalds... dirty but nice

ok, here is the code, basically the function is in the functions.php file and is being called from the add_topic.php file.

Many Thanks

Sunit

[sunit_modi]

ok

dont worry about it but thanks all the same.

Basically found some bullitin board software at http://www.hotscripts.com/PHP/Scripts_and_Programs/Discussion_Boards/ that will do the trick.
It works and is very very simple.

Ive attached it if anyone wants it.