Insert INTO Problem?

joelxez · Jul 1, 2002

Dear Experts,

I'm having an error, there's no data added...

Here's my PHP Code Below (add.php)
____________________________________________________________

<?php

$host = "localhost";
$user = "joel";
$pass = "";
$database = "personal";
$table = "tblpersonal";

echo "<B>This is a list of items I have in my table named $table</B> <hr>";

// Connecting to the Database
$connect = @mysql_connect($host, $user, $pass) or die("could not connect to server&quot

;

@mysql("$database","INSERT INTO $table VALUES(
'ID',
'Name',
'Address')&quot

;

// Query the Database
$result = @mysql_query(@mysql) or die("could not complete your query&quot

;

?>

____________________________________________________________

And here's my add.html

<html>

<head>

<title>ADD</title>
</head>

<body>

<form method="POST" action ="add.php">
<input type="text" name="Name" size="20"></p>
<p><input type="text" name="Address" size="20"></p>
<p><input name="ID" size="20" type = "hidden"></p>
<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>

</body>

</html>

____________________________________________________________

Joel,

RISTMO · Jul 1, 2002

Well, I'm no expert, but I hope you'll accept my answer anyway ;-). You are doing this:

@mysql("$database","INSERT INTO $table VALUES('ID','Name','Address')&quot

;

That's incorrect. You must say which row the info goes into or it doesn't know what to do with the info. I'm not what you called the rows, but if they were called id, name, and address, it would look like this:

@mysql("$database","INSERT INTO $table('ID','Name','Address') VALUES ('$ID','$Name','$Address')&quot

;

That should work

.

Rick
If I have helped you just click the first link below to let me know

danielhozac · Jul 1, 2002

I see some fatal errors in the code. First of all, there is no such function as mysql. Also, mysql_query takes a string as argument. Your code should look something like this:
<?php

$host = "localhost";
$user = "joel";
$pass = "";
$database = "personal";
$table = "tblpersonal";

echo "<B>This is a list of items I have in my table named $table</B> <hr>";

// Connecting to the Database
$connection = @mysql_connect($host, $user, $pass) or die("could not connect to server&quot

;
@mysql_select_db($database, $connection);

$query = "INSERT INTO $table VALUES(
'ID',
'Name',
'Address')&quot

;

// Query the Database
$result = @mysql_query($query) or die("could not complete your query&quot

;
?> //Daniel

RISTMO · Jul 1, 2002

Oh, I thought that was a function I hadn't learned yet! Can you do that like that? I thought you had to do this with the rows and their values:

$query = "INSERT INTO $table ('ID','Name','Address') VALUES('$ID','$Name','$Address')&quot

;

// Query the Database
$result = @mysql_query($query) or die("could not complete your query&quot

;

That's how I usually do it and it works.

Rick If I have helped you just click the first link below to let me know

danielhozac · Jul 1, 2002

If you are inserting the values in the exact same order as they are listed in the database table, you don't need the list of fields to insert into. But if you are just inserting in, for example, 3 out of 4 fields where the field that you dont insert into is an auto-incrementing index, you would need the field list. //Daniel

joelxez · Jul 1, 2002

Daniel,

I used your code but there's an error:

Parse error: parse error, unexpected ')' in C:\Inetpub\

http://wwwroot\php\view\add.php

on line 18

Joel,

KarveR · Jul 2, 2002

daniels code has this error:
'Address')");
the second bracket is surplus ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Insert INTO Problem?

joelxez

Programmer

RISTMO

Programmer

danielhozac

Programmer

RISTMO

Programmer

danielhozac

Programmer

joelxez

Programmer

KarveR

MIS

Similar threads

Part and Inventory Search

Sponsor