want to make a encylopedia using current DB

[Marco van Herwaarden]

Originally Posted by aussiev8

anyone?

Start by looking through the function libraries in your includes directory, then look how those functions are being learned.

You already got the best manual there is: the vB source code.

[aussiev8]

uhmm cool, i don't want someone to walk me through it, for an open source project the documentation is limited and the community help is shocking...

nobody wants to help a new coder get off his feet...
i think you guys are stuck up!

[cinq]

Originally Posted by rake

to get all the terms from the database starting with a certain letter, you could use this query:

SELECT * FROM table WHERE title LIKE '$letter%'

then loop through all rows to display the list of entries for that letter..

rake already provided the solution to what you are asking

[Marco van Herwaarden]

Well i consider myself a new coder as well, but i learned myself the way i described it. And in my view that is the only way you can (good) learn something like this.

If you have any specific questions, you will find to community and the members/coders/staff to be very willing to answer and help you solve your problems.

[memobug]

Originally Posted by aussiev8

uhmm cool, i don't want someone to walk me through it, for an open source project the documentation is limited and the community help is shocking...

nobody wants to help a new coder get off his feet...
i think you guys are stuck up!

I tried to help. It seems you just wouldn't answer my question

-- A stuck-up coder

[aussiev8]

its just an addon, never mind
i'll go about it on my own..
thanks to the guys that helpd.

[cinq]

Originally Posted by memobug

I tried to help. It seems you just wouldn't answer my question

I think aussie knows how to code php/mysql in general, just that he wants to learn how to tie it in with vb using vb's various functions.

Please correct me if I am wrong.

[memobug]

Yes. I (still have) no clue from his post how, even generally, this encyclopedia was going to integrate with vbulletin. Did it appear on thread view and list every term on that page for definition? Did it appear beside a post? Was it somehow related to search? Maybe I'll never know.

Regards,

Matt

[aussiev8]

as i stated, i wanted it to be a thread view, (hence asking about how to make it look like the forum) sorry if i wasn't clear enough..

i just wanted it to act, for instance the same as "articles" this is the best way i could think of setting it out...

it'll have [a b c d e f g h i j k l m n o p q r s t u v w x y z ] in a bar
and when you click on a letter all of the definitions for that letter will come up!

ant
apple
ashtay

then when you click on the "ashtray" link it'll take you to a thread like view with the definition..

?? follow??

ps. i'm sorry i lost the plot, was just getting fed up with it not working the way i wanted it too.. i scrapped the previous attempt and will be a bit calmer and ask for help
i can't bevelie i make coporate fully interactive php styled secure sites, but i'm having trouble with this!

please someone either help me, or shoot me

[rake]

start with a blank page,
require("./global.php");
to get the vb back-end, so you can access vb resources..

Get your database structure straight. One table should be enough to start with. Something like id ; title ; definition will work.

if($_REQUEST['do'] == showletter)
{
globalize($_REQUEST, array ('l' => STR));

$l = $DB_site->query("SELECT * FROM table WHERE title LIKE '$letter%' ORDER BY title ASC");
while($def = $DB_site->fetch_array("$l"))
{
.....
}
}

This should be enough to get you started. You can work your way up from there. If you don't know what something is, just search here, or through the vb files, and you'll find it.