日期:2014-05-17 浏览次数:20433 次
<?php $conn=mysql_connect("localhost","root","123456"); mysql_query('set names utf8'); mysql_select_db("abc",$conn); $news=mysql_query("select * from eb_news where categoryId='53' order by createDate"); $a=mysql_num_rows($news); $i=1; $i2=1; $conn2=mysql_connect("localhost","root","123456"); mysql_select_db("tjdx",$conn2); $result=mysql_query("select * from sea_info where categoryid='759' order by dotime"); $b=mysql_num_rows($result); echo '<div style="border:solid 2 red;width:200px; float:left;">'; while($os=mysql_fetch_array($news)){ echo $i;echo '--';echo date('Y-m-d',$os['createDate']);echo '--';echo $os['id']; echo '<br>';$i++; mysql_query("insert into sea_info (parentid,categoryid,title,content,dotime) values('744','759','$os[title]','$os[content]','$os[createDate]')"); } echo'</div>'; echo '<div style="border:solid 2 red;width:200px; float:left;">'; while($os2=mysql_fetch_array($result)){ echo $i2;echo '--';echo date('Y-m-d',$os2['dotime']); echo '<br>';$i2++; } echo'</div>'; echo $b; echo '<br>'; echo $a; ?>