SELECT'ing from an arry?

[Austin]

$lines = file("list.txt" );
$l_count = count($lines);

for($i = 0; $i < 3; $i++) {
$var = $lines[$i];
}

mysql_query("SE LECT 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

[Jerry Stuckle]

The Natural Philosopher wrote:

Jerry Stuckle wrote:

>The Natural Philosopher wrote:

>>Austin wrote:
On Nov 6, 7:15 pm, The Natural Philosopher <[e-mail] e:
Austin wrote:
>$lines = file("list.txt" );
>$l_count = count($lines);
>for($i = 0; $i < 3; $i++) {
> $var = $lines[$i];
>}
>mysql_quer y("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
>correctl y
>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.
js*******@attgl obal.net
=============== ===

[dave]

On Nov 6, 4:15 pm, The Natural Philosopher <[e-mail] e:

Austin wrote:

$lines = file("list.txt" );
$l_count = count($lines);

for($i = 0; $i < 3; $i++) {
$var = $lines[$i];
}

mysql_query("SE LECT 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'?

i'm confused why he expects $var to equal anything but the last
element in the array $list.

[Jerry Stuckle]

dave wrote:

On Nov 6, 4:15 pm, The Natural Philosopher <[e-mail] e:

>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'?

i'm confused why he expects $var to equal anything but the last
element in the array $list.

Just a misplaced right brace...

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