HI All
This is my updated code.
<?php
$dbhost = 'localhost:3036';
$dbuser = 'Dbuser';
$dbpass = 'MyPassword';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
$sql = "SELECT t.old_text FROM
my_wiki.page p INNER JOIN my_wiki.revision r ON p.page_latest = r.rev_id
INNER JOIN my_wiki.text t ON r.rev_text_id = t.old_id
WHERE p.page_id = 208";
mysql_select_db('my_wiki.text');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not get data...' . mysql_error());
}
$content = "";
while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
{
$content .= "(text from the page : {$row['t.old_text']}";
}
echo '
<script type="text/javascript">
{
alert(' . {$content} . ');
}
</script>';
?>
For some reason nothing happens.
Cheers
Alistair