MSSQL_FETCH_ASSOC(3)MSSQL_FETCH_ASSOC(3)mssql_fetch_assoc - Returns an associative array of the current row in the resultSYNOPSIS
array mssql_fetch_assoc (resource $result_id)
DESCRIPTION
Returns an associative array that corresponds to the fetched row and moves the internal data pointer ahead. mssql_fetch_assoc(3) is equiv-
alent to calling mssql_fetch_array(3) with MSSQL_ASSOC for the optional second parameter.
PARAMETERS
o $result_id
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
RETURN VALUES
Returns an associative array that corresponds to the fetched row, or FALSE if there are no more rows.
EXAMPLES
Example #1
mssql_fetch_assoc(3) example
<?php
// Send a select query to MSSQL
$query = mssql_query('SELECT [username], [name] FROM [php].[dbo].[userlist]');
// Check if there were any records
if (!mssql_num_rows($query)) {
echo 'No records found';
}
else
{
// Print a nice list of users in the format of:
// * name (username)
echo '<ul>';
while ($row = mssql_fetch_assoc($query)) {
echo '<li>' . $row['name'] . ' (' . $row['username'] . ')</li>';
}
echo '</ul>';
}
// Free the query result
mssql_free_result($query);
?>
PHP Documentation Group MSSQL_FETCH_ASSOC(3)
Check Out this Related Man Page
MSSQL_FETCH_ARRAY(3)MSSQL_FETCH_ARRAY(3)mssql_fetch_array - Fetch a result row as an associative array, a numeric array, or bothSYNOPSIS
array mssql_fetch_array (resource $result, [int $result_type = MSSQL_BOTH])
DESCRIPTION mssql_fetch_array(3) is an extended version of mssql_fetch_row(3). In addition to storing the data in the numeric indices of the result
array, it also stores the data in associative indices, using the field names as keys.
An important thing to note is that using mssql_fetch_array(3) is NOT significantly slower than using mssql_fetch_row(3), while it provides
a significant added value.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
o $result_type
- The type of array that is to be fetched. It's a constant and can take the following values: MSSQL_ASSOC, MSSQL_NUM, and
MSSQL_BOTH.
RETURN VALUES
Returns an array that corresponds to the fetched row, or FALSE if there are no more rows.
EXAMPLES
Example #1
mssql_fetch_array(3) example
<?php
// Send a select query to MSSQL
$query = mssql_query('SELECT [username], [name] FROM [php].[dbo].[userlist]');
// Check if there were any records
if (!mssql_num_rows($query)) {
echo 'No records found';
} else {
// The following is equal to the code below:
//
// while ($row = mssql_fetch_row($query)) {
while ($row = mssql_fetch_array($query, MSSQL_NUM)) {
// ...
}
}
// Free the query result
mssql_free_result($query);
?>
NOTES
Note
Field names returned by this function are case-sensitive.
Note
This function sets NULL fields to the PHP NULL value.
SEE ALSO mssql_fetch_row(3).
PHP Documentation Group MSSQL_FETCH_ARRAY(3)
Hello Gurus,
I am new to this forum and I have a BASIC knowlege in UNIX commands. I have a data file which contains 1 billion records, how to find 5678th row and put this rows into a new file? Can anybody please give the command how to do this? (3 Replies)
Hi,
I have data in the following format:
data1
data2 data3 data4
data5 data6
data7 data8 data9
data10
I require the final output to be:
data1
data1
data1
data1
i only require the 1st line but I need to replicate it in n rows where n is the number of rows where data... (4 Replies)
Hi Friends,
can you help me with this
I would like to write records from a query into a flat file?
I am currently using this code
Is there any other method ???
sqlplus -s username/password <<- !
select * from emp_db;
quit
! > sample.txt
Thanks in advance.
Thanks
Sam :) (3 Replies)
hi
how do i manipulate .csv file to add an extra row after each row using shell script?
I need a blank line added for each 1000 records in my file?
I will then need to copy and paste some data in the blank row created.
thanks 4 ur support
neil (3 Replies)
Hi,
I have a shell script that returns 10 records for the column Name and age from a select query. Where when i store those data in retrieve_list.txt file i need to store the data in a particular format like:-
$Jason$30
$Bill$23
$Roshan$25
Here is my script:
1)... (15 Replies)
Hi
I need to do some thing like "find and insert before that " in a file which contains many records. This will be clear with the following example.
The original data record should be some thing like this
60119827 RTMS_LOCATION_CDR INSTANT_POSITION_QUERY 1236574686123083rtmssrv7 ... (8 Replies)
Most shells flavors do not have associative arrays a.k.a. maps.
How would you emulate an associative array?
I had this problem once and found a working solution, but I don't want to spoil the game hence I wont tell it.
Wonder if anyone comes up with something better. (5 Replies)
echo "what is your username?"
read username
echo $username
echo /home/$username
$backup="backup"
$restore="restore"
#
#
if
then
echo "No username provided"
else
echo "hi $username would you like to backup or restore?"
read userrequest
echo $userrequest
if
then
... (4 Replies)
I'm not very good at associative arrays; and working on this PHP code has got me a bit stumped. My goal is to populate a (multidimensional) associative array in a PHP while look after a MySQL query. The code fragment looks like this:
while($campaign_row = mysql_fetch_array($campaigninfo))
{
... (9 Replies)
Hello,
can somebody help me on this please.
I have a list of numbers and I want to print them in one line seprated by a comma except the last one using awk
34
12
56
76
88
output
34,12,56,76,88
Thanks Sara (15 Replies)
Hello
I have been trying to remove a row from a file which has the same first three columns as another row - I have tried lots of different combinations of suggestion on this forum but can't get it exactly right.
what I have is
900 - 1000 = 0
900 - 1000 = 2562
1000 - 1100 = 0
1000 - 1100... (7 Replies)
Hi
echo " username "
read username
echo "password"
stty -echo
read password
stty echo
through read i am taking standard input and redirecign them to a file
echo " username=${username}/${password} " > file.lst
now from the same shell script i want to delete the password (i.e... (4 Replies)