[PHP-DB] Re: Hi, simple question

2003-07-01 Thread Shivanischal A
Hi, or u can just try "select last_insert_id() from test" - thats what i do. however even mentioning the table-name doesn't seem to be necessary; i just do it for readability. -shiva "Patrik Fomin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > > im adding a post to the data

[PHP-DB] Possible solution to a simple newbie problem of JOINs

2003-07-01 Thread David Shugarts
My newbie problem is solved and it may help other newbies if I share it. The idea is to take two or more tables and combine their data into one table that you can query. Each of the source tables may only have one or two columns of overlap. You want records (rows) that do not fill in data in unu

RE: [PHP-DB] Hi, simple question

2003-07-01 Thread Nick Pappas
There's two methods I use, depending on the situations I need. What it sounds like you want is this: $sql = "SELECT id FROM test ORDER BY id DESC LIMIT 1"; Often when I need to know the next avaliable ID prior to making an insert, I'll do this-- $sql ="SHOW TABLE STATUS LIKE 'test'"; $array =

Re: [PHP-DB] Hi, simple question

2003-07-01 Thread Oscar Rylin
see mysql_insert_id($link_identifier) -- rylin Patrik Fomin wrote: Hi, im adding a post to the database, is there any way to retrive back the ID for the post that i just created? the id is auto_increment and primary key. like $sql = "insert into test (namn, www) values('test', 'test.com')"; my

[PHP-DB] Hi, simple question

2003-07-01 Thread Patrik Fomin
Hi, im adding a post to the database, is there any way to retrive back the ID for the post that i just created? the id is auto_increment and primary key. like $sql = "insert into test (namn, www) values('test', 'test.com')"; mysql_query($sql); $row = mysql_get_post("id"); ? the only way i coul

[PHP-DB] PHP and a mailing list system.

2003-07-01 Thread Rene Groothuis (Aeqis)
Hi All, Can somebody suggest a good (freeware) mailing list system that uses PHP. It must support sub- and unsubscribe by sending e-mail to the admin e-mail address (example [EMAIL PROTECTED]). Thanks. Cheers, Rene. === R. Groothuis - Aeqis Gruttosingel 50 2

Re: [PHP-DB] non-GPL MySQL licenses & PHP5

2003-07-01 Thread Becoming Digital
> So, why then not using the GPL for PHP. Soo many people are releasing their > software under the GPL. This just begs for the "if everyone jumped off a bridge..." question we've all heard from our parents on at least one occassion. Edward Dudlik Becoming Digital www.becomingdigital.com Did I h

RE: [PHP-DB] Looking for a php database browser..

2003-07-01 Thread Ryan Marks
Using phpMyAdmin, you can grant a user specific privileges to do just what you are asking about. If you only want the data changed, give them some or all of these: SELECT, INSERT, UPDATE, and DELETE. You can specify how much the user can see or change at the level of the database, table, or colum

[PHP-DB] Looking for a php database browser..

2003-07-01 Thread Daniel Szasz
Hello I have to give the possibilitz to browse the tables from a database and update the data inside. Since there are a lot of tables I prefer to use a smart php table browser. The user is not allowed to update the structure only the data so I can't use the phpMyAdmin that is already installed on

RE: [PHP-DB] Reading from a file

2003-07-01 Thread Gary . Every
Looks like the first question was answered correctly, for the second one look at the ltrim and rtrim functions. $var = ""; $var = rtrim($var); echo ":$var:"; output is :: Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 "Pay It Forward" mailto:[EMAIL PROTECTED] ht

Re: [PHP-DB] non-GPL MySQL licenses & PHP5

2003-07-01 Thread Rasmus Lerdorf
On Tue, 1 Jul 2003 [EMAIL PROTECTED] wrote: > [EMAIL PROTECTED] (Rasmus Lerdorf) wrote in > news:[EMAIL PROTECTED]: > > > On Tue, 1 Jul 2003, Nabil wrote: > >> You need to purchase commercial non-GPL MySQL licenses: > >> > >> a.. If you distribute MySQL Software with your non open source > >> s

Re: [PHP-DB] non-GPL MySQL licenses & PHP5

2003-07-01 Thread zaphod
[EMAIL PROTECTED] (Rasmus Lerdorf) wrote in news:[EMAIL PROTECTED]: > On Tue, 1 Jul 2003, Nabil wrote: >> You need to purchase commercial non-GPL MySQL licenses: >> >> a.. If you distribute MySQL Software with your non open source >> software, b.. If you want warranty from MySQL AB for the My

Re: [PHP-DB] Reading from a file

2003-07-01 Thread Adam Voigt
$data = file('c:\file.txt'); for($counter = 0; $counter < count($data); $counter++) $data[$counter] = explode("\t",$data[$counter]); Poof. For: bob ninajim joe You will get: $data[0][0] = 'bob'; $data[0][1] = 'nina'; $data[0][2] = 'jim'; $data[0][3] = 'joe'; Nice and easy

[PHP-DB] Reading from a file

2003-07-01 Thread Rick Dahl
I need to read from a file that is tab delimited. Is there anyway to specify that it reads between each tab and that is it. I know fread() uses bytes to figure out what to read but that isn't very practical in my case. Also, how do I get rid of any white space at the end of a variable if the

RE: [PHP-DB] hmmm

2003-07-01 Thread Hutchins, Richard
That hardly excuses an obscenity-laden tirade broadcast to thousands of people who use this list for legitimate purposes every day. I visited your website and noticed you use PHP to drive it. So I would imagine that you have benefited from a little of the knowledge exchanged in this forum. Seems to

Re: [PHP-DB] hmmm

2003-07-01 Thread brandy
i HAVE ever told i have UN subscribed but still got it Citeren Jason Wong <[EMAIL PROTECTED]>: > On Tuesday 01 July 2003 19:46, Lester Caine wrote: > > > WTF does "To unsubscribe, visit: http://www.php.net/unsub.php"; at the > > > bottom of every e-mail mean to you idgit? > > > > The problem se

Re: [PHP-DB] hmmm

2003-07-01 Thread Jason Wong
On Tuesday 01 July 2003 19:46, Lester Caine wrote: > > WTF does "To unsubscribe, visit: http://www.php.net/unsub.php"; at the > > bottom of every e-mail mean to you idgit? > > The problem seems to be deciding WHAT to use as an eMail > address, it may be case sensitive, so that PHP-DB- does not > wo

Re: [PHP-DB] hmmm

2003-07-01 Thread Lester Caine
WTF does "To unsubscribe, visit: http://www.php.net/unsub.php"; at the bottom of every e-mail mean to you idgit? The problem seems to be deciding WHAT to use as an eMail address, it may be case sensitive, so that PHP-DB- does not work, but php-db- does. Don't you love standardisation ;) Just lik

RE: [PHP-DB] hmmm

2003-07-01 Thread Ben Lake
WTF does "To unsubscribe, visit: http://www.php.net/unsub.php"; at the bottom of every e-mail mean to you idgit? Ben -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 4:38 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] hmmm YOU FUCKING SHIT

Re: [PHP-DB] hmmm

2003-07-01 Thread Lester Caine
To unsubscribe, visit: http://www.php.net/unsub.php It is a little daunting if you are having trouble with your nappy ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.p

[PHP-DB] Re: hmmm

2003-07-01 Thread Pete Morganic
The man is entoxicated with the exuberance of his own verbosity Winston Churchill [EMAIL PROTECTED] wrote: YOU FUCKING SHIT!!! UNSUBSCRIBE MY EMAIL PLEASE !!! GOD VERDOMME !!! UNSUBSCRIBE IT NOW,MOTHER FUCKER BABI LOE BANGSAT LOE KONTOL LOE !!! SIKTIR GIT!!! YALLA!!! HOER !!! GO AWAY FR

Re: [PHP-DB] hmmm

2003-07-01 Thread Evan Morris
SAY WHAT? WHO ARE YOU TALKING TO? HAVE YOU GONE INSANE? IS YOUR MOTHER A GERBIL? DO YOU KNOW HOW STUPID YOU SOUND WHEN YOU SEND THESE UTTERLY BIZARRE, VERBALLY ABUSIVE NOTES FROM THE VOID TO AN ENTIRE MAILING LIST OF PEOPLE WHO HAVE NO IDEA WHAT YOU'RE TALKING ABOUT? AND USING CAPS ALL THE TIME IND

[PHP-DB] hmmm

2003-07-01 Thread brandy
YOU FUCKING SHIT!!! UNSUBSCRIBE MY EMAIL PLEASE !!! GOD VERDOMME !!! UNSUBSCRIBE IT NOW,MOTHER FUCKER BABI LOE BANGSAT LOE KONTOL LOE !!! SIKTIR GIT!!! YALLA!!! HOER !!! GO AWAY FROM MY MAIL BOX WILL YA!!! FUCK SHIT U BASTARD MOTHER FUCKER ASSHOLE !!! PECUN LOE BABI LOE JANCUK !!!

[PHP-DB] Re: Obtaining mysql for php 4.1.2 on Linux

2003-07-01 Thread Cristian MARIN
./configure --with-mysql if you have the sources of php 4.1.2 please read the manual on how to build him. It's very important to know what do you whant to do with php in order to compile him. A configuration line that could help you and will build modules is: './configure' 'i386-redhat-linux' '--