[PHP-DB] from a table, I have to pick only those rows which have two specified fields
Any simple command like distinct? -- Vaibhav Informatics, 304 Vasant Plaza, Munirka, Near Subway, New Delhi-110 067 Ph: 011-26194466 Email :[EMAIL PROTECTED]
[PHP-DB] solution reqd for summation of vertical columns in PHP
Please let me know if there is a simple method to total up the column values in Mysql database tables using php as in excel. -- Vaibhav Informatics, 304 Vasant Plaza, Munirka, Near Subway, New Delhi-110 067 Ph: 011-26194466 Email :[EMAIL PROTECTED]
[PHP-DB] ordering date in varchar
We have a problem. We have given the dates as date.month.year eg 27.12.2007 The field is named as varchar. We have to arrange ths list of dates in ascending order. Can anyone help? Varchar arranges the list by scanning from left side. Perhaps scanning from right side will do. How to do it? -- Vaibhav Informatics, 109 Vasant Plaza, Munirka, Near Subway, New Delhi-110 067 Ph: 011-26194466 Email :[EMAIL PROTECTED]
[PHP-DB] Ordering a varchar field in mysql
*Questions on PHP* In one of our tables, one of the field is acc_no, we had given the data type as varchar, since it could take any alpha-numeric values. In viewing this, we used 'order by acc_no.' The sequence of records shown was 1,10,100,1000,A1, A10, A100, etc. whereas we want the sequence to be 1,2,3,4,etc. for all the numeric values followed by alpha-numeric values A1, A2, A3, etc. Can someone please give us the code for this type of ordering? -- Vaibhav Informatics, 109 Vasant Plaza, Munirka, Near Subway, New Delhi-110 067 Ph: 011-26194466 Email :[EMAIL PROTECTED]
