retriving data from table and i need to insert the retrived data into another table i

Expand|Select|Wrap|Line Numbers

 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>STUDENT FORM</title> </head> <body bgcolor="#333333"> <?php

$HTNO=$_POST['HTNO'];

$RANK=$_POST['RANK'];

$Name=$_POST['Name'];

$FName=$_POST['FName'];

$DOB=$_POST['DOB'];

$SSC=$_POST['SSC'];

$Gender=$_POST['Gender'];

$Caste=$_POST['Caste'];

$Region=$_POST['Region'];

$Fee=$_POST['Fee'];

$db=odbc_connect("masterodbc","sa","chaithu");

$stmt="INSERT into reglist(HTNO,RANK,Name,FName,DOB,SSC,Gender,Caste,Region,FEE)values('".$_REQUEST['HTNO']."','".$_REQUEST['RANK']."','".$_REQUEST['Name']."','".$_REQUEST['FName']."','".$_REQUEST['DOB']."','".$_REQUEST['SSC']."','".$_REQUEST['Gender']."','".$_REQUEST['Caste']."','".$_REQUEST['Region']."','".$_REQUEST['FEE']."')";

$result = odbc_do($db,$stmt);

if($result)    

{

    echo "<script language='javascript'>\n";

    echo "alert('Successfully Inserted');window.location.href='reg.php';";

    echo "</script>\n";

}

else

{

    echo "<script language='javascript'>\n";

    echo "alert('Not Inserted ');window.location.href='reg.php';";

    echo "</script>\n";

}

odbc_close($db);

?> </body> </html>

Oct 28 '13 #1

Subscribe Post Reply

888

by: William Case | last post by:

I cannot believe I'm having this much trouble doing such a simple thing! I have two tables with identical structure. I can use an A2K select query to show the records in table 1 that match...

Microsoft Access / VBA

HOW TO UPDATE A TABLE BASED ON CHANGES IN ANOTHER TABLE?

by: EKL | last post by:

Hi, I'm making a sort of Customer and Orders database in MS Access 2003. My problem is that I wish to update the table "tblTransaction" based on changes made in the table "tblOrderDetails"....

Microsoft Access / VBA

Table in a cell of another table

by: Mark Goldin | last post by:

I have a table that is inside of a cell of another table. It seems that I cannot adjust the height of that cell. I have an extra space underneath of the internal table. ----------------------...

ASP.NET

how to insert record from another table to dataset?

by: jaYPee | last post by:

as of now i am using a stored procedure from my sql server 2000 to insert record from another table. what i need now is on how can i insert record by not using the stored procedure and insert it...

Visual Basic .NET

polating (insert into...) a table with determined record from another table.

by: Prabu Subroto | last post by:

Dear my friends... I created a table (named : sven1). I want to populate this table with the record from another table (named : appoinment). but I don't know how to formulate the sql query. ...

PostgreSQL Database

Reporting a table with two columns from another table

by: John Bokma | last post by:

I have a table A, with two ID columns. In a report both ID colums should be shown with the actual value stored in a second table, B The problem is, both IDs need to be looked up in B, but are not...

Microsoft SQL Server

Import Excel file into a table that is linked to another table

by: Randoz | last post by:

I recieve an updated excel file with pers information every other week and when I go to import the data into my table the data is not updated for the records that are linked to a course table. I...

Microsoft Access / VBA

Calculating a table value from values in another table, based on other fields.

by: zoeb | last post by:

Currently I have a table, and would like the calculate a field in the table by referencing values from another 3 tables. i.e. tblData Index1, Index2, Index3, Value 1 2 3 2...

Microsoft Access / VBA

Max value from one table in one field in another table

by: Hillwalker | last post by:

Hi Raw recruit, no VB knowledge but some general programming experience..... Access 2000 on XP In form view, I wish to fill the field (ONLY on the record being viewed) with the maximum value...

Microsoft Access / VBA

how to split a row item n insert it in another table

by: vikvikash | last post by:

hi i have split the data using the split command now i want to insert the split data to be inserted into another table. there r many records in the previous table i want each record to be split and...

Microsoft SQL Server

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

retriving data from table and i need to insert the retrived data into another table i

Similar topics