Menu
Community /Pin to ProfileBookmark
@NogDogJul 18.2012 — #Nothing jumps out at me. I guess the next thing I'd try is sticking in some debug code to see if any pattern emerges that might help indicate where the problem is, e.g.:
@NogDogJul 18.2012 — #Huh...I didn't see this before, but don't you just need to do this instead of running the same query again inside the loop?
While loop gets same record multiple times
I’ve spent HOURS on this and I can’t figure it out. My while loop below returns the same record (Sub-Total? three times. Please see the image below for my table structure. Also, this is in an OsCommerce installation, so the “tep_…..” functions are an OsCommerce thing. I don’t believe they’re the problem though because I’ve tried a few other non-OsCommerce solutions here.
[code=php]
$ot_query = tep_db_query(“select * from ” . TABLE_ORDERS_TOTAL . ” where orders_id = ‘” . (int) $order_id . “‘”);
if (tep_db_num_rows($ot_query)) {
while ($ot = tep_db_fetch_array($ot_query)) {
$order_total_sql = tep_db_query(“select * from ” . TABLE_ORDERS_TOTAL . ” where orders_id = ‘” . (int) $order_id . “‘”);
$order_total_result = tep_db_fetch_array($order_total_sql);
$email_order .= strip_tags($order_total_result[‘title’]) . ‘ ‘ . strip_tags($order_total_result[‘text’]) . “n”;
}
}
See the attached image for the table structure. See how there are three different rows that have the same orders_id, but different orders_total_id’s and of course the other data is different as well.
Sign in
to post a comment4 Comments(s) ↴
0
@NogDogJul 18.2012 — #Nothing jumps out at me. I guess the next thing I'd try is sticking in some debug code to see if any pattern emerges that might help indicate where the problem is, e.g.:[code=php]
$ot_query = tep_db_query("select * from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int) $order_id . "'");
if (tep_db_num_rows($ot_query)) {
while ($ot = tep_db_fetch_array($ot_query)) {
// DEBUG //
echo "<pre>".print_r($ot, 1)."</pre>n"; // or user error_log() instead of echo
// END DEBUG //
$order_total_sql = tep_db_query("select * from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int) $order_id . "'");
$order_total_result = tep_db_fetch_array($order_total_sql);
$email_order .= strip_tags($order_total_result['title']) . ' ' . strip_tags($order_total_result['text']) . "n";
}
}[/code]0
@NogDogJul 18.2012 — #Huh...I didn't see this before, but don't you just need to do this instead of running the same query again inside the loop?[code=php]
$ot_query = tep_db_query("select * from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int) $order_id . "'");
if (tep_db_num_rows($ot_query)) {
while ($ot = tep_db_fetch_array($ot_query)) {
$email_order .= strip_tags($ot['title']) . ' ' . strip_tags($ot['text']) . "n";
}
} [/code]