Gossamer Forum
Quote Reply
Table prefix question
Hi,

just installed GForum , now I wanted to use a global that I already use in Links SQL to display the number of total links in the database.

Now the problem is that the tables for GForum and Links have different prefixes, so I can't use the global from Links SQL without modifying it a bit.

In the documentation I found
Quote:
To set a prefix:

$db->prefix("foo");

to get the current prefix:

my $prefix = $db->prefix;

What this will do is prepend 'foo' to the beginning of every table name.

I tried that to set the table prefix according to my Links tables, but it won't work. Instead I get an error.

Can someone please tell me how to get data from tables with a different prefix?

Thank you.

Andreas
-------------------------------------------------
http://www.archaeologie-online.de
Subject Author Views Date
Thread Table prefix question Digger 2876 Mar 17, 2002, 12:10 PM
Thread Re: [Digger] Table prefix question
Alex 2814 Mar 17, 2002, 1:29 PM
Thread Re: [Alex] Table prefix question
Digger 2795 Mar 18, 2002, 6:24 AM
Thread Re: [Digger] Table prefix question
Alex 2782 Mar 18, 2002, 11:56 AM
Thread Re: [Alex] Table prefix question
Digger 2783 Mar 18, 2002, 12:14 PM
Post Re: [Digger] Table prefix question
Alex 2783 Mar 18, 2002, 12:20 PM