[PHP] mysql:fixing gaps in id-key fields

hi, it happens to me quite often that after testing a mysql table or after deleting several rows that there are gaps in the numeration of my 'id field' (key). i always use the same field type for my 'id field:' id int(255) unsigned NOT NULL auto_increment, what is the best way to quickly correc

[PHP] MySQL: copying entire columns

hi, i've created a mysql table from an excel csv dump and the field-order is not the way i want it. could someone possibly give me a hint on how i can create a copy of an entire column, place it in the position where i want in my table, and then delete the original column? i'm using phpMyAdmin

Re: [PHP] Excel and PHP in Unix

hi, i just wanted to put in a plug for my own code to generate dynamic Excel or Word files here. it's ultra easy to use: http://sourceforge.net/projects/php-doc-xls-gen/ thanks, tom Pavel Jartsev wrote: > > Iván Toda Caraballo wrote: > > > Hello, > > > > I am using the Unix version

Re: [PHP] MySQL: copying entire columns

tter. 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 matter, exept to fulfill a hum

[PHP] max # of characters for links to work in emails?

hi, i'm working on an eCard project and somehow need to find out what the reasonable limit is on characters for urls in email bodies (normal text, not mime). i know that some mail clients will cut off urls that are too long or else throw a line break in the middle of them--thus rendering them 'u

[PHP] comparing 2 mysql tables

hi, i've got 2 different MySQL tables. i need to check which entries in the text-field 'User' in one table are NOT present in the 'User' field in the other table. then i need to either save this array to a textfile or otherwise prepare it for creating a new, third table. any hints on how this

[PHP] MySQL: Updating ID auto_increment fields

howdy, this should be simple but i don't know it. i use the following mysql table field as the Key for my tables: "id int(10) unsigned NOT NULL auto_increment," now, when i have to clean up items in my tables, like when users have sent off a .html form multiple times and i want to delete dupli

[PHP] 2 General MySQL Questions

hi, i'm awared that this is not exactly the correct forum for these questions. please humor me this one time: 1) can anyone refer me please to a public, postable MySQL newsgroup? i've found a few MySQL newsgroups, but none of them allows posting. it would be great if you could also tell me

[PHP] substr() in MySQL SELECT?

hi, could someone please tell me why this doesn't work? i thought that string functions could be used in select statements? i dunno... SELECT User, SendDate FROM my_form WHERE substr(SendDate, 0, 2)=19; and i've tried the damn thing with brackets around all different parts. thanks much, to

Re: [PHP] substr() in MySQL SELECT?

$table_name WHERE (Answer=0)&&( abs((SUBSTRING(SendDate, 1, 2)) - $NowDay) > 7 ) thanks again, tom Don Read wrote: > > On 19-Sep-2001 Tom Churm wrote: > > hi, > > > > could someone please tell me why this doesn't work? i thought that > > string fu

[PHP] Array Elements & While Loops

hi, my problem is this: i'm using a while loop to check elements in an Array for valid email syntax. if $User[0] is a valid email address but $User[1] is not, the code for $User[0] is still executed before the die statement. i need my loop to finish checking ALL array elements for validity, an

[PHP] Re: Array Elements & While Loops

mail > > should be: > > if ($flag == 1) // notice the double-equal signs > > "Tom Churm" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > hi, > > > > my problem is this: i'm using a wh