PHP MySQL Insert Syntax

[kvigor]

/*I'm trying to insert values from an array into MySQL DB but the insert
begins at the last record in the table and not at first record in the table.
I have added the cellSuffixes column after I already populated 30 records in
other columns*/

Code:

foreach($list as $key=>$value)
{
$query = "INSERT INTO carriers (cellSuffixes) VALUES('$value')";
mysql_query($query,$connex) or die("Query failed: ".
mysql_error($connex));
}
echo "done";
mysql_close($connex);

//I don't know what the sytax s/b to get the data to be inserted in the
first row of the column.

[ad...@buskirkgraphics.com]

Insert is for a new row

Alter or Update is for an exsisting row

Code:

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[kvigor]

Thanks :-)

<ad...@buskirkgraphics.com> wrote in message
news:28422285.219271207072476641.JavaMail.servlet@perfora...

[fwd...@gmail.com]

//
you can use this query to update all the records in the table:
//

$query = "update carriers set cellSuffixes='$value'";

//
Because you have already inserted 30 records and you are making
changes to your data I think you need to use WHERE clause like this.
//

$query = "update carriers set cellSuffixes='$value' where id=ROW ID
COMES HERE";