How to use a variable between many blocks of PHP

jangoux

Hi,

I am writing a page and i am having some trouble with some variable stuff. I have a block of PHP code connecting to a dbserver and performing a query, and some blocks of regular HTML, a block of PHP, HTML...you got the idea. The first PHP code also fetches the results of the Dbquery. The problem is that i am having trouble printing the rest of the variables on the other blocks. I've tried assigning variables to the whole vector that resulted from the query, and printing this variables, but no luck.

Here's a sample of the code :

<?php while ($bandas=mysql_fetch_array($query)) {
print "$bandas[nome]" ; } / works ok and prints / ?>

HTML BLOCK

<?php
print "$bandas[estado]" ; ?>

HTML BLOCK....

Also tried :

<?php while ($bandas=mysql_fetch_array($query)) {
print "$bandas[nome]" ; }
$estado="$bandas[estado]"; ?>

HTML BLOCK

<?php
print "$estado" ; ?>

Also tried global variables with no luck. Any tips?

Thanks,
Ivan

BSTRhino

jangoux I think there's nothing wrong with your code, so look carefully at your SQL query. Does it return a column called 'estado'? If not, that could be your problem.

paulnaj

If you write your first PHP block with a bit of indenting for readability 😉 ...

<?php 
while ($bandas = mysql_fetch_array($query)) { 
  print "$bandas[nome]" ; 
} 
/* works ok and prints */ 
?>

... it's easy to see that you've closed the while loop straight after printing one line.

Try indenting your code to reflect containment ...

<?php 

while ($bandas = mysql_fetch_array($query)) { 
  print $bandas['nome']; 

?>
<!-- HTML BLOCK -->
<?php 

  print $bandas['estado'];

?>
<!-- HTML BLOCK -->
<?php 

} // Close loop here

?>

I've changed your "$bandas[nome]" to $bandas['nome'], which seems more natural and readable to me, but that's just a preference ... your way works.

Paul.

drawmack

<?php
while ($bandas=mysql_fetch_array($query)) {
    print "$bandas[nome]"; 
} /* works ok and prints */ 
?>

HTML BLOCK

<?php 
print "$bandas[estado]" ;  

?>

HTML BLOCK....

The problem is your running your while loop through the entire query, then your attempting to run a second while loop to go through the query again. Try this:

<?php
while($bandas = mysql_fetch_array($query)) {{
    print $bandas['nome'];
?>
    html block
<?php print $bandas['estado']; ><
    html block...
<?php } //end whils ?>

jangoux

drawmack, Thanks, that worked. I just didn't understand why the 2 '{ {' and just one to close everything. Is there any reason to this?

jangoux

Also, in the same script, I am having trouble with this block :

<?php  if (file_exists("http://www.norteaorock.com.br/bandas/$bandas[nome]/logo.jpg")) 
{
  print "<img src=\"http://www.norteaorock.com.br/bandas/$bandas[nome]/logo.jpg\" width=\"152\" height=\"123\" border= \"1\" >"; 
 } else 
{ print "<img src=\"http://www.norteaorock.com.br/imagem/nologo.jpg \" width=\"152\" height=\"123\" border=\"1\"> "; }  ?>

I always get a parse error on the line with the else statement. What's the problem?

paulnaj

Im surprised the 2 '{{' did work ... each opening brace needs a corresponding closing brace.

drawmack

yeah that was a typo on my part.