PHP - What Is Difference Between Php Date And Mysql Now() ??

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=310181.0

Hi everyone,

I have this php code, which connects to a mysql database (through dbconnect.php) and is meant to select the lowest difference between two variables. I can't get very far. The most valuable differences are not the lowest per se, as much as the closest to 0, either positive or negative. Both numbers are positive integers. The page dictates the relative 'ranking' of the page, by multiplying the rank by 20, so that with each successive page, the retrospective line is 20 higher in ranking. The section 20*$page+x is not a value, but a ranking, so the instance would by, in words 'select the lowest difference between two numbers. If the number closest to 0 cannot be selected, can we find the highest value out of the two variables and subtract the lower (they are interchangeable)
Code: [Select]
<?php
 $page = $_GET['page'];
 include("dbc.php") //connect to mysql database
 $result = mysql_query("SELECT * FROM posts {WHERE (ROW1-ROW2) = 20*$page +1}"); // { indicates my unsure section
while($row = mysql_fetch_array($result)){
 $id = $row['id'];
 $username = $row['id'];
 $sum1 = $row['id'];
 $sum2 = $row['id'];
}
 $result1 = mysql_query("SELECT * FROM posts {WHERE (ROW1-ROW2) = 20*$page +2}"); // { indicates my unsure section
while($row1 = mysql_fetch_array($result1)){
 $id2 = $row['id'];
 $username2 = $row['id'];
 $2sum1 = $row['id'];
 $2sum2 = $row['id'];
}
//this continues with the mysql $page+x increasing successively 
?>
Also, could we apply a formula that would increase the weighting of those with a higher sum.

Thanks a lot, this is really over my head

Jack

Hi there,

I have a string '12/04/1990', that's in the format dd/mm/yyyy.

I'm attempting to convert that string to a Date, and then insert that date into a MySQL DATE field.

The problem is, every time I try to do so, I keep getting values like this in the database: 1970-01-01.


Any ideas?


Much appreciated.

Does anybody know how to take the queried standard date format - 2012-04-02 for example - and print it to the page as April 2, 2012? Or at the very least, to switch to 04-02-2012? Trying to find some tutorials online.

I want to have a feature on a website I'm building where the user can select rows from a MySQL table based on it's age.  For example they could select a piece of content between 30-60 days old.  I'm going to do this using the following sequel

"WHERE article_date BETWEEN 2010-12-01 AND 2010-11-01"

However I'm not sure how to make this work.  If the date is 2010-12-12 what is the easiest way to subtract 30 days from this date?  Thanks for any help. 

hello with tis button i generate some statistics from mysql


if(isset($_POST['sub1']))

                                {
           
                                    $result = mysql_query("SELECT servitoros1, COUNT(*) from history WHERE serv LIKE '%be%'  group by serv1");
                                   
                                    while($row = mysql_fetch_row($result))
                                                                           {
                                                                               


                                          echo "<tr>";
                                                                                 foreach($row as $cell)
                                                                           
                                                                            echo "<td ALIGN=\"center\">$cell<FONT></td>";   
                                                    
                                                                                    echo "</tr>\n";
                                                                               
                                                                           }
                                   
                                   
                                    mysql_free_result($result);
                 
                            }


               
                      but each record have datetime field!!


so how can i set this display betwean 2 selectable datetimes

e.g.

from 2/2/2011 15:45   to  3/2/2011 23:59

guys, im having a problem here thats making me crazy

im making a system and i want to insert the current date in the mysql. I have the field called 'data' in the DB, but when i make the code to insert all the other fields, including the 'data', its work perfectly... unless that damn date!

$query = "INSERT INTO news (id, titulo, mensagem, data) VALUES (NULL, '$titulo', '$mensagem', 'date(\"d/m/Y\")')";

whats wrong with that?
its stores in DB as '0000-00-00'.
 

i need a javascript date picker that will put a date in a text flied in the format of Y-m-d so that it can be posted to mysql also i need some kind of php to validite this

Hello,
this is my first time on this forum and also a modest newb on php, but i heard alot of people i know visit this site to get help on php. So i have a question, i know how to submit a form to mysql, the question is how do i recieve each indivual data i submit with the form by date and display it in order by date. i would like to submit kind of a status up everyday similar to twitter but order it by date and have it look kinda like:

July 5, 2006

This is a status example text that i will sumbit via form, links can be clicked and etc.
This is a status example text that i will sumbit via form, links can be clicked and etc.
This is a status example text that i will sumbit via form, links can be clicked and etc.

July 4, 2006

This is a status example text that i will sumbit via form, links can be clicked and etc.
This is a status example text that i will sumbit via form, links can be clicked and etc.

hey guys the date stored in mysql is yyyy-mm-dd i need to convert it to do a string compare i have used the following

$query = "SELECT * FROM booking where id=$sel"; 
            $result = mysql_query($query);
           while ($row = mysql_fetch_array($result))
           { $num1=$row['no_rooms'];
               $from1=$row['from'];
               $to=$row['to'];
               $sel1=$row['room_type'];
               $date = date('d-m-y', strtotime($from1)); 
             
              }
                 echo "$date";


it prints 01-01-70 can any1 tell me where is the error?

thanks

im trying to crete a page that will search mysql for entrys from ??? days previous.

ive not started on the php yet as i wanted to get the query done but im having a slight problem.

date is in dd/mm/yyyy format. if i run this query
SELECT * FROM `dsgi_serval` WHERE date >= '10/09/2010' 

it ONLY sorts by DD and not MM or YYYY, so anything greater than the 10th of the month shows regardless of what month.

when i get to the php ill either do a drop down box with a preset number or days or a text box where u enter the number of days or even a txt box u enter the actual day u want to search from. im undecided which would be best.

another problem i face with the php is how to tell the script to search from ? ?? when it says search from the past 3 days?


<?php

$date = date("d/m/y");    // todays date 04/12/2010
$_post= 3 days;           // search from 01/12/2010
$date - $_post = $search; // 01/12/2010;
$sql="SELECT * FROM $tbl_name" where date >= '$search';

echo the results


?>



i no the above is not proper php but i hope it saya what im trying to do.

Thanks

Hi all

I have an SQL database that holds dates in this format: yymmdd example: 110824

I am echoing the value:

Code: [Select]
<?php echo $showdata['date']; ?>

How do I reverse the string so it shows 240811 ?

Cheers
Pete

I'm having trouble inserting a formatted PHP DateTime into a MySQL table.

I'm getting:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',2012-01-31)' at line 4

I get the error when I try to insert the date as a string from a DateTime object via:
$insertDate = $date->format('Y-m-d');

As well as when I try to recast it as a date object:
$insertDate = date("Y-m-d",strtotime($date->format('Y-m-d')));

I've also tried putting the date in ' ' 's and escaped " " 's.


My insert query is:
$insert = "INSERT INTO pendingordersdetails (PartNumber,Oqty,Pqty,Aqty,PartStatus,
PartPrice,idOrderNo,PrtTariffCode,PrtLocation,LineNum,PKqty,SPqty,AllocationDate)
VALUES ('$partNum',$oQty,0,$aQty,'Excess',$price,$orderNum,'$tariffCode',
'$location',$lineNum,$PKqty,$SPqty,'$allocDate');";

and the echoed output is:
INSERT INTO pendingordersdetails (PartNumber,Oqty,Pqty,Aqty,PartStatus, PartPrice,idOrderNo,PrtTariffCode,PrtLocation,LineNum,PKqty,SPqty,AllocationDate) VALUES ('0446535240 ',3,0,1,'Excess',163.89,66,' ', 'A0406E01',2,,,'2012-01-31');

Anyone have any ideas?

Hello dear members, first of all sorry for my grammer i'm from Switzerland  . So now: I have a problem with php. I want to put out the date of a blogpost in this format dd:mm:yyyy instead of yyyy:mm:dd. I tried it a long time and used many different ways like: date, dateformat, strto etc. but at the and nothing worked for me. So here is a picture of the blogpost and i'll add the file with my compressd php code.   I'd be glad if you could help me Regards Mr_Ironic

Hello,

I would like to order by date that contains day and month, like this: 14-3
Is this possible?

Quote

$sql = mysql_query("SELECT * FROM date WHERE online='1'");