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 abcd

[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] -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: if($a

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 plea

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 i

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 1

Re: [PHP-DB] another redirecting question

2003-06-03 Thread Metin Kale
ation using the back 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 pa

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