help w\ith this count and loop code.

aron

i basicly want to start the count at 0 then do a loop to see if in the database a filed is = to 1 if it is then run the javascript if it is not the add 1 to the count and loop again but if the count is = 5 then stop and run the javascript at the bottom.

it will refresh the parent page which will have the error message.

count = 0
while (count <= 5) {
if ($line["type"] == 1 ){?>
<script language="JavaScript">
opener.location.reload();
self.close();
</script>
<?
}
count = count ++
}else}?>
<script language="JavaScript">
opener.location.reload();
self.close();
</script>
<?
}
?>

anyone able to help.

TTT

it will refresh the parent page which will have the error message.

...and the error is???

razz

You syntax is wrong. Missing $'s and ;'s and the brace after the else is backwards should be{.

Should be $count = 0;
while($count <=5)
{
code here
}

$count = $count++;

You could also do:

for ($count = 1, $count <= 5, $count++)
{
if ($line["type"] == 1 )
{
?>
<script language="JavaScript">
opener.location.reload();
self.close();
</script>
<?
}

 }
 else
 {

?>
<script language="JavaScript">
opener.location.reload();
self.close();
</script>
<?
}
?>

Hope that helps,

razz

aron

i missed out a part sorry.

for ($count = 1, $count <= 5, $count++)
{
if ($line["type"] == 1 )
{
?>
<script language="JavaScript">
opener.location.reload();
self.close();
</script>
<?
}
}
else
{
?>
<script language="JavaScript">
opener.location.reload();
self.close();
</script>
<?
}
?>

it comes up blank so somthing is incorrect in this script.?

cheers aron.

aron

if ($chkRE == "1"){ ?>
<script language="JavaScript" for="window" event="onload()">
window.open("xml_scripts/xml_script_<? echo $xml_page ; ?>.php?property_id=<? echo $listing_id ; ?>", "myannouncer", "scrollbars=no,resizable=no,height=230,width=170")
</script>
<?
}
$count = 0;
while($count <=5)
{
if ($line["re_visibility"] == 1 )
{
?>
<script language="JavaScript">
opener.location.reload();
self.close();
</script>
<?
}
} else {
?>
<script language="JavaScript">
opener.location.reload();
self.close();
</script>
<?
}
}
$count = $count++;
?>

still comes up blank.

razz

Where are these variables coming from:

$chkRE
$xml_page
$listing_id
$line["re_visibility"]

Also the last one should be single quotes I believe as in $line['re_visibility']

Other than that I don't see anything that is jumping out at me.

razz

aron

<?
$connection = mysql_connect("domain","user","pass") or die('Could not connect to the database server');
$db = mysql_select_db("test", $connection) or die ("Unable to select database1");
$sql = "SELECT * FROM Listings WHERE id=$listing_id";
$sql_result = mysql_query($sql,$connection) or die ("Error: ".mysql_error()."<br /><br />".$sql);
$line = mysql_fetch_array($sql_result);

$original_page = $line["type"];
echo $original_page . "<br>";

if ($original_page=='Rental House')
{
$xml_page = "rental";
}else if ($original_page == "Rental Unit")
{
$xml_page = "rental";
}else if ($original_page == "Business")
{
$xml_page = "business";
}else if ($original_page == "Rural")
{
$xml_page = "rural";
}else if ($original_page == "Land Commercial")
{
$xml_page = "land_commercial";
}else if ($original_page == "Land Residential")
{
$xml_page = "land";
}else if ($original_page == "Land Estates")
{
$xml_page = "land";
}else if ($original_page == "Land")
{
$xml_page = "land";
}else if ($original_page == "Riverfront Land")
{
$xml_page = "land";
}else
{
$xml_page = "residential";
}

echo $xml_page . "<br>";

if ($chkRE == "1")
{
?>
<script language="JavaScript" for="window" event="onload()">
window.open("xml_scripts/xml_script_<? echo $xml_page ?>.php?property_id=<? echo $listing_id ?>", "myannouncer", "scrollbars=no,resizable=no,height=230,width=170")
</script>
<?
}
$count = 0;
while($count <=5)
{
if ($line['re_visibility'] == 1 )
{
?>
pass 1
<?
} else {
?>
pass2
<?
}
}
$count = $count++;
echo "end";
?>

aron

is it beacause there are to many if else statement.??

please help.

$original_page = $line["type"];
echo $original_page . "<br>";

echo $xml_page . "<br>";

aron

im trully baffeled.??

aron

bubblenut

Right the main problem is that your $count++ is outside the while loop so the while loop is infinite. Move the $count++ inside the preceding brace. Also there are two variables $chkRE and $listing_id which never appear to be set. If they are POST/GET/SESSION vars use the $POST/$GET/$_SESSION notation. The opening <? s should really be <?php although on most servers this won't make a differene (still better to be <?php)
Try those and let us know of the result.
HTH

germanjulian

u gotta love loops when you suddenly have over 100.000 date entries in your database. :rolleyes:

aron

i changed it to what you said.

i have registered global set to on thats why i had this like this

if ($chkRE == "1")

if ($POST ['chkRE'] == "1")
{
?>
<script language="JavaScript" for="window" event="onload()">
window.open("xml_scripts/xml_script<? echo $xml_page ?>.php?property_id=<? echo $listing_id ?>", "myannouncer", "scrollbars=no,resizable=no,height=230,width=170")
</script>
<?
}
$count = 0;
while($count <=5)
{
if ($line['re_visibility'] == 1 )
{
?>
pass 1
<?
} else {
?>
pass2
<?
}
$count = $count++;
}
echo "end";
?>

page comes up blank.
dosent echo anything.

cheers aron.