[Resolved] stupid error

[k994519]

HI guys,

got a stupid error the simple one about unexpected $end

Ive looked and looked but i cant seem to find it after taking 20 mins away from the screen I cant still find it, ive punched the monitor more than once and I beg you for ur help.....

here is the code

<?php 

session_start();
header("Cache-control: private");

//$page_title = "Survey Admin: Edit Questions";
include_once("start_page_login.php");
print("<h3>Welcome to the admin page <b>".$_SESSION["login"]."</h3></b><br>\n");
include_once("start_page_admin.php");
include_once("config.php");
include_once("forms.php");

doCSS();



$checkpostarray=$_POST['checkboxarray'];

if(! is_array($checkpostarray))
{
	$checkpostarray = array(); 
}

echo("\$_POST['checkboxarray'] ");foreach ($checkpostarray as $key => $value)

{
	echo("($key = $value )");
}

$query="SELECT description FROM modules WHERE description='".$_POST["description"]."'";
	// Run query:
$result=mysql_query($query, $link) or die("MySQL query $query failed.  Error if any: ".mysql_error());

if (!$result)
	{ 
			if ( !$result){ ?>  <P>Error performing ID query:<?=mysql_error()?></P>  <?php 
	}

while ($row=mysql_fetch_array($result,MYSQL_ASSOC))
	{
		$available='N'; if (in_array($row['desciption'],$checkpostarray)) $available='Y';

		if(!@mysql_query("UPDATE modules SET Available='$available' WHERE description=$row[description]"))
	{
			?>
	<P> Error performing update:<?=mysql_error()?></P>
<?php
} // if
}
// while
// Display selection

$result = @mysql_query("Select * from modules");

mysql_query("UNLOCK TABLES");

if (!$result){
	?>  <P>Error performing * query:<?=mysql_error()?></P>  <?php exit(); 
	}?>
<form action="<?=$SERVER['PHP_SELF']?>" method="post">

<?php while ($row=mysql_fetch_array($result,MYSQL_ASSOC))
	{ ?>
  <?=$row['module_id']?> <?=$row['description']?> <?="Available[".$row['Available']."]"?>
  <input type="checkbox" name="checkboxarray[]"  value="<?=$row['ID']?>"
     <?php if (in_array($row['description'],$checkpostarray)) {?>checked<?php 
	} // if ?> /><br/>
<?php
	}
	 // while ?>
<input type="submit" value="New Selection" />
</form>
</html>

thanks for your help in advance

[cgraz]

That's a lot of code. Could you post the line number?

Cgraz

[k994519]

last line

i have commented out some html stuff below though.........

this is the error message....

Parse error: parse error, unexpected $end in c:\program files\apache group\apache\htdocs\add_module.php on line 218

[cgraz]

I'm pretty sure you're missing a closing bracket for this if statement

if (!$result) {  // this if statement, not the one below
    if ( !$result){ ?>  <P>Error performing ID query:<?=mysql_error()?></P>  <?php  } 

Cgraz

[k994519]

Hey dude,

Iv tried to change the code but i get another error now.........

I am getting really really angry with this now......... 🙁

as ever thanks for ur help,

error message Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in c:\program files\apache group\apache\htdocs\check.php on line 71 marked with an *

<?php  

session_start(); 
header("Cache-control: private"); 

//$page_title = "Survey Admin: Edit Questions"; 
include_once("start_page_login.php"); 
print("<h3>Welcome to the admin page <b>".$_SESSION["login"]."</h3></b><br>\n"); 
include_once("start_page_admin.php"); 
include_once("config.php"); 
include_once("forms.php"); 

doCSS(); 



$checkpostarray=$_POST['checkboxarray']; 

if(! is_array($checkpostarray)) 
{ 
    $checkpostarray = array();  

} 

echo("\$_POST['checkboxarray'] ");foreach ($checkpostarray as $key => $value) 

{ 
    echo("($key = $value )"); 
} 

$query="SELECT description FROM modules WHERE description='".$_POST["description"]."'"; 
    // Run query: 
$result=mysql_query($query, $link) or die("MySQL query $query failed.  Error if any: ".mysql_error()); 

if (!$result) 
    {  

            if ( !$result)
				{
				?>  <P>Error performing ID query:<?=mysql_error()?></P>  <?php  

				{
	} 

while ($row=mysql_fetch_array($result,MYSQL_ASSOC)) 
    { 
        $available='N'; if (in_array($row['desciption'],$checkpostarray)) $available='Y'; 

	}

$query="SELECT description FROM modules WHERE description='".$_POST["description"]."'";

// Run query:
$result=mysql_query($query, $link) or die("MySQL query $query failed.  Error if any: ".mysql_error());



} // if 
} 
// while 
// Display selection 

$result = @mysql_query("Select * from modules"); 

if (!$result){ 

print"error"; mysql_error();  
}
?> 
<form action="<?=$SERVER['PHP_SELF']?>" method="post"> 

<?php while ($row=mysql_fetch_array($result,MYSQL_ASSOC)) 
    {
 * $row['module_id']?> <?=$row['description'] "Available[".$row['Available']."]";?> 

  <input type="checkbox" name="checkboxarray[]"  value="<?php $row['module_ID']?>"> 
     <?php 
	  if (in_array($row['description'],$checkpostarray)) 
	  {
	  ?>checked<?php  

	  }
	  // if ?> /><br/> 
<?php 
	  }
   // while ?> 
<input type="submit" value="New Selection" /> 
</form> 

[cgraz]

This code is REALLY ugly 😃

   $row['module_id']?> <?=$row['description'] "Available[".$row['Available']."]";?> 

What exactly are you trying to do there? Print the variables? If so, try this

echo $row["module_id"] . " " . $row["description"] . " Available " . $row["Available"];

Cgraz

[k994519]

thanks dude,

I know the code is ugly its not mine

its my so called lecturer who gets paid 50k a year....... yep go figure

it does not print the field description from the table modules, can u please please please please please help me..... if possible suggest another way of creating a check box which shows the details in description from table modules.......

thanks