Results 1 to 2 of 2

Thread: Reading Text File and Updating Database

Threaded View

  1. #1

    Thread Starter
    PowerPoster lintz's Avatar
    Join Date
    Mar 2003
    Location
    The 19th Hole
    Posts
    2,697

    Resolved Reading Text File and Updating Database

    I'm using the code below to read a txt file from my site then looping through it 1 line at a time and updating user details. The problem is if the txt file has more than 1 line the database is not updated. Can anyone help me out?

    PHP Code:
    include("db_connect.php");

    $array_tmp file('osprey.txt');

    foreach(
    $array_tmp as $v) {
    $Update_Details mysql_query("UPDATE tblUsers SET OSPREY = 'YES' WHERE username = '$v'");
    }

    echo 
    "All Complete" 
    Last edited by lintz; Oct 21st, 2004 at 09:10 PM.

Posting Permissions

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



Click Here to Expand Forum to Full Width