conect to 2 databases

[alin19]

$dataIN=date("Y-m-d");
$query="SELECT * FROM `actiuni_tran`";
if ($r=mysql_query($query))

			while ($row = mysql_fetch_array($r))
			{
			$simbol=$row['actiuni'];
			mysql_close($conexiune);


			$database="bursa";
			$conexiune=mysql_connect($hostname,$username,$password)
			or die ("Nu ma pot conecta la baza de date");
			$bazadate2=mysql_select_db($database,$conexiune)
			or die ("Nu gasesc baza de date");

			$query_up="SELECT `pret tran` FROM `stocks` WHERE `simbol`='$simbol' order by `time` desc limit 1";
			$query_af_up=mysql_query($query_up);
			$query_ex_up=mysql_fetch_array($query_af_up);
			$pret=$query_ex_up['pret'];



			mysql_close($conexiune);
			$database="apelmarja";
			$conexiune=mysql_connect($hostname,$username,$password)
			or die ("Nu ma pot conecta la baza de date");
			$bazadate=mysql_select_db($database,$conexiune)
			or die ("Nu gasesc baza de date");

			echo $Simbolfirst." ".$PretTranfirst." ".$VolTranfirst."</br>";
			$queryInsert="INSERT INTO `pret_actiuni` ( `id` , `simbol` , `pret` , `data`)
							VALUES ('','$simbol', '$pret', '$dataIN')";

						mysql_query($queryInsert);


			}

 

this part isn't executed

 

$database="bursa";

$conexiune=mysql_connect($hostname,$username,$password)

or die ("Nu ma pot conecta la baza de date");

$bazadate2=mysql_select_db($database,$conexiune)

or die ("Nu gasesc baza de date");

 

$query_up="SELECT `pret tran` FROM `stocks` WHERE `simbol`='$simbol' order by `time` desc limit 1";

$query_af_up=mysql_query($query_up);

$query_ex_up=mysql_fetch_array($query_af_up);

$pret=$query_ex_up['pret'];

 

 

 

[schme16]

Give this a try:

 

<?php
$dataIN=date("Y-m-d");
$query="SELECT * FROM `actiuni_tran`";
if ($r=mysql_query($query))
$conexiune=mysql_connect($hostname,$username,$password)

			while ($row = mysql_fetch_array($r))
			{
			$simbol=$row['actiuni'];
			mysql_close($conexiune);


			$database="bursa";
			$bazadate2=mysql_select_db($database,$conexiune)
			or die ("Nu gasesc baza de date");

			$query_up="SELECT `pret tran` FROM `stocks` WHERE `simbol`='$simbol' order by `time` desc limit 1";
			$query_af_up=mysql_query($query_up);
			$query_ex_up=mysql_fetch_array($query_af_up);
			$pret=$query_ex_up['pret'];



			mysql_close($conexiune);
			$bazadate=mysql_select_db($database,$conexiune)
			or die ("Nu gasesc baza de date");

			echo $Simbolfirst." ".$PretTranfirst." ".$VolTranfirst."</br>";
			$queryInsert="INSERT INTO `pret_actiuni` ( `id` , `simbol` , `pret` , `data`)
							VALUES ('','$simbol', '$pret', '$dataIN')";

						mysql_query($queryInsert);


			}
                ?>

[alin19]

 

actuali the code is like this, i posted here only the part with the problem

<?php
$hostname="localhost";
$username="root";
$password="tractor";
$database="apelmarja";


$conexiune=mysql_connect($hostname,$username,$password)
or die ("Nu ma pot conecta la baza de date");

$bazadate=mysql_select_db($database,$conexiune)
or die ("Nu gasesc baza de date");



$dataIN=date("Y-m-d");
$query="SELECT * FROM `actiuni_tran`";
if ($r=mysql_query($query))

			while ($row = mysql_fetch_array($r))
			{
			$simbol=$row['actiuni'];
			mysql_close($conexiune);
			$database="bursa";

			$conexiune=mysql_connect($hostname,$username,$password)
			or die ("Nu ma pot conecta la baza de date");

			$bazadate2=mysql_select_db($database,$conexiune)
			or die ("Nu gasesc baza de date");

			$query_up="SELECT `pret tran` FROM `stocks` WHERE `simbol`='$simbol' order by `time` desc limit 1";
			$query_af_up=mysql_query($query_up);
			$query_ex_up=mysql_fetch_array($query_af_up);
			$pret=$query_ex_up['pret'];


			mysql_close($conexiune);
			$database="apelmarja";
			$conexiune=mysql_connect($hostname,$username,$password)
			or die ("Nu ma pot conecta la baza de date");
			$bazadate=mysql_select_db($database,$conexiune)
			or die ("Nu gasesc baza de date");

			echo $Simbolfirst." ".$PretTranfirst." ".$VolTranfirst."</br>";
			$queryInsert="INSERT INTO `pret_actiuni` ( `id` , `simbol` , `pret` , `data`)
							VALUES ('','$simbol', '$pret', '$dataIN')";

						mysql_query($queryInsert);


			}


?>

[schme16]

I maintain that you are calling the mysql_connect function too much, and that it half the reason (if not all) for your troubles.

 

if the databases are on the same server then call the server once ( via mysql_connect() ) and then call the database needed when its needed.

 

like, this (try it, I think it should work....)

 

<?php
$hostname="localhost";
$username="root";
$password="tractor";
$database="apelmarja";


$conexiune=mysql_connect($hostname,$username,$password)
or die ("Nu ma pot conecta la baza de date");

$bazadate=mysql_select_db($database,$conexiune)
or die ("Nu gasesc baza de date");



$dataIN=date("Y-m-d");
$query="SELECT * FROM `actiuni_tran`";
if ($r=mysql_query($query))

			while ($row = mysql_fetch_array($r))
			{
			$simbol=$row['actiuni'];
			$database="bursa";
			$bazadate2=mysql_select_db($database)
			or die ("Nu gasesc baza de date");

			$query_up="SELECT `pret tran` FROM `stocks` WHERE `simbol`='$simbol' order by `time` desc limit 1";
			$query_af_up=mysql_query($query_up);
			$query_ex_up=mysql_fetch_array($query_af_up);
			$pret=$query_ex_up['pret'];


			$database="apelmarja";
			$bazadate=mysql_select_db($database)
			or die ("Nu gasesc baza de date");

			echo $Simbolfirst." ".$PretTranfirst." ".$VolTranfirst."</br>";
			$queryInsert="INSERT INTO `pret_actiuni` ( `id` , `simbol` , `pret` , `data`)
							VALUES ('','$simbol', '$pret', '$dataIN')";

						mysql_query($queryInsert);


			}


?>