#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2001
    Posts
    37
    Rep Power
    13

    Easy new project - admin option )add on


    Hello I need some help with a project

    This will also give you a free script and bits of other scripts to help you in other projects. What I need done is pretty simple and in time I could manage to do it.

    All I need done is a admin area to change results in DATABASE

    I dont mean changing the user ID or anything like that. What I need done is to move a record and replace another record in its place.

    expamle

    Search word :Adventure

    Recodes shown in order from MySql

    So what I'd like to be able to do is change results of that record.


    If anyone has a better way of doing it please contact me , thanks



    team@swf-empire.com
    http://swf-empire.com
  2. #2
  3. /(bb|[^b]{2})/

    Join Date
    Nov 2001
    Location
    Somewhere in the great unknown
    Posts
    5,163
    Rep Power
    792
    What is the table structure like? This can be done fairly easily depending on the table structure.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2002
    Location
    Osaka
    Posts
    9
    Rep Power
    0
    Your idea sounds quite interesting !

    I have some doubts:
    a) After the user enters "Adventure", should the PHP script search
    across all tables in database, or only the user-specified table.

    b) Should the PHP script search all column in the table, or only
    user-specified column.

    I think the entered value should be validated against the column type in the database.

    I see only one likely problem related to foreign-keys.
    i.e if user enters an invalid value for a particular record,
    then the references will no longer be valid.

    You can contact me at ajaypatilpune@hotmail.com

    Ajay
    Last edited by ajaypatil; July 8th, 2002 at 04:53 AM.

IMN logo majestic logo threadwatch logo seochat tools logo