mysql-php error message

[sreesrinivas1]

<?php
$todb            = 'localhost';
$fromdb          = 'test1.deftlogic.com';
$smstable        = sms;
$paid_bribetable = bd_paidabribe;
$countertable    = tab3;
 
//connecting to the local database
$con = mysql_pconnect($todb, 'dtestfor_ipab', 'IaMzieU3#b%$'); //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 " . $countertable . "", $con);
 
$max = mysql_fetch_assoc($rs2);
 
print_r($max['ma']);
//connecting to the local database ends
//connecting to the remote database
$dblink2 = mysql_pconnect($fromdb, 'dtestone_ipab', '!*D-pD)g5)FJ'); // 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 " . $smstable . " 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($todb, 'dtestfor_ipab', 'IaMzieU3#b%$'); //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 " . $paid_bribetable . "(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($fromdb, 'dtestone_ipab', '!*D-pD)g5)FJ'); // connect server 2
 
mysql_select_db('dtestone_db_2025', $dblink2); // select database 2
 
$rs4  = mysql_query("select max(sms_index) as 'ma' from " . $smstable . "");
$max2 = mysql_fetch_assoc($rs4);
//connecting to the remot database ends
//connecting to the local database
$con  = mysql_pconnect($todb, 'dtestfor_ipab', 'IaMzieU3#b%$'); //servername,username,password
if (!$con) {
    die("couldn't connect");
}
 
mysql_select_db("dtestfor_IPAB_db", $con);
 
mysql_query("UPDATE '" . $countertable . "' 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...

[johny10151981]

everything is right with syntax but some thing is wrong with your Query that you didnt write.

here is it

$Query="...";
$res=mysql_query($Query);//here is Query is incorrect or query is not suppose to return any resource such as update query, insert query or delete query. 
//now if you try this
$row=mysql_fetch_assoc($res); // you will get error.
 
 
 

[Dormilich]

I’d hazard a guess at 'ma' (invalid context for a string)

[sreesrinivas1]

@dormilich 'ma' is just used as a temporary value to store the details collected from the table...

[Dormilich]

check the SQL error message then. I wouldn’t be the least bit surprised if that’s the position where the error is occuring.