prathikanoe 0 Newbie Poster

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.