Re: Help with query MySQL and PHP

2008-07-03 Thread axis
time. Just the query to do that. Thanks, Rick Fitzgerald John Meyer wrote: It would be better to post this sort of question at [EMAIL PROTECTED] axis wrote: Hi, I want to create a new column or table from queries of the values of columns I( already have. My tab

Help with query MySQL and PHP

2008-07-02 Thread axis
Hi, I want to create a new column or table from queries of the values of columns I( already have. My table is : PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS products_id products_extra_fields_id products_extra_fields_value 1 1

What's the best way to INSERT a long list of email addresses and names into a TABLE?

2006-09-12 Thread axis
rchar(27) NOT NULL default 'Retail', `customers_group_id` int(11) NOT NULL default '0', PRIMARY KEY (`customers_id`), KEY `purchased_without_account` (`purchased_without_account`) ) TYPE=MyISAM AUTO_INCREMENT=60 ; I only have Name and Email in the text file. Sincerely,

What's the best way to INSERT a long list of email addresses and names into a TABLE?

2006-09-12 Thread axis
ustomers_group_name` varchar(27) NOT NULL default 'Retail', `customers_group_id` int(11) NOT NULL default '0', PRIMARY KEY (`customers_id`), KEY `purchased_without_account` (`purchased_without_account`) ) TYPE=MyISAM AUTO_INCREMENT=60 ; I only have Name and Email in the te

Best way to copy between two databases with the same tables but different number of rows

2006-08-23 Thread axis
Hi, I'm trying to copy between two databases with the same tables, but the destination one has a different number of rows. I used SQLyog first to create the script with the necessary commands and it partially worked after applying it to the second table, but my problem is with one of the table

Pls Help !

2002-12-19 Thread Axis Computers
I'm trying to figure out how can I do this: I'm designing a mysql db for a delivery service, and I encounter a problem each item delivered has a code associated and it also does some querys in other associated tables, I mean: Prod ID = 11 Prod = PizzaRecipeID=01 REcipe has the ingredi

Re: [PHP] Questions regarding inserting and updating data into a MySQL db

2002-09-10 Thread Axis Computers
Thanks for the tip I will try that, I'm still learning MySQL and PHP, although I did a couple of complex applications, there are some techniques that still are 'obscure' to me. Regards, Ricardo Fitzgerald AXIS Computers - Original Message - From: "Chris Shiflett&quo