Zaratul
-
Posts
4 -
Joined
-
Last visited
Never
Posts posted by Zaratul
-
-
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
Creating a new user
in MySQL Help
Posted
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?