nilansanjaya

you should keep a record in the database and update the no.of views / downloads per song on the database. or else in a flat file.

try using, <?php header("Location: path_to_fail_page.php"); ?>

if you want to do it with pure php ( and little bit of javascript. not ajax ) just submit the form to the same page , on the onchange method of the select, using javascript, then capture the values on the top and do what you want to do <select name="select_name" onChange="document.form_name.submit();">

so what help you exactly need ? a way to do it ? ideas ? codes?

query the database and get the details. then, while( $row = mysql_fetch_array($results) ){ echo 'id: '.$row['id'].'<br />'; echo 'id: '.$row['tamil'].'<br />'; echo 'id: '.$row['english'].'<br />'; echo 'id: '.$row['maths'].'<br />'; } you can do the html formatting part as you want. its just a example

are you getting a php error or a mysql error ?

did you checked the mysql user's permission on that database ?

NO problem

link isn't empty. its the database link mysql_connect('localhost', 'testusr', 'testpw'); better to use a different variable for sql , ex: $query

this , mysql_query ($link); should be mysql_query ($query); and use $query = "sql query here"; between the if statement , like i mentioned before

try this <?php $link = mysql_connect('localhost', 'testusr', 'testpw'); mysql_select_db('testdb', $link); $email = $_POST['e-mail']; $query = ""; if ($_POST['action'] == 'Register') { if ($_POST['newsletter'] == 'Mens') { $query = "INSERT INTO newsletters(mens) VALUES('$email')"; } elseif ($_POST['newsletter'] == 'Mens & Womens') { $query = "INSERT INTO newsletters(mensandwomens) VALUES('$email')"; } elseif ($_POST['newsletter'] == 'Womens') { $query = "INSERT INTO newsletters(womens) VALUES('$email')"; } ;} mysql_query ($link, $query); mysql_close($link); ?>

you cant just use "$query =" and put a if statement in the middle like that

can u explain whats goin on ? and why friendly url's not working ? i guess its easily done using friendly url's ( mod_rewrite ) and bit of logic

it should be <?php if ( $firstname == "Joe" && $lastname == "Shmo" ) { echo( "Welcome, Myself!" ); } else { echo( "Welcome, $_POST[firstname] $_POST[lastname]!" ); } ?>

im not sure that a folder can be renamed inside a zip file. so i suggest you could extract it , make the change's and compress it back to a zip , unless some other person give's you a better solution