jana

can u describe u r table structure

as a mysql query u can use select last_insert_id(); as in php u can u as zenag said

i am new to php. and my problm is, when i fetch the data from the database the time format automatically changes to 12hrs format. but in my database the time is in 24hrs format. in my database it is looking like this. 2006-12-02 19:28:00.000 when i fetch this data into a row variable it automatically changes to Dec 02 2006 07:28 PM and i want only the time from the field not the date. can anybody help me?.

i will explain my prob detailed. a string is fetched from the table from the database. the string will look like as follows. IN:- 9:01AM <BR> IN:- 9:10AM <BR> OUT:9:45PM <BR> IN:-10:02 AM Like this and so on......... i want the string splited and stored into two arrays as In[] and Out[]; every In's with the time should be stored in array variable In[] and Out's in Out[]. and my db is  mssql server 2000 i am fetching the row into a row variable as $row=msssql_fetch_row($result); and the lenghty detailed field is $row[8]; $temp=$row[8]; $temp=explode('<BR>' $temp); and thus $temp is an array having all in's and out's accordingly. and from here my trouble starts. i don't know how to split in's and out's seperately. can anybody help me.

My datatype for the field is nvarchar(1000).

Hi to all, i hav a prob. when i fetch the data from the table to the row. it shows upto to only 255 characters. and my db is mssql server 2000. but in my db field it has more than 255 chars. can anyone help me regarding this issue?

thanx alot. and one more doubt. i want both iis and my wamp server to be run on same server can i change the port number of iis and install wamp server so that i can run bot the services can i do this.

can any one help me to convert the string to time type? I am having a column $t1 variable as string and the values will be stored like this '10:27 AM', '10:30 PM' and i wnt to convert it to time format b'cause i want to compare this $t1 variable as switch($t1) {   case (($t1>'00:00')&&($t1<'09:00'))   {           $row2=$t1;           break;   }   case (($t1>'09:00')&&($t1<'09:10'))   {           $row3=$t1;           break;   } }

Can any on suggest me which is the best way to get an input(date) from the user. 1. Year in one list box, month in one list box, date in one list box. 2. Is there any calendar function in php like VB?

it's working fine, thanx alot.

The subquery is running fine but, when i include it with the update query it returns a warning message. i viewed the warning message by show warnings. it says that [color=red]column set to default value, Null supplied to not null column ttime at row 2.[/color]

i am also new to mysql, i also got the same error while accesing thru PHP. i solved it by setting the root password. hav u set the root password to mysql.

i just made one change and it's working now but not as exactly i wanted. and the change is update ltime set ltime.ttime=(select addtime(ltime.ttime, timediff(rtime.ttime, '09:10')) from rtime where ltime.emp_id=rtime.emp_id and rtime.ttime>'09:10'); but when i changed the rtime.ttime values, the previous values of ltime.ttime are not added to current value. ex: rtime (emp_id          ttime) as001            09:15:00 as002            09:06:00 as003 09:11:00 ltime (emp_id          ttime) as001            00:06:00 as002            00:02:00 as003            00:00:00 here i want to add the ltime.ttime with timediff(rtime.ttime, '09:10'), but i got the result as ltime emp_id          ttime as001            00:05:00 as002            00:00:00 as003            00:01:00

i am having two tables ltime and rtime, ltime (emp_id    ttime) as001      00:00:00 as002      00:00:00 as003      00:00:00 rtime (emp_id    ttime) as001      09:10:00 as002      09:05:00 as003      09:16:00 and i want to update the ltime table and i used subqery as [color=red]update table ltime set ttime=(select addtime(ltime.ttime, timediff(rtime.ttime, '09:10')) from ltime, rtime where ltime.emp_id=rtime.emp_id and rtime.ttime>'09:10');[/color] and i am getting error in this. can anyone help me to solve this?????????

i have two tabes as test1 and test2. test1 (e_id, e_name) test2 (e_id, e_name) and i want to insert the values into test1 from test2. can i do like this? insert into test1 values("select e_id, e_name from test2 where e_id>3"); can anyone solve this?

can i integrate crystal reports with php and mysql?

i hav a table emp_master as emp_id emp_name tittle sex dept_id active and i want a report in a a4 paper who are all active.

Thanx alot. its working fine

How to generate reports by getting the data from mysql? any idea

yes, i do hav more than 10 machines interconnected via LAN.

where i can find the chmod settings?

i am new to php. i hav installed wamp and created a simple script tst.php as <?php echo "hello world"; ?> on machine (10.0.0.1) and worked fine on this machine when i tried the same script on 10.0.0.2 as (http://10.0.0.2/tst.php) an error apperas as "[color=red][size=10pt]Forbidden You don't have permission to access /tst.php on this server. Apache/2.0.59 (Win32) PHP/5.1.6 Server at 10.0.0.1 Port 80[/size][/color]" can anyone tell me how to solve this?

No, i hav designed in system(10.0.0.1) and i want to view that in (10.0.0.2). how to view that? i hav tried by http://localhost/tst.php in (10.0.0.2) the reply by the borwser was. permission denied

i am new to php and mysql. i have installed WAMP and i hav designed a page in php and i want view that page in other system over intranet. can any one tell me how to configure that?

can anyone tell me how to bring a message box in a webpage(HTML) after clicking submit button.