Hello guys,
I have in PERL an associative 2-dimensional array, called matrix. The array (actually the matrix) is made up like this
matrix = x;
matrix = y;
matrix = w;
matrix = z;
...
but the names a, b, c, d are set just at runtime.
The question is: how can i get all the keys of... (2 Replies)
Hi Guys,
I have an array which has numbers including blanks as follows:
1
26
66
4.77
-0.58
88
99
11
12
333
I want to print a group of three elements as a different column in a file as follows:(including blanks where there is missing elements) for.e.g. array element #7... (4 Replies)
I'm trying to create a Matrix using bash. The expected output is
.AB CDE FG
1
2
3
4
5
6
7
I'm a newbie in shell language, really appreciate if there is anyone who can guide me with this.
Double post again, continued here (0 Replies)
I have a file like this:
ASSPASVFETQY,hTRBV12-4,hTRBJ2-5,2
ASSPASTGGDYGYT,hTRBV18,hTRBJ1-2,2
ASSPASGDGYT,hTRBV5-1,hTRBJ1-2,2
ASSPASFPEDTQY,hTRBV27,hTRBJ2-3,2
ASSPARVNYGYT,hTRBV5-1,hTRBJ1-2,2
ASSPARTSGGLNEQF,hTRBV6-4,hTRBJ2-1,2
ASSPARQSYNEQF,hTRBV11-1,hTRBJ2-1,2... (3 Replies)
Hi all,
I been looking for a solution to the fact that when I use:
for (i=1; i<=NF; i++) print $ifields that are originally in a single line are printed in a single line
I have severals files for which the first 7 are the same, but the number of variables after that can vary, for example NF... (5 Replies)
First of I would just like to state that I am not looking for you guys to just do my work for me, I do want to learn and actually understand everything that is happening.
Hey all, I am having trouble on this. What I need to do is... Write an executable C file that will take a text file (not a... (8 Replies)
#!/bin/bash
PH=(AD QD QC 5H 6C 8C 7D JH 3H 3S)
echo ${PH}
In the above array, how can I print to screen just the first 8 elements of ${PH} and have the last 2 elements print just below the first line starting underneath AD?
I need to do this in order to save terminal window spacing... (5 Replies)
I use the following script to print the sum and how could I extend this to print medians instead? thanks
name s1 s2 s3 s4
g1 2 8 6 5
g1 5 7 9 9
g1 6 7 8 9
g2 8 8 8 8
g2 7 7 7 7
g2 10 10 10 10
g3 3 12 1 24
g3 5 5 24 48
g3 12 3 12 12
g3 2 3 3 3
output
name s1 s2 s3 s4
g1 5 7 8 9... (5 Replies)
Discussion started by: quincyjones
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 arraySYNOPSIS
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)