Re: [PHP-DB] Concat 3 fields in a query

2004-12-03 Thread metin kale
wouldn't it be $_POST['PO_Year'].-.$_POST['PO_Month'].-.$_POST['PO_Day'] ? metin [EMAIL PROTECTED] wrote: Hello I have a application that has an insert query (using a mysql database) and I am having an issue with trying to combine three fields with a dash . Here is my code can anyone please

Re: [PHP-DB] -14 Days Ago

2004-10-08 Thread metin kale
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html That web page has tons of details. metin Cole S. Ashcraft wrote: I am trying to see whether a data in an array pulled from a MySQL DB (YEARMONTHDATE) is older than 14 days ago. I am trying to do this in PHP. My code looks like:

[PHP-DB] Selecting date/time from an Access database

2003-11-25 Thread Metin Kale
Hello all.. I've been tasked to retrieve info from an Access database and I've been successful in selecting data and displaying it. But I do have a problem with DATE/TIME data. When I run a query asking for TIME data, I get the value -1 returned. ? $conn = new COM(ADODB.Connection) or

Re: [PHP-DB] order by an average in another table (basically a top 10 list)

2003-06-18 Thread Metin Kale
Just a shot in the dark.. it may be wrong, but try it out.. SELECT avg(rating) AS avgrating FROM ratings WHERE parent_id = '$id' ORDER BY avgrating DESC LIMIT 10 try that out.. should work. metin At 04:06 PM 6/18/2003 -0400, chris wrote: I've done a google search, but most of the results are

Re: [PHP-DB] another redirecting question

2003-06-03 Thread Metin Kale
button? I solved this problem a different way by setting and clearing session variables on entry and exit to a series of pages. Grant On Fri, 2003-05-30 at 10:25, Metin Kale wrote: Well, if you're inserting some data into a database and the person refreshes the page, it would re-insert the data again

RE: [PHP-DB] another redirecting question

2003-05-31 Thread Metin Kale
Rick, The way I solved this problem is to have the output sent to a variable, let's say $temp_data, create a session and store $temp_data as a session variable, redirect to another page where I can read $temp_data and have it displayed on that page by calling it. Hopefully my explanation is

Re: [PHP-DB] another redirecting question

2003-05-31 Thread Metin Kale
Well, if you're inserting some data into a database and the person refreshes the page, it would re-insert the data again into the database. Including the page like you did at the end wouldn't change that fundamental problem, hence why you'd want to have it redirect to another page. Metin At

Re: [PHP-DB] A Doubt

2002-08-30 Thread Metin Kale
Could you enable a session variable to keep track of it? If you have an if statement in mnop.php that calls the abcd.php page, then have that if statement also start a session and register a variable. This way, if the variable you set is equal to a certain value, then you know that