INSERT INTO syntax ??

[nogard]

I am not getting anywhere with this. Could you correct the code for INSERT INTO I am at a complete loss as how to do this.

Even a simple tutorial would be appreciated.

<?php
if($db = mysql_connect("localhost", "user", "pw"))
{ echo "Connection to MySQL server 'localhost' successful!<br>\n"; }
mysql_select_db("coachin3",$db);
echo "Database selected<br>\n";
$query = "CREATE TABLE event (
name VARCHAR(25),
date DATE NOT NULL,
type VARCHAR(15),
remark VARCHAR(255)
)";
if(mysql_query($query,$db))
{ echo "Table 'test' created<br>\n"; }
$row = "INSERT INTO event (name,date,type,remark) VALUES ('$query')";
('Fluffy', '1995-05-15', 'litter', '3 kittens', '3 female'),
('Buffy', '1996-25-15', 'litter', '4 dogs', '3 female, 1 male')
)";
if(mysql_query($row,$db))
{ echo "Insert successful<br>\n"; }
mysql_close ($db);
?>

[[deleted]]

Sharon, I suggest you start by thinking this through logically:

$row = "INSERT INTO event (name,date,type,remark) VALUES ('$query')";
('Fluffy', '1995-05-15', 'litter', '3 kittens', '3 female'),
('Buffy', '1996-25-15', 'litter', '4 dogs', '3 female, 1 male')
)";

$query contains a query you just defined a few lines ago, why would you want to insert that?

Right after the $query, you put ";, which ends the string!
Thus "('Fluffy.." etc is a new PHP command.

Read more about the INSERT syntax here:
http://www.mysql.com/doc/I/N/INSERT.html

[subwiz]

hi!
i have given the modified program below. i didn't check it out in my system. but it should work!! also check out the comments given in the program.

<?php
$db = mysql_connect("localhost", "user", "pw") or die ("Connection to MySQL server localhost failed!");
mysql_select_db("coachin3") or die("Database select fail!");
$query = "CREATE TABLE event ( ";
$query .= "name VARCHAR(25),";
$query .= "date DATE NOT NULL,";
$query .= "type VARCHAR(15),";
$query .= "remark VARCHAR(255)";
$query .= ")";

//create table query
//do not execute this query more than once!
$link = mysql_query($query) or die("Create table query failed!");

//check the "date" format of mysql. u cannot insert '-' in a date column!!
//modify the same below!
//note the slashes added for the remark column.

$row = "INSERT INTO event (name,date,type,remark) VALUES ('Fluffy', '1995-05-15', 'litter', '3 kittens\', \'3 female')";
mysql_query($row) or die("Query failed!");
$row = "INSERT INTO event (name,date,type,remark) VALUES ('Buffy', '1996-25-15', 'litter', '4 dogs\', \'3 female, 1 male') )";
mysql_query($row) or die("Query failed!");
mysql_close ($db);
?>

hope u find it helpful!
-Subhash.
http://www.indiwiz.com/

[nogard]

THANK YOU VERY MUCH.

Yes that was helpful.
This is my first script I have coded and I am learning where I can :>

So syntax for INSERT INTO is like this?

I looked all over for that syntax.

$var = "INSERT INTO event (column heading1, column heading2, column heading3, column heading4, column heading5) VALUES
row1('column1 data', 'column2 data, 'column3 data', 'column4 data', 'column5 data'),
row2('column1 data', 'column2 data, 'column3 data', 'column4 data', 'column5 data')";

/ query table data variable/
$doit=mysql_query($var);

"When the student is ready the teacher will appear"

[nogard]

I am here to learn the logic so I can think things through 🙂 If I understood how to think this through logically I would not be posting newbie questions here.

This is my 1st script and asked for some friendly advice in this HELP forum. Is that a crime here?

"There are no dumb questions except the one that is not asked."

[nogard]

After reading a few more tutorials I thought $query would contain the type of values to be inserted.

The ; after ($query) was a typo and there is no edit feature that I see on this forum.

I have recieved the answer I was looking for and can now better understand the URL you suggested. Had I not been given the correct syntax I would have still been at a loss.

Thanks for your time.

"Practice makes perfect if you have something to practice."