I would like to echo some simple variable which is fetched frome a mysql table, but it doesn't show anything, even an error. This is the code:
<?PHP
$query_home = $db_connect->QUERY("SELECT * FROM home WHERE id =1");
IF($query_home->num_rows == 1)
{
$id = $query_home->FETCH_OBJECT()->id;
$home = $query_home->FETCH_OBJECT()->home;
$homepage = nl2br($home);
}
?>
<TD>
<?PHP ECHO"$homepage"; ?>
</TD>
EDITED :
every time you use FETCH_OBJECT() it will change the index of row. so to solve it, you can call it once and put it in variable
<?PHP
$query_home = $db_connect->QUERY("SELECT * FROM home WHERE id =1");
IF($query_home->num_rows == 1)
{
$obj = $query_home->FETCH_OBJECT();
$id = $obj->id;
$home = $obj->home;
$homepage = nl2br($home);
}
?>
<TD>
<?PHP ECHO"$homepage"; ?>
</TD>
hopefully it can help you in some way,
have a nice day.