0) { mysql_select_db($database, $linkid); $type = trim($type); $descript = trim($descript); $url = trim($url); $newtype = trim($newtype); if ($login == "guest") { echo "\n"; } else { echo "\n"; echo "\n"; if ($REQUEST_METHOD == "POST" && isset($addtype) && $newtype != "") { $result = mysql_query("SELECT grp FROM bookmarkgrp " . "ORDER BY grp DESC LIMIT 1;"); $grpcnt = 1; if (($rows = mysql_num_rows($result)) == 1) { $row = mysql_fetch_row($result); $grpcnt = $row[0] + 1; } $q = "INSERT INTO bookmarkgrp VALUES (" . " $grpcnt, '$newtype');"; $result = mysql_query($q); } } if ($login != "guest" && $REQUEST_METHOD == "POST" && $insert) { if ($type != "" && $descript != "" && $url != "") { $q = "SELECT grp FROM bookmarkgrp WHERE grpdesc = '$type';"; $result = mysql_query($q); if (($rows = mysql_num_rows($result)) == 1) { $row = mysql_fetch_row($result); $grp = $row[0]; $q = "INSERT INTO bookmark VALUES (" . " '$descript', '$url', $grp);"; $result = mysql_query($q); } } } $result = mysql_query($query); # $fields = mysql_num_fields($result); # $rows = mysql_num_rows($result); # $table = mysql_field_table($result, 0); # # # for ($i = 0; $i < $fields; $i++) { # $type = mysql_field_type ($result, $i); # $name = mysql_field_name ($result, $i); # $len = mysql_field_len ($result, $i); # $flags = mysql_field_flags ($result, $i); # $fd_name[$i] = $name; # } while ($row = mysql_fetch_array($result)) { echo ""; printf("", $row['url'], $row['description']); # $row[$fd_name[1]], $row[$fd_name[0]]); printf("", $row['url'], $row['url']); # $row[$fd_name[1]], $row[$fd_name[1]]); # printf("", $row[$fd_name[3]]); printf("", $row['grpdesc']); echo "\n"; } if ($login != "guest") { echo "\n"; echo "\n"; echo "\n"; echo "\n"; } mysql_close($linkid); } else { echo "error " . mysql_errno() . ":" . mysql_error(); } ?>
DescriptionURLType
DescriptionURLType\n"; echo ""; echo ""; echo "
%s%s%s%s
\n"; echo "\n"; echo "