Holding links in a database
| From: | Shaun | Date: | Sat, 07 Aug 2004 15:19:10 +0000 |
| Subject: | Holding links in a database | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-193083@lists.php.net to get a copy of this message | ||
Hi,
I have a table in my database that holds links for individual pages on my
site:
mysql> DESCRIBE Page_Links;
+-----------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+----------------+
| Link_ID | int(11) | | PRI | NULL | auto_increment |
| PHP_SELF | varchar(100) | | | | |
| Action | varchar(100) | | | | |
| Link | varchar(255) | | | | |
| Link_Text | varchar(100) | | | | |
+-----------+--------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
The links that appear on each page depend on PHP_SELF i.e./users/index.php
and $_GET[action] variable i.e. add_user.
This all works well until there is a problem with the form validation, for
example if I am on the add_user.php page and I click to add a user I am
taken back to the users list, the action is insert_user and I display the
links accordingly. However if there is a problem with the submission i.e.
the user leaves a field blank then they are redirected to the add_user.php
page, the action is still insert_user but I would not want the same links to
appear on this page.
Any help on this matter would be greatly appreciated