PDA

View Full Version : repeated text wont write to database



Frg10
June 9th, 2005, 11:16 PM
Hi. Got another one here. Regarding the chat i am trying to do, im just quite curious why the php cannot write to mySQL the same message. you cannot have word repetitions any ideas?:crying:

Frg10
June 13th, 2005, 11:27 PM
still not working :tired:

Frg10
June 15th, 2005, 02:57 AM
still not working :tired:

scotty
June 15th, 2005, 04:27 AM
Moved, maybe you have more success here ;)

scotty(-:

Frg10
June 15th, 2005, 09:40 PM
thanks scott... arent you dr evil's scott? lolz... kiddin

Frg10
June 18th, 2005, 03:02 AM
help me please :( ive done everything to make it work and im stuck...

here is the php file:
<?php
include_once ('access.php');
// ---------------------
// get variables
// sent by flash
// ---------------------
$channel = $HTTP_GET_VARS['thisChannel'];
$saidto = $HTTP_GET_VARS['thisSaidto'];
$myid = $HTTP_GET_VARS['thisID'];
$message = $HTTP_GET_VARS['message'];
$comment = $HTTP_GET_VARS['message'];

if(empty($message) || empty($channel))
{
die();
}
// ---------------------
// Write data on mysql
// ---------------------
if(!(empty($comment))){
$comment = substr($comment,0,10000);
$comment = htmlspecialchars($comment);
$comment = nl2br($comment);
$timeof = date("YmdHis");
$query = "INSERT INTO messages (message,where,time,from,to) VALUES ('$comment','$where','$time','$userid','$sendto')";
$mydatabase->query($query);
$query = "UPDATE users set lastaction='$timeof' WHERE user_id='$myid'";
$mydatabase->query($query);
}
$mydatabase->close_connect();
?>
:puzzled:

Frg10
June 20th, 2005, 02:28 AM
got it now... something to do with the cache... thanks anyways :smirk: