inserting serialized values into fields?

[jos lohan]

Hi, I m using,

PHP Version: 5.2.14
MySQL Version: 5.0.91

i would like to insert values 12000 to 14999 into (item_id) field, via phpmyadmin

tables and fields have been created, i was wondering if some one here could please help me with a sql query to insert 3000 values into a field.

Im rather new to the managing database, i hope i'm not confusing, here;s what i want,

#TABLE_NAME
=================================
#ITEM_ID           #TAG_ID
=================================
1                       128
>                        >
11999                128

I would like values to be created below these.

[Daria]

So item ID will be incremented from 12000 to 14999?
What about tag ID? Would they all have values of 128, or incremented from 129 to 12129? or would they be null or zero?

[jos lohan]

sorry, should have made it clearer,
# item_id will increment
# tag_id will remain the same at 128

[aj_nsc]

PHP Script:

$i=12000;

  $query = "insert into `tbl_name` (item_id,tag_id) values";
  $q = false;
while($i<14999) {
   $q .= (!$q) ? "" : ", ";
   $q .= "('".$i."','128')";
}

  mysql_insert($query.$q); 

[jos lohan]

I used the query provided, but I think its not in the right syntax, but then again, i m new to sql.

MySQL said: Documentation
#1064 - 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 '$i=12000' at line 1

i should mention, values are being added to the existing table 'ws_items', whhich i have substituted in the query provided.

[aj_nsc]

It's not an SQL query, it's a tiny PHP program that generates an SQL query.

[Daria]

...which means that you will not be using it via phpmyadmin, but rather run it on the server via your web browser. So what you need to do is to create a php file, then within it include the mysql connect portion to connect to the database, then include the snippet provided by aj_nsc, upload it to the server, then physically go to the http://yourdomainname.com/yourscript.php (whatever that may be), and run it that way.

[jos lohan]

okay, i feel sheepish for not realizing that. I'll create a php script and post back how it went. Thank you all for help.