Subiecte care încep cu '.$c.'';
include '../meniu_subiect_lista.php';
}
else
{
echo 'Subiecte
';
include '../meniu_subiect_start.php';
}
include "../header_content.php";
include '../config.php';
include '../show_access.php';
$link = mysql_connect( $citatepedia_serv, $citatepedia_user, $citatepedia_pass );
if ( ! $link )
die( "Couldn't connect to MySQL" );
else
{
mysql_select_db( $citatepedia_data,$link ) or die ( "Couldn't open database: ".mysql_error() );
$mycontext_theme='D';
$mycontext_order='data_extern DESC';
if ($c<>"")
{
echo 'Toate subiectele care încep cu '.$c.'
';
$result = mysql_query( "SELECT * FROM citatepedia_subiect WHERE LEFT(subiect0,1)='".substr($c,0,1)."' ORDER BY subiect0", $link ) or die ( "Couldn't select: ".mysql_error() );
$mycontext_limit=1+round(mysql_num_rows($result)/20);
echo '';
while ( $row = mysql_fetch_array( $result ) )
{
echo '- ';
if ($row['inregistrari']>1000) echo '';
echo ''.$row['subiect'].'';
if ($row['inregistrari']>1000) echo '';
if ($row['opus']<>'') echo ' (subiect complementar: '.$row['opus'].')';
if ($_SERVER['REMOTE_ADDR']==$access) echo ' e';
echo '
';
}
echo '
';
}
else
{
$mycontext_limit='10';
$date=getdate();
$sarbatori_cond=' citatepedia.lungime<=250 ';
include '../sarbatori.php';
$result5 = mysql_query( "SELECT * FROM citatepedia_subiect ORDER BY accesat DESC LIMIT 3", $link ) or die ( "Couldn't select: ".mysql_error() );
while ( $row5 = mysql_fetch_array( $result5 ) )
{
$subiect=$row5['subiect'];
include '../despre.php';
}
echo 'Alte subiecte accesate recent
';
$result = mysql_query( "SELECT * FROM citatepedia_subiect ORDER BY accesat DESC LIMIT 4,50", $link ) or die ( "Couldn't select: ".mysql_error() );
echo '';
while ( $row = mysql_fetch_array( $result ) )
{
echo '- '.$row['subiect'].'';
if ($row['opus']<>'') echo ' (subiect complementar: '.$row['opus'].')';
if ($_SERVER['REMOTE_ADDR']==$access) echo ' e';
echo '
';
}
echo '
';
}
}
echo '
';
include '../module_ad3.php';
include "../sidebar.php";
mysql_close( $link );
include "../footer_general.php";
?>