I did the while loop so that it would not be dependent on the array size but I see from your while loop that you were not concerned about that. So, for loop looks like this:
Last edited by Vi-Curious; 02-12-2010 at 06:30 AM..
Reason: Edited based on cfajohnson post
how can i make one script fail if some condition is not satisfied.i m writing if ..else logic in script.i need some standard command to do that ,, (1 Reply)
Hello,
while i was saving a web file directing on to usb location there was some network problem which result in error WRITE DELAYED on windows xp.
so pen drive is not getting completely formated(show as Windows was unable to complete format).From then onwords it is not allowing to copy... (0 Replies)
Hi
I've gotten a plugin script that won't run. I keeps throwing an error at the following line.
for BARCODE_LINE in `cat ${TSP_FILEPATH_BARCODE_TXT} | grep "^barcode"`
do
#something
done
The error reads
... (3 Replies)
All ,
I am trying to install POCO lib on Solaris server.
When I do make -s,I am getting the following error.
make: Fatal error in reader: Makefile, line 10: Unexpected end of line seen
Few of the content:
#
# Makefile
#
# The global Makefile for POCO
#
#sinclude config.make
... (0 Replies)
Dear all,
I would like to count the no;of word "INFORMATION" in a file called alt.lst and output to a unix variable INFORMATION.so to do this I wrote the below code
INFORMATION=echo 'INFORMATION' | tr -cs 'A-Za-z' '\n' < /app/tisq005/01/home/tisq005b/scripts/alt.lst | grep -c "INFORMATION"... (2 Replies)
Hi all,
I have below code
sqlplus -s ext/exo@TIS << EOF
whenever sqlerror exit failure rollback;
set echo off
set head off
set serveroutput on
set termout on
set trimspool on
SPOOL $SPOOL_FILE
select 'ROWS '|| ' '||decode((count(Part_no)),0,'With greater values not... (3 Replies)
Hi All
I have two shell scripts where the second is getting invoked from the first. E.g.
test1.sh and test2.sh Within test1, the code is something like this:
#!/bin/bash
. test2.sh
usage() {
echo "..."
echo "....."
}
SRC=$1
DEST=$2
case "$3" in
tran) doTran ;;
*)... (7 Replies)
Hello Gurus,
I am writing one script at linux.
The logic is
There is a find command which will find some specific files daily and store at a variable
Then echo that variable .
Now when I am trying to read the variable by using for loop it is throwing error as below:cat: CKDT.dat: No such... (5 Replies)
Hi,
I have downloaded gzipped source tarball of python3.7. I have tried to compile like below,
./configure --prefix=/directory
Compiling seems to be ok..But when running make all..Getting too many missing initializer warnings
/python3.6/Python-3.6.0/Modules/_cursesmodule.c: At top level:... (1 Reply)
Hi,
Prustat is throwing error only in zones. But it is working fine in global.
dtrace: invalid probe specifier
/*
** The following is a trimmed version of two seperate DTrace scripts:
**
** socketsnoop.d - snoop TCP network socket traffic by process.
** This is intended to identify the... (3 Replies)
Discussion started by: Sumanthsv
3 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)