I'm having some trouble with this issue...I'm using perl DBI and mysql
for a customer addressbook. I know MySQL won't needlessly update a row
if nothing's changed, but since I'm using $rc = $sth-rows; as an
indicator of success, customers will get stuck if they decide they don't
want to change
I'm trying to write a query that will tell me how many abandoned carts
there are in a cart table I have.
each item in a cart is a record, so simply querying on records won't
work. What I need to count is how many distinct customerId's there
are. a sample from the table looks like:
cartItemId
I have a new client that wants to use filemaker on his mac to enter data
for site information. I'm sure that I can take that and export the
files and import into the site's MySQL database...but I'm wondering if
it is possible to link his filemaker database to the MySQL database
using ODBC? I
Quick newbie question...I am storing dates in my mysql table records,
how can i select the record with the most recent date?
bonus question (more of a scripting question)...
I need to use perl or php to list the dates out in ranges. in the table
they look like:
2002-02-17
2002-02-24
I'm trying to figure out a query that will tell me the total number of
people in our house email file that physically opted out in the last
week. I'm a bit of a mysql newbie as you can tell...
This is the general concept, though it doesn't seem to work:
select count(id) from contact # my
I'm setting up some tracking stats for (opt-in) e-mail campaigns, and
one of the things I'm tracking is click-thrus. I'm going to re-direct
traffic thru a script that will just count the number of clicks, and
store that number in a mysql table.
It needs to be fast and efficient, and I'm
