MadTechie

the single quote are not needed, can you run this query via PMA to check what results your getting SELECT * , TIME_FORMAT( `time` , '%H:%i' ) AS fTime, MONTHNAME( `date` ) AS `month` , YEAR( `date` ) AS `year` , DATE_FORMAT( '`date`', '%d/%m/%y ' ) AS fDate FROM gigs WHERE MONTHNAME( `date` ) =7 AND YEAR( `date` ) =2009 ORDER BY `date` ASC LIMIT 0 , 30 as on mine i get 2 results also check the values of $cMonth and $cYear (echo the query)

Assuming $cMonth = 7 and $cYear = 2009 this SELECT *, TIME_FORMAT(`time`,'%H:%i') as fTime, MONTHNAME(`date`) as `month`, YEAR(`date`) as `year`, DATE_FORMAT('`date`','%d/%m/%y ') as fDate FROM gigs WHERE MONTHNAME(`date`) = 07 AND YEAR(`date`) = 2009 ORDER BY `date` ASC returns so EDIT: the mistake was assuming the SELECT alias would remain in the WHERE clause which they don't.

Ahhh i assume you entered while(list($entry)= mysql_fetch_row($result)) //Update this line $table to $entry

Quick example SELECT * FROM `test0001` WHERE YEAR(`mydate`)=2009 AND MONTH(`mydate`)= 6 your statement should be SELECT *, TIME_FORMAT(`time`,'%H:%i') as fTime, MONTHNAME(`date`) as `month`, YEAR(`date`) as `year`, DATE_FORMAT('`date`','%d/%m/%y ') as fDate FROM gigs WHERE MONTHNAME(`date`) = $cMonth AND YEAR(`date`) = $cYear ORDER BY `date` ASC

yep that's a kick yourself error okay well let us know the outcome

can you do a structure dump so i can recreate the table gigs and what are you trying to find ? everything on a set month ?

Is that an insult ? welcome to the board! LOL

You know what.. if he doesn't start, saying thank you and clicking solved on his thread.. i'm just going to stop helping him!

$sql = "SELECT * FROM Bands WHERE bandname='$bandname'" should be $sql = "SELECT * FROM Bands WHERE bandname='$bandfield' " or $bandfield = $_POST['bandfield']; should be $bandname = $_POST['bandfield'];

$target_path =$target_path.basename($_FILE['uploadedfile']['name']; should be $target_path =$target_path.basename($_FILE['uploadedfile']['name']);

okay so $_FILES["file"]["name"] should be $_FILES["1"]["name"] also !

I assume your storing the filepaths of the videos in a database.. as for getting a thumbnail well if all the videos are the same format/encoding you could possible write a parsa.. but thats going to be long and slow.. I would recommend you use ffmpeg (external program run via system())

that line is wrong surely it should be if(move_uploaded_file($_FILES["file"]['tmp_name'], $_FILES["file"]["name"]) of course that depends on the form!

His missing a ) or a ;, on line 14 or a few before that, I ask him to post his code but he hasn't so..

Oh my bad.. mysql.error should be mysql_error

lol, its always the last place you look can you click topic solved bottom left

post your code.

Would you like to share the error?

change $resA = mysql_query($sqlA) or die(mysql.error()); to $resA = mysql_query($sqlA) or die("$sqlA:".mysql.error()); But it sounds like $entry isn't being set

$result = mysql_query("SELECT * FROM Bands WHERE bandname='$bandname'") or die(mysql_error());

How is that vulnerable to RFI ? your pages are hard coded!

Well I can see 2 things 1. not stating the problem/error or what your trying to do, 2. lack of code tags maybe add a username password database name, mysql_error()

I'll say Polar Bear (i know i am wrong here as a Kodiak should win) but where is the battle ground ?

And why do you think this is a IIS problem ? I'll move this to the PHP help, but also you will need to post your form and PHP code.. the problem is likely in the form, check the METHOD is POST and the ENCTYPE is multipart/form-data

correct if($page) { is not needed