vb.org Archive - [Parse error ]in my code help needed

Page 1 of 2

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - [Parse error ]in my code help needed (https://vborg.vbsupport.ru/showthread.php?t=57167)

Almax1

09-17-2003 04:03 PM

[Parse error ]in my code help needed

Parse error: parse error in /xxx/xxx/xxx/topp.php on line 17

================================================== =

PHP Code:


		
			
<?php





require("admin/config.php");

$db=mysql_connect($servername,$dbusername,$dbpassword) or die("Unable to connect to database");

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





$postsresult = mysql_query("SELECT COUNT(*) AS count,postuserid,postusername FROM thread WHERE forumid IN (10,11) GROUP BY postuserid ORDER BY count DESC LIMIT $maxposters;") or die("Unable to complete query");

while ($topposters = mysql_fetch_array($postsresult)):

    if (($counter++ % 2) != 0) {

        $bc=$bc1;

    } else {

        $bc=$bc2;

}

eval("dooutput(\"".gettemplate("topp")."\");");

?>

=========================================

trying to display thread starters in 2 forums 10 & 11
in a template
a simple guideline would be great please

SmEdD

09-17-2003 07:00 PM

try

PHP Code:


		
			
<?php

require("admin/config.php");

$db=mysql_connect($servername,$dbusername,$dbpassword) or die("Unable to connect to database");

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



$postsresult = mysql_query("SELECT COUNT(*) AS count,postuserid,postusername FROM thread WHERE forumid IN (10,11) GROUP BY postuserid ORDER BY count DESC LIMIT $maxposters") or die("Unable to complete query");

while ($topposters = mysql_fetch_array($postsresult)):

if (($counter++ % 2) != 0) {

$bc=$bc1;

} else {

$bc=$bc2;

}



eval("dooutput(\"".gettemplate("topp")."\");");

?>

Almax1

09-17-2003 07:21 PM

Parse error: parse error in /xxx/xxx/xxx/topp.php on line 15

had tried that bit of code earlier already :(

thanks for trying though ;)

any clues ??

filburt1

09-17-2003 07:25 PM

Quote:

Originally Posted by Almax1

Parse error: parse error in /xxx/xxx/xxx/topp.php on line 15

had tried that bit of code earlier already :(

thanks for trying though ;)

any clues ??

You're missing a closing brace for the loop. If you indent this way, it is far easier to read:

PHP Code:


		
			
while ($topposters = mysql_fetch_array($postsresult))

{

    if (($counter++ % 2) != 0)

    { 

        $bc=$bc1; 

    }

    else

    { 

        $bc=$bc2; 

    }

}

Almax1

09-17-2003 07:50 PM

No joy filburt1 :(
inserted this code

PHP Code:


		
			
<?php 



require("admin/config.php"); 

$db=mysql_connect($servername,$dbusername,$dbpassword) or die("Unable to connect to database"); 

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





$postsresult = mysql_query("SELECT COUNT(*) AS count,postuserid,postusername FROM thread WHERE forumid IN (10,11) GROUP BY postuserid ORDER BY count DESC LIMIT $maxposters;") or die("Unable to complete query"); 

 while ($topposters = mysql_fetch_array($postsresult)) 

{ 

    if (($counter++ % 2) != 0) 

    { 

        $bc=$bc1; 

    } 

    else 

    { 

        $bc=$bc2; 

    } 

}  

eval("dooutput(\"".gettemplate("topp")."\");"); 

?>

result= Unable to complete query

could this be the template ??

filburt1

09-17-2003 07:55 PM

Quote:

Originally Posted by Almax1

No joy filburt1 :(
inserted this code

PHP Code:


		
			
<?php 



require("admin/config.php"); 

$db=mysql_connect($servername,$dbusername,$dbpassword) or die("Unable to connect to database"); 

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





$postsresult = mysql_query("SELECT COUNT(*) AS count,postuserid,postusername FROM thread WHERE forumid IN (10,11) GROUP BY postuserid ORDER BY count DESC LIMIT $maxposters;") or die("Unable to complete query"); 

 while ($topposters = mysql_fetch_array($postsresult)) 

{ 

    if (($counter++ % 2) != 0) 

    { 

        $bc=$bc1; 

    } 

    else 

    { 

        $bc=$bc2; 

    } 

}  

eval("dooutput(\"".gettemplate("topp")."\");"); 

?>

result= Unable to complete query

could this be the template ??

Don't include a semicolon in the query; only do that in the mysql command-line client.

Almax1

09-17-2003 08:10 PM

Thanks for your time filburt1
i took the semicolon out from the end of the query with no joy :(

Almax1

09-17-2003 08:53 PM

stuck completley now
/me *cries* for HELP :P

Logician

09-18-2003 10:24 AM

assign a value for "$maxposters". It is blank in your code so query has a syntax error.

Almax1

09-18-2003 12:51 PM

Thanks Logician but still no luck :(

changed the code to this

PHP Code:


		
			
<?php 



/////////////// CONFIG ///////////////

//

$maxposters = "10"; // change this to the number of posters you want to show.

$bc1 = "#777777"; // change to first alternating color.

$bc2 = "#555555"; // change to second alternating color.

///////////// END CONFIG /////////////





require("admin/config.php"); 

$db=mysql_connect($servername,$dbusername,$dbpassword) or die("Unable to connect to database"); 

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





$postsresult = mysql_query("SELECT COUNT(*) AS count,postuserid,postusername FROM thread WHERE forumid IN (10,11) GROUP BY postuserid ORDER BY count DESC LIMIT $maxposters;") or die("Unable to complete query"); 

while ($topposters = mysql_fetch_array($postsresult)) 

{ 

    if (($counter++ % 2) != 0) 

    { 

        $bc=$bc1; 

    } 

    else 

    { 

        $bc=$bc2; 

    } 

} 

eval("dooutput(\"".gettemplate("topp")."\");"); 

?>

Fatal error: Call to undefined function: gettemplate() in /xxx/xxx/xxx/xxx/xxx/topp.php on line 28

All times are GMT. The time now is 01:12 PM.

Page 1 of 2

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05748 seconds Memory Usage 1,771KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: