Blank Page :O Please HELP

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?????:shocking:

<?php

 require('includes/application_top.php');

 
    global $db;
      $gal_sql = "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  '#%' ";

   
      
    
	 $gal_sql_result = @mysql_query ($gal_sql) or die (mysql_error()); 
	
	  
	 
while ($row = mysql_fetch__array($gal_sql_result)) {
	  $gal_prod_id = $row['T0.products_id'];
      $gal_prod_name = $row['T1.products_name'];
      $gal_prod_model = $row['T0.products_model'];
      $gal_prod_img = $row['T0.products_image'];
      $gal_prod_prc = $row['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>";
}   
 
?>

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?????:shocking:

<?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>

i have changed it to this but still nothing....

<?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>

There's a Tutorial/FAQ on finding the causes of blank pages, which can be found by searching the Tutorials section for "blank page" ... pretty neat, huh? https://www.zen-cart.com/tutorials/index.php?article=82

Your use of short-open-tags is probably a contributor to the problem.

DrByte:

Your use of short-open-tags is probably a contributor to the problem.

What is short-open-tags ???

Googling "short open tags php" brings up this link as the first result, which answers that question: http://php.net/manual/en/ini.core.php#ini.short-open-tag

i do not understand why using <?php and ?> might cause any problems.... is there any other way that i should do it ?

If your server is configured to NOT allow short_open_tags then if you DO use them, as your code above does, then you'll be causing PHP errors, which could be the cause of the blank pages you're complaining about.

What are the myDebug-xxxx.log files telling you?

as i see almost all zencart files begin with <?php

i did try that but no file such as myDebug-xxxx.log was created.... there is only .htaccess and index.php there....

Perhaps you'll need to enable your own error logging within your custom code to find out what's causing the failure.

how do i do that ? please help me some more :)

please see my query and tell me if something is wrong with it...

or if i did not include some require(xxxx.php) file in order to connect with my database.

btw the php file i created is in my root folder

What is "or sqlerr(FILE, LINE)" intended to do?
Is sqlerr() a valid function in PHP?

yes it is... it tracks any errors and return it to me...

i have removed that piece of code but still nothing... still blank...

i have made some debugging.... the problem is in this part i think :

 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>"; 

      } 

This does not return anything so i guess that my vars may not populate correct.

i have defined another var and populate it manually and it shows ok.

$hi='hello';

<td align='center'><?=$hi?></td>

and i get the hello only....

So any ideas why my other vars may not get populated ????