Zaratul

How do i create a new MySQL user for a database called \"Soul_Forum\"? and do i need to set up the ODBC thing for an invision board forum?

this is more then that but it starts at line 10 and goes till then end of the function. thanks again shownode(0); // display all the main threads // This function is a recursive function which shall display all the br /anches // and sub br /anches of the threads function shownode($nodecode) { global $connect; // using the global variable for connection // Get a list of all the sub nodes which specific parentcode $noderesult = odbc_exec($connect,\"select * from forum where parentcode = $nodecode\"); echo \'<ul type=\"disc\">\'; while(odbc_fetch_row($noderesult)) // get all the rows { $code = odbc_result($noderesult,\"code\"); $title = odbc_result($noderesult,\"title\"); $uname = odbc_result($noderesult,\"uname\"); $email = odbc_result($noderesult,\"email\"); echo \"<li>\"; echo \"<a href=\"node.php?node=$code\"> $title </a>\"; echo \"-- by ($uname) $email<br />\"; shownode($code); } echo \"</ul>\"; }

thanks for the help but i am getting this error now. any ideas? Discussion Forum using PHP/Access under IIS Post New Message Warning: SQL error: [MySQL][ODBC 3.51 Driver][mysqld-4.0.12-nt]Unknown column \'parentcode\' in \'where clause\', SQL state S0022 in SQLExecDirect in d:inetpubwwwrootforum.php on line 19 Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in d:inetpubwwwrootforum.php on line 21

n00b Question, I am folling a tutoral at phpbuilder.com and came accross this part where it wants me to make a DB in Microsoft access but i dont have it I have MySQL and was wondering if anyone could give me the SQL for making a database that will be the equivelant to the one shown. The DB name the want is forum ( i think ), thanks for all the help!! oops forgot the link http://www.phpbuilder.com/columns/jayesh20...029.php3?page=4