How do I display a result of a query?

[DrewM]

Well I'm trying to show the Results from a data base query in a templeat can any one tell me how to do this?

[tehste]

Originally Posted by Larrysw

Well I'm trying to show the Results from a data base query in a templeat can any one tell me how to do this?

well you need to put the results into an array. Unless it's a query_first as there is only one result so it will be in an array already.

Then just use $foo[foo] in the templates.

[DrewM]

I know how to do arrays but can you show me a exaple code my tables fields are:
id
name
url
description

[Nullifi3d]

$variable = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "tablename WHERE id = id");
$variable['id']
$variable['name']
$variable['url']
$variable['description']

[DrewM]

thank you

That code cases errors

anyone?

[DrewM]

help!

[Nullifi3d]

what error?????

[DrewM]

I get:
Parse error: parse error, unexpected T_VARIABLE in /home/rdsx667/public_html/tutorials/test.php on line 55

EDIT: before this code there was no error ( This isn't suppose to sound rude)

[Nullifi3d]

please disply your code to me. lines 50-60.

[DrewM]

heres the code:
$variable = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "tablename WHERE 1 = Links");
$variable['id']
$variable['name']
$variable['url']
$variable['description']
eval('print_output("' . fetch_template('site_test') . '");');