|
|
Posted by Jerry Stuckle on 11/07/07 01:27
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.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|