Displaying 3 results from an estimated 3 matches for "mysql_result".
2003 Dec 31
1
AGI - IVR - Time Clock
...,emp
where auto.Strid=store.store_id and auto.Empid=emp.id
ORDER BY Date, Time";
$result = mysql_query($query);
$number = mysql_numrows($result);
print "There are $number records in the Database:<p>";
for ($i=0; $i<$number; $i++) {
$v_callid = mysql_result($result, $i, "CallerID");
$v_store = mysql_result($result, $i, "name");
$v_emp = mysql_result($result, $i, "employee");
$v_date = mysql_result($result, $i, "Date");
$v_time = mysql_result($result, $i, "Time");...
2006 Mar 14
3
ActiveRecord row-by-row processing
I want to use ActiveRecord outside of Rails to do processing on large
tables. I want to be able to process the rows as they are retrieved
rather than having to store the results in an intermediate array.
Any suggestions?
Looks like I could hack the adapter to provide an accessor to the
underlying DBI handle. Anything cleaner than that?
2010 Mar 05
2
Bug in driver-mysql.c + fix
...unix_socket,
- db->client_flags) == NULL;
+ db->client_flags | CLIENT_MULTI_RESULTS) == NULL;
alarm(0);
if (failed) {
if (conn->connect_failure_count > 0) {
@@ -429,6 +430,7 @@
struct mysql_db *db = (struct mysql_db *)_db;
struct mysql_connection *conn;
struct mysql_result *result;
+ int nr;
result = i_new(struct mysql_result, 1);
result->api = driver_mysql_result;
@@ -442,6 +444,17 @@
case 1:
/* query ok */
result->result = mysql_store_result(conn->mysql);
+ while((nr = mysql_next_result(conn->mysql)) >= 0) {
+ /* more results? -1 = n...