hi there,
i ve tried the first time on php and mysql.
i have some simple questions for the pros
i have to tables:
table1 and table2
the fields of table1:
table1_id
table1_name
table2_id
the fields of table2:
table2_id
table2_name
now, you can see, the table2_id is needet for table1
the first thing, i want to ask is:
how can i do the reference in sql-script?
my script looks like this:
CREATE TABLE table1
(
table1_id MEDIUMINT(9) NOT NULL DEFAULT 1 AUTO_INCREMENT,
table1_name VARCHAR(55) NOT NULL,
table2_id MEDIUMINT(9) NOT NULL,
PRIMARY KEY (table1_id)
);
CREATE UNIQUE INDEX artikelindex ON table1
(
table1_name(55)
);
CREATE TABLE table1
(
table2_id MEDIUMINT(9) NOT NULL DEFAULT 1 AUTO_INCREMENT,
table2_name VARCHAR(55) NOT NULL,
PRIMARY KEY (table2_id)
);
CREATE UNIQUE INDEX artikelindex ON table2
(
table2_name(55)
);
there is no reference, so how can i do a reference for this mysql?
and: do i have to put on line PRIMARY KEY (table1_id)
something like this PRIMARY KEY (table1_id,table2_id) ?????
now the php part for this problem
i want to do an entry in table1 with the following form:
(artikel means table1 and warengruppe means table2)
<form name="artikel_neu" method="post" action="artikel_neu.php">
<div align="center">
<table width="98%" border="0">
<tr>
<td width="107">Artikelname</td>
<td width="610"> <input type="text" name="artikel_name" maxlength="55" size="55">
</td>
</tr>
<tr>
<td width="107"> Artikel-Bezeichnung-Bon:</td>
<td> <input type="text" name="artikel_name_bon" size="23" maxlength="20" >
</td>
</tr>
<tr>
<td width="107">Warengruppe</td>
<td>
<?php
$query = mysql_query ("SELECT warengruppe_name FROM warengruppe ORDER BY warengruppe_name");
?>
<select name="Array[warengruppe]">
<option selected>Warengruppe waehlen!</option>
<?
while ($zeile = mysql_fetch_array($query)) {
$warengruppe = $zeile["warengruppe_name"];
print ("<option value=\"$warengruppe\">$warengruppe</option>");
}
?>
</select> </td>
</tr>
</table>
<p>
<input name="eintragen" type="submit" id="Eintragen" value="Eintragen">
<input name="loeschen" type="reset" id="loeschen" value="Eingabe loeschen">
</p>
</div>
</form>
could anyone help me out to understand that? is someone here to post a small examplecode how to handle that?
thank you
k
