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]

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') . '");');

[Nullifi3d]

lol, you have to put:
$variable['id'], $variable['name'], $variable['url'], $variable['description'] in your template (site_test). $variable['id'] would display the mysql field id as do the other variables have the sam operation.

and with the query you need to change tablename to your mysql table name. ANd change 1 to a valid mysql field (i think this would be id, name, description, or url).

[DrewM]

I get this error when I save the templeat:
Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/rdsx667/public_html/forum/includes/adminfunctions_template.php(3537) : eval()'d code on line 18

[Nullifi3d]

Just to let you know. it's extremly hard for peole to help you if you don't post the code you're using when you list errors. When asking for help try to list the error and your code.

Remove the ' from the variables when putting them in vbulletin templates.

[DrewM]

sorry about this I'll try removing ' from it though.
It works with this thank you for the help.

on more question and I'm done how do I make the code repeat for the resaults?

[Nullifi3d]

you mean print the results for each row in the table?

[DrewM]

yes, help much apprictated

[Nullifi3d]

$rows = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "tablenamehere");
while ($row = $db->fetch_array($rows)) {
eval('$rowbits .= "' . fetch_template('templatenamehere') . '";');
}

Replace 'tablenamehere' with the name of the table which has the rows you want to print out. Replace 'templatenamehere' with the name of the template you want printed for every row in that table. Obviously you have to create a new template (templatenamehere). This template will be printed to the browser (eval'd) over and over again for each row in the table (tablenamehere). In the template you put your html and variables you want displayed for each row.

[DrewM]

thanks for the help it is much apprcated.

[Nullifi3d]

No prob, glad to help.