<script type="text/javascript" src="js/prototype.js"></script>
<script type="text/javascript" src="js/scriptaculous.js?load=effects"></script>
<script type="text/javascript" src="js/lightbox.js"></script>
<link rel="stylesheet" href="css/lightbox.css" type="text/css" media="screen" />
<?
db_connect();
$prod_sel=mysql_fetch_assoc(mysql_query("SELECT * FROM vacante WHERE id='$id'"));
$id=$prod_sel['id'];
$titlu=$prod_sel['titlu'];
$categorie=$prod_sel['categorie'];
$subtitlu=$prod_sel['subtitlu'];
$subtitlu=str_replace("\r\n","<br />",$subtitlu);
$poze=$prod_sel['poze'];
$poze=explode(', ',$poze);
$tabel=$prod_sel['tabel'];
$tabel1=$prod_sel['tabel1'];
$tab1_nume=$prod_sel['tab1_nume'];
$tab1_note=$prod_sel['tab1_note'];
$tabel2=$prod_sel['tabel2'];
$tab2_nume=$prod_sel['tab2_nume'];
$tab2_note=$prod_sel['tab2_note'];
$tabel3=$prod_sel['tabel3'];
$tab3_nume=$prod_sel['tab3_nume'];
$tab3_note=$prod_sel['tab3_note'];
$tabel4=$prod_sel['tabel4'];
$tab4_nume=$prod_sel['tab4_nume'];
$tab4_note=$prod_sel['tab4_note'];
$vvvv=explode('~!~',$tabel);
$val=$vvvv[0];
$nr_row=$vvvv[1];
$val=explode(chr(254),$val);
$vvvv=explode('~!~',$tabel1);
$tab_1=$vvvv;
$val1=$vvvv[0];
$nr_row1=$vvvv[1];
$nr_col1=$vvvv[2];
$val1=explode(chr(254),$val1);
$vvvv=explode('~!~',$tabel2);
$tab_2=$vvvv;
$val2=$vvvv[0];
$nr_row2=$vvvv[1];
$nr_col2=$vvvv[2];
$val2=explode(chr(254),$val2);
$vvvv=explode('~!~',$tabel3);
$tab_3=$vvvv;
$val3=$vvvv[0];
$nr_row3=$vvvv[1];
$nr_col3=$vvvv[2];
$val3=explode(chr(254),$val3);
$vvvv=explode('~!~',$tabel4);
$tab_4=$vvvv;
$val4=$vvvv[0];
$nr_row4=$vvvv[1];
$nr_col4=$vvvv[2];
$val4=explode(chr(254),$val4);
/*foreach ($val as $k => $v) {
//$k=str_replace('รพ','\r\n',$v);
echo "<br>".$k."->".$v."<br>";
}*/
?>
<link href="easy.css" rel="stylesheet" type="text/css">
<table width="533" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr>
<td align="center" valign="top" class="titlu_pagina"><? echo $titlu; ?></td>
</tr>
<tr>
<td align="center" valign="top" class="important"><? echo "$subtitlu"; ?></td>
</tr>
<tr>
<td align="center" valign="top">
<fieldset style="float:right; margin-left:5px;">
<legend align="left" >Poze</legend>
<? if ($poze[0]!='') { ?>
<a href='xadmin/upload_pics/big/<? echo $poze[0]; ?>.jpg' rel="lightbox[<? echo $titlu; ?>]" title='<? echo $titlu; ?>'> <img src='xadmin/upload_pics/small/<? echo $poze[0]; ?>.jpg' border='1' class="img_big_border" /></a>
<? } ?>
<br />
<br />
<?
if ($poze[1]!='') { ?>
<a href='xadmin/upload_pics/big/<? echo $poze[1]; ?>.jpg' rel="lightbox[<? echo $titlu; ?>]" title='<? echo $titlu; ?>'> <img src='xadmin/upload_pics/small/<? echo $poze[1]; ?>.jpg' border='1' class="img_big_border" /></a>
<? } ?>
<br />
<br />
<?
if ($poze[2]!='') { ?>
<a href='xadmin/upload_pics/big/<? echo $poze[2]; ?>.jpg' rel="lightbox[<? echo $titlu; ?>]" title='<? echo $titlu; ?>'> <img src='xadmin/upload_pics/small/<? echo $poze[2]; ?>.jpg' border='1' class="img_big_border" /></a>
<? } ?>
<br />
<br />
<?
if ($poze[3]!='') { ?>
<a href='xadmin/upload_pics/big/<? echo $poze[3]; ?>.jpg' rel="lightbox[<? echo $titlu; ?>]" title='<? echo $titlu; ?>'> <img src='xadmin/upload_pics/small/<? echo $poze[3]; ?>.jpg' border='1' class="img_big_border" /></a>
<? } ?>
<br />
<br />
<?
if ($poze[4]!='') { ?>
<a href='xadmin/upload_pics/big/<? echo $poze[4]; ?>.jpg' rel="lightbox[<? echo $titlu; ?>]" title='<? echo $titlu; ?>'> <img src='xadmin/upload_pics/small/<? echo $poze[4]; ?>.jpg' border='1' class="img_big_border" /></a>
<? } ?>
</fieldset>
<div align="left" class="info_titlu" >
<div align="justify">
<? echo "Categorie : $categorie"; ?>
</div>
</div>
<? for($i=0; $i<$nr_row; $i++) {
$old_val=explode("|",$val[$i]);
$j=0;
?>
<div align="left" class="info_titlu" >
<div align="justify">
<?
echo makeClickableLinks($old_val[$j]);
$j++;?>
</div>
</div>
<div align="left" class="info_subtitlu" >
<div align="justify">
<?
echo makeClickableLinks($old_val[$j]);
$j++;?>
</div>
</div> <div align="justify" class="info_detalii">
<?
if ($old_val[$j]!="") $old_val[$j]="<img src='images/bilete_de_avion_arrow.jpg' alt='paragraf' width='4' height='7' /> ".$old_val[$j];
$old_val[$j]=str_replace("\r\n","<br /><img src='images/bilete_de_avion_arrow.jpg' alt='paragraf' width='4' height='7' /> ",$old_val[$j]);
echo makeClickableLinks($old_val[$j]);
$j++;
?>
</div>
<? } ?>
</td>
</tr>
<tr>
<td align="center" valign="top">
<? if (strlen($tab_1[0])>1 || ($tab_1[1]>1 && $tab_1[2]>1)) {?>
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td colspan="<? echo $nr_col1;?>" align="left" class="info_titlu"><div align="left"><? echo $tab1_nume;?></div></td>
</tr>
<?
for($i=0; $i<$nr_row1; $i++) {
$old_val=explode("|",$val1[$i]);
?>
<tr>
<?
for($j=0; $j<$nr_col1; $j++) {
?>
<td <? if ($i!=0){ ?>bgcolor="#FFE2BF"<? } ?><? if ($i==0){ ?>bgcolor="#FBCAA2" class="bold"<? } ?>>
<?
$old_val[$j]=str_replace("\r\n","<br />",$old_val[$j]);
echo makeClickableLinks($old_val[$j]);
?></td>
<? } ?>
</tr>
<? } ?>
<tr>
<td colspan="<? echo $nr_col1;?>" align="left" class="red"><div align="left"><? echo $tab1_note;?></div></td>
</tr>
</table>
<? } ?>
<? if (strlen($tab_2[0])>1 || ($tab_2[1]>1 && $tab_2[2]>1)) {?>
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td colspan="<? echo $nr_col2;?>" align="left" class="info_titlu"><div align="left"><? echo $tab2_nume;?></div></td>
</tr>
<?
for($i=0; $i<$nr_row2; $i++) {
$old_val=explode("|",$val2[$i]);
?>
<tr>
<?
for($j=0; $j<$nr_col2; $j++) {
?>
<td <? if ($i!=0){ ?>bgcolor="#FFE2BF"<? } ?><? if ($i==0){ ?>bgcolor="#FBCAA2" class="bold"<? } ?>>
<?
$old_val[$j]=str_replace("\r\n","<br />",$old_val[$j]);
echo makeClickableLinks($old_val[$j]);
?></td>
<? } ?>
</tr>
<? } ?>
<tr>
<td colspan="<? echo $nr_col2;?>" align="left" class="red"><div align="left"><? echo $tab2_note;?></div></td>
</tr>
</table>
<? } ?>
<? if (strlen($tab_3[0])>1 || ($tab_3[1]>1 && $tab_3[2]>1)) {?>
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td colspan="<? echo $nr_col3;?>" align="left" class="info_titlu"><div align="left"><? echo $tab3_nume;?></div></td>
</tr>
<?
for($i=0; $i<$nr_row3; $i++) {
$old_val=explode("|",$val3[$i]);
?>
<tr>
<?
for($j=0; $j<$nr_col3; $j++) {
?>
<td <? if ($i!=0){ ?>bgcolor="#FFE2BF"<? } ?><? if ($i==0){ ?>bgcolor="#FBCAA2" class="bold"<? } ?>>
<?
$old_val[$j]=str_replace("\r\n","<br />",$old_val[$j]);
echo makeClickableLinks($old_val[$j]);
?></td>
<? } ?>
</tr>
<? } ?>
<tr>
<td colspan="<? echo $nr_col3;?>" align="left" class="red"><div align="left"><? echo $tab3_note;?></div></td>
</tr>
</table>
<? } ?>
<? if (strlen($tab_4[0])>1 || ($tab_4[1]>1 && $tab_4[2]>1)) {?>
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td colspan="<? echo $nr_col4;?>" align="left" class="info_titlu"><div align="left"><? echo $tab4_nume;?></div></td>
</tr>
<?
for($i=0; $i<$nr_row4; $i++) {
$old_val=explode("|",$val4[$i]);
?>
<tr>
<?
for($j=0; $j<$nr_col4; $j++) {
?>
<td <? if ($i!=0){ ?>bgcolor="#FFE2BF"<? } ?><? if ($i==0){ ?>bgcolor="#FBCAA2" class="bold"<? } ?>>
<?
$old_val[$j]=str_replace("\r\n","<br />",$old_val[$j]);
echo makeClickableLinks($old_val[$j]);
?></td>
<? } ?>
</tr>
<? } ?>
<tr>
<td colspan="<? echo $nr_col4;?>" align="left" class="red"><div align="left"><? echo $tab4_note;?></div></td>
</tr>
</table>
<? } ?>
</td>
</tr>
</table>
<div align="center"><a href='javascript:history.back(-1);'><img src="images/icon_formular.jpg" alt="lista" width="26" height="32" border="0" /> <br />
[inapoi la listare]</a><br />
</div> </td>
</tr>
</table>
end of first code
<link href="easy.css" rel="stylesheet" type="text/css">
<? for($stele=5;$stele>0;$stele--) {
$nr_col=1;
db_connect();
//echo "SELECT * FROM vacante WHERE loc='$loc'";
$q=mysql_query("SELECT * FROM vacante WHERE status!='inactiv' AND loc='$loc' AND categorie='$stele' ORDER BY titlu ASC");
$num_rows = mysql_num_rows($q);
if ($num_rows>0) {
?>
<table width="533" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3" align="left" valign="top" background="images/titlu_bg.gif" class="subliniat1" style="padding:5px"><div align="left" class="titlu_pagina2">Categorie : <? echo $stele; ?> *</div></td>
</tr>
<tr>
<?
while ($row=mysql_fetch_assoc($q)) {
$row_id=$row['id'];
$row_titlu=$row['titlu'];
$row_subtitlu=$row['subtitlu'];
$poze=$row['poze'];
$poze=explode(', ',$poze);
?>
<td align="left" valign="top" class="subliniat1" style="padding-bottom:5px; padding-top:5px; width:177px">
<div align="center" style="width:170px; float:left; margin:2px;">
<a href="index.php?page=detalii_hotel&cat=vacante&id=<? echo $row_id; ?>"><img src='xadmin/upload_pics/small/<? echo $poze[0]; ?>.jpg' class="img_big_border" /><br /><? echo $row_titlu; ?></a>
</div> </td>
<? if ($nr_col%3==0) { ?></tr><tr><? } ?>
<? $nr_col++; } ?>
<? if ($num_rows==2) { ?>
<td align="left" valign="top" class="subliniat1" style="padding-bottom:5px; padding-top:5px; width:177px"> </td><? } ?>
</tr>
</table>
<? }} ?>
can someone please correct this 2 codes ? i don't know exacly where i have mistakes please help me.
thank you very much