Multi table Insert delete select function needed.

Multi table Insert delete select

[Gruessle]

I am going nuts here and I know with all the functions out there, there must be an easier way to do this. Maybe someone can point me to the right tutorial or even show me how to do this.

I have a $main_id and many $sub_id tables and like to “SELECT to view” INSERT and DELETE those. UPDATE must not be but would be nice.
Here is how it looks:

Main Table
----------------------------------------------------------
id ¦ something ¦ something ¦ something ¦ main_id
----------------------------------------------------------
22 ¦ Red Hat¦ SuSe ¦ Debian ¦ 35
----------------------------------------------------------

Sub Table 1
----------------------------------------------------------
id ¦ something ¦ main_id ¦ sub_id
----------------------------------------------------------
40 ¦ gold ¦ 35 ¦ 2
----------------------------------------------------------

Sub Table 2 out of 7
----------------------------------------------------------
id ¦ something ¦ else ¦ main_id ¦ sub_id
----------------------------------------------------------
40 ¦ Nails ¦ Woody ¦ 35 ¦ 2

Sub Table 3 out of 7
----------------------------------------------------------
id ¦ something ¦ main_id ¦ sub_id
----------------------------------------------------------
40 ¦ something ¦ 35 ¦ 2

I can't get the delete function to work when using variables

[edited by: coopster at 11:33 am (utc) on Mar. 18, 2005]
[edit reason] removed url per TOS [webmasterworld.com] [/edit]

[jatar_k]

how the piece of code you are having trouble with? Specifically where you are constructing your query.

[Gruessle]

If you are asking about my delete problem here it is:

This workd fine
if ($_POST['delete']){
$delete = $_POST['delid'];
$error = DeleteQuery ("type_doc", "where progr_id=2");
}

But this does not:
if ($_POST['delete']){
$error = DeleteQuery ("type_doc", "where progr_id=$_POST['delid']");
}

But this does not:
if ($_POST['delete']){
$delid = $_POST['delid'];
$error = DeleteQuery ("type_doc", "where progr_id=$delid");
}

[jatar_k]

are you sure delid is getting passed properly?

maybe try

if ($_POST['delete']){
$error = DeleteQuery ("type_doc", "where progr_id=" . $_POST['delid']);
}

OR

if ($_POST['delete']){
$delid = $_POST['delid'];
$error = DeleteQuery ("type_doc", "where progr_id=" . $delid);
}

[Gruessle]

Still this does work!

if ($_POST['delete']){
$delid = $_POST['delid'];
$error = DeleteQuery ("type_doc", "where progr_id=2");
}

Following if does not. (echo is blank)

if ($_POST['delete']){
$delid = $_POST['delid'];
echo "DelID: $delid";
$error = DeleteQuery ("type_doc", "where progr_id=" .$delid);
}

while (list(,$v) = each ($values)){
echo "$v[0], $v[1]<br>\n";
}

$values = SelectQuery ("type_doc", "progr_id, Documentation");

print "<table cellpadding=2 cellspacing=0 border=0 bgcolor=\"#FFFF99\" width=\"600\">\n";
print "<tr>
<th>Progr ID</th><th>Documentation</th><th>Delete</th>
</tr>\n";

while (list(,$qry) = each ($values))
{
$tx = ($tx == 'odd')? ('even') : ('odd');
print "
<tr>
<td class='$tx'>$qry[0]</td><td class='$tx'>$qry[1]</td>
<td class='$tx'>
<form name='delete' method='post' action=$PHP_SELF>
<input name='delid' type='hidden' value=$qry[prog_id]>
<input type='submit' name='delete' value=Delete>
</form>
</td>
</tr>\n
";
}
print "</table>\n";

[jatar_k]

based on that data you aren't passing the delid properly via $_POST

what does it say for the

echo "DelID: $delid";

[Gruessle]

It comes back blank

[Gruessle]

Got is changes this
<input name='delid' type='hidden' value=$qry[prog_id]>

to this
<input name='delid' type='hidden' value=$qry[0]>

And it's working
Thanx