Technology TidBits

Answers to various technical questions on php programming, mysql, linux, and many more categories.



I need a php function to put all rows from a mysql query into an array

Last updated: 09/04/2010

This function takes a database link ($link), SQL statement ($sql) and array ($all_rows), and returns the result from the query in the array ($all_rows) which is passed in by reference.

function select_sql_rows ($link,$sql,&$all_rows) {
$r = mysql_query($sql,$link);
if (!$r) {
$message  = 'Invalid query: ' . mysql_error() . "\n";
$message .= 'Whole query: ' . $sql;
print $message;
exit;
}
while ($results = mysql_fetch_array($r, MYSQL_ASSOC)) {
array_push($all_rows,$results);
}
$rows = mysql_num_rows($r);
//print "Got: $rows rows
\n"; mysql_free_result($r); return($rows); }

 


Other questions in this category:
What causes an Error 400 when running php on IIS?
Function to handle string substitution in php
What causes array problems with php from one host to another?
My php installation can't write to the Save Session Path - how do I fix it?
how can I output my php arrays in a readable html format using print_r?
How can I get mysql table definitions in my php script?
How can I execute commands on mysql using a php script?
How can I capture the contents of an included file?
How can I slash out a price to denote a sale price in html and php?
php session id keeps changing on every reload - how can I fix this?
How can I get php errors to show in the browser?
How can I keep leading zeros when building a CSV file?
When I try adding text to images in php, the color does not match what I want. How can I fix this?
How can I get bounced emails from my email CGI or PHP script?
How can I modify a script that relies on register globals being turned on?
Configuring htmleditor to do file uploads using php
How can I format my php print_r statements to be more readable in html?
How can I make a state drop down list for my forms?
Why doesn't ftp_connect work in my php script?
How can I force my php scripts to run php5 ?
Why isn't my ioncube installation not working?
How can I remove strange characters from a string in php?
How can I test a portion of my php code without everyone seeing it?
How can I turn off the + / - that shows up in my oscommerce product listing?
How can I authenticate a user in my vbulletin database from a php script?
My php scripts aren't registering $HTTP_GET_VARS variables anymore!
How do I get rid of "Fatal error: Allowed memory size of 8388608 bytes exhausted" in my php scripts?
Resizing images in php doesn't work
What's a php regex to grab text from an html document
How can I run a remote web script or page from php?
How can I load a mysql query into a hash in php?
How can I check if a php script is running on SSL?
How to match a mysql datetime field for a specific day
Why does my php script give this error - "Call to undefined function: hash()"



Powered by KnowledgebasePublisher 1.1
Superb Internet
Content provided by Roberts WebForge, Inc.