How do I pull data from a table into a module?

Lieutenant Joined: Jan 23, 2003 Posts: 258 Location: USA

I built a table called 'nuke_demo'.

It has 2 columns:
demo1 text not null
demo2 text not null

how can I get the text from the table into my new module?

I tried this...

function demo() {
global $demo1, $demo2;

if ($demo1 != "") {
echo "$demo1<br>\n";
}
if ($demo2 != "") {
echo "$demo2<br>\n";
}
}

It obviously didn't work. I'm using php-nuke 6.5b6 at my test site.

Any suggestions?

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

You have to call it via a mysql select query:

select * from demo;

And assign it to variables that you can use.

Lieutenant Joined: Jan 23, 2003 Posts: 258 Location: USA

Sorry, I'm a little lost.

I understand that:
$sql = "SELECT * FROM demo";

but what do you mean by assign variables that I can use?

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Example from index.php:

$sql = "SELECT * FROM ".$prefix."_referer";
$result = $db->sql_query($sql);
$numrows = $db->sql_numrows($result);
if($numrows>=$httprefmax) {
$sql = "DELETE FROM from ".$prefix."_referer";
$result = $db->sql_query($sql);
}

Posted: Thu Feb 06, 2003 8:16 pm

More or less, it'd come up to something like:

Code: