Posted by The Natural Philosopher on 11/07/07 00:15

Austin wrote:
> $lines = file("list.txt");
> $l_count = count($lines);
>
> for($i = 0; $i < 3; $i++) {
> $var = $lines[$i];
> }
>
> mysql_query("SELECT name FROM list WHERE name='$var'");
>
>
>
> In the list.txt it would have data like:
> Code:
>
> One
> Two
> Three
>
>
>
> And "echo $list[0];" would come up as "one".
>
> I need to SELECT the name "one" and return the column data.
>
> It doesn't select anything, even though it does get the data correctly
> when echo'd. What's wrong?
>
> OR am I going the wrong way w/ this? :x
>
I am completely baffled. What makes you think that Mysql has anything to
do with a file called 'list.txt'?

[Back to original message]