Forum Moderators: open
But for some reason this script was working when I had about 10 users in the db, but I know have 18 users and it does not add the record to the table when the insert query is run. I know the query is working fine as I echoed the output to the screen.
Can any body help?
Code Below
$xml = new SimpleXMLElement($data);
foreach($xml->status as $results) {
$tweet = mysql_escape_string($results->text);
$datetime = $results->created_at;
$queryselectresult = "SELECT * FROM letwitour.".$id." WHERE statusid='$results->id'";
$selectresult = mysql_query($queryselectresult, $conn)or die('Error :666 ' . mysql_error());
if (mysql_num_rows($selectresult)) {
$updatetweetSQL = ("
UPDATE
letwitour.".$id ."
SET
statusid = '$results->id',
tweet_text = '$tweet',
create_time_date = '$results->created_at'
WHERE
statusid = '$results->id'");
#mysql_query($updatetweetSQL,$conn) or die('Error 3: ' . mysql_error());
mysql_query($updatetweetSQL, $conn)or die('Error 3: ' . mysql_error());
} else {
$insertintoTB = "INSERT IGNORE INTO letwitour.".$id ."
VALUES ('NULL','$results->id','$tweet','$results->created_at')" ;
mysql_query($insertintoTB, $conn) or die('Error 2: ' . mysql_error());
$count ++;
}
#echo $results->text;
#echo $results->id .'<br /><br />';
}