Re: [PHP-DB] Auto load PHP

2001-04-03 Thread Renze Munnik
David Balatero wrote: > > Maybe after the UPDATE statement, you could do: > > header("Location: /path/to/other/script.php"); > ?> > > ...but I don't know, I don't use header() that much. > > -- David Balatero > > -Original Message- > From: Jim Ray [mailto:[EMAIL PROTECTED]] > Sent: M

Re: [PHP-DB] display login info

2001-04-03 Thread Renze Munnik
Liz Bander wrote: > > I want to display a user's full name and user id that would be from their > login action. (The login stuff is already set up.) How would I be able to > grab the user id from the login? Any ideas on where to look? > > Thanks, > > Liz > > -- > PHP Database Mailing List (

Re: [PHP-DB] Search results

2001-04-03 Thread Xsarus Internetdiensten
Use in your select-query 'LIMIT'. (See MySQL manual) It's possible then to specify the range and the startingpoint. So? Only the right buttons: i.e. Simple, isn't? Daniel Kieviet Xsarus Internetdiensten www.xsarus.nl - Original Message - From: "David Drummond" <[EMAIL PROTECTED]> To: <

Re: [PHP-DB] Auto load PHP

2001-04-03 Thread Renze Munnik
On Tue, Apr 03, 2001 at 09:05:57AM +0100, Galvin, Max wrote: > Why not a simple if statement to check if the function worked and then > include("script2.php") ? > > M > Well... I've got three reasons for that... 1. I never use include() for redirection. It was never meant to be used for that

Re: [PHP-DB] Auto load PHP

2001-04-03 Thread Renze Munnik
On Tue, Apr 03, 2001 at 09:48:07AM +0100, Galvin, Max wrote: > Jim Ray didn't say he wanted it redirected though, he said he wanted it > "called". Redirecting was brought in by someone who replied to the post. > > I would also use header() but if the poster is looking for a quick "plug in" > solu

[PHP-DB] Some assistance please

2001-04-03 Thread Shannon Doyle
Hi People, I have a sql query running an array'd result that should echo a different result depending on the result of the query. However, it successfully does one of the entries from the query, but then appears to stop. With no further results displayed. Could someone take a look at the code at

Re: [PHP-DB] array_diff usage

2001-04-03 Thread Martin Skjöldebrand
On Monday 02 April 2001 15:41, you wrote: > > -Original Message- > > From: Martin Skjoldebrand [mailto:[EMAIL PROTECTED]] > > Sent: Saturday, March 31, 2001 10:52 PM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] array_diff usage > > > > > > I'm daft. I don't understand the PHP Manual. >

[PHP-DB] Re: Solaris 2.6, PHP 4.0.4pl1, Solid EE 3.51

2001-04-03 Thread Dan Kalowsky
> 1, I'm not sure what is needed in the Solid lib directory and where I can get the >files if > they're not in the archive I've used to install Solid You will need library build 123 (I believe thats the number) ONLY if you're using the version 3.51 version. > 2, Because there are a number of in

Re: [PHP-DB] Validating forms

2001-04-03 Thread B. van Ouwerkerk
>It is much more efficient to do that type of validation client-side, using >Javascript. No >sense in making another round trip to the server if not necessary. True.. but this only works if your visitor has javascript enabled.. the biggest avantage in serverside scripting IMHO is you can forse

RE: [PHP-DB] How to limit a WHILE statement?

2001-04-03 Thread Michael Rudel
Yes, LIMIT will do the job, but to answer your question: $x = 0; while ( ( $myrow = mysql_fetch_array( $result ) ) and ( ++$x < 20 ) ) { [...] } Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtref

RE: [PHP-DB] Auto load PHP

2001-04-03 Thread Michael Rudel
"; if ( !empty( $message ) ) die( " ".$message." " ); } ?> Greetinx, Mike Michael Rudel - Web-Development, Systemadministration - ___ Suchtreffer AG Bleicherstraße 20 D-78467 Konstanz Germany fon: +49-(0)7531-89207-

Re: [PHP-DB] duplicate a table

2001-04-03 Thread Johannes Janson
Hi, just install phpMyAdmin which has a feature to duplicate tables structure only or structure and data. ""McShen"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 9aak89$ruv$[EMAIL PROTECTED]">news:9aak89$ruv$[EMAIL PROTECTED]... > > how do i duplicate a table? > i tried > create table refer2 selec

RE: [PHP-DB] duplicate a table

2001-04-03 Thread Rubanowicz, Lisa
I installed mySQLFront and it can do the same thing too through a GUI. You save a *.sql file with or without data. All the Best Lisa -Original Message- From: Johannes Janson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 2:36 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] dupli

Re: [PHP-DB] Auto load PHP

2001-04-03 Thread Renze Munnik
On Tue, Apr 03, 2001 at 03:11:49PM +0200, Michael Rudel wrote: > // Redirects to another Page using HTTP-META Tag >function redirect( $url, $message = "", $delay = 0 ) >{ > /* redirects to a new URL using meta tags */ > echo ""; > if ( !empty( $message ) ) >

[PHP-DB] INFORMIX INFO PROBLEM

2001-04-03 Thread Misterio X . - Anonymo
Is there any "civilised" way how to obtain a list of tables of a database / list of columns in table using INFORMIX/php? I know about the INFO TABLES and INFO COLUMNS commands but these won't work with PHP - "INFO" is specialy interpreted by "dbaccess" as I lately found out - it is not a native ES

[PHP-DB] MySQL Connection...

2001-04-03 Thread Leonardo Rezende
Hi all, I'm having some problems with mysql, php4 and apache ... PHP works ok... but a can't connect mysql database... This is the error message: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /home/httpd/html/t.php on l

[PHP-DB] php.exe Application Error. The instruction at "0x77fca2bf" referenced memory at "0x32343662". The memory could not be "written".

2001-04-03 Thread Jesus Estrada Gil
Hi, I've read the archive looking for a solution for this, I only found people with the same problem, but no answer... But.. I'll try. I have php4.04, Win2k, IIS5 and MS SQL7.0 I've read readme.txt, a thousand of times, I've uncommented extension=php_mssql70.dll, I've copied all the dlls to c:\wi

[PHP-DB] Re: easy db question

2001-04-03 Thread Angela Curtis
Are you deleting them one by one? If you set a condition for the deleting, then the auto_increment value won't go back to zero, but if you just delete all it will. For example, if you say: delete from my_table where 1>0; it won't reset the value. But if you just say: delete from my_table; it shou

[PHP-DB] Problems with MySQL

2001-04-03 Thread Bruno
Hello, I've just installed a porgram that uses PHP4 to access a MySQL database. The problem is that I get the following error when I try to access the PHP file via web : Warning: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111) in /usr/local/hlstats/hlstatsi

Re: [PHP-DB] Problems with MySQL

2001-04-03 Thread Jeffrey A Schoolcraft
* Bruno ([EMAIL PROTECTED]) wrote: > The strange thing about this is that MySQL leaves the mysqld.sock in /tmp, > not in the directory that the error reports. I've just installed MySQL > v3.23, and I had v3.22 before, which had it's sock file on /var/run/mysqld. You might want to make sure your p

Re: [PHP-DB] Problems with MySQL

2001-04-03 Thread B. van Ouwerkerk
>client with a newer version, ¿Could this be the case? ¿How does PHP >comunnicate with MySQL? Edit your php.ini file.. (probably in /usr/local/lib/php) and edit the entry for mysql.sock Bye, B. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

Re: [PHP-DB] Validating forms

2001-04-03 Thread Joe Brown
Do both, javascript and server side validation. Javascript can cut down on unnessary page refreshes. Serverside is the only way to guarentee the results, because of the reasons outlined here. Yes, it's more work, but it will provide a better experience for the end surfer. No? -Joe ""B. van O

RE: [PHP-DB] iODBC Mac OS X HOWTO

2001-04-03 Thread Andrew Hill
Okay, so no attachments to the lists :) Here is the HOWTO: http://www.iodbc.org/osxphp_iodbc.htm Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness Infrastructure Technology http://www.openlinksw.com office:781.273.

[PHP-DB] iODBC Mac OS X HOWTO

2001-04-03 Thread Andrew
Hi all, In the past couple of weeks, many people have asked me about compiling PHP / Apache under Mac OS X, so I've updated my iODBC HOWTO specifically for Mac OS X. This walks through the process of enabling ODBC support in PHP, so your Mac OS X PHP applications can pull data from any relationa

[PHP-DB] iODBC Mac OS X HOWTO

2001-04-03 Thread Andrew Hill
Hi all, In the past couple of weeks, many people have asked me about compiling PHP / Apache under Mac OS X, so I've updated my iODBC HOWTO specifically for Mac OS X. This walks through the process of enabling ODBC support in PHP, so your Mac OS X PHP applications can pull data from any relationa

[PHP-DB] column names

2001-04-03 Thread Mauricio Junqueira
HI, does anyone knows how to retrive information about the columns names of a table? I know that is possible to use show table mytable using isql but I need to get information about the columns using sql. that information is to be accessed with a php script. so, I'm looking for something resemb

RE: [PHP-DB] column names

2001-04-03 Thread Brian Hardwick
"SHOW FIELDS FROM $table" - Brian Tangible Networks www.tangible-networks.com -Original Message- From: Mauricio Junqueira [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 5:10 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] column names HI, does anyone knows how to retrive inform

Re: [PHP-DB] column names

2001-04-03 Thread Meir kriheli
On Tuesday 03 April 2001 23:10, Mauricio Junqueira wrote: > HI, > > does anyone knows how to retrive information about the columns names of a > table? > I know that is possible to use show table mytable using isql but > I need to get information about the columns using sql. > that information is t

Re: [PHP-DB] column names

2001-04-03 Thread Mauricio Junqueira
Meir kriheli wrote: > On Tuesday 03 April 2001 23:10, Mauricio Junqueira wrote: >> HI, >> >> does anyone knows how to retrive information about the columns names of a >> table? >> I know that is possible to use show table mytable using isql but >> I need to get information about the columns using

Re: [PHP-DB] Some assistance please

2001-04-03 Thread rjones
Shannon, Try changing your last 'elseif' to an 'else'. It could be hanging on the else-if syntax. Rich - Original Message - From: "Shannon Doyle" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 03, 2001 6:27 AM Subject: [PHP-DB] Some assistance please > Hi People, > >

RE: [PHP-DB] PHP4.0.4 segfaults with odbc_pconnect

2001-04-03 Thread Daevid Vincent
So close and yet so far away... is there an "odbcping" type program? If we run "odbcping" on the SQL2000 server, it works fine (to itself of course, but using the ODBC settings AFAIK). [root=pts/1]2:08pm@content:{/usr/local/openlink/bin}> setenv LD_LIBRARY_PATH=/usr/local/openlink/odbcsdk

[PHP-DB] Global query

2001-04-03 Thread le_pit_est_un
I am starting a new project, I don’t have a lot of experience and before running in the wall, I would appreciate to receive your comments : I have 50 texts (presently in Word format) (one text per month for the past 4 years) Each text is around 50KB (in .asc format) These texts have more or l

[PHP-DB] Re: [PHP] RE: [PHP-DB] PHP4.0.4 segfaults with odbc_pconnect

2001-04-03 Thread Andrew Hill
Daevid, On Tuesday, April 3, 2001, at 08:31 PM, Daevid Vincent wrote: > So close and yet so far away... is there an "odbcping" type program? If > we > run "odbcping" on the SQL2000 server, it works fine (to itself of > course, > but using the ODBC settings AFAIK). > yes, it's called odbctest.

[PHP-DB] Re: [PHP] iODBC Mac OS X HOWTO

2001-04-03 Thread Michael Stearne
Thanks a lot, this will be a big help. Michael On Tuesday, April 3, 2001, at 02:58 PM, Andrew wrote: > Hi all, > > In the past couple of weeks, many people have asked me about compiling > PHP / > Apache under Mac OS X, so I've updated my iODBC HOWTO specifically for > Mac > OS X. > > This wal