php problem improving template vars html ouput tag

change to this code whats wrong to get the value of the row elements?

$rs = mysql_query("SELECT elements,id FROM $dbase.".$table_prefix."site_tmplvars WHERE id=$id");
$row = $rs;
$value = $row[’elements’];

you have to call fetchRow() function to return the actual row -- $row = fetchRow($rs) -- remember $rs is a SQL result set resource and not an array

now i change to this code

$rest =substr($id, 2, 0);
$table = $modx->getFullTableName("site_tmplvars");
$result = $modx->db->select("name, elements", $table, "name = ’.$rest.’ ");
$row = fetchRow($result);
$value = $row[’elements’ ];

and send "Fatal error: Call to undefined function: fetchrow() in /home/puedesbe/public_html/balu/inicio/manager/includes/tmplvars.format.inc.php on line 129"

actually, since you changed to using DBAPI functions, which I should have recommended anyway , here’s what you need to do...replace $row= fetchRow($result) [NOTE: which should have been $row= $modx->fetchRow(), but this is a deprecated function from Eto] with...

thanks it works (and finaly not use because im in the wrong way)
in the next post i put the code for frocess frontend htmltags like forms and the result send the variables and ability to use checkbox
hi