Posted by Jerry Stuckle on 11/07/07 12:53

The Natural Philosopher wrote:
> Jerry Stuckle wrote:
>> The Natural Philosopher wrote:
>>> 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?
>>>
>>
>> You're missing the fact he only showed maybe 2% of his code, and that
>> he's querying a MySQL database for rows that match the contents of the
>> flat file.
>>
> Now by what leap of faith did you arrive at that conclusion?
>

I read what he said.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]