thats only 3 column on another table.
otherwise if u try to get the values from prev. then you should create a good algorithm to check n compare dates and product's prices etc. then if there is any...

store those details on another table with cust id n product id n store that price there.

dump your tables and attach them here. i need to the structure.

set default datetime format as yours. then try it again.

i can do all these in one code but u gotta pay me :P

i ll see possible or not after checking ur tables... dump your tables n send me...
it ll take max 5minutes to write this script.
hope u...

this is my own solution: try it. works for me
select * from mytable where
mydate BETWEEN date_format(Now() - INTERVAL 1 DAY,'%e/%c/%Y - %H:%i:%s') AND date_format(Now(),'%e/%c/%Y - %H:%i:%s') ";
...

general mistake :

change $_post tags to $_request

you already posted the values... why you post them again on page itemENTRY.php

funny :)

i think no one knows sql very well...

just basics ??

i wanna put 1st row in action with 2nd row... then 2nd with 3rd and go on...
i did this three records i got correct result but when i add more records... everything is involved... i tried many...

get R-Studio Network or Pro edition somewhere

DIY DiskRecovery 3.1.

here....

# The maximum amount of concurrent sessions the MySQL server will
# allow. One of these connections will be reserved for a user with
# SUPER privileges to allow the administrator to...

i found a javacode on this site... hope it helps.

http://www.c-point.com/JavaScript/articles/file_access_with_JavaScript.htm