31
Yes you certainly mis-understood. I want to extract content from one page to another.
I am thinking a smarty like this. This doesn't work. It is just a concept:
I don't know the smarty tags but if there is one that locates the content of a directory in the database I think I can get it to work.
Or more likely an SQL query. This didn't work either but it's because I don't have a clue about DB query strings so someone with knowledge please help me correct this query.
It is to extract from the content column of the xoops_newblocks table and identify it by the title column 'Test'
I am thinking a smarty like this. This doesn't work. It is just a concept:
<div>
<{show $block.content from=$xoops_dirname == "basic"}>
</div>
I don't know the smarty tags but if there is one that locates the content of a directory in the database I think I can get it to work.
Or more likely an SQL query. This didn't work either but it's because I don't have a clue about DB query strings so someone with knowledge please help me correct this query.
It is to extract from the content column of the xoops_newblocks table and identify it by the title column 'Test'
<{php}>
$username='root';
$password='password';
$hostname='localhost';
$databasename='xoops';
$conection = @mysql_connect($hostname, $username, $password);
mysql_select_db($databasename);
$results = mysql_query("SELECT content FROM xoops_newblocks WHERE title=('Test') ");
while ( $row = mysql_fetch_array( $results ) ) {
echo mysql_result($result);
}
<{/php}>
