Re: [php-list] MYSQL Update

2006-05-21 Thread Sudhir
  please check the table field "BatchID" if this is primary key then no need to insert that data in this field   Gordon Stewart <[EMAIL PROTECTED]> wrote:   $query="INSERT INTO `BatchID` ( `KID` , `BATCHID` , `Email` , `Title` , `Region` , `City` , `Address` , `ViewStatus` , `UpdateStatus`)

[php-list] mysql_query in function

2006-05-21 Thread mrptitlouis
Hello, This is my first post on this group, and actually my first post in a yahoo group. I develloping my own website at the moment, and I'm trying new conding type of php. However there is something that i dont understand in the function. I put a mysql_query in the function that apparently do

Re: [php-list] MYSQL Update

2006-05-21 Thread Mike Brandonisio
Hi, You do not use back ticks in the values. They should be single  quotes. See [EMAIL PROTECTED] response. Sincerely, Mike -- Mike Brandonisio  *    Web Hosting Tech One Illustration *    Internet Marketing tel (630) 759-9283    *    e-Commerce [EMAIL PROTECTED]    *    http

Re: [php-list] Current user Sessions

2006-05-21 Thread Mike Brandonisio
Hi, You will want to use a separate table not the user table since this  will be scratch data. If you want to display split values for users  and guests assign everyone an ID from the new table and place that in  a cookie var. By using a cookie you can see if a visitor has been to  the site

Re: [php-list] MYSQL Update

2006-05-21 Thread riquez
On 21 May 2006, at 15:40, Gordon Stewart wrote: > $query="INSERT INTO `BatchID` ( `KID` , `BATCHID` , `Email` , `Title` > , `Region` , `City` , `Address` , `ViewStatus` , `UpdateStatus`) > VALUES (`$name`,``, ``, `$title`, `$region`, `$suburb`, `$address`, > `$view`, `$update`)"; > $result=mysq