[php-list] MYSQL Update

2006-05-20 Thread Gordon Stewart
$query="INSERT INTO `BatchID` ( `KID` , `BATCHID` , `Email` , `Title` , `Region` , `City` , `Address` , `ViewStatus` , `UpdateStatus`) VALUES (`$name`,``, ``, `$title`, `$region`, `$suburb`, `$address`, `$view`, `$update`)"; $result=mysql_query($query) or die( "Unable to add data\n" . mysql_erro

Re: [php-list] Current user Sessions

2006-05-20 Thread riquez
>  On May 20, 2006, at 6:31 PM, [EMAIL PROTECTED] wrote: > > > I'd like to add a "who's online" section to my home made forum. > > When a user logs-in they are given a session $_SESSION['user'] > > (containing their username) for the duration of their stay. > > > > How can I use PHP to list all

Re: [php-list] Current user Sessions

2006-05-20 Thread Mike Brandonisio
Hi, You'll have to write your data to a table since other users will have  query the table to count how many entries are live. You'll also have  to figure out how to deal with people who leave the site. Sincerely, Mike -- Mike Brandonisio  *    Web Hosting Tech One Illustration

[php-list] Current user Sessions

2006-05-20 Thread riquez
Hi, I'd like to add a "who's online" section to my home made forum. When a user logs-in they are given a session $_SESSION['user']  (containing their username) for the duration of their stay. How can I use PHP to list all of the currently active 'user' sessions  that the system has created?

[php-list] Optimizing a PHP script

2006-05-20 Thread Nick Jones
Hello all, I have a small PHP script that creates an XML doc on-the-fly for an AJAX application. Right now the page that we've got is just using a meta refresh to fetch the new data from the server, but that's so 1999! I'm incorporating AJAX to fetch the new page data now so I've got a quick qu

Re: [php-list] Update MYSQL - Two tables

2006-05-20 Thread Anil Kumar
Hi Gordon After inserting into the First table, After success Insertion there is a seperate function in mysql,mysq_insert_id(), This is will get the last insert id from the first table. thx and regards Anilkumar On 5/20/06, Gordon Stewart <[EMAIL PROTECTED]> wrote: > >  I've got 2 tables in