Timeline for Update virtuemart_product_prices based on weight
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 11, 2014 at 21:45 | comment | added | fresh1 | YES! All in all that did the trick, with the right WHERE and a nice structured query. Thanks again, i must have made all the way around old SQL and then again Joomla SQLi to come back to this. | |
| Jul 11, 2014 at 21:42 | vote | accept | fresh1 | ||
| Jul 1, 2014 at 11:59 | comment | added | fruppel | Your WHERE clause is still wrong. It should be something like ->where($db->quoteName('virtuemart_product_id') . ' = ' . $db->quote($newresults[2])); because $newresults[2] is the ID of your virtuemart product I guess | |
| Jul 1, 2014 at 11:36 | comment | added | fresh1 | Updated, the $weight = $newresults['product_weight']; was giving the "Notice: Unidentifyed product_weight on.." so i put in the ['3'] | |
| Jul 1, 2014 at 9:14 | comment | added | fruppel | Can you var_dump() your $results, ie print the result of var_dump($results);? | |
| Jul 1, 2014 at 8:49 | comment | added | fresh1 | Thank you, moving forward here i suppose, but still no cigar. With loadRowList() goes thru the first row ok and then stops, maybe with some counting or $i, dunno throwing punches in the dark here | |
| Jul 1, 2014 at 7:25 | history | edited | fruppel | CC BY-SA 3.0 |
added 531 characters in body
|
| Jul 1, 2014 at 7:18 | history | answered | fruppel | CC BY-SA 3.0 |