parse error

[dingsbums]

Parse error: parse error in E:\blabla on line 27

i have this error and i'm not shure what i'm doing wrong. since i change php from 3 to 4 there are serval new errors. (i could fix them) but this one makes me ...

here's the code: starting on line 20:

<?php

include("conf.php");
include("functions.php");

$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_select_db($db) or die ("Unable to select database!");
$limit = 3;
$query_count = "SELECT id FROM cd";

$result_count = mysql_query($query_count);

$totalrows = mysql_num_rows($result_count);

if(empty($page))

$page = 1;

$limitvalue = $page $limit - ($limit);

$query = "SELECT FROM cd ORDER BY timestamp DESC LIMIT $limitvalue, $limit";

$result = mysql_query($query) or die("Error: " . mysql_error());

if (mysql_num_rows($result) > 0)

{
while($row = mysql_fetch_object($result))
{

?>

this is line 27:
$limit = 3;

any help?!

[planetsim]

Its probably correct just that i do it different

mysql_select_db($db) or die ("Unable to select database!");

to

mysql_select_db($db)or die ("Unable to select database!");

Im thinking it might be the space before the "or"

[xblue]

don't think so, most spaces are ignored anyway.

your code doesn't look suspicious as far as I can see apart from the two opening brackets you probably close later (but could you use the &#091;php] &#091;/php] tags next time?)

have you checked your includes?

[dingsbums]

i check the includes again.

seams to be ok 2. (sorry about the

)

so here i post the rest source because i really can't figure it out. (i put all the source together in one file)  

[code=php]

include("conf.php");
include("functions.php");

$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_select_db($db) or die ("Unable to select database!"); 
$limit        = 3;
$query_count  = "SELECT id FROM cd";      

$result_count = mysql_query($query_count);       

$totalrows    = mysql_num_rows($result_count);

if(empty($page))

$page = 1;       

$limitvalue = $page * $limit - ($limit);  

$query     = "SELECT * FROM cd ORDER BY timestamp DESC LIMIT $limitvalue, $limit";           

$result    = mysql_query($query) or die("Error: " . mysql_error());

if (mysql_num_rows($result) > 0)

{
	while($row = mysql_fetch_object($result))
	{

<a href="lp_view.php?id=<? echo $row->id; ?>"><img src="../covers/<? echo $row->titel; ?>" border="0" alt="cover - click for more information" width="90" height="90"></a><b>
<font face="Verdana, Arial, Helvetica, sans-serif, Holstein" size="-2" class="wfi">

}

}

else

{

<b>NO INPUT</b></font><font face="Verdana, Arial, Helvetica, sans-serif, Holstein" size="-2"><i>

 

			  if($page != 1){  
    $pageprev = $page--; 

    echo("<a href=\"$PHP_SELF&page=$pageprev\">PREV</a>&nbsp;");  
        }else 
    echo("PREV&nbsp;");  

$numofpages = $totalrows / $limit;  

for($i = 1; $i <= $numofpages; $i++){ 

    if($i == $page) 
        echo($i."&nbsp;"); 
    else 
        echo("<a href=\"$PHP_SELF&page=$i\">$i</a>&nbsp;");  

        }  

if(($totalrows % $limit) != 0){ 

    if($i == $page) 
        echo($i."&nbsp;"); 
    else 
        echo("<a href=\"$PHP_SELF&page=$i\">$i</a>&nbsp;"); 

}   

if(($totalrows - ($limit * $page)) > 0){ 

    $pagenext     = $page++;  

    echo("<a href=\"$PHP_SELF&page=$pageprev\">NEXT</a>");  

}else 
    echo("&nbsp; NEXT ".$limit);  


mysql_free_result($result); 



}

[xblue]

that's okay, after all it was your first post and from now on you'll know. what you posted still seems fine to me, post the includes (hope they aren't too long?) in case you still don't find anything.

[dingsbums]

thanks for your help.

ok. so here are the config and the function php files...

conf.php

$host = "localhost";
$user = "root";
$pass = "sqlpassword";
$db = "wfi";
$def_contact = "mailto:me";

functions.php

function formatDate($val)

{

$arr = explode("-", $val);

return date("d M Y", mktime(0,0,0, $arr[1], $arr[2], $arr[0]));

}

[xblue]

sorry, I'd like to help, but I really don't see it. hopefully somebody else will.

[dingsbums]

thanks, anyway. it makes me nervous.
because i'm sitting over this for hours.
and i can't see what i did wrong...

do anybody else got an idea?!

[dingsbums]

i've got the solution!

it was a compilation error. i have written some parts in a external editor and i paste it into a wysiwyg later. put it up with it.

that was the problem. it makes a mess with the binary. many strange tags where into the document.

i put them out and now the parse error is gone.

just to let you know... 🙂 juhu