2 quick questions

Strikerz95 · #1 (**permalink**) 07-01-04, 14:33

The first one is:

When I use a SELECT statement in MySQL to return rows in a table, I get a grandtotal count at the bottom when the console returns the specified rows. I am selecting rows INTO OUTFILE and I do not want the grandtotal part included in the txt file. Is there anyway to get rid of it?

The second one has to do with PERL, so hopefully one of you PERL gurus will know the answer:

I am concatenating text in the code as follows:

Code:

@user_name[$i] = @user_name[$i].1;

I simply want to attach a 1 to the end of the user_name, but when I do it leaves a space between the user_name and the 1, so it looks like this:

bperry 1 instead of bperry1

Is there a way to get rid of that space?

Brian

Pat Phelan · #2 (**permalink**) 07-01-04, 15:04

Suppressing the "decoration" rows depends on what is producing them. The simple answer in this case is just to have perl ignore them.

The space is because 1 is a number. Now "1" is a string. That should work better!

-PatP

Strikerz95 · #3 (**permalink**) 07-01-04, 16:02

Thanks for the help, I'll get PERL to ignore those lines. However, changing 1 to "1" didn't fix the problem. Any other ideas? Here is a bit more of the code I am using:

Code:

####this assigns a 1 to the end of particular users that meet the requirement with in the loop that this line is contained####
@user_name[$i] = @user_name[$i]."1";

####this line sorts the array####
@user_name2 = sort{$a cmp $b}@user_name;

####this part outputs to HTML####
for ($i=0;$i<$count;$i++)
{
	print "@user_name2[$i]";
	print "<br>";
}

Now the source code for HTML output looks like this where users have a 1 at the end of their user_name:

Code:

<br>SLucero
<br>SManzo
<br>SMartinez
<br>SMartinez
1<br>SMaxwell
<br>SMiers
<br>SMooney
<br>SParzyk

Pat Phelan · #4 (**permalink**) 07-01-04, 16:10

Just for the jolly factor, between the first a second lines that you posted try using:

Code:

chop(@user_name[$i]);

-PatP

Strikerz95 · #5 (**permalink**) 07-01-04, 16:21

Great! That worked, thanks alot,

Brian

Strikerz95 · #6 (**permalink**) 07-01-04, 19:11

I also have another question. How do you return the first character of an array?

Pat Phelan · #7 (**permalink**) 07-01-04, 22:57

There are more ways to get the first character than I can easily count, and each has its own advantages and disadvantages. The "brute force" and "one size fits all" solution is:

Code:

$firstchar = SubString(@array[0], 1, 1);

Depending on just what you envision doing, there are probably both more elegant and more efficient ways of doing that.

-PatP

Strikerz95 · #8 (**permalink**) 07-02-04, 13:22

thanks again

Internet Services

Web Development

Digital Marketing

Consumer Tech