insertin double value

[nehakarnatak]

<?php
session_start();
include("connect_wec.php");

$q1="INSERT INTO category( Category)
VALUES
( TRIM( '$_POST[category]' )) ";





if (!mysql_query($q1))




die('Error:qry_Create_Categ: ' . mysql_error());



}

//header("Location: Http://localhost/crm/admin/Create_Categ ... ategCreate");

header("Location: http://indiaenergycongress.in/crm/admin ... atagCreate");


exit();



?>

[NigelRen]

Could you please explain what you are expecting and what's actually happening.

There is one obvious problem at

Code: Select all

$q1="INSERT INTO category( Category)
VALUES
( TRIM( '$_POST[category]' )) ";

The value isn't being retrieved properly. Should be something like

Code: Select all

$q1="INSERT INTO category( Category)
VALUES
( TRIM( '".$_POST["category"]."' )) ";

This comes down to when accessing things like $_POST - you normally have to put the name of the field your after in quotes. This because it acts as an index - which is a string, and strings are normally enclosed in quotes.