Need help splitting a field for query

Anon

I'm a little frustrated and I'm hoping someone can give me a hand.

I have a form element in which a user puts in names, seperated by hitting < return > on the keyboard.

These names are then split into an array so that I can query my database against them.

The problem I am having is that if there is more than one name in the list the only one that splits and works correctly for the query is the last name. The other names are all getting an extra space after the word.

I have tried using eregi_replace() to get rid of the space but that does not work either.

The odd thing is that I am using very similar split code elsewhere without problems.

When I look at the error it generates, it says it can not "jump to row 0" for the "mysql_result", however, I also tried pulling it out using "mysql_fetch_row" with no luck.

Here is the code I am using:

(the textarea field name is: related_members)

$pat = "\n"; //to separate at return
$member_array = split($pat, $related_members);
$total_related_members = count($member_array);
$count = 0;
while($count < $total_related_members)
{
$query = "select company from members where ";
$query .= "username=\"$member_array[$count]\"";

$result = @($query, $link);

$company = @mysql_result($result, 0, company);

print("$company" . ": ");
print("<a href=\"http://myserver.com/$member_array[$count]\">");
print("myserver.com/$member_array[$count]</a>");
print("<BR>");

$count++;
}

Any suggestions anyone has will be GREATLY appreciated!

Thanks.

Anon

I forgot to mention...the names that are being put in are only one word names. Usernames basically.

Thanks.

Jason wrote:

I'm a little frustrated and I'm hoping someone can give me a hand.

I have a form element in which a user puts in names, seperated by hitting < return > on the keyboard.

These names are then split into an array so that I can query my database against them.

I have tried using eregi_replace() to get rid of the space but that does not work either.

The odd thing is that I am using very similar split code elsewhere without problems.

When I look at the error it generates, it says it can not "jump to row 0" for the "mysql_result", however, I also tried pulling it out using "mysql_fetch_row" with no luck.

Here is the code I am using:

(the textarea field name is: related_members)

$pat = "\n"; //to separate at return

$member_array = split($pat,....

Anon

Try This! I'm not sure if this will work, however, it is better form. I almost always recommend FOR loops over WHILE loops when dealing with form submitted(user inputed) arrays. It'll give you a lot more control, sorting ability, etc. Also, if you want this thing to be bullet proof, I'd use a nice regular expression to clean up the data. It's important to do this when considering data integrity, security, etc. Good Luck!

$pat = "\n"; //to separate at return
$member_array = split($pat, $related_members);

 for($i = 0; $i < count($member_array); $i++) 
 { 

  $query = "select company from members where  username = '$member_array[$i]'";

$result = @($query, $link);

$company = @mysql_result($result, 0, company);

echo "$company: ";
echo "<a href=\"http://myserver.com/$member_array[$i]\">";
echo "myserver.com/$member_array[$i]</a>\n";
echo "<BR>\n";

}

Anon

Thanks. I tried it, but it does the same thing. I'm still getting an extra space at the end of all of the array elements, except for the last one.

I have tried using regular expressions to remove the space but it doesn't seem to work.

Mark wrote:

$pat = "\n"; //to separate at return
$member_array = split($pat, $related_members);

 for($i = 0; $i < count($member_array); $i++) 
 { 

  $query = "select company from members where  username = '$member_array[$i]'";

$result = @($query, $link);

$company = @mysql_result($result, 0, company);

echo "$company: ";
echo "<a href=\"http://myserver.com/$member_array[$i]\">";
echo "myserver.com/$member_array[$i]</a>\n";
echo "\n";

}

Anon

Why not just use chop() to remove the extra space? Or, if it's always there - one character at the end - you can get rid of it with a substr().

-Keegan

Anon

chop() was the answer. Thanks. Not sure why I didn't think of that myself. I think I stared at that page for a little too long!

Thanks all!

-- Jason

Keegan Miller wrote:

Why not just use chop() to remove the extra space? Or, if it's always there - one character at the end - you can get rid of it with a substr().

-Keegan