Search results for query: *

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?

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...

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?

hello, i have a web interface built to show the output of several tables that distributors can edit, now i need to find a script that can take all those tables, and merge/update them into a single table on a second database. any ideas?

ok, so i have a view, how would i put a primary key into it? i have this code: DROP VIEW IF EXISTS `Book`.`view`; CREATE ALGORITHM=UNDEFINED DEFINER=`server`@`` SQL SECURITY DEFINER VIEW `view` AS select `Products`.`ID` AS `ID`,`Products`.`Description` AS `Description`,`Products`.`Size` AS...

ok, i have a few different fields, in decimal, how would i put the $ sign in front of the numbers, what would i put into query?

i want to remove the trailing numbers from my columns, lets say my price, for example, is 199.00, i get 199.0000. i was told to use the "ROUND(price,2)" but how would i apply that to the 5 or so columns? what would be my syntax?

hi all, im migrating over from access to mysql, after finally figuring out access. i need to do a formula that automatically calculates two fields in a database and gives me a percentage. the formula is GPM=(srp-net)/srp . i got it to work, but its not doing it in order of operations. please help!!

hi all, ive posted on another forum on this site, but i think this is the right one.. i have ms access, and im trying to set up formulas, but its not working right. example columna columnb columnc 123 456 789 im trying to calculate this formula columnc = column a -...

hi all, im trying to make a formula to update an item automatically. example column a column b column c 123 456 789 my formula would be column c = column a - column b / column a i tried Me((column c)) = Me!((column a)) - ((column b)) / Me!((column a)) without the...