|
|
Posted by The Natural Philosopher on 11/07/07 05:19
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?
Navigation:
[Reply to this message]
|