Re: from excel to the mySQL

2010-08-03 Thread sam rumaizan
  visit this site :   http://www.daniweb.com/forums/thread119197.html   --- On Tue, 8/3/10, Marc Guay wrote: From: Marc Guay Subject: Re: from excel to the mySQL To: "HaidarPesebe" Cc: "MySQL Lists" Date: Tuesday, August 3, 2010, 7:34 AM > I'm needs a way to upload data from excel to th

drop down menu to a table

2009-03-02 Thread sam rumaizan
How do I insert data from a drop down menu  (select box) to a table

Re: Error: Duplicate entry '0' for key 'PRIMARY'

2009-03-02 Thread sam rumaizan
Are you trying to do an Insert On Duplicate Key? Do ou want to insert a new row if it doesn't already exist or update one if it does? On Mon, Mar 2, 2009 at 4:09 PM, sam rumaizan wrote: > Are you talking about Length/Values1 > > > > --- On Mon, 3/2/09, Gary Smith wrote: &g

Re: Error: Duplicate entry '0' for key 'PRIMARY'

2009-03-02 Thread sam rumaizan
y have unique values. With that said, it would be more useful to have a ddl and the query causing the problem. --Original Message-- From: sam rumaizan To: mysql@lists.mysql.com ReplyTo: samc...@yahoo.com Sent: Mar 2, 2009 12:56 PM Subject: Error: Duplicate entry '0' for k

Re: Error: Duplicate entry '0' for key 'PRIMARY'

2009-03-02 Thread sam rumaizan
. Ensure that all in the primary key have unique values. With that said, it would be more useful to have a ddl and the query causing the problem. --Original Message-- From: sam rumaizan To: mysql@lists.mysql.com ReplyTo: samc...@yahoo.com Sent: Mar 2, 2009 12:56 PM Subject: Error: Dup

Error: Duplicate entry '0' for key 'PRIMARY'

2009-03-02 Thread sam rumaizan
Error: Duplicate entry '0' for key 'PRIMARY'   how can i fix it ?

LAST_INSERT_ID & LAST_UPDATE_ID

2007-05-26 Thread sam rumaizan
How can I select (retrieve) the last updated cell (field). Basically I need to pull the new information only. I'm using for updating my database: UPDATE table SET column = CONCAT_WS ('column,'" . $column."') WHERE column= value; I need to select data: SELECT * FROM table WHERE column=What

Mysql and Textarea

2007-05-22 Thread sam rumaizan
I'm just a php beginner. So please be patient with my stupid questions. What am I missing in this code that causing the function can’t update the textarea? Update button erase the old information from mysql database and replace it with nothing. Basically it can’t read what is ins

index number of a specific cell

2007-05-21 Thread sam rumaizan
Is there a function in mysql to view the index number of a specific cell/field? For example if I want the index number for info4 or info7. Is it possible? Column 1 Column 2 Column 3 Column 4 Column 5 Info1 Info2

Mysql and Textarea

2007-05-19 Thread sam rumaizan
Can someone show me the mysql query statement to update the Text Area (the Text Area is populated with information from mysql) basically I want to allow the user to change or add information to the original data. scroll down to read the code. The text area I need to update is red font. ht

Object-Oriented database

2007-05-04 Thread sam rumaizan
Is there such thing call Object-Oriented database for mysql? Basically can I store an item as an object in myql? - Looking for earth-friendly autos? Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.

Importing data from excel sheet

2007-04-07 Thread sam rumaizan
I have created table in mysql with 12 fields Field1Field2 Field3 Field4 ……… Field12 I have an excel sheet with 12 columns and 150 rows. My question is how can I import all of the columns from the excel sheet to my table without losing any information.

append information

2007-04-05 Thread sam rumaizan
I have a question if you don't mind. The update statement will replace the existing information. What if I have Textarea instead and I want to add information to the field without erasing previous information. Basically append information - Looki

insert data in to columns base on the selection of the list box.

2007-04-03 Thread sam rumaizan
Can you help me please? 1-I have created a while loop to populate the list box with the information of column1. 2-I need to update (insert data) in to column2, column3, column4 base on the selection of the list box. echo''; $query = "SELECT column1 FROM table"; $res

The time of last updated field

2007-04-02 Thread sam rumaizan
I have to two different fields Last_Updated and Story. I want whenever Story Field got updated (modified) the time and date of the modification get recorded (insert) in Last_Updated Field - No need to miss a message. Get email on-the-go with Yahoo! Mail fo