| |
|
|
<%
'SELECT * FROM posts
'left outer join comments on posts.id_post=comments.id_post and posts.id_post='$id'
'group by posts.post_id, stampcreate ORDER BY posts.post_id, stampcreate
'sql="select * from editor e left outer join writers w on e.wid=w.wid order by e.wid asc"
'sql="select distinct w.wpic,w.wid,e.authorid,e.wid,e.header,e.authorbody from editor e left outer join writers w on e.wid=w.wid order by e.wid asc"
sql="select distinct a.authorname,w.wpic,a.authorid,a.header,a.authorbody,a.authordate from editor a, writers w where w.wid=a.wid and a.authorname <>'Mr. Jarallah' group by a.authorname"
'sql="select * from writers order by wid desc"
'Response.Write(sql)
set rs=conn.execute(sql)
'cnt=1
' datetime = Now()
'response.write datetime
%>
<% 'sql= "select * from editor where authorname='Naseer Otaibi' order by authorid desc"
'set rs=Conn.execute(sql)
if rs.eof then
Response.Write("")
end if
while not rs.eof
id=rs("authorid")
pic=rs("wpic")
aname=rs("authorname")
%>
Writers opinion 2007
|
| | | |
|
">
<%
else
response.write ""
end if%>
