#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Posts
    12
    Rep Power
    0
    I have a this table,it is a train time table.
    It format is the following:

    id train_number train_name station_name start_time stop_time
    1 T83 dalian--beijing dalian 13:40 --
    2 T83 dalian--beijing jinzhong 14:10 14:00
    3 ... ... .. ....
    .. ...
    10 T84 beijing--dalian jinzhong 8:20 8:10
    11 T84 beijing--dalian dalian -- 9:00

    This tables have 80,000 recorders,the same train line have out and home train_number.

    I need query any two stations time,i declare $name1,$name2 .

    How to use PHP to query these quickly?

    Thanks!

  2. #2
  3. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,643
    Rep Power
    4492
    It's a little hard to understand exactly what you want...can you explain a little more?

    Do you want to search for a certain time or a specific train station?

    ---JH

Similar Threads

  1. Display and Refresh of PHP in URL query
    By wuji in forum PHP Development
    Replies: 3
    Last Post: January 30th, 2004, 12:20 PM
  2. Flash, PHP query problem
    By camcim in forum PHP Development
    Replies: 0
    Last Post: January 25th, 2004, 10:52 PM
  3. Can I query a network user with PHP?
    By BirdBlack in forum PHP Development
    Replies: 1
    Last Post: January 23rd, 2004, 11:42 PM
  4. PHP + MySQL query to make a link
    By emp/ir:kal in forum PHP Development
    Replies: 6
    Last Post: January 22nd, 2004, 12:10 PM
  5. PHP -> MySQL Query problem
    By Thr3ddy in forum MySQL Help
    Replies: 5
    Last Post: January 19th, 2004, 11:24 PM

IMN logo majestic logo threadwatch logo seochat tools logo