insert data into database

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'add que(quedtion_tex)VALUES('')' at line 1

this my code

Expand|Select|Wrap|Line Numbers

 <html>

<head>

<title>

add question

</title>

<meta name="keywords" content="Web Tech Template, CSS, HTML" />

<meta name="description" content="Web Tech Template is a free CSS website provided by templatemo.com" />

<link href="css/templatemo_style.css" rel="stylesheet" type="text/css" />

<script language="javascript" type="text/javascript">

</script>

</head>

<body>
 
<?php

error_reporting(0);
 
$quedtion_tex=$_POST['quedtion_tex'];

$con = mysql_connect("localhost","root","");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }
 
mysql_select_db("center_db", $con);
 
$sql="INSERT INTO add que(quedtion_tex)VALUES('$quedtion_tex')";
 
if (!mysql_query($sql,$con))

  {

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

  }

echo "1 record added";
 
mysql_close($con)

?>
 
<form action="add que.php" method="post">

<p>

<input type="text" name="quedtion_tex">

<input type="submit" name="submit"  value="add que" >

</p>
 
</body>

</html>

May 3 '14 #1

Subscribe Post Reply

1540

Luuk

1,047

Expert 1GB

Why did you not use '[CODE/]' tags around your code?

INSERT INTO add que(quedtion_tex)VALUES.....
is not a valid SQL statement.
What is the name of your database table?

May 3 '14 #2

fatma fares

name of my database table(add que)

May 3 '14 #3

Luuk

1,047

Expert 1GB

You should use backquotes "`" around your tablename, when you decide to use a space in its name....

May 3 '14 #4

koharu

Hi Fatma Fares.

Standard MySQL Syntax for an Insert Statement goes as followed;

Expand|Select|Wrap|Line Numbers

INSERT INTO `add que` VALUES ();

For example;

Expand|Select|Wrap|Line Numbers

 INSERT INTO `my users` VALUES ('','Koharu',md5('myPass'),'something@towho.com');
 

I suggest you do some reading on MySQL Queries here;
https://dev.mysql.com/doc/refman/5.0/en/examples.html

May 5 '14 #5

by: Santo Santis | last post by:

How can I make an .exe file that can insert data automatically in a SQLServer database, I can do it in C, but how can I connect to SQLServer and execute a query. All data that I have to insert...

Microsoft SQL Server

Using Transactions to Insert Data to Db2 Database

by: Dinu | last post by:

Hi All I am trying to insert data within a transaction, into a Db2 database from asp.net. I have created a System DSN using ISeries Access Driver(32 bit) for Windows. I am then connecting...

DB2 Database

how to INSERT data into a table in SQL express2005 using ASP.Net2.0

by: Pratik Gupte | last post by:

I have created a database in .mdf format, but I am unable to insert data into its tables. Can anybody help how to insert data using ASP.Net 2.0 using SQL Server 2005 Express edition in windows...

ASP.NET

insert data -

by: VitaminB | last post by:

Hi Guys, I try to insert data from a form into a mysql database, but it did not work... There is no error, but the data did not pass thru the table. This is the short script:

PHP

PHP Form data database insert

by: andrewtayloruk | last post by:

I'm a newbie when it come to things php and i'm having a bit of trouble. I'm trying to insert data from an html form into a mysql database and can't get it to work. Just a few bits about my...

PHP

Insert Data directly into database using WinForm DataGrid

by: danishce | last post by:

Hello, I want to insert data directly into my windows form data grid and load a combobox(userid) in the 1st column of data grid,a textbox(password) in 2nd column of datagrid. The code for insert...

.NET Framework

Insert data into database

by: Doc11 | last post by:

I'm trying to allow users insert data into a database using the form view. But when I click the insert button I get this error: Server Error in '/Customer Database' Application....

.NET Framework

How to insert data to a SQL database Using VB

by: Newbie19 | last post by:

I am creating a project that would insert data into a SQL database when the User placed the information into the VB application. Then at a click of a button, it would add this data into the...

Visual Basic 4 / 5 / 6

Can not insert data into SQLite3 database

by: Betikci Boris | last post by:

Can not insert data into SQLite3 database through browser however i can easily insert data into my db from konsole, in both attmpts i used php 5.2.6 on 2.6.25.* linux kernel i think there is a...

PHP

An Issues in Insert Data Into Oracle Database using BizTalk Server 2006 R2 project an

by: akshalika | last post by:

I am new to Biztalk. In my project we need to connect oracle database and insert data into oracle table using BizTalk project. I use WCF Adapter pack(SP2). I create biztalk project then using Consume...

.NET Framework

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

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

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++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

insert data into database

Similar topics