i am very new to ajax, i knw php and js well, but now my problem is i am not able to update the query. i retrived some records from database using php nd mysql, but now my req is i need to put button , after clicking the button i need to update the order in database, as php is server side,upon onclick event it is in html, so i want to call function where i can update my query. so i used ajax, but i am not geetng how can i implement it .. i have written some ajax code can u tell me how can i do this..i have implemented ajax in process page
database
-- phpMyAdmin SQL Dump
-- version 2.9.2
-- [url]http://www.phpmyadmin.net[/url]
--
-- Host: localhost
-- Generation Time: Jul 09, 2009 at 06:37 AM
-- Server version: 5.0.27
-- PHP Version: 5.2.1
--
-- Database: `kanoe`
--
-- --------------------------------------------------------
--
-- Table structure for table `admin`
--
CREATE TABLE `admin` (
`ID` int(15) NOT NULL,
`Admin_id` varchar(20) NOT NULL,
`Password` varchar(25) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `admin`
--
INSERT INTO `admin` (`ID`, `Admin_id`, `Password`) VALUES
(1, 'kanoe', 'kanoe123'),
(0, 'prathiba', '123456'),
(0, 'admin', 'admin123');
-- --------------------------------------------------------
--
-- Table structure for table `images`
--
CREATE TABLE `images` (
`id` int(15) NOT NULL auto_increment,
`image1` text NOT NULL,
`photo` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `images`
--
INSERT INTO `images` (`id`, `image1`, `photo`) VALUES
(1, 'images/Blue hills.jpg', ''),
(2, '', 'images/aegeri-lake-switzerland_small.JPG'),
(3, '', 'images/aegeri-lake-switzerland_small.JPG');
-- --------------------------------------------------------
--
-- Table structure for table `menureg`
--
CREATE TABLE `menureg` (
`menuid` int(15) NOT NULL auto_increment,
`menuname` varchar(25) NOT NULL,
`descri` varchar(850) NOT NULL,
`order1` int(15) NOT NULL,
PRIMARY KEY (`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=65 ;
--
-- Dumping data for table `menureg`
--
INSERT INTO `menureg` (`menuid`, `menuname`, `descri`, `order1`) VALUES
(60, 'Home', 'kjj', 1),
(61, 'About Us', 'kjl', 2),
(62, 'contact', 'dghhf', 3),
(63, 'gh', 'chh', 4),
(64, 'hg', 'kkgkj', 5);
pls find the attachment for the code..
waiting for the reply
regards