Asp'de haberleri 2 li yapma?

22-01-2010, 23:40:07

merhaba

Aşağıdaki gibi haber kodlarım var sitede ben haberleri yan yana ve
aşağıya doğru devam etmesini istiyorum bunu nasıl yapabilirim.
----------------------

<%
set trs = server.createobject("adodb.recordset")
sql="select * from makale order by id desc"
trs.open sql,baglanti,1,3

shff = inject(Request.QueryString("shff"))
IF Not IsNumeric(REQUEST.QUERYSTRING("shff")) THEN
Response.Redirect "default.asp"
Response.End
END IF

if trs.eof Then
Response.Write "<br><br><div align=""center"" class=""uye"">Kayıtlı  <b>trs</b> yok ! </div>  "
Response.End
End If

s = 1
If shff="" Then shff="1"
trs.pagesize = 10
trs.absolutepage = shff
sayfa_sayisi = trs.pagecount
For i=1 To trs.pagesize
If trs.Eof Then exit for
%>
<table border="0" width="570" id="table4">
						<tr>
							<td width="160"><a href="news.asp?id=<%=trs("id")%>">
							<b><font face="Tahoma" color="#58514E"><%=trs("baslik")%></font></b></a><font color="#58514E"><b><font face="Tahoma" color="#58514E">
							</font></b></font> </td>
							<td width="293"><font face="Tahoma" color="#666666"><%=trs("tarih")%></font></td>
						</tr>
						<tr>
							<td width="95">
							<img border="0" src="<%=trs("resim")%>" width="103" height="161"></td>
							<td width="459" colspan="2"><b>
							<font face="Tahoma" color="#58514E"><%=left(trs("makale"),250)%><br><br><a href="news.asp?id=<%=trs("id")%>">
							<font color="#58514E">Haberin devamını okumak için tıklayın</font></a></font></b></td>
						</tr>
					</table>

23-01-2010, 14:51:15

#2

JoomlASP

Buyrun size gerekli kodlar...

kendinize göre uyarlayabilirsiniz.

<% 
Response.Write "<table width=""100%"" border=""0"" cellpadding=""0"" cellspacing=""10""><tr align=""left"">"
'Veritabanındaki tabloya bağlantı cümleciğin Örneğin:set veri = baglanti.Execute("select * from veriler")

for z=1 to 10
if  veri.eof then exit for

Response.Write "<td width=""50%"" valign=""top"">"

Response.Write "<img src="& veri("resim") &" height=""75"" width=""100"" align=""left"">"

Response.Write "<b><a href=oku.asp?id="&veri("id")&">" & veri("baslik") & "</a></b><br>"&left(veri("icerik"),100)&"..."

Response.Write "<p align=""right""><a href=oku.asp?id="&veri("id")&">Devamı..</a></p></td>"
if z mod 2 = 0 then response.write "</tr><tr>"

veri.MoveNext
next
veri.close
set veri=nothing
Response.Write "</tr></table>"
%>

buradaki if z mod 2 = 0 then response.write "</tr><tr>" kısmındaki 2 kaç sütun görünmesini istiyorsan o değeri ver... yan yana 2 sütun için 2 verdirdim...

23-01-2010, 16:07:08

#3

hayat_okulu

Ekledim çok sağolasın.aşağıdaki hatayı verdi.

benim tablolar makale haber baslik ve resim diye kayıtlı
------------
Microsoft VBScript compilation error '800a0401'

Expected end of statement

/ilke/Default.asp, line 213

Response.Write "<b><a href=oku.asp?id="&haber("id")&">" & haber("baslik") & "</a></b><br>"&left(haber("icerik"),100)&"..."

----------------------------

23-01-2010, 16:25:27

#4

JoomlASP

sayfanın tam kodunu gönderebilir misin?

23-01-2010, 16:27:33

#5

hayat_okulu

Sayfanın Tam kodu:
-----------------------




<html><head>

<!--#include file="siteayar.asp"-->
<meta http-equiv="Content-Type" content="text/html; charset=windows-1254">
<title><%=title%></title>
<meta http-equiv="Content-Language" content="tr">
<meta http-equiv="Copyright" content="<%=copy%>">
<meta http-equiv="Reply-to" content="<%=sitemail%>">
<meta name="TITLE" content="<%=title%>">
<meta name="author" content="CEO">
<meta name="description" content="<%=description%>">
<meta name="keywords" content="<%=keywords%>">
<meta name="Abstract" content="<%=copy%>">
<meta name="ROBOTS" content="ALL">
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	background-color: #FFFFFF;
}
-->
</style>
<link rel="stylesheet" href="files/style.css" type="text/css">
<LINK href="css.css" type=text/css rel=stylesheet>
<script src="inc/facefiles/jquery-1.2.2.pack.js" type="text/javascript"></script>
<link href="inc/facefiles/facebox.css" media="screen" rel="stylesheet" type="text/css" />
<script src="inc/facefiles/facebox.js" type="text/javascript"></script>
<script type="text/javascript">
    jQuery(document).ready(function($) {
      $('a[rel*=facebox]').facebox() 
    })
</script>
<script type="text/javascript">
<!--
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>
<body>

</body>
		<body onload="MM_preloadImages('images/12.jpg','images/13.jpg','images/14.jpg','images/15.jpg','images/16.jpg','images/17.jpg','images/18.jpg','images/19.jpg')">
<table width="802" align="center" border="0" cellpadding="1" cellspacing="0">
  <tbody><tr>
    <td bgcolor="#cccccc"><table width="800" border="0" cellpadding="0" cellspacing="0">
        <tbody><tr>
          <td bgcolor="#ffffff">
         
          <table width="800" border="0" cellpadding="0" cellspacing="0">
            <tbody><tr>
              <td width="796">

      <table border="0" cellspacing="0" cellpadding="0" width="780" align="center" id="table3">
<tr>
	<!--#include file="ust.asp"-->
</tr>
<tr>
	<td>
	
	
	</td>
</tr>
</table>
      
				</td>
              <td width="4"></td>
            </tr>
          </tbody></table>
          </td>
        </tr>
        <tr>
          <td background="files/3.jpg" bgcolor="#ffffff" height="5"><img src="files/3.jpg" width="1" height="5"></td>
        </tr>
        <tr>
          <td bgcolor="#ffffff"><table width="800" border="0" cellpadding="0" cellspacing="0">
              <tbody><tr>
                <td valign="top" width="200" align="center" bgcolor="#f1f1f1"><script type="text/javascript">
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<table width="200" border="0" cellpadding="0" cellspacing="0">
  <tbody><tr>
    
<!--#include file="inc/sol.asp"--->


                <td valign="top" width="600" align="center">
				<table border="0" width="100%" id="table1">
				
					</table>
					
					<img border="0" src="images/player2%20.gif" width="799" height="250">
				<table width="570" border="0" cellpadding="0" cellspacing="0">
                  <tbody><tr>
                    <td class="style_bora" height="35">
                    <%
                    Set haber=Server.Createobject("adodb.recordset")
                    sql="Select top 5 * from makale order by id desc"
                    haber.open sql,baglanti,1,3
                    do while not haber.eof %>
					<table border="0" width="801" id="table4">
						<tr>
							<td width="215"><a href="news.asp?id=<%=haber("id")%>">
							<b><font face="Tahoma" color="#58514E"><%=haber("baslik")%></font></b></a><font color="#58514E"><b><font face="Tahoma" color="#58514E">
							</font></b></font> </td>
							
						</tr>
						<tr>
							<td width="215">
							<img border="0" src="<%=haber("resim")%>" width="266" height="174"></td>
							<td width="576" colspan="2"><b>
							<font face="Tahoma" color="#58514E"><%=left(haber("makale"),500)%><br><a href="news.asp?id=<%=haber("id")%>">
							<font color="#58514E">yazının devamı</font></a></font></b>          <td background="files/3.jpg" bgcolor="#ffffff" height="5"><img src="files/3.jpg" width="1" height="5"></td>
</td>
						</tr>
					</table>
					<% haber.movenext
					loop 
					%>
					
					</td>
                  </tr>

                </tbody></table></td>
              </tr>
            </tbody></table>
            </td>
        </tr>
        <tr>
          <td background="files/3.jpg" bgcolor="#ffffff" height="5"><img src="files/3.jpg" width="1" height="5"></td>
        </tr>
        <tr>
          <td valign="middle" align="center" background="files/22.jpg" bgcolor="#d6d6d6" height="40"> <table width="780" border="0" cellpadding="0" cellspacing="0">
            <tbody><tr>
              <td class="style_bora" valign="middle" width="390" align="left"><%=copy%></td>
              <td class="style_bora" valign="middle" width="390" align="right">
				<a target="_blank" href="http://www.ilkedizayn.com">İlke Dizayn</a></td>
            </tr>
          </tbody></table></td>
        </tr>
      </tbody></table>
    </td>
  </tr>
</tbody></table>


</body></html>

23-01-2010, 16:37:10

#6

JoomlASP

aşağıdaki şekilde bir kullanır mısınız?

Alıntı

html><head>


<meta http-equiv="Content-Type" content="text/html; charset=windows-1254">
<title><%=title%></title>
<meta http-equiv="Content-Language" content="tr">
<meta http-equiv="Copyright" content="<%=copy%>">
<meta http-equiv="Reply-to" content="<%=sitemail%>">
<meta name="TITLE" content="<%=title%>">
<meta name="author" content="CEO">
<meta name="description" content="<%=description%>">
<meta name="keywords" content="<%=keywords%>">
<meta name="Abstract" content="<%=copy%>">
<meta name="ROBOTS" content="ALL">
<style type="text/css">

</style>
<link rel="stylesheet" href="files/style.css" type="text/css">
<LINK href="css.css" type=text/css rel=stylesheet>
<script src="inc/facefiles/jquery-1.2.2.pack.js" type="text/javascript"></script>
<link href="inc/facefiles/facebox.css" media="screen" rel="stylesheet" type="text/css" />
<script src="inc/facefiles/facebox.js" type="text/javascript"></script>
<script type="text/javascript">
jQuery(document).ready(function($) {
$('a[rel*=facebox]').facebox()
})
</script>
<script type="text/javascript">
<!--
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById

; return x;
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>
<body>

</body>
<body onload="MM_preloadImages('images/12.jpg','images/13.jpg','images/14.jpg','images/15.jpg','images/16.jpg','images/17.jpg','images/18.jpg','images/19.jpg')">
<table width="802" align="center" border="0" cellpadding="1" cellspacing="0">
<tbody><tr>
<td bgcolor="#cccccc"><table width="800" border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
<td bgcolor="#ffffff">

<table width="800" border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
<td width="796">

<table border="0" cellspacing="0" cellpadding="0" width="780" align="center" id="table3">
<tr>

</tr>
<tr>
<td>

</td>
</tr>
</table>

</td>
<td width="4"></td>
</tr>
</tbody></table>
</td>
</tr>
<tr>
<td background="files/3.jpg" bgcolor="#ffffff" height="5"><img src="files/3.jpg" width="1" height="5"></td>
</tr>
<tr>
<td bgcolor="#ffffff"><table width="800" border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
<td valign="top" width="200" align="center" bgcolor="#f1f1f1"><script type="text/javascript">
<!--
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}

function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById

; return x;
}

function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
<table width="200" border="0" cellpadding="0" cellspacing="0">
<tbody><tr>



<td valign="top" width="600" align="center">
<table border="0" width="100%" id="table1">

</table>

<img border="0" src="images/player2%20.gif" width="799" height="250">
<table width="570" border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
<td class="style_bora" height="35">
<table border="0" width="801" id="table4"> <tr>
<%
Set haber=Server.Createobject("adodb.recordset")
sql="Select top 5 * from makale order by id desc"
haber.open sql,baglanti,1,3

for z=1 to 10
if haber.eof then exit for
%>

<td width="215"><a href="news.asp?id=<%=haber("id")%>">
<b><font face="Tahoma" color="#58514E"><%=haber("baslik")%></font></b></a><font color="#58514E"><b><font face="Tahoma" color="#58514E">
</font></b></font> </td>

</tr>
<tr>
<td width="215">
<img border="0" src="<%=haber("resim")%>" width="266" height="174"></td>
<td width="576" colspan="2"><b>
<font face="Tahoma" color="#58514E"><%=left(haber("makale"),500)%><br> <a href="news.asp?id=<%=haber("id")%>">
<font color="#58514E">yazının devamı</font></a></font></b> <td background="files/3.jpg" bgcolor="#ffffff" height="5"><img src="files/3.jpg" width="1" height="5"></td>
</td>
<%
if z mod 2 = 0 then response.write "</tr><tr>"
haber.movenext
next
haber.close
set haber=nothing
Response.Write "</tr></table>"
%>
</td>
</tr>

</tbody></table></td>
</tr>
</tbody></table>
</td>
</tr>
<tr>
<td background="files/3.jpg" bgcolor="#ffffff" height="5"><img src="files/3.jpg" width="1" height="5"></td>
</tr>
<tr>
<td valign="middle" align="center" background="files/22.jpg" bgcolor="#d6d6d6" height="40"> <table width="780" border="0" cellpadding="0" cellspacing="0">
<tbody><tr>
<td class="style_bora" valign="middle" width="390" align="left"><%=copy%></td>
<td class="style_bora" valign="middle" width="390" align="right">
<a target="_blank" href="http://www.ilkedizayn.com">İlke Dizayn</a></td>
</tr>
</tbody></table></td>
</tr>
</tbody></table>
</td>
</tr>
</tbody></table>

</body></html>