Jump to content


Photo

n00b question


  • Please log in to reply
4 replies to this topic

#1 Zaratul

Zaratul
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 24 April 2003 - 09:31 PM

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.phpbuilde...029.php3?page=4

#2 slate

slate
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 24 April 2003 - 09:54 PM

CREATE DATABASE your_db;

CREATE TABLE `yourtable` ( `code` INT(9) NOT NULL AUTO_INCREMENT, `parentcode` INT(9) NULL , `title` VARCHAR(30) NULL , `description` VARCHAR(30) NULL , `uname` VARCHAR(30) NULL , `email` VARCHAR(30) NULL , UNIQUE ( `code` ) );

#3 Zaratul

Zaratul
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 24 April 2003 - 10:11 PM

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

#4 slate

slate
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 24 April 2003 - 10:25 PM

Show me lines 10-25 of forum.php please

#5 Zaratul

Zaratul
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 24 April 2003 - 10:28 PM

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>\";
}




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users