Re: [PHP-DB] Skipping a row

2003-12-19 Thread Robby Russell
John Greco wrote: $sql2 = "select * from product where whseNum = '".$whseNumber."' order by prodNum"; What does your PHP code look like after that? What is your index starting with? are you starting with 0? or 1? $sql = "SELECT id FROM product WHERE something = this"; $rs = pg_query($sql); $i =

RE: [PHP-DB] Reading emails with PHP

2003-12-19 Thread Dillon, John
> It may be sacrilege to mention it here, but there is an excellent perl > module for handling mail bounces; I've used it to write a handler that > catches the returned mail, gets the address(es) and reason(s) for the > bounce, and then goes into our DB and flags the matching users. I looked > al

[PHP-DB] Re: Re:Subject: DB, XML and & sign

2003-12-19 Thread Muhammed Mamedov
Then thing is that I have a string to play with AFTER form submission.. So if user enters something like this "Say hello to Alex & Özgür" to my PHP file this will be sent like "Say hello to Alex & Özgİr". You see there are 2 ampersands here, and only one should be removed - the one just after "Alex

Re: [PHP-DB] Reading emails with PHP

2003-12-19 Thread David T-G
John, et al -- ...and then Dillon, John said... % % > It may be sacrilege to mention it here, but there is an excellent perl % > module for handling mail bounces; I've used it to write a handler that ... % % I'd be interested in more details on this, from the pov of a person who No problem. %

RE: [PHP-DB] Reading emails with PHP

2003-12-19 Thread Dillon, John
As one who has used php (without classes) but has seen cpan in operation (I'd describe it as connecting to the internet from the c: prompt, if using Windows) and it's impressive though complicated, only the documentation is a bit flat on perl and beginners lists require you to have memorised Learni

[PHP-DB] can anyone help me with a control menu for a database?

2003-12-19 Thread Reinder Otter
Its kind of complicated beacause the code is about 1400 lines...but the thing is that it automatically gets all tables with contents from the database wich u can alter or delete. If someone thinks he is up for it, I can give you the complete code. Tnx Rein -- PHP Database Mailing L

Re: [PHP-DB] Reading emails with PHP

2003-12-19 Thread David T-G
John, et al -- [We're going to talk about perl a bit more, albeit comparing and contrasting with php. If this should be kicked off of the list, just let us know.] ...and then Dillon, John said... % % As one who has used php (without classes) but has seen cpan in operation % (I'd describe it as

Re: [PHP-DB] Re: Re:DB, XML and & sign

2003-12-19 Thread Neil Smth
No, it wont because htmlspecialchars() will only convert the characters I mentioned. Your ISO-8859-1 characters will remain unchanged, depending on the database encoding set in your running MySQL server. So your htmlspecialchars(string) will give you Say hello to Alex & Özgür Not what you ass

Re: [PHP-DB] Planetside

2003-12-19 Thread Cal Evans
What is the Planetside database? Let me know how I may be of service, =C= * Cal Evans * http://www.eicc.com * We take care of your IT, * So you can take care of your business. * * I think inside the sphere. Madaleno wrote: Hi, can someone help me on how to access Planetside database to get some ch

Re[2]: [PHP-DB] Planetside

2003-12-19 Thread Richard Davey
Hello Cal, Friday, December 19, 2003, 10:28:19 PM, you wrote: CE> What is the Planetside database? It's a pay-to-play on-line multi-player FPS game run by Sony. I don't think you could interface with it directly, at least I'd be pretty surprised if you can. -- Best regards, Richard

Re: [PHP-DB] Creating temp tables in MSSQL

2003-12-19 Thread Frank M. Kromann
Hi John, you need to specify a name for the column that you create with the convert function. Like this select distinct convert(varchar(36), amount) id into #temp1 from fred #temp1 will now have one column called id. #temp1 can be removed with droptable #temp1 or by closing the connection to th

Re: [PHP-DB] Creating temp tables in MSSQL

2003-12-19 Thread Frank M. Kromann
Hi Matt, Tables in tempdb are deleted when the connection is closed or when the user deletes them with drop table #tempname. - Frank > Hi Frank. > > When does this table get deleted? when the DB connection closes or does > one have to run a process to clear the temp tables? > > Thanks, > Matt