[RESOLVED] automating requests

[alexmace]

Hi, I'm looking for a way to read a list of ID's from a file and parse them into a request. Firstly, I need a function that will return a count of the lines in the file, and after that, how would I impliment the following example? I've tried fopen() / fread() and fopen() / fgets(), neither output anything. Please help, I'm going crazy here.

while (count > 0) {
$var = "line from file";
$query="SELECT * FROM table WHERE ID='$var';"
$result=mysql_query($query);

    "Do outputing stuff here"

   }

[bogu]

I didnt understant what u want to do...

But anyway, did u try this function file()? it returns u an array with elements each line of the file ...

[alexmace]

At the core of the problem, I'm trying to open a file and put the each line into a variable which is then put into a mysql query. It seems that php is not opening any file in my tests to that effect.

[bogu]

alexmace wrote:

I'm trying to open a file and put the each line into a variable which is then put into a mysql query

Then function file() is what u`r looking for ...

[alexmace]

Here's the working code:

$file = file("out.txt");

$count=count($file);
$index=0;

while ($index < $count) {
$med = rtrim($file[$index]);
$query="SELECT ('..','..','..') FROM nymed WHERE medallion='$med'";

    $result=mysql_query($query);
    if (!$result) {
            echo "Could not run query: " . mysql_errror();
            }

    $row=mysql_fetch_row($result);
    if (!$row) {
            echo "Could not retrieve result: " . mysql_errror();
            }