Re: [PHP-DB] marking DB entries...

2002-03-23 Thread Ljungan
Thanks Frank! Just to be certain, cant I If two users enter the same address you will have two different records in the address table - identical except for the authority field. store the information and just update the authority field? i.e If the are two fields that look the same (made by

Re: [PHP-DB] marking DB entries...

2002-03-23 Thread Ljungan
thanks for your answer! I already made the login page =). /Ljungan Adam Royle [EMAIL PROTECTED] skrev i meddelandet [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I have done an address book in php, although I kept the username/password in with the rest of their details. If you wanted to keep

RE: [PHP-DB] Remote Connection to Mysql

2002-03-23 Thread Boaz Yahav
Also make sure you don't have anything blocking port 3306 like a FW or some IP Filter between the computers. Sincerely berber Visit http://www.weberdev.com Today!!! To see where PHP might take you tomorrow. -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED]]

[PHP-DB] Re: calculations based on checkbox value

2002-03-23 Thread Hugh Bothwell
Here is some code, which I modestly suggest is superior for the following reasons: 1. Includes simply scaffolding (ie a sample form). 2. Code is separated into functions, rather than one monolithic block. 3. Somewhat improved word-counting. == html head style

[PHP-DB] Re: php-db Digest 23 Mar 2002 22:20:08 -0000 Issue 1113

2002-03-23 Thread Frank Flynn
See below... On 3/23/02 2:20 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: From: Ljungan [EMAIL PROTECTED] Date: Sat, 23 Mar 2002 11:17:15 +0100 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] marking DB entries... Thanks Frank! Just to be certain, cant I If two users enter the same

[PHP-DB] Again Select then update

2002-03-23 Thread Jen Downey
Hi all! $query = SELECT name FROM users WHERE uid={$session[uid]}; $ret = mysql_query($query); while(list($name) = mysql_fetch_row($ret)) print (your name is $name); $update = $name; $query_update[name] = UPDATE my_items SET name = $update; $result = mysql_query($query_update[name])or

[PHP-DB] Please help me! :(

2002-03-23 Thread Leif K-Brooks
I have a site where things in the database have ids. When something new is added, it gets an id one higher than the highest existing id. I use code something like this: $gethighestid = mysql_fetch_array(mysql_query(select id from table order by id desc limit 1)); $tobeid = $gethighestid[id]+1;

RE: [PHP-DB] Please help me! :(

2002-03-23 Thread Howard Picken
Can I ask why you're not using autoincrement for your id field? If you used this you would never have the problem your having. Everytime a record is added it will increment the id field by one, so you don't have to use all the code your using. Howard -Original Message- From: Leif