Weird INCLUDE / mySQL problem
| From: | Dan Tappin | Date: | Sat, 16 Mar 2002 19:08:42 +0000 |
| Subject: | Weird INCLUDE / mySQL problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-88768@lists.php.net to get a copy of this message | ||
I have a simple INCLUDE file that creates a default dynamic tab style table
of contact for the top of each of my pages.
I wanted a solution where I could control the content by simply changing an
integer in mySQL indicating weather a tab was visible or not. It works but I
now have a strange problem.
Each entry in the DB has unique id but I recently added a 'order' value. For
example: Home = 10, Buy = 20, Sell = 30, Contact = 40. Well I added Manage =
35 so that I could sort my results and control the order with our re-writing
code.
The problem is that when I use the include the sort order gets lost. In all
cases I have the ORDER BY toc_order which are my 10,20,30,35 values in each
row.
Can anyone shed some light on this issue?
Here is a link for an example:
http://test.oilfiielddepot.com/test
Please CC me as I am on digest mode.
Thanks,
Dan Tappin (dan@wavefront.ca)