Insert into db problem

[benbigun]

I have 3 tables and i want to insert some values to one where $iid in 3rd table needs to be the same as $id in first table.
I have a form which visitors can post their comments. The default value is 0 so i can submit them to be displayed.
Here is the code and the form

HTML: Select all

mysql_select_db($database)
or die ("Could not select database because ".mysql_error());
$sorgu= 'select * from icerik WHERE id='.$_GET["id"];
$gelen = mysql_query($sorgu); 
$sonuc = mysql_fetch_array($gelen);
$kategorisi = $uc['id'];
if(!$_POST["gonder"]) 
{ 
$yorum= "insert into yorumlar VALUES('$id','$iid','$isim','$email','$sehir','$yas','$yorum','$tarih','$durum') where iid=".$kategorisi;
$veri_gir = mysql_query ($veri);
} 
echo '<form method="POST">';
echo '<table width="500" class="yorumgonder"><tr>';
echo '<td width="211">Adınız Soyadınız / Rumuzunuz</td><td width="28">:</td><td width="261">';
echo '<input type="text" name="isim" size="40" class="input"></td></tr><tr>'; 
echo '<td width="211">E-mail adresiniz</td><td width="28">:</td><td width="261">'; 
echo '<input type="text" name="email" size="40" class="input"></td></tr><tr>'; 
echo '<td width="211">Şehir</td><td width="28">:</td><td width="261">'; 
echo '<input type="text" name="sehir" size="40" class="input"></td></tr><tr>'; 
echo '<td width="211">Yaşınız</td><td width="28">:</td><td width="261">'; 
echo '<input type="text" name="yas" size="40" class="input"></td></tr><tr>'; 
echo '<td width="211">Yorumunuz</td><td width="28">:</td><td width="261">'; 
echo '<textarea name="yorum" cols="40" rows="10" class="input"></textarea></td></tr><tr>';
echo '<td width="211">&nbsp;</td><td width="28">&nbsp;</td><td width="261">';
echo '<input type="submit" name="Submit" value="Gönder" class="submit"></td></tr></table>'; 
echo '</form>'; 

I can print the id and get it no problem with it. But i can't insert the comment into db. Help pls. Tnx.

[sypher]

I dont understand your code, you have not declared any of your values to insert in the db :S

[benbigun]

How can i? Please write it's code.

[sypher]

You have said to the script. insert the following values $id $iid etc. into the table but you have not declared what those values are.

[benbigun]

id is in table1 and iid is in table 2. The problem is iid needs to be the same as the id. With the form i am getting the values and trying to insert them but i couldnt find a way to write this : insert all the data you get from the form and insert this comment's iid as id.

[Edgee]

You have no action on your form either. you need to post the data somewhere.

[sypher]

If your using the same id why dont u just use the same variable? :O

Ill post an example of inputting info into a database tomorrow.

[sypher]

Say i had a database with a table named test and had 3 fields name, email and url and i wanted to enter some information into this table.

The following is the php code with discussion on how it works below it.

PHP: Select all

<?php
// This is my database connection in order to connect to my server.
include ("db-connection.php");

// Here i define the variables i want to entr into the table. The variables can be generated dynamically or manually as long as the variables are defined how you generate them doesn't matter in this exercise
$name='sypher';
$email='testing.@testing.com';
$url='www.sypher-design.co.uk';

// My db function. Inserting the above variables above into the requied fields by stating the fields then the values.
$query = "INSERT INTO test (name, email, url) VALUES ('$name','$email','$url')";

// This activates the above function.
mysql_query($query);

// Closing the mysql connection to reduce security and sessions.
mysql_close();

// Shows success message
echo "Entry Added"
?>