Re: [PHP] MySQL: copying entire columns

2001-11-30 Thread Chris Hobbs
Tom Churm wrote: >$sql = "Insert into $table_name(Address, Phone, Name) >values('$Address','$Phone','$Name')"; > >if this is true, it'll save me a lot of useless time trying to reorder >my tables. > That be it :) -- ___ ____ _ Chris Hobbs / \ \

Re: [PHP] MySQL: copying entire columns

2001-11-30 Thread Andrey Hristov
$value){ $tmp = explode($cschar,trim($value)); $tmp[count($tmp)] = $tmp[$which_column]; unset($tmp[$which_column]); $out_cont[] = implode(",",$tmp); } $fd = fopen($out_fname,'w+'); fwrite($fd,implode("\r\n",$out_cont)); fclose($fd); ?> HTH Regards, Andrey Hristov - Origin

Re: [PHP] MySQL: copying entire columns

2001-11-30 Thread Tom Churm
hi, miles: i think you helped me hit on something big here. each time i've been using INSERT statements in my php code, i've been addressing the field names in exactly the order they appear in my mysql table. ie: i've been using $sql = "Insert into $table_name(Name, Address, Phone) values('$Na

Re: [PHP] MySQL: copying entire columns

2001-11-30 Thread Miles Thompson
Tom It's a relational database, field column position does not matter. One Date's 121 rules, if I remember correctly. In terms of human readability, it sometimes matters. Check the MySQL manual, I think there's an example of this under the ALTER TABLE command. But really, position doesn't mat