Updating a table in mysql jestem bogiem film o paktofonice online dating
Thank youhi guys, if im going to create a table with derived column(meaning it's value is automatically created based from the value of another column from the table).
for example i have a base column named birth_date and the derive column is age (where age is automatically computed based on the value entered in the birth_date).
Would you like to answer one of these unanswered questions instead?
value that was inserted by a client in a different time zone, you will get a value that is not the same as the value stored in the database.$id=$_GET['id']; $username="username"; $password="password"; $database="your_database"; mysql_connect(localhost,$username,$password); $query=" SELECT * FROM contacts WHERE id='$id'"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i As you can see, this code will output a standard form, but instead of having blank boxes like on the form for inserting a new record, this one already has the current information from the database inserted into it.This makes it much more effective for an update script.If there are duplicates, then to only pull the record which has the newest time stamp.Thanks CREATE TABLE sample.taceledger ( `runno` INT(10) unsigned not null default '0', `doc_no` DECIMAL(6,0) unsigned NOT null , `doc_date` DATE, `gl` DECIMAL(4,0) unsigned not null , `slcode` VARCHAR(6) not null , `tr` VARCHAR(1) not null , `cr_db` VARCHAR(1) not null, `amount` DECIMAL(13,2)unsigned not null , `revcode` DECIMAL(4,0)unsigned not null , `narration` VARCHAR(30)unsigned not null, `cramt` DECIMAL(13,2) unsigned not null, `indi` VARCHAR(1)not null , `dbamt` DECIMAL(13,2) unsigned not null, `acctype` VARCHAR(1) unsigned not null, PRIMARY KEY (`runno`) )ENGINE=Inno DB; I am getting error #1064 on `indi` line I am unable to clear it can u find some solution I'm making a table with employees for a store.
This didn't initially work for me because my ID was not unique.