Query returns results in phpmyadmin but not in script

[showman13]

I guess I'm getting a bit frustrated with this thing. It should be simple, but I am finding a way to make it hard.

Here is the issue. I have a query that when plugged into phpmyadmin, it returns the expected results, but when I run it in a script, it says it returns 1 row, but there is nothing in it, or at least I can't figure out how to see it.

$sql="SELECT users.email, user_data.fname, user_data.mname, user_data.lname, user_data.phone, user_data.dsp_pref FROM users, user_data WHERE users.mem_id = user_data.mem_id && users.user = '$affiliate'";

$result=mysql_query($sql) or die(mysql_error()."<br><br>".$sql);

for ($i=0; $i<=5; $i++)
  {
  echo "The number is " . $i . " result is ".$result[$i]."<br />";
  }

produces these results:

The number is 0 result is
The number is 1 result is
The number is 2 result is
The number is 3 result is
The number is 4 result is
The number is 5 result is

But the same query (copied and pasted) into phpmyadmin gives me:

email fname mname lname phone dsp_pref
[e-mail] First Middle Last 701-555-1212 26

Am I doing something wrong in displaying the result set?

[dagon]

don't know where you got the idea to use a for loop, what you want is:

while ($row = mysql_fetch_assoc($result)) {
    echo $row["email"];
echo $row["fname"] ;
}

[showman13]

dagon,

Thank you for your response.

While your answer wasn't what I was looking for, it did key me to realize what it was I was doing wrong.

I missed putting in a line:

$row=mysql_fetch_row($result);

The whole thing looks like this, and works perfectly.

$sql="SELECT users.email, user_data.fname, user_data.mname, user_data.lname, user_data.phone, user_data.dsp_pref FROM users, user_data WHERE users.mem_id = user_data.mem_id && users.user = '$affiliate'";

$result=mysql_query($sql) or die(mysql_error()."<br><br>".$sql);

$row=mysql_fetch_row($result);

for ($i=0; $i<=5; $i++)
{
echo "The number is " . $i . " result is ".$row[$i]."<br />";
}

Produced these results:

The number is 0 result is [e-mail]
The number is 1 result is First
The number is 2 result is Middle
The number is 3 result is Last
The number is 4 result is 701-555-1212
The number is 5 result is 26

It always seems to be the simplest things that cost me the most time.

Thanks again,
Doug

[dagon]

with out the loop you will only get one row

[showman13]

dagon;10946442 wrote:

with out the loop you will only get one row

There is only one row with or without the loop

All the loop does is display the 6 fields within the row that was returned in the result.

I'm just happy to get past that point of frustration that I brought on myself for forgetting to add that last line of code.

[dagon]

if you only expect one result, add LIMIT 1 to the end of the query this stops the whole db being searched.

[showman13]

dagon;10946448 wrote:

if you only expect one result, add LIMIT 1 to the end of the query this stops the whole db being searched.

GOOD POINT... thank you.

I had forgotten about doing that.

I am just getting back into PHP after about 5 years away from it. It isn't all coming back as quickly as I would have liked, but it is coming. And with the help of this forum, I am able to get over the rough spots.

Thanks again for your help

Doug