in a product I have
PHP Code:
//get the last post created
$getpost = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "post WHERE postid ORDER BY postid DESC");
$post2 = $db->fetch_array($getpost);
$pagetext = $post2['pagetext'];
//if radio button is set to "positive" then display a positive random message
if ($_POST['random_reply'] == "pos")
{
$getrr = $db->query_read("SELECT * FROM " . TABLE_PREFIX ."random_reply WHERE ptext ORDER BY RAND()");
$rr = $db->fetch_array($getrr);
$rr = $rr['ptext'];
}
//if radio button is set to "negative" then get a negative random message
elseif ($_POST['random_reply'] == "neg")
{
$getrr = $db->query_read("SELECT * FROM " . TABLE_PREFIX ."random_reply WHERE ntext ORDER BY RAND()");
$rr = $db->fetch_array($getrr);
$rr = $rr['ntext'];
}
//if none are selected then have $rr insert as nothing
elseif ($_POST['random_reply'] == 0)
{
$rr = "";
}
//get the pagetext from the post table and a randon reply and combine them
$db->query_write("
UPDATE " . TABLE_PREFIX . "post
SET pagetext = '$pagetext $rr'
WHERE postid = " . $post2['postid'] . "
");
the above probably needs edited but I never got a chance to test it out.
I have three radio buttons in the newreply template
Code:
<input type="radio" name="random_reply" value="0">None
<input type="radio" name="random_reply" value="pos">Positive
<input type="radio" name="random_reply" value="neg">Negative
I just want to get the random reply and combine it with the post message like attachments do.