Lordcraft
Narys
Generolas

Pranešimai: 930
Įstojęs: 2006 Rugs. 6 16:09:15
|
Sveiki, turiu tokia panel is pinigu_sistemos ir joje rodo banerius bet juos rodo vertikaliai. kaip reikia padaryti kad juos rodytu horizontaliai ir kaip reikia padaryti kad pvz jaigu yra prideti du baneriai o panelej rodo 5, kad rodytu tuos 2 pridetus ir 3 banerius su laisva vieta?
opentable("AAA");
if(dbcount("(*)", "money_banners", "tipas='1'") > 0){
$sql = dbquery("SELECT * FROM ".$db_prefix."money_banners WHERE `parodymai` = `kiekis` and tipas='1'");
while ($baneris = dbarray($sql)){
unlink(INFUSIONS."pinigu_sistema/banners/120x60/".$baneris[imgas]);
dbquery("DELETE FROM ".$db_prefix."money_banners WHERE id = '".$baneris[id]."' and tipas='1'");
}
$sql = dbquery("SELECT * FROM ".$db_prefix."money_banners WHERE tipas='1' LIMIT 5");
while ($baneris = dbarray($sql)){
echo "<center><a href='".stripinput(htmlspecialchars($baneris[adresas]))."'><img src='".INFUSIONS."pinigu_sistema/banners/120x60/".$baneris[imgas]."' border='0'></a></center>";
$result = dbquery("UPDATE ".$db_prefix."money_banners SET `parodymai` = `parodymai`+ 1 WHERE id=".$baneris[id]."");
}
}else{
echo "<center><a href='".INFUSIONS."pinigu_sistema/banners120.php'><img src='".INFUSIONS."pinigu_sistema/banners/reklama120.gif' border='0'></a></center>";
}
closetable();
|
edis2
VIP narys
Antras po Dievo

Pranešimai: 3644
Įstojęs: 2008 Rugs. 25 17:09:15
|
opentable("AAA");
if(dbcount("(*)", "money_banners", "tipas='1'") > 0){
$sql = dbquery("SELECT * FROM ".$db_prefix."money_banners WHERE `parodymai` = `kiekis` and tipas='1'");
while ($baneris = dbarray($sql)){
unlink(INFUSIONS."pinigu_sistema/banners/120x60/".$baneris[imgas]);
dbquery("DELETE FROM ".$db_prefix."money_banners WHERE id = '".$baneris[id]."' and tipas='1'");
}
$sql = dbquery("SELECT * FROM ".$db_prefix."money_banners WHERE tipas='1' LIMIT 5");
while ($baneris = dbarray($sql)){
echo "<center><a href='".stripinput(htmlspecialchars($baneris[adresas]))."'><img src='".INFUSIONS."pinigu_sistema/banners/120x60/".$baneris[imgas]."' border='0'></a></center>";
$result = dbquery("UPDATE ".$db_prefix."money_banners SET `parodymai` = `parodymai`+ 1 WHERE id=".$baneris[id]."");
}
}else{
echo "<center><a href='".INFUSIONS."pinigu_sistema/banners120.php'><img src='".INFUSIONS."pinigu_sistema/banners/reklama120.gif' border='0'></a></center><br>";
}
closetable();
Kažkas panašaus?
|
Lordcraft
Narys
Generolas

Pranešimai: 930
Įstojęs: 2006 Rugs. 6 16:09:15
|
tai kad tu nieko nepakeitei... viskas taip kaip ir buvo.
|
ex-it
Narys
Ekspertas

Pranešimai: 2696
Įstojęs: 2007 Gru. 24 11:12:58
|
opentable("AAA");
if(dbcount("(*)", "money_banners", "tipas='1'") > 0){
$sql = dbquery("SELECT * FROM ".$db_prefix."money_banners WHERE `parodymai` = `kiekis` and tipas='1'");
while ($baneris = dbarray($sql)){
unlink(INFUSIONS."pinigu_sistema/banners/120x60/".$baneris[imgas]);
dbquery("DELETE FROM ".$db_prefix."money_banners WHERE id = '".$baneris[id]."' and tipas='1'");
}
$sql = dbquery("SELECT * FROM ".$db_prefix."money_banners WHERE tipas='1' LIMIT 5");
while ($baneris = dbarray($sql)){
echo "<td><a href='".stripinput(htmlspecialchars($baneris[adresas]))."'><img src='".INFUSIONS."pinigu_sistema/banners/120x60/".$baneris[imgas]."' border='0'></a></td>";
$result = dbquery("UPDATE ".$db_prefix."money_banners SET `parodymai` = `parodymai`+ 1 WHERE id=".$baneris[id]."");
}
}else{
echo "<center><a href='".INFUSIONS."pinigu_sistema/banners120.php'><img src='".INFUSIONS."pinigu_sistema/banners/reklama120.gif' border='0'></a></center><br>";
}
closetable();
|
Lordcraft
Narys
Generolas

Pranešimai: 930
Įstojęs: 2006 Rugs. 6 16:09:15
|
ex-it aciu, tavo kodas veikia. o kaip dabar padaryti pvz jaigu LIMIT yra 5 o baneriai ideti tik 2, tai tuos 2 bannerius ir terodo, kodel neveikia
}else{
echo "<center><a href='".INFUSIONS."pinigu_sistema/banners120.php'><img src='".INFUSIONS."pinigu_sistema/banners/reklama120.gif' border='0'></a></center><br>";
}
?
kaip padaryti kad rodytu tas 3 laisvas vietas?
|
maxas66
Narys
Buldozeris
Pranešimai: 287
Įstojęs: 2009 Rugs. 8 21:09:44
|
opentable("AAA");
if(dbcount("(*)", "money_banners", "tipas='1'") > 0){
$sql = dbquery("SELECT * FROM ".$db_prefix."money_banners WHERE `parodymai` = `kiekis` and tipas='1'");
while ($baneris = dbarray($sql)){
unlink(INFUSIONS."pinigu_sistema/banners/120x60/".$baneris[imgas]);
dbquery("DELETE FROM ".$db_prefix."money_banners WHERE id = '".$baneris[id]."' and tipas='1'");
}
$sql = dbquery("SELECT * FROM ".$db_prefix."money_banners WHERE tipas='1' LIMIT 5");
$kiek = dbcount("(*)", "money_banners", "tipas='1'");
if ($kiek == '5') {
while ($baneris = dbarray($sql)){
echo "<td><a href='".stripinput(htmlspecialchars($baneris[adresas]))."'><img src='".INFUSIONS."pinigu_sistema/banners/120x60/".$baneris[imgas]."' border='0'></a></td>";
$result = dbquery("UPDATE ".$db_prefix."money_banners SET `parodymai` = `parodymai`+ 1 WHERE id=".$baneris[id]."");
}
} else if ($kiek == '4') {
while ($baneris = dbarray($sql)){
echo "<td><a href='".stripinput(htmlspecialchars($baneris[adresas]))."'><img src='".INFUSIONS."pinigu_sistema/banners/120x60/".$baneris[imgas]."' border='0'></a></td>";
$result = dbquery("UPDATE ".$db_prefix."money_banners SET `parodymai` = `parodymai`+ 1 WHERE id=".$baneris[id]."");
}
echo "<td><a href='".INFUSIONS."pinigu_sistema/banners120.php'><img src='".INFUSIONS."pinigu_sistema/banners/reklama120.gif' border='0'></a>/td>";
} else if ($kiek == '3') {
while ($baneris = dbarray($sql)){
echo "<td><a href='".stripinput(htmlspecialchars($baneris[adresas]))."'><img src='".INFUSIONS."pinigu_sistema/banners/120x60/".$baneris[imgas]."' border='0'></a></td>";
$result = dbquery("UPDATE ".$db_prefix."money_banners SET `parodymai` = `parodymai`+ 1 WHERE id=".$baneris[id]."");
}
echo "<td><a href='".INFUSIONS."pinigu_sistema/banners120.php'><img src='".INFUSIONS."pinigu_sistema/banners/reklama120.gif' border='0'></a>/td>";
echo "<td><a href='".INFUSIONS."pinigu_sistema/banners120.php'><img src='".INFUSIONS."pinigu_sistema/banners/reklama120.gif' border='0'></a>/td>";
} else if ($kiek == '2') {
while ($baneris = dbarray($sql)){
echo "<td><a href='".stripinput(htmlspecialchars($baneris[adresas]))."'><img src='".INFUSIONS."pinigu_sistema/banners/120x60/".$baneris[imgas]."' border='0'></a></td>";
$result = dbquery("UPDATE ".$db_prefix."money_banners SET `parodymai` = `parodymai`+ 1 WHERE id=".$baneris[id]."");
}
echo "<td><a href='".INFUSIONS."pinigu_sistema/banners120.php'><img src='".INFUSIONS."pinigu_sistema/banners/reklama120.gif' border='0'></a>/td>";
echo "<td><a href='".INFUSIONS."pinigu_sistema/banners120.php'><img src='".INFUSIONS."pinigu_sistema/banners/reklama120.gif' border='0'></a>/td>";
echo "<td><a href='".INFUSIONS."pinigu_sistema/banners120.php'><img src='".INFUSIONS."pinigu_sistema/banners/reklama120.gif' border='0'></a>/td>";
} else if ($kiek == '1') {
while ($baneris = dbarray($sql)){
echo "<td><a href='".stripinput(htmlspecialchars($baneris[adresas]))."'><img src='".INFUSIONS."pinigu_sistema/banners/120x60/".$baneris[imgas]."' border='0'></a></td>";
$result = dbquery("UPDATE ".$db_prefix."money_banners SET `parodymai` = `parodymai`+ 1 WHERE id=".$baneris[id]."");
}
echo "<td><a href='".INFUSIONS."pinigu_sistema/banners120.php'><img src='".INFUSIONS."pinigu_sistema/banners/reklama120.gif' border='0'></a>/td>";
echo "<td><a href='".INFUSIONS."pinigu_sistema/banners120.php'><img src='".INFUSIONS."pinigu_sistema/banners/reklama120.gif' border='0'></a>/td>";
echo "<td><a href='".INFUSIONS."pinigu_sistema/banners120.php'><img src='".INFUSIONS."pinigu_sistema/banners/reklama120.gif' border='0'></a>/td>";
echo "<td><a href='".INFUSIONS."pinigu_sistema/banners120.php'><img src='".INFUSIONS."pinigu_sistema/banners/reklama120.gif' border='0'></a>/td>";
}
} else {
echo "<center><a href='".INFUSIONS."pinigu_sistema/banners120.php'><img src='".INFUSIONS."pinigu_sistema/banners/reklama120.gif' border='0'></a></center>";
}
closetable();
Galėjo ir paprasčiau žinoma, tačiau, nedirba šiandien galva, nežinau ar veiks jisai.
Redagavo maxas66 2009 Gru. 23 14:12:47 |
Lordcraft
Narys
Generolas

Pranešimai: 930
Įstojęs: 2006 Rugs. 6 16:09:15
|
kaip ir veikia bet ten prie td pamirsai padeti <
|