SitePoint Sponsor |
|
User Tag List
Results 1 to 1 of 1
-
May 28, 2001, 00:47 #1
- Join Date
- Mar 2001
- Location
- the Netherlands
- Posts
- 519
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
adding a value, checking for old... I'm lost... please help
Argh...
I have a new problem... using the following code, a new page is added to table pages, with the id of the new rubrieken.id.
For instance:
table pages; id(34), subcatid(7), txt(), rubrieken(34)
I will post too pieces of code... one from add.php, which allows the user to add a new rubriek to a page, or to add an exsisting rubriek to a page.
add1.php checks if it is a new rubriek, or an old one...
add.php:
PHP Code:elseif (isset ($subcatid)){
$subcatid = $subcatid;
print "<html><head><title>Adding a rubriek</title></head>";
print "<form name='toevoegenform' method='POST' action='add1.php'>";
print "Title of new rubriek: <b>";
print "<input type='text' name='rubtitel' size='40'><br>";
print "<select name='oudrubid'><option value=''>Select old rubriek...</option>";
$sql = "SELECT * FROM rubrieken ORDER BY titel";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
// function extract will take the key/value pairs in
// array $row and place them in their own variables
// being $titel and $id
extract($row);
$oudrubid = $id;
print "<option value='$id'>$titel</option>";
}
print "</select>";
print "<input type='hidden' name='subcatid' size='1' value='$subcatid'>";
print "<body onload=\"document.toevoegenform.rubtitel.focus();\">";
}
PHP Code:elseif (isset ($subcatid)){
$sql = "SELECT * FROM pages WHERE subcat = '$subcatid'";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
/* /// extract each element of array $row into its own variable /// */
extract($row);
if ($rubtitel){
if ($rubrieken){ // rubrieken has an existing value
$pageid = mysql_result($result,0,'id');
$sql = "INSERT INTO rubrieken(id,titel) VALUES('','$rubtitel')";
$result = mysql_query($sql);
$sql1 = "SELECT * FROM rubrieken WHERE titel = '$rubtitel'";
$result1= mysql_query($sql1);
$rubid = mysql_result($result1,0,'id');
$sql2 = "SELECT rubrieken FROM pages WHERE id = '$pageid'";
$result2= mysql_query($sql2);
$rubriek= mysql_result($result2,0,'rubrieken');
$rubids = $rubriek . ',' . $rubid;
$sql3 = "UPDATE pages SET rubrieken='$rubids' WHERE subcat =$subcatid";
$result3= mysql_query($sql3);
print " Rubrieken $rubids has been added to Page $pageid, along with rubrieken $rubriek";
}
else { // rubrieken is empty
$sql = "INSERT INTO rubrieken(id,titel) VALUES('','$rubtitel')";
$result = mysql_query($sql);
$subcatid = $subcatid;
$sql2 = "SELECT * FROM rubrieken WHERE titel = '$rubtitel'";
$result2= mysql_query($sql2);
$rubid = mysql_result($result2,0,'id');
$sql3 = "INSERT INTO pages(id,subcat,txt,rubrieken,datum) VALUES('','$subcatid','','$rubid','')";
$result3= mysql_query($sql3);
print "Rubriek <b>$rubtitel, $subcatid, rubid: $rubid</b> has been correctly submitted";
}
}
if ($oudrubid){
$sql1 = "SELECT * FROM pages WHERE subcat = '$subcatid'";
$result1 = mysql_query($sql1);
$row1 = mysql_fetch_array($result1);
/* /// extract each element of array $row into its own variable /// */
extract($row1);
if ($rubrieken){
print "Num: $num1 subcatid = $subcatid res2 = $res2";
$pageid = mysql_result($res1,0,'id');
$sql2 = "SELECT * FROM pages WHERE id = '$pageid'";
$result2= mysql_query($sql2);
$rubriek= mysql_result($result2,0,'rubrieken');
$rubids = $rubriek . ',' . $oudrubid;
$sql3 = "UPDATE pages SET rubrieken='$rubids' WHERE subcat =$subcatid";
$result3= mysql_query($sql3);
print " Rubrieken $rubids has been added to Page $pageid, along with rubrieken $rubriek";
}
else { // rubrieken is empty
$subcatid = $subcatid;
print "Num: $num1 subcatid = $subcatid";
$sql3 = "INSERT INTO pages(id,subcat,txt,rubrieken,datum) VALUES('','$subcatid','','$oudrubid','')";
$result3= mysql_query($sql3);
print "Rubriek <b>$rubtitel, $subcatid, rubid: $rubid</b> has been correctly submitted";
}
}
}
Bookmarks