forum.lissyara.su

Код: Выделить всё

 
	    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);