Код: Выделить всё
mysql_select_db( DBNAME, $dbconnect)
or die("Ошибка бд: ".mysql_error());
$select = mysql_query("SELECT * FROM table1");
$row = mysql_fetch_array($select);
do
{
echo $row[column1].'<br/>';
}
while($row = mysql_fetch_array($select));
Код: Выделить всё
$conn=mysql_connect($dbhost,$dbuser,$dbpass) or die("Could not connect : " . mysql_error());
mysql_select_db($dbname) or die("Could not select database");
mysql_query("SET NAMES utf8");
$query = "SELECT * FROM table1";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
while ($row = mysql_fetch_array($result)){
$column1_pr=$row['column1'];
$column2_pr=$row['column2'];
echo $column1.'<br/>;
echo $column2.'<br/>;
mysql_select_db($dbname2) or die("Could not select database");
$query2 = "INSERT INTO (db2_tbl1_col1,db2_tbl1_col1) VALUES ($column1,$column2)";
mysql_query($query2) or die("Query failed : " . mysql_error());
}
Код: Выделить всё
$ttoday = time();
$tdiff = ($pun_user['timezone'] - $pun_config['o_server_timezone']) * 3600;
$ttoday += $tdiff;
$tyear = date("Y");
$tmonth = date("n");
$tday = date("j", $ttoday);