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

Austin wrote:
> On Nov 6, 7:15 pm, The Natural Philosopher <a...@b.c> wrote:
>> 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'?
>
> Well if you flatfile something then sure it does...
> Now ignore the irrelevant and input something useful.
>
I wansn't aware that Mysql dealt with flat files.

I cant see the point of using it with a flat file that has already been
opened another way..

I didnt think a mysql query worked without opening a connection to a
database.

Now, what am I missing here?

[Back to original message]