02-03-2009
Quote:
Originally Posted by
uativan
set -f
set -- $name
echo $3
I used the code and it work fine, thank you very much!!
The result from the sql now is a little bit different,
"name ------------ Peter (1 row)"
"name ------------ Mary Lee (1 row)"
The result is vary in word length.
set -f
set -- $name
echo $3
'Peter' is ok
'Mary' is not ok, I want to get 'Mary Chan'.
I want to get
'Peter'
'Mary Chan'
Any enhancement i could do?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have several lines like this ones:
123456789abcde /aa/bb/123456_$data.log
123456789abcde /aa/bb/123456_not_a_data_log
987654321ab /aa/bb/xpto123456_$data.log
...
How do I get into a variable the value "/aa/bb/123456_$data.log" , searching only for the beggining and ending... (3 Replies)
Discussion started by: Scarlos
3 Replies
2. Shell Programming and Scripting
This is probably pretty simple butI'm not sure how to best go about it.
If I have
FILE="myBigLongFileName_1.xls"
FILE_PREFIX=`echo $FILE| cut -d"." -f1`
# that gives "myBigLongFileName_1"
All i want to do now is chop the "_1" from the end of $FILE_PREFIX
Any ideas anyone? (3 Replies)
Discussion started by: djkane
3 Replies
3. Shell Programming and Scripting
i have a strings
abc-def.csv
ghi-jkl.csv
i want to make it as
abc-*-def.xyz
ghi-*-jkl.xyz
How to do it?. (5 Replies)
Discussion started by: senthilk615
5 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I have a value of a filepath in a variable
DATAFILE with value as "customtop/gpsore37/gepspo/1.0/bin/ashoka.csv
".
Now i want the value of last 4 charcters in to another variable.
That is EXTENSION = .csv
How can i do this in Shell scripting
Thanks in advance
Alla Kishore (8 Replies)
Discussion started by: alla.kishore
8 Replies
5. UNIX for Dummies Questions & Answers
I need to check the occurrence of one string within another.
code
********************
if ;then do something done
********************
Thanks (7 Replies)
Discussion started by: w020637
7 Replies
6. UNIX for Dummies Questions & Answers
Hi
I use the below cmd to get the list of files that are modified than <temp> file in the <path> diretory
cmd:find <path> -name '*.zip' -type f -newer <temp> -print
i am getting all the list of files that are new or modified, with abs path, i want to copy all of these files to a... (3 Replies)
Discussion started by: Naveen_5960
3 Replies
7. Shell Programming and Scripting
I have a string '<Hi>abc</Hi>"
How to print "abc" (6 Replies)
Discussion started by: sandy1028
6 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I hav a string lets say aa.txt:bb:txt
length of the string can vary.. I have to keep the token inside a array and the delimiter is : plz send me the code (2 Replies)
Discussion started by: Deekay.p
2 Replies
9. Shell Programming and Scripting
Hi All,
I have a ouput string likes 'u8wos' or 'u10acsd' or somthing else 'u{number}{any characters}'and I want to get the number behind the letter 'u' by bash shell.
Thanks
Damon (11 Replies)
Discussion started by: Damon_Qu
11 Replies
10. UNIX for Dummies Questions & Answers
Hi,
My requirement is to get the substring and then remove special character.
Ex
I have data like T_SYSTEM_XXXXX_YYYY_ZZZ
I want to get XXXXXYYYYZZZ
the part after T_SYSTEM is varying it might be XXX_YY or just XX
can you tell me which all commands i have to use.
i understand i... (5 Replies)
Discussion started by: Mohammed_Tabish
5 Replies
LEARN ABOUT PHP
mysql_fetch_assoc
MYSQL_FETCH_ASSOC(3) 1 MYSQL_FETCH_ASSOC(3)
mysql_fetch_assoc - Fetch a result row as an associative array
SYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should
be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
omysqli_fetch_assoc(3)
o PDOStatement::fetch
array mysql_fetch_assoc (resource $result)
DESCRIPTION
Returns an associative array that corresponds to the fetched row and moves the internal data pointer ahead. mysql_fetch_assoc(3) is equiv-
alent to calling mysql_fetch_array(3) with MYSQL_ASSOC for the optional second parameter. It only returns an associative array.
o $
result -The result resource that is being evaluated. This result comes from a call to mysql_query(3).
Returns an associative array of strings that corresponds to the fetched row, or FALSE if there are no more rows.
If two or more columns of the result have the same field names, the last column will take precedence. To access the other column(s) of the
same name, you either need to access the result with numeric indices by using mysql_fetch_row(3) or add alias names. See the example at the
mysql_fetch_array(3) description about aliases.
Example #1
An expanded mysql_fetch_assoc(3) example
<?php
$conn = mysql_connect("localhost", "mysql_user", "mysql_password");
if (!$conn) {
echo "Unable to connect to DB: " . mysql_error();
exit;
}
if (!mysql_select_db("mydbname")) {
echo "Unable to select mydbname: " . mysql_error();
exit;
}
$sql = "SELECT id as userid, fullname, userstatus
FROM sometable
WHERE userstatus = 1";
$result = mysql_query($sql);
if (!$result) {
echo "Could not successfully run query ($sql) from DB: " . mysql_error();
exit;
}
if (mysql_num_rows($result) == 0) {
echo "No rows found, nothing to print so am exiting";
exit;
}
// While a row of data exists, put that row in $row as an associative array
// Note: If you're expecting just one row, no need to use a loop
// Note: If you put extract($row); inside the following loop, you'll
// then create $userid, $fullname, and $userstatus
while ($row = mysql_fetch_assoc($result)) {
echo $row["userid"];
echo $row["fullname"];
echo $row["userstatus"];
}
mysql_free_result($result);
?>
Note
Performance
An important thing to note is that using mysql_fetch_assoc(3) is not significantly slower than using mysql_fetch_row(3), while it
provides a significant added value.
Note
Field names returned by this function are case-sensitive.
Note
This function sets NULL fields to the PHP NULL value.
mysql_fetch_row(3), mysql_fetch_array(3), mysql_data_seek(3), mysql_query(3), mysql_error(3).
PHP Documentation Group MYSQL_FETCH_ASSOC(3)