mysql-php error message

[srinivas_sree]

<?php
/*$todb='localhost';
$fromdb='test1.deftlogic.com';
$smstable=sms;
$paid_bribetable=bd_paidabribe;
$countertable=tab3;
*/
    //connecting to the local database
	$con=mysql_pconnect('localhost','user','pass');//servername,username,password
        if(!$con)
		{
     		die("couldn't connect");
		}

mysql_select_db("dtestfor_IPAB_db",$con);//databasename

$rs2=mysql_query("select sms_index as 'ma' from tab3", $con);

$max=mysql_fetch_assoc($rs2);

print_r($max['ma']);
//connecting to the local database ends
//connecting to the remote database
	$dblink2 = mysql_pconnect('test1.deftlogic.com', 'user','pass'); // connect server 2

    mysql_select_db('dtestone_db_2025', $dblink2);  // select database 2

    //echo $dblink2;

    if(!$dblink2)
    {
     echo "not connected";
    }
    else echo "db2 connected";
$rs=mysql_query("select Message from sms where sms_index>=".$max['ma'],$dblink2);
$msgs=mysql_fetch_assoc($rs);
$msgs2=array();
//connecting to the remot database ends
//connecting to the local database
	        do
		{
		   array_push($msgs2,$msgs['Message']);
		}
		while($msgs=mysql_fetch_assoc($rs));

	$con=mysql_pconnect('localhost','user','pass');//servername,username,password
            if(!$con)
	{
 		   die("couldn't connect");
	}

       mysql_select_db("dtestfor_IPAB_db",$con);//databasename

       foreach($msgs2 as $m)
	{
		$m2 = explode(",",$m);
		mysql_query("insert into bd_paidabribe(city,dept,amount) values('".$m2[0]."','".$m2[1]."','".$m2[2]."')", $con);
	}
//connecting to the local database ends
//connecting to the remot database	
	        $dblink2 = mysql_pconnect('test1.deftlogic.com', 'user','pass'); // connect server 2

        mysql_select_db('dtestone_db_2025', $dblink2);  // select database 2

	$rs4=mysql_query("select max(sms_index) as 'ma' from sms");
	$max2=mysql_fetch_assoc($rs4); 
//connecting to the remote database ends
//connecting to the local database
	        $con=mysql_pconnect('localhost','user','pass');//servername,username,password
                if(!$con)
		{
     		   die("couldn't connect");
		}

        mysql_select_db("dtestfor_IPAB_db",$con);

	mysql_query("UPDATE tab3 SET sms_index = ".$max2['ma']);
 //connecting to the local database ends
 ?>

Hi all.....i am trying to get the values from sms table which is on one server and insert those values into another table in another server. while doing that i'm using another table that will check the max value in sms table accordingly it will insert the values. all the code seems fine but when i execute the code i'm getting the error message as Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource on (url) in line no 37,45,67. i think the wrong is there with the syntax. any help will be much appreciated.....thanks in advance...

[srinivas_sree]

thanks for editing my code and giving the suggestion...even after giving the connection this many times still sometimes the error is showing no database is selected like that...and what is the wrong with the code now...can u please suggest me the best way to get me out of this problem...

[srinivas_sree]

<?php
//connecting to the local database
$con=mysql_pconnect('localhost','user','pass');//servername,username,password
if(!$con)
{
die("couldn't connect");
}
echo "database connected";
mysql_select_db("dtestfor_IPAB_db",$con);//databasename
$rs2=mysql_query("select sms_index as 'ma' from tab3", $con);
$max=mysql_fetch_assoc($rs2);
print_r($max['ma']);
//connecting to the local database ends
//connecting to the remote database
$dblink2 = mysql_pconnect('test1.deftlogic.com', 'user','pass'); // connect server 2

mysql_select_db('dtestone_db_2025', $dblink2); // select database 2

//echo $dblink2;

if(!$dblink2)
{
echo "not connected";
}
else echo "db2 connected";

$rs=mysql_query("select Message from sms where sms_index>=".$max['ma'],$dblink2);
$msgs=mysql_fetch_assoc($rs);
$msgs2=array();

//connecting to the remot database ends
//connecting to the local database
do
{
array_push($msgs2,$msgs['Message']);
}
while($msgs=mysql_fetch_assoc($rs));

foreach($msgs2 as $m)
	{
		$m2=explode(",",$m);
		mysql_query("insert into bd_paidabribe(city,dept,amount) values('".$m2[0]."','".$m2[1]."','".$m2[2]."')", $con);
	}

//connecting to the local database ends
//connecting to the remot database

	$rs4=mysql_query("select max(sms_index) as 'ma' from sms");
	$max2=mysql_fetch_assoc($rs4); 

//connecting to the remot database ends
//connecting to the local database

	mysql_query("UPDATE tab3 SET sms_index = ".$max2['ma']);

//connecting to the local database ends
?>

so this is the thing what u r suggesting me...i tried even like this the error is
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dtestfor/public_html/ipabex1.php on line 37

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dtestfor/public_html/ipabex1.php on line 45

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dtestfor/public_html/ipabex1.php on line 67

[vivek151189]

First of Your code

while($msgs=mysql_fetch_assoc($rs));

is incorrect

and second in two mysql_query you have not passed the connction variable i.e

mysql_query("insert into bd_paidabribe(city,dept,amount) values('".$m2[0]."','".$m2[1]."','".$m2[2]."')", $con);

$rs4=mysql_query("select max(sms_index) as 'ma' from sms");

mysql_query("UPDATE tab3 SET sms_index = ".$max2['ma']);

see where is necessary put that connction string
because of which your query didn't given the answer due to which you are getting the warning

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dtestfor/public_html/ipabex1.php on line 37

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dtestfor/public_html/ipabex1.php on line 45

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dtestfor/public_html/ipabex1.php on line 67