Recent content by compudude86

ok, ive modified it to this and gotten it to work: <code> delete P from Products as P inner join ( select Description , NetBtl , min(Date) as min_date from Products group by Description , NetBtl having count(*) > 1...

thank you very much, it worked, it took out some 634 duplicate records.

ok, so i have a table of products, called "products" located in a database called "Book". my problem is when i update products, using a csv file through phpmyadmin, it will add another row, all the same info (price, description, etc) but different dates, and different primary keys...

looking to buy a copy of irix from someone, anyone?

i am using phpmyadmin to create reports from my database. i export them to a PDF file, and it arranges them by another field, i would like it to arrange a-z by the tables "description" field. how would i do this?

ok. how would i go about doing this in phpmyadmin export to pdf?

i have a view that i need ordered by ascending when i access it. right now it sorts by ID i believe. here is my code to create the view: DROP VIEW IF EXISTS `Book`.`book`; CREATE ALGORITHM=UNDEFINED DEFINER=`server`@`` SQL SECURITY DEFINER VIEW `Book`.`book` AS select `view`.`Description` AS...

ahh, that worked perfectly. thank you very much!!

i am using something called dataface as my frontend, and i run the query in mysql query browser to create "view" which the frontend gets its information from

i have only a very basic knowledge of mysql, so i would not know how to do that. i have set the field in the table that the view gets its data from as 19,2 but its not making a difference

ok, i used that query, but now my NetBtl field has a number like 12.000000000 in it, instead of the 12.00 field it was before. how do i fix this?

ok, i have a mysql query, (CREATE VIEW `Book`.`view` AS SELECT ID, Description, Size, Pack, List, Net, Discount, NetBtl, SRP, Vendor, Date, CONCAT(ROUND((srp-netbtl)*100/srp),'%') as GPM FROM Products;) and i need to add in the formulas (List-Discount=Net)and (Net/Pack=NetBtl) along with it...

ok, i have a form in access, so that i can edit and apply mathematical formulas to a local access table, but my linked table doesnt get changed. so i made a view of the table, and i only get one line of the table, not the whole table. how do i fix this?

hello, i have smartmail, "Sendmail version 8.13.5.20060308, config V10/Berkeley". when i installed it, and went to the sendmail.mc file, and theres nothing for smart_host. i am setting this up on sbc yahoo dsl. help!!

i want to make a report, that would print to 8x11 landscape, in a standard html table, using mysql as the source. how would i do this?