seemeamal

am an absolute beginer.will i become a successful webdeveloper.halfway through my first project:) .. need encouragement:)

Dear all, The first query works while the second doesnt, am not able to figure, can u please help me out. 1) // $query3="insert into ttrough(am,pm) select ttam.subject,ttpm.subjectpm from ttam,ttpm where ttam.class != ttpm.classpm limit 1";// this one actually takes two columns from different tables and checks whether they are …

Dear all, Am half way through my computer lab management project. to generate the timetable automatically i've written an algorithm. and for it to work i need an sql query that can : table-> ttprofile: id lab_name subject_name. now i looked every where, is there a command to take the …

[CODE]<?php //update has an error! ?> <?php include("lock.php");// contains session details $connect=mysql_connect("localhost","root",""); mysql_select_db("login",$connect); if(isset($_POST[""])){ $dept_name=$_POST["dept_name"]; $year=$_POST["year"]; $current_sem=$_POST["current_sem"]; $total_students=$_POST["total_students"]; $regulation=$_POST["regulation"]; } //------------------------------------------------------------------------------------------------------------------ if(isset($_POST["insert"])){ if($_POST["insert"]=="yes"){ $dept_name=$_POST["dept_name"]; $year=$_POST["year"]; $current_sem=$_POST["current_sem"]; $total_students=$_POST["total_students"]; $regulation=$_POST["regulation"]; $query="insert into classprofile(dept_name,year,current_sem,total_students,regulation) values('$dept_name','$year','$current_sem','$total_students','$regulation')"; if(mysql_query($query)) echo "<center>Record Inserted!</center><br>"; } else{ echo"not inserted, try again"; } } //------------------------------------------------------------------------------------------------------------------- if(isset($_POST["update"])){ if($_POST["update"]=="yes"){ $dept_name=$_POST["dept_name"]; $year=$_POST["year"]; $current_sem=$_POST["current_sem"]; …