expecting `T_WHILE'

borlandology

hi
after i browser the fiile containing this code it says:
parse error, expecting T_WHILE' in C:\xampp\htdocs\class\nav.php on line 78 Where is my fault? thy [code=php]do { if ( $r = mysql_fetch_array( $result_right_sec ) ) { $sec_name = $r['name']; $sec_id = $r['id']; $sec_icon = $r['icon']; $right_cat = "{$right_cat}"." <tr>\n\t<td height='20' width='130' valign='middle' align='right' dir='rtl'><a href=\"".( "javascript:ajaxpage('sec.view.php?id=".$sec_id."', 'main1');" )."\"".( "><b>".$sec_name."</b></a></td>\n\t<td height='20' width='24' valign='middle' align='center'><img border='0' src='{$sec_icon}' width='16' height='16'></td>\n\t</tr>" ); $result_right_cat = mysql_query( "SELECTid,name,sec` FROM cat WHERE sec='".$sec_id."' ORDER BY id ASC" );
do
{
} while ( !( $rr = mysql_fetch_array( $result_right_cat ) ) );
$cat_name = $rr['name'];
$cat_id = $rr['id'];
$right_cat = "{$right_cat}"." <tr>\n\t\t\t<td height='20' width='130' valign='middle' align='right' dir='rtl'><a href=\"".( "javascript:ajaxpage('cat.view.php?id=".$cat_id."', 'main1');" )."\"".( ">".$cat_name. "</a></td>\n\t\t\t<td height='20' width='24' valign='middle' align='center'><img border='0' src='images/switchon.gif' width='12' height='12'></td>\n\t\t\t</tr>" );
} while ( 1 );
}[/code]

laserlight

If you indent your code properly, you would discover that the while on the second line does not match with the do on the first line.

zypher11

this part confuses me. what are you trying to accomplish?

do
{
} while ( !( $rr = mysql_fetch_array( $result_right_cat ) ) );

borlandology

$result_right_sec = mysql_query( "SELECT id, name, icon FROM sec ORDER BY id ASC" );

borlandology

actually it's a pre-wrote script i'm manipulating to get familiar with it, but this part has error itself.

zypher11

remove the `s from the col names. whats the errors your getting?

borlandology

zypher11;10954348 wrote:
remove the `s from the col names. whats the errors your getting?

parse error, expecting `T_WHILE' in C:\xampp\htdocs\class\nav.php
on line 78

zypher11

as laserlight stated, indent your code properly and it will show that your while loops don't line up correctly. that's at a parse error is, a typo

borlandology

zypher11;10954350 wrote:
as laserlight stated, indent your code properly and it will show that your while loops don't line up correctly. that's at a parse error is, a typo

Here u r....

$result_right_sec = mysql_query( "SELECT `id`, `name`, `icon` FROM sec ORDER BY id ASC" );
do
{
    if ( $r = mysql_fetch_array( $result_right_sec ) )
    {
        $sec_name = $r['name'];
        $sec_id = $r['id'];
        $sec_icon = $r['icon'];
        $right_cat = "{$right_cat}"." <tr>\n\t<td height='20' width='130' valign='middle' align='right' dir='rtl'><a href=\"".( "javascript:ajaxpage('sec.view.php?id=".$sec_id."', 'main1');" )."\"".( "><b>".$sec_name."</b></a></td>\n\t<td height='20' width='24' valign='middle' align='center'><img border='0' src='{$sec_icon}' width='16' height='16'></td>\n\t</tr>" );
        $result_right_cat = mysql_query( "SELECT `id`, `name`, `sec` FROM cat WHERE sec='".$sec_id."' ORDER BY id ASC" );
        do
        {
        } while ( !( $rr = mysql_fetch_array( $result_right_cat ) ) );
        $cat_name = $rr['name'];
        $cat_id = $rr['id'];
        $right_cat = "{$right_cat}"." <tr>\n\t\t\t<td height='20' width='130' valign='middle' align='right' dir='rtl'><a href=\"".( "javascript:ajaxpage('cat.view.php?id=".$cat_id."', 'main1');" )."\"".( ">".$cat_name.      "</a></td>\n\t\t\t<td height='20' width='24' valign='middle' align='center'><img border='0' src='images/switchon.gif' width='12' height='12'></td>\n\t\t\t</tr>" );
    } while ( 1 );
}

zypher11

theres your problem, your following your if statement with a while(1); it should be following the initial do statement.

are you just returning 1 row from each query? if your just doing a single loop with a query for each loop then do this:

$result_right_sec = mysql_query( "SELECT `id`, `name`, `icon` FROM sec ORDER BY id ASC" );
while( $r = mysql_fetch_array( $result_right_sec ) )
{
	$sec_name = $r['name'];
	$sec_id = $r['id'];
	$sec_icon = $r['icon'];
	$right_cat = "{$right_cat}"." <tr>\n\t<td height='20' width='130' valign='middle' align='right' dir='rtl'><a href=\"".( "javascript:ajaxpage('sec.view.php?id=".$sec_id."', 'main1');" )."\"".( "><b>".$sec_name."</b></a></td>\n\t<td height='20' width='24' valign='middle' align='center'><img border='0' src='{$sec_icon}' width='16' height='16'></td>\n\t</tr>" );
	$result_right_cat = mysql_query( "SELECT `id`, `name`, `sec` FROM cat WHERE sec='".$sec_id."' ORDER BY id ASC" );

$rr = mysql_fetch_array($result_right_cat);
$cat_name = $rr['name'];
$cat_id = $rr['id'];
$right_cat = "{$right_cat}"." <tr>\n\t\t\t<td height='20' width='130' valign='middle' align='right' dir='rtl'><a href=\"".( "javascript:ajaxpage('cat.view.php?id=".$cat_id."', 'main1');" )."\"".( ">".$cat_name.      "</a></td>\n\t\t\t<td height='20' width='24' valign='middle' align='center'><img border='0' src='images/switchon.gif' width='12' height='12'></td>\n\t\t\t</tr>" );
}

borlandology

zypher11;10954352 wrote:

theres your problem, your following your if statement with a while(1); it should be following the initial do statement.

are you just returning 1 row from each query? if your just doing a single loop with a query for each loop then do this:

$result_right_sec = mysql_query( "SELECT `id`, `name`, `icon` FROM sec ORDER BY id ASC" );
while( $r = mysql_fetch_array( $result_right_sec ) )
{
	$sec_name = $r['name'];
	$sec_id = $r['id'];
	$sec_icon = $r['icon'];
	$right_cat = "{$right_cat}"." <tr>\n\t<td height='20' width='130' valign='middle' align='right' dir='rtl'><a href=\"".( "javascript:ajaxpage('sec.view.php?id=".$sec_id."', 'main1');" )."\"".( "><b>".$sec_name."</b></a></td>\n\t<td height='20' width='24' valign='middle' align='center'><img border='0' src='{$sec_icon}' width='16' height='16'></td>\n\t</tr>" );
	$result_right_cat = mysql_query( "SELECT `id`, `name`, `sec` FROM cat WHERE sec='".$sec_id."' ORDER BY id ASC" );

$rr = mysql_fetch_array($result_right_cat);
$cat_name = $rr['name'];
$cat_id = $rr['id'];
$right_cat = "{$right_cat}"." <tr>\n\t\t\t<td height='20' width='130' valign='middle' align='right' dir='rtl'><a href=\"".( "javascript:ajaxpage('cat.view.php?id=".$cat_id."', 'main1');" )."\"".( ">".$cat_name.      "</a></td>\n\t\t\t<td height='20' width='24' valign='middle' align='center'><img border='0' src='images/switchon.gif' width='12' height='12'></td>\n\t\t\t</tr>" );
}

u know the error points to a line which i think is irrelevant to this part of code it's:

$right_cat = "{$right_cat}\n\n\n\t</table></div>\n\t<div align='center'>\n<form method='POST' action='search.php' name='search'>\n<input type='submit'  class='def' value='&#1580;&#1587;&#1578;&#1580;&#1608;' name='B1'><input type='text' name='search' size='20' dir='rtl' class='def'>\n</form></div>\n\t</td>\n\t\t<td valign='top' background='images/def_images/right_block_right.jpg' height='148'>\t<img border='0' src='images/def_images/right_block_right.jpg' width='5' height='2'></td>\n\t</tr>\n\n\t\n\t\n\t<tr>\n\t\t<td valign='middle' align='center' colspan='3' height='24' class='right_block_foot'></td>\n\t</tr>\n\t<tr>\n\t\t<td width='1'></td>\n\t\t<td width='184'></td>\n\t\t<td height='6' width='5'></td>\n\t</tr>\n</table>";

anyway, thanks but this time i got:
Fatal error: Cannot redeclare class Config in C:\xampp\php\PEAR\Config.php on line 44
wtf is it to do with config.php !!?
i'm newbie and i'm feeling dizzy now !😕😕😕

bradgrafelman

borlandology wrote:
Cannot redeclare class Config

As the error message states, you tried to redeclare a class, meaning it was declared once already. Sounds like the Config.php file is being included more than once and you should look into using [man]include_once/man/[man]require_once/man (whichever is applicable).

Also note that performing SQL queries within loops of other SQL queries is a very huge red flag suggesting highly unoptimized use of the SQL database's relational features (a.k.a. one of the main reasons the thing exists in the first place). Instead, you should probably be JOIN'ing the two tables together. If you can explain in words what you're trying to do with the above code, we'd be happy to show you an example of what I mean.