Codezwiz >> Forums >> General PHP Nuke Help >> Help with SQL in a new Module

Im making a new module to help sort out my videos on my site. The first version used no sql and was hard to add new stuff. This time i want to use sql to store the file location, width, height, and name of the video. I would also like to add and modify from admin.

What i want it to do is show the video with the selected height and width using cid. the videos will be accessed directly from EDL as a download and not from the front page of this module.

As i have no idea how to use sql so if anyone could help me set up the sql part of this module. I already have the design. Of course ill give credits to whoever helps in any way.

Register

well... i tried and with some success

heres the code i used:

function flash($cid) {

global $prefix, $dbi;
$result = sql_query("select cid, title, width, height, file, colour, id from ".$prefix."_downloads_categories where cid=$parentid", $dbi);
list($cid, $title, $width, $height, $file, $colour, $id) = sql_fetch_row($result, $dbi);
$cid = intval($cid);

include("modules/DownloadManager2/Addons/Flash.php");

}