Ecommerce cart

2006-09-06 Thread wizard007

Hi,

I am starting a site that enables people to purchase information using
credits bought on the site.
e.g. you buy 10 credits for £10 and they sit in your online account on the
site for you to spend whenever you like.

Does anyone know of a script or software already in existance that we can
buy to do this?

Thanks for any help you can give.
-- 
View this message in context: 
http://www.nabble.com/Ecommerce-cart-tf2226398.html#a6169649
Sent from the MySQL - General forum at Nabble.com.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Problem with updating table

2006-08-11 Thread wizard007

I have a site with horse racing results and the results table consists of:
Date, Time, Course, Horse, Odds, Result, Profit

I have about 6 months results in there and obviously there are no unique
fields.
Each morning I imprt a new spreadsheet with the days racing selections
without the odds and result field filled in. As the day goes on I use a page
to update the results but when I update a race with horse that has run in
the past it updates the new record and the old record as well. I now have 2
identical records as the data updates has overwritten the old record for the
horses race before.

Any ideas!?!?!?!?
-- 
View this message in context: 
http://www.nabble.com/Problem-with-updating-table-tf2089249.html#a5758339
Sent from the MySQL - General forum at Nabble.com.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Date Problems

2006-07-13 Thread wizard007

Hi,

Just tried the date format script posted but it returns the following error:
Parse error: parse error, unexpected '%' in
/homepages/7/d123417448/htdocs/PayGo/results_14days.php on line 33

I used $query_Recordset1 = "SELECT date_format(Date, "%d/%m/%Y") as Date,
Course, Time, Horse, Odds1, Odds2, `Result` FROM Results";
-- 
View this message in context: 
http://www.nabble.com/Date-Problems-tf1937078.html#a5310495
Sent from the MySQL - General forum at Nabble.com.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Date Problems

2006-07-13 Thread wizard007

I have just started with MYSQL and am building a racing site using PHP.

I have Date, Course, Time, Horse, Odds, Result as my fields and the database
is poulated with the data. 

I'm having problems with the formatting of data when it is output.

Problem 1.
I want to display the date in the format dd/mm/. I know you can use the
DATE_FORMAT command but I can't seem to get it to work. Can anyone give me
the exact script I need to write.

Problem 2.
I also want to display the results in the last 7 days in descending order by
date.
I can't seem to work out a way of doing that either.

I'm a newb so please be gentle! :-)


-- 
View this message in context: 
http://www.nabble.com/Date-Problems-tf1937078.html#a5307385
Sent from the MySQL - General forum at Nabble.com.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]