shimi

sorry had it wrong:SUBSTRING_INDEX(str,delim,count) Returns the substring from string str before count occurrences of the delimiter delim. If count is positive, everything to the left of the final delimiter (counting from the left) is returned. If count is negative, everything to the right of the final delimiter (counting from the right) is returned. SUBSTRING_INDEX() performs a case-sensitive match when searching for delim. mysql> SELECT SUBSTRING_INDEX('www.mysql.com', '.', 2); -> 'www.mysql'mysql> SELECT SUBSTRING_INDEX('www.mysql.com', '.', -2); -> 'mysql.com'

remove "rs.Open sql,conn" or "conn.Execute sql"you run the insert statment twice...

Hi,I have a problem with ajax, when getting hebrew data from a mySQL or MSACCESS database, it shows some question mark and a part of the HTML tag of the table containing the data.EXAMPLE: ??ble>any suggestion how to solve this problem?Thanks,Shimi.

i know about the inner join, but what i mean is to have a field that contains a subtotal.i.eName Fname trnsa b 1a b 2a b 4a b -1(null null sum=6)c d 1c d 2c d 1c d -1(null null sum=3)the result will be:Fname Lname suma b 6c d 3possible?

Hi,I would like to know if you can use sum(), and combine more the one table.For example, i got two tables, one table contains people names and addresses(id,fname,lname...) , and the other table contains, those people transaction history(id, name_id,date_,amount).The result, i want to get is a table with the peoples names, and the sum or their transaction, with one select.i tried something like this: select names.id,names.fname,trns.id,sum(amount) where names.id=trns.id group by trns.id I know this code is wrong, but i still would like to know if it is possible.thanks.shimi.