SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Zealot Kyle_C's Avatar
    Join Date
    Apr 2001
    Location
    South Florida
    Posts
    165
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    script to store and retrieve data in mysql

    Anyone know of a program that I can use to store and retrieve data in mysql . I have a bunch of data forms on my sites and wish to gather and retrieve data some other way then having it emailed to my outlook..
    Last edited by Kyle_C; Jun 22, 2002 at 20:52.


  2. #2
    SitePoint Member
    Join Date
    Jun 2002
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you want to use MySQL use INSERT and SELECT
    PHP Code:
    mysql_query("INSERT INTO table (text) VALUES ('Some text.')");
    $s mysql_query("SELECT * FROM table");
    while (
    $r mysql_fetch_object($s)) {
        echo 
    $r->text;

    Which will insert something into the database and then read it.

  3. #3
    SitePoint Zealot Kyle_C's Avatar
    Join Date
    Apr 2001
    Location
    South Florida
    Posts
    165
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm not sure I understand.. Fist let me explain that I'm not a web tech and know very little about it. But what I do know, is what I need. So let me try to explain a little better here... I have 6 and soon 8 forms that gather a visitors data some are for free trials some request fearther info on a service and so on.. so all have deferent data fields. I what something to be able to store this data in one place (mysql would be ideal) where I can also retrieve it at a latter date based on a certen data field... I tried my best to describe Can anyone lend a hand

    Thanks


  4. #4
    SitePoint Zealot Kyle_C's Avatar
    Join Date
    Apr 2001
    Location
    South Florida
    Posts
    165
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It also needs to have a user friendly interface something like how you would use MS access to store and gather data from forms..

    Thanks



Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •