I have created the following PHP file in order to get some information, after i extract this info i will make some more modifications in order to have the following data in a marquee on my homepage .
When i call the PHP file i get only a blank page....
Can you please help?????
PHP Code:
<?php
require('includes/application_top.php');
global $db;
$gal_sql = mysql_query("SELECT T0.products_id, T1.products_name, T0.products_model, T0.products_image, T0.products_price
FROM zc_products T0 inner join zc_products_description T1 on T0.products_id = T1.products_id
WHERE T0.products_model NOT LIKE '#%' ") or sqlerr(__FILE__, __LINE__);
$gal_sql_result = mysql_fetch_assoc($gal_sql) or die("No Products");
while ($gal_sql_result = mysql_fetch_array($gal_sql)) {
$gal_prod_id = $gal_sql_result[T0.products_id];
$gal_prod_name = $gal_sql_result[T1.products_name];
$gal_prod_model = $gal_sql_result[T0.products_model];
$gal_prod_img = $gal_sql_result[T0.products_image];
$gal_prod_prc = $gal_sql_result[T0.products_price];
echo "<TR><TD>$gal_prod_id</TD><TD>$gal_prod_name</TD><TD>$gal_prod_model</tr><tr><td>$gal_prod_img</td></tr><tr><td> $gal_prod_prc</td></tr>";
}
?>
<tr>
<td align='center'><?=$gal_prod_id;?><?=$gal_prod_name;?></td>
</tr>