php两张数据库表建立联系,mysql数据库中2个表建立关系解决思路

PHP code<?php

$DBserver = "localhost";

$DBname = "new";

$DBuser = "root";

$DBpassword = "";

$con = mysql_connect("localhost","root","");

mysql_select_db("new");

$query = mysql_query("select page_id,page_text from pagecontents where img_exist > 0") or die(mysql_error() );

while($rows = mysql_fetch_array($query))

{

$pid = $rows['page_id'];

$ptext = $rows['page_text'];

$ptext = mysql_real_escape_string($ptext);

$ptext = preg_replace('/poweredby_mediawiki_88x31\.png/s','',$ptext);

if(preg_match_all('/.+\.(gif|swf|jpg|png)/is',$ptext,$match)){

$ptext = $match[1][0];

$ptext = mysql_real_escape_string($ptext);

}

mysql_select_db("lookdb",$con);

$sql = "update imgmulu set page_id = ('{$pid}') where img_name = ('{$ptext}')";

mysql_query($sql) or die(mysql_error());

}

?>