Date Format

don_log · #1 (**permalink**) 06-09-10, 09:46

I want to insert in a value using php but some problem
in it's sql query

insert into school.std_info values('7','std','sd','2323','mj','234','sadf23',D ATE_FORMAT('17-11-1990','%d-%m-%Y'),'male','234234','234234','2010-06-09','22','10')

this is the mysql query giving me error when i direct put in mysql

PHP Code:


			


#1136 - Column count doesn't match value count at row 1



INSERT INTO school.std_info

VALUES (

'7', 'std', 'sd', '2323', 'mj', '234', 'sadf23', DATE_FORMAT( '17-11-1990', '%d-%m-%Y' ) , 'male', '234234', '234234', '2010-06-09', '22', '10'

)

PHP Code:


			
stnd_code int(11)   

  stnd_fcode int(11)                

  stnd_name varchar(50) 

  stnd_fname varchar(50)

  stnd_fnic varchar(25)

  stnd_mname varchar(50)

  stnd_mnic varchar(25) 

  stnd_add varchar(100) 

  stnd_dob date

  stnd_gender varchar(6)

  stnd_ph int(11)                

  stnd_mob int(11) 

 stnd_jdate date 

  stnd_fees int(5)  

  stnd_class varchar(10)

table structure

r937 · #2 (**permalink**) 06-09-10, 11:04

Quote:

Originally Posted by don_log

but some problem

do you see what the problem is? you have 15 columns in the table, but you are supplying only 14 values, therefore the error is "Column count doesn't match value count"

by the way, that DATE_FORMAT function call will ~not~ do what you expect -- use the STR_TO_DATE function instead

don_log · #3 (**permalink**) 06-09-10, 12:25

it insert this function date in null

NULL show in row

when i insert and browse the table

healdem · #4 (**permalink**) 06-09-10, 13:33

mysql expects dates in ISO format YYYY/MM/DD, or YYYY-MM-DD or some other year month day styling

r937 · #5 (**permalink**) 06-09-10, 14:32

which is what the STR_TO_DATE function accomplishes

saviola · #6 (**permalink**) 06-11-10, 14:05

The default way to store a date in MySQL is with the type DATE. Below is the proper format of a DATE.
- YYYY-MM-DD
- Date Range: 1000-01-01 to 9999-12-31

Quote:

INSERT INTO dateplayground (dp_name, dp_date) VALUES ('DATE: Manual Date', '2020-2-14')

Below is a quick script that will spit out the MySQL table dateplayground in HTML.

PHP Code:


			
<?php

$query = "SELECT * FROM dateplayground";

$result = mysql_query($query) or die(mysql_error());



echo "<table border='1'><tr>";

for($i = 0; $i < mysql_num_fields($result); $i++){

    echo "<th>".mysql_field_name($result, $i)."</th>";

}

echo "</tr>";

while($row = mysql_fetch_array($result)){

    echo "<tr>";

    for($i = 0; $i < mysql_num_fields($result); $i++){

        echo "<td>". $row[$i] ."</td>";

    }

    echo "</tr>";

}



echo "</table>";



?>

Internet Services

Web Development

Digital Marketing

Consumer Tech