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

    Join Date
    Jun 2000
    Posts
    114
    Rep Power
    15
    I'm a total convert, but during my early explorations with PHP and mySQL, I'm beginning to wonder if certain concepts aren't applicable to mySQL. For example, in MsAccess there is a notion of a "current record" which you can "move" to by seeking a match in its primary key (this isn't done with conventional SQL). Then you can "move about" your recordset. So in the past, I've put previous page and next page buttons on webpages that roughly translated as "move up" or "move down" in the recordset. Is this sort of thing possible with PHP (or should I just ask, how is it possible with PHP/MySQL?)
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    14
    Rep Power
    0
    You can make an easy primary key field with a n sql statement such as the following:

    CREATE TABLE ToDoList (
    ItemNumber INT(4) UNSIGNED NOT NULL AUTO_INCREMENT,
    Description VARCHAR(200),
    DateWritten DATE,
    LastUpdate DATE,
    DateCompleted DATE);
    DESCRIBE ToDoList;

    A new ItemNumber will be added and properly incremented automatically every time you add a record with an sql statement such as:
    INSERT INTO ToDoList (Description, DateWritten, LastUpdate, DateCompleted) VALUES ('Make a ToDoList Application','2000-05-05','2000-05-05',NULL);
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    114
    Rep Power
    15
    Let me try to clarify my question. With access and VB, it's possible to select a record and navigate your recordset without SQL statements, is this also possible with PHP and mySQL?

Similar Threads

  1. php/mysql Developer needed for online game
    By Lord Melo in forum Project Help Wanted
    Replies: 1
    Last Post: October 29th, 2003, 09:15 PM
  2. Fast User Switching Does not work
    By sherrodclan in forum Windows Help
    Replies: 9
    Last Post: August 19th, 2003, 02:14 AM
  3. PHP/MySQL Application Design/Architecture Books
    By glambert in forum PHP Development
    Replies: 7
    Last Post: April 10th, 2003, 09:52 PM
  4. PHP/MySQL Issues... Please help.
    By misteraven in forum PHP Development
    Replies: 14
    Last Post: August 7th, 2002, 08:03 PM
  5. Need Qualified PHP/MySQL Programmer
    By ITGL72 in forum PHP Development
    Replies: 0
    Last Post: February 18th, 2002, 11:47 AM

IMN logo majestic logo threadwatch logo seochat tools logo