query

hi Is there anyone can solve my problem with query...i have two table as below:- Table employee -- ID position name -- AManagerAA BClerk BB cClerk CC Table Leave --- ID approval status -- -- B A

query problem

hai everybody, i have a problem with query.I have no idea about it,whether it can be done or not.i want to query out name order by alphabet,The range is provided like Aa - Ad. so the result should be like this:- Browse Aa to Ac Name A Aa aa Aabenraa Aachen Aakjaer, Jeppe Abadan Abaddon

query

Hi everybody, Can anybody help me? is there any other specific command instead order by ID DESC to select all the record from table where the ID is the last ID.The ID is autoincrement. Record is like this:- ID name gender 1 aF 2 bM 3 cM 4 dF 5 eM Result should

query problem

hi everyboby, How to select latest 3 days records from the table according to the latests date. The data is like this:- name date a 02-03-01 b 02-03-15 c 02-03-20 d 02-03-20 e 02-04-28 f 02-04-28 g 02-04-30 The result should be like this:- name date g

insert problem

hi everybody, I have problem with inserting data into table. MY table is:- Name type IDint(9)autoincrement Total int(9) while i insert the data,i want the total(ID+2).Its mean the record should be like this:- ID Total 1 3 2 4 3 5 is it possiblei have try is like this

server disconnect

hi everybody, Can anyone tell whats wrong with the server..the connection to server disconnect automaticaly.we have to press refresh button again and again until the its show all the folders...is there anything wrong with installationcan anyone help me sql,query

nvarchar

hi, what is the function of nvarchar...is it can use in mysql7. sql thanks in advance _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

get date

hi everybody, I want to get date expire according to their term joining...let say 6 month term..so i have to get the date when reach 6 month can anyone help me... query sql thanks in advance. _ Join the world’s largest e-mail

database problem

hi everybody, i have problem with storing chinese word to databaseall the chinese automatic change to code like this #31639;#30424;#12290; its not only waste the space, also i have problem to display it...sometime, some of the word not complete and also display symbols.is there anybody

query daymonth

hi, Can anyone help me.how to query out only day and month from the table. The result should be like this:- --- |05-04| --- |06-04| --- |07-04| --- is there any way to do this.Please help me. thanks in advance. _

again date question

hi, I have some more problem with date query. 1.how to return month from numeric to aalpabet.04-Apr. 2.how to return day or month without 0 in front. i mean if day is 01-1,same also month if 02-2. Is it possible.please help me. Thanks in advance.

query problem

hi everyone, i have a field call state...data inside this field separate by comma...johor,kl,ipoh.i want to query out data from state field which content johor,ipoh dosen't matter if there is other state name.is it possible.can anyone help me. thanks in advance

copy table

hi, how to copy table from one database to another database,is it possible. Please help me. Thanks in advance _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com

unable call database

hi everyone, I have problem call database.Its unable to call database below, but rest of database can be call.Can anybody help me. mysql_connect($host,$user,$passwd) or die (Can't connect to server); $db = mysql_select_db(dictionary) or die(unable to call db) ; thanks in advance

DBASE help

hai do anyone know how to join table in DBASE? The situation :- table 1 - EM_id EM_gender table 2 - EN_id EN_name The question is how to select all field from table1 and EN_name from table2 at one query? .The EM_id and EN_id is same.Is that any idea. please help me.

DBASE help

hai do anyone know how to join table in DBASE? The situation :- table 1 - EM_id EM_gender table 2 - EN_id EN_name The question is how to select all field from table1 and EN_name from table2 at one query? .The EM_id and EN_id is same.Is that any idea. please help me.

RE: integerchar problem

table test - +---+--+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +---+--+--+-+-+---+ | id_1 | char(3) | | | | | |

integer char

hai , i have a problem in query. My field type is integer. The table is empty and i want to select max number from the field but it display error message.Then i try to change the type to char ,it's can but, the max is until 9 only.is there anyone can help me. thanks in advance

what is Decode

hai Do anybody knows what is DECODE using mysql and what is the purpose using it. Thanks in advance. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Re: some help in PHP

From: [EMAIL PROTECTED] To: saraswathy saras [EMAIL PROTECTED] Subject: Re: some help in PHP Date: 19 Jun 2001 09:22:42 - Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words

listing data form database

hai Can anybody help me? I'am query out data(country name) from database,total count of country if 100.Now i want to arrange the country's name by 3 column() not long list.It should be example: trtdAntigua/tdtdAustralia/tdtdAustria/td/tr trtdBarbados/tdtdBelgium/tdtdBrazil/td/tr

auto assign password

Do anyone know how to assign password automatically in mysql or create password automatically by using only the user ID. Thanks in advance. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

auto assign password

do anyone know how to assign password automatically in mysql or create a password by using only user ID. Thanks in advance. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

assign auto password

Do anyone know how to assign password automatically or create a new password in mysql by using only user id. Thanks in advance _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.