Thanks for all the previous help.
I'd like guidance with the update query below:
I’ve tried this query to update sell_price without successfully changing the ‘sell_video’ and/or Price:
Any assistance with this update query is welcomed.
I'd like guidance with the update query below:
Code:
if (!empty($get_videos)) {
$len = count($get_videos);
foreach ($get_videos as $key => $video) {
$video = PT_GetVideoByID($video, 0, 0, 0);
$pt->last_video = false;
if ($key == $len - 1) {
$pt->last_video = true;
}
$final .= PT_LoadPage('search/list', array(
'ID' => $video->id,
'USER_DATA' => $video->owner,
'THUMBNAIL' => $video->thumbnail,
'URL' => $video->url,
'ajax_url' => $video->ajax_url,
'TITLE' => $video->title,
'DESC' => $video->markup_description,
'VIEWS' => $video->views,
'VIEWS_NUM' => number_format($video->views),
'TIME' => $video->time_ago,
'DURATION' => $video->duration,
'VIDEO_ID_' => PT_Slug($video->title, $video->video_id),
'GIF' => $video->gif,
'PRICE' => number_format( $video->sell_video < $config['sell_video'] ? $config['sell_video'] : $video->sell_video)
));
}
}
I’ve tried this query to update sell_price without successfully changing the ‘sell_video’ and/or Price:
Code:
if ($sell_video === 0 && $wallet === 0.5) {
$db->rawQuery("UPDATE ".PRICE." SET `sell_video` = `sell_video` = '1' WHERE `id` = '".$video->video_id."'");
Any assistance with this update query is welcomed.
Last edited: