03-31-2009
When I've seen him do PHP queries against a MySQL DB, he doesn't just do a single query. He'll usually pull in multiple bits of information even though to me it doesn't seem relevant. But afterwards in his PHP script, the data returned from the queries is used in groups. Kind of hard to explain I guess. It's just that my thinking would be:
Execute a query and pull in one column of data
Process the data
Execute another query for another column
Process that data
etc...
Then take all the data stored in arrays and format it for display
Whereas his thinking seems to be
Execute a query to pull in all needed data from multiple tables
Process in one function and format for display
I guess maybe it just takes having a lot of familiarity with the language and you start to see the quicker way of doing things. His approaches also seem to be able to avoid the spaghetti logic I get myself into sometimes by nature of their compactness.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have been a student at Hendrix Institute for about a year now. My term is comming to an end by the end of december. I have learned varios computer programs for web development that include Flash 5 and Dreamweaver. Actionscripting, Javascript and Database development with Access was all... (4 Replies)
Discussion started by: andrew25008
4 Replies
2. UNIX for Dummies Questions & Answers
All,
Have an AMD-K6/2 PC, 20G.Hd along with RH7.2.
Wanting to know what I should do in terms of setup (workstation/server) and then what I can do with it?
I'd like to learn a DBMS and SQL - can I do this using RedHat?
Any suggestions with how I can use/ what I can do with this appreciated. (3 Replies)
Discussion started by: Cameron
3 Replies
3. UNIX for Dummies Questions & Answers
The current backup procedure we using a tar command in linux.
The files are stored in one partition in different folders. The docs stores in day wise folders like ex: /usr/data/xyz/20050129, /usr/data/xyz/20050130 .............etc
We using tar & gzip command to take backup everyday. The backup... (3 Replies)
Discussion started by: bache_gowda
3 Replies
4. UNIX for Advanced & Expert Users
We run WebSphere and by default it wants to install everything under /usr. While I can understand the default (everyone has a /usr) I would like to move this over to a dedicated volume group called apps and then setup my lv's and fs's here. Our WebSphere Admin doesn't like this because apparently... (1 Reply)
Discussion started by: scottsl
1 Replies
5. Solaris
Hi all,
I have worked on HP UNIX and now i have moved to SunSolaris which i never used to work.
I am more on programming side like shell and perl scripting.
So i want to know from you experts that i need to take care or changes which i code in sun solaris in compared to HP unix.
Suggestions... (1 Reply)
Discussion started by: ravi.sadani19
1 Replies
6. Shell Programming and Scripting
Hi,
I have written a script which calls a process which ends up in a reboot of the system. At the end of the reboot it prompts for login & i need to provide the login details. am not able to figure out hw to do this.
Doubt: will echoing login details after calling the process work?
for ex:... (1 Reply)
Discussion started by: meera
1 Replies
7. UNIX for Advanced & Expert Users
Hello there....i am a final year comp science student.......i am thinking of doing my project on unix platform......which one do u suggest?thanx in advance... (3 Replies)
Discussion started by: theprasad1990
3 Replies
8. Solaris
I've been busy and fell behind on Sun/Oracle. Forgive me if too basic. I welcome brief, cryptic, or advanced replies. I also welcome noobie information since I may have no clue what's up at the moment.
Problem statement:
I inherited a computer to set up. I would rather not figure out 8 months... (1 Reply)
Discussion started by: Nevyn
1 Replies
9. UNIX for Dummies Questions & Answers
Hi guys, i'm undergoing a traning in solaris administration and i request if any one have an idea on the interview questions on solaris.
thank you. (3 Replies)
Discussion started by: 038karthik
3 Replies
10. Shell Programming and Scripting
i=1
out=""
j=`expr 2 * $1`
while
do
out="$out"#""
echo $out
((i=i+1))
done
while
do
print ${out%?}
((i=i+1))
done
This script is throwing an error:
gurnish:/home/fnb/gurnish/saurabh/scripts> while1 3
expr: 0402-050 Syntax error.
# (6 Replies)
Discussion started by: targetshell
6 Replies
LEARN ABOUT PHP
mssql_result
MSSQL_RESULT(3) MSSQL_RESULT(3)
mssql_result - Get result data
SYNOPSIS
string mssql_result (resource $result, int $row, mixed $field)
DESCRIPTION
mssql_result(3) returns the contents of one cell from a MS SQL result set.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
o $row
- The row number.
o $field
- Can be the field's offset, the field's name or the field's table dot field's name (tablename.fieldname). If the column name has
been aliased ('select foo as bar from...'), it uses the alias instead of the column name.
Note
Specifying a numeric offset for the $field argument is much quicker than specifying a fieldname or tablename.fieldname argu-
ment.
RETURN VALUES
Returns the contents of the specified cell.
EXAMPLES
Example #1
mssql_result(3) example
<?php
// Send a select query to MSSQL
$query = mssql_query('SELECT [username] FROM [php].[dbo].[userlist]');
// Check if there were any records
if (!mssql_num_rows($query)) {
echo 'No records found';
} else {
for ($i = 0; $i < mssql_num_rows($query); ++$i) {
echo mssql_result($query, $i, 'username'), PHP_EOL;
}
}
// Free the query result
mssql_free_result($query);
?>
The above example will output something similar to:
Kalle
Felipe
Emil
Ross
Example #2
Faster alternative to above example
<?php
// Send a select query to MSSQL
$query = mssql_query('SELECT [username] FROM [php].[dbo].[userlist]');
// Check if there were any records
if (!mssql_num_rows($query)) {
echo 'No records found';
} else {
while ($row = mssql_fetch_array($query)) {
echo $row['username'], PHP_EOL;
}
}
// Free the query result
mssql_free_result($query);
?>
NOTES
Note
When working on large result sets, you should consider using one of the functions that fetch an entire row (specified below). As
these functions return the contents of multiple cells in one function call, they're MUCH quicker than mssql_result(3).
SEE ALSO
Recommended high-performance alternatives: mssql_fetch_row(3), mssql_fetch_array(3), mssql_fetch_assoc(3), mssql_fetch_object(3).
PHP Documentation Group MSSQL_RESULT(3)