[PHP-DB] Escape for MSSQL?

2001-04-13 Thread Thomas
ackslash in C? Many thanks in advance, Thomas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Escape for MSSQL?

2001-04-13 Thread Thomas
Hello! Many thanks for the answers and the link, I'll check on Tuesday in the office. Cu, Thomas Jeff Carnahan wrote: > In article <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] says... > }In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > }} > }}Does anybo

RE: [PHP-DB] imap problem

2001-06-21 Thread Thomas
Did you compile php with the --with-imap option ? Because generally, this type of message happens when the function is not installed. - Mensaje original - De: "vipin chandran" <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED]> Enviado: mercredi 20 juin 2001 14:54 Asunto: [PHP-DB] imap problem

RE: [PHP-DB] submitbutton/imagebutton

2001-06-22 Thread Thomas
No, with an image, the value captured are the coordinates x and y above the image this means that if your variable is called submit, the two variables $submit_x and $submit_y are set. - Mensaje original - De: "Jan de Koster" <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED]> Enviado: vendred

RE: [PHP-DB] problem with regular expression

2001-07-16 Thread Thomas
Why not simply : "[a-zA-Z0-9]+" that would match any sequence of letters or numbers ? - Mensaje original - De: "Jennifer Arcino Demeterio" <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED]> Enviado: lundi 16 juillet 2001 04:35 Asunto: [PHP-DB] problem with regular expression i have a script

[PHP-DB] EZ Question...I think

2001-12-03 Thread Thomas
he definition on any site...can anyone help? Please reply to group. Thanks. Thomas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: EZ Question...I think

2001-12-03 Thread Thomas
Thanks everyone. Appreciate it. "Thomas" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I have looked into some source code that I found, but I'm a newbie at this, > and don't understand.. > > if ( 0 == $this-&

[PHP-DB] [DB_DataObject] why is there no query($query, $params) method?

2005-05-09 Thread Thomas
re is a query method, of course, but it takes only one SQL string argument.. Cheers, Thomas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] [DB_DataObject] why is there no query($query, $params) method?

2005-05-09 Thread Thomas
.org wrote: On 09/05/05, Thomas <[EMAIL PROTECTED]> wrote: Is there any reason that this method signature is not supported by DB_DataObject? Perhaps because it doesn't make sense to wrap every DB method when you can already do $dataObject->getDatabaseConnection()->query(...) -- Kiera

[PHP-DB] New to PHP/MySQL - Need help with images

2008-01-05 Thread Thomas
I'm attempting to make a table with one row and 3 columns holding three different images. I want each image URL to be called from my database. Everything is set-up in my database. When I use the following code, it places the same picture across the three columns and does this three times (c

[PHP-DB] Forms submitting to a session array

2008-01-13 Thread Thomas
I'm trying to create a shopping cart where users can visit a product page (called from a MySQL database depending on the url ending in ?product_id=#). On the product page users can select options from dropdown lists (such as color, etc.) These dropdown lists are also dynamically generated f

[PHP-DB] Spørgsmål vedr. print af $row[]

2001-01-18 Thread Thomas Secher
Jeg sidder med et php-dokument som benytter echo $row[] fuktionen. I enkelte $row output vil jeg gerne begrænse antallet af viste karakterer. Findes der en direkte echo/$row funktion eller har du en anden fix idé ? Thomas. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e

AW: [PHP-DB] Pictures+MySQL+PHP

2002-01-27 Thread Thomas Lamy
:-) And now it is very easy to do full backups, and no problem with db/fs getting out of sync. Only one thing has given me a hard time: The first time I stored all 5 instances of an image (thumb plus 4 other resolutions) in the same db table, but mysql choked on it when it became about 200 mb (the

[PHP-DB] cutting off zeros >> 10.00 to 10

2002-02-06 Thread Thomas Murphy
Hallo, i was wondering if there is a built-in function in php that just cuts off not needed zeros from float-numbers (like changing "1.90" to "1.9" or "10.00" to "10"). I get this numbers from a mysql-database, perhaps there even is a mysql-function

Re: [PHP-DB] cutting off zeros >> 10.00 to 10

2002-02-06 Thread Thomas Murphy
t; > No charge...this time. =) thank you very much. :) bye, Thomas Murphy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] cutting off zeros >> 10.00 to 10

2002-02-06 Thread Thomas Murphy
converted to 1.9 without problems... bye, Thomas Murphy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

AW: [PHP-DB] multiple inserts

2002-04-20 Thread Thomas Schön
i think, your sql-statement isn´t correct. Maybe you don´t insert the right count of values, or you try to insert NULL in a "NOT NULL"-defined column. Try to "echo" the statement and run it with phpMyAdmin, wich will show you the position of your error in your statement. mysql_insert_id() gives y

[PHP-DB] libphp4.so, Sun Solaris 8, relocation error

2002-07-22 Thread Thomas Langås
/bin:/store/bin:/usr/ccs/bin:/sbin:/usr/sbin Anyone around with a possible solution, or does anyone need more info to help solve the problem? I would be happy to provide more info, and I would be very gratefull for a solution to this problem. -- Thomas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Are running sessions using a MySQL handler faster?

2002-08-21 Thread Jonathan Thomas
Good afternoon! Quick performance question - I'm currently preparing the release of a new website running on a Linux box written in PHP and MySQL with sessions throughout. I've read a bit about changing the PHP session handler to use a database vs. the flat file method. Does anyone have experie

AW: [PHP-DB] strange behavior

2002-09-12 Thread Thomas Lamy
ine, which is automatically defined to session_name().session_id() if the user has turned off cookies. Read: http://php.net/session Thomas > -Ursprüngliche Nachricht- > Von: Martin Adler [mailto:[EMAIL PROTECTED]] > Gesendet: Donnerstag, 12. September 2002 14:34 > An: [EMAI

AW: [PHP-DB] Large files using phpMyAdmin

2002-09-22 Thread Thomas Lamy
and magic_quotes. Can't tell how you designed picture uploads, but if you did it "the right way" (my opinion, no flames :-), both need to be "Off". Thomas > Von: Steve Vernon [mailto:[EMAIL PROTECTED]] > Gesendet: Sonntag, 22. September 2002 20:00 > An: [E

AW: [PHP-DB] getting mysql_fetch_row into array

2002-09-23 Thread Thomas Lamy
] = $row[0]; } Thomas > -Ursprüngliche Nachricht- > Von: LSC Exhibits Department [mailto:[EMAIL PROTECTED]] > Gesendet: Montag, 23. September 2002 19:17 > An: '[EMAIL PROTECTED]' > Betreff: [PHP-DB] getting mysql_fetch_row into array > > > Going through brain

Re: [PHP-DB] export to csv file

2002-09-28 Thread Thomas Lamy
Diana Castillo [mailto:[EMAIL PROTECTED]] wrote: > > Hi, I want to export some fields on a regular basis from a > table to a text > file, preferable to the users local computer. I tried writing > to a file with > fopen but I get "permission denied" when I try to open it for writing. > What is t

AW: [PHP-DB] error_reporting()

2002-09-30 Thread Thomas Lamy
Do you have display_errors = On in your php.ini ? Ryan Jameson (USA) wrote: > > I do the following > > error_reporting(E_ALL); > echo error_reporting(); > ?> > > and it says 2047 and still reports no errors. What overrides > my setting? > > Thanks... > <>< Ryan -- PHP Database Mailing Li

Re: [PHP-DB] Error query : mysql_result

2002-10-10 Thread Thomas Lamy
s seems to be a common trivial error: in 139, you get the number of rows found, but if there are none, you try to retrieve data in line 140, where you get the error message. Exchange line 140 with 142, and the error message will go away. And please, the next time you ask here, post only code s

AW: [PHP-DB] OT...where do I go for this......?

2002-10-10 Thread Thomas Lamy
your (old, maybe handcrafted) httpd.conf. Thomas Michael Cortes [mailto:[EMAIL PROTECTED]] wrote: > Gesendet: Donnerstag, 10. Oktober 2002 18:52 > An: [EMAIL PROTECTED] > Betreff: RE: [PHP-DB] OT...where do I go for this..? > > > I just checked and register_globals are on

Re: [PHP-DB] update and join?

2002-10-10 Thread Thomas Lamy
quot;col3"=>"data3"), => array ("col2"=>"data2","col3"=>"data3"), ); and then, do the updates in a neat foreach loop: foreach ($a as $pkey=>$data) { [ build update stmt from $data array ] dbquery ($stmt) } Hope this helps. Thomas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] easier way to do this? (time interval)

2002-10-11 Thread Thomas Lamy
AND HOUR(dtg)>=7 "); ... where 86400 = 24 hours (in seconds) See <http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1302> Thomas > -Ursprüngliche Nachricht- > Von: Thoenen, Peter Mr. EPS > [mailto:[EMAIL PROTECTED]] > Gesendet: Freitag, 1

Re: [PHP-DB] catalog system

2002-10-21 Thread Thomas Lamy
Sorry, didn't want to be that offensive. It just comes through from time to time. Thomas Sparks [mailto:alex@;paychoice.com] wrote: > > Yes, I've been trying to learn what I need. Yes, I've surfed the > newbie/wanna be places. I just asked if anyone knew of one, &g

Re: [PHP-DB] catalog system

2002-10-21 Thread Thomas Lamy
ining day(s). Really. [No, this was not off-topic] Thomas PS: I (and many others on the list) _like_ to help people with problems when their stuck. But from time to time this list tends to be a nubee-forum. I take time from my projects to read this list (and answer sometimes), just to give back to

Re: [PHP-DB] Idea as to why this query won't work as expected?

2002-11-05 Thread Thomas Lamy
sy if you remember: AND is equal to multiplication, OR is equal to addition. Multiplications are done before additions, so ANDs are done before ORs. Thomas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] ROugh idea of speed

2002-11-09 Thread Thomas Lamy
olved moving to the above configuration. I am really confident with the current setup, which is running for half a year now. But keep in mind that - most of the times - you get far more performance by optimizing your database (and queries) than by upgrading hardware (the --log-slow-queries and

[PHP-DB] oracle 8i client/ PHP 4.0.4pl1 breaks

2001-04-12 Thread Dave Thomas
the cause. Should I suspect bad Oracle link libraries? Dave Thomas Chief Software Architect BCD Enterprises, Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscri

[PHP-DB] PHP/OCI8 design for persistent connection tuning

2001-04-17 Thread Dave Thomas
ook for www.somewhere.com:88/banner.gif, which is fine since this is a new architecture. There are other OS approaches, like Linux khttpd (i dunno - is it ready for production?) and Squid. Any thoughts? Dave Thomas Chief Software Architect BCD Enterprises, Inc. -- PHP Database Maili

AW: [PHP-DB] Concurrent update to database (PostgreSQL or MySQL) ??

2001-04-18 Thread Thomas Lamy
27;s a bit of work, but it had never let me down. Thomas id INT NOT NULL AUTO_INCREMENT PRIMARY KEY Is what I use in the WHERE clause to update data ts CHAR(32) NOT NULL UNIQUE I > -Ursprüngliche Nachricht- > Von: Doug Semig [mailto:[EMAIL PROTECTED]] > Gesendet: Mitt

AW: AW: [PHP-DB] Concurrent update to database (PostgreSQL or MySQL) ??

2001-04-18 Thread Thomas Lamy
above and could become a CON because > it could mean > that programmers can list unnecessary fields in the UPDATE > statement, which > is unnecessary network traffic. I prefer to update complete sets of data (as long as it's not against performance, like updating some large BLOB

AW: [PHP-DB] Variable passing

2001-04-24 Thread Thomas Lamy
u enter the next page. Thomas > > "Brinzoi Constantin Aurelian" <[EMAIL PROTECTED]> schrieb im > Newsbeitrag > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Hi ! > > > > Here is the problem: I got 8 pages, shown one after > another. Ea

AW: [PHP-DB] syntax error - -- agghhh!

2001-04-24 Thread Thomas Lamy
rd) && > (!eregi("^([a-z0-9_]|\\-|\\.)+@(([a-z0-9_]|\\-)+\\.)+[a-z]{2,4 > }$",$email)) > { > > It worked fine until I added the tricky part: > > && > (!eregi("^([a-z0-9_]|\\-|\\.)+@(([a-z0-9_]|\\-)+\\.)+[a-z]{2,4 > }$",$email) > You

[PHP-DB] Truncated data retrieved from MSSQL Server

2001-07-14 Thread Thomas Merlin
Hello, I'm trying to retrieve data from a table sitting on a MSSQL Server Database but the query result is always truncated over 255 characters... PHP 4.05 is running on a Linux box The column is a varchar 5000 Thanks for any help. Thomas. -- PHP Database Mailing List (http://www.ph

[PHP-DB] Re: forming a multi-dimensional from a MYSQL DB QUERY

2001-07-24 Thread Thomas Bender
You've got to call it by $tbl[0]["hardware"] greetings Thomas -- -- 4Ws Netdesign GbR www.webinside.de... ..wir machen Homepages -- "Cody Caughlan" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED]... > Hello, > > I am implementing a

Re: [PHP-DB] Retrieving Rows - Can I Change The Order?

2001-07-28 Thread Thomas Lamy
nstead of mysql_fetch_row(), so you can refer to your columns by name, as in: $q = mysql_query("select id,name from address;"); $a = mysql_fetch_array ($q); ==> now you can use $a['id'] and $a['name'] to get the field's values. I found it always good practice

[PHP-DB] MS-SQL, PHP, IIS

2001-08-07 Thread Thomas Winkler
Hi., I'm currently using an IIS5 (W2k) with php4.0.6 (CGI) and MS SQL Server 2000. I've run into problems when fetching fileds of the type datetime from the database. When using the MS SQL Query Analyzer I get my dates formated like this out of my database: 2001-06-08 08:14:40.000 When using php

[PHP-DB] RE: Mysql to CSV

2001-08-25 Thread Thomas Spellman
Check the PHP Classes site, I think I remember seeing one there. http://phpclasses.upperdesign.com/browse.html -Original Message- From: Higgy [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 25, 2001 4:51 AM To: [EMAIL PROTECTED] Subject: Mysql to CSV Hi, Does any one know of a scri

[PHP-DB] Compiled dBase Extension for Win32?

2001-09-13 Thread Thomas Kaeser
Hi! I am trying to find a compiled dBase library (php_dbase.dll) for PHP4; found many hints, but nothing useful. Thanks for your help! Thomas -- Thomas Kaeser [EMAIL PROTECTED] *** Courage is not the absence of fear, but rather the judgement that something else is more important than fear

[PHP-DB] Sybase Stored Procedures

2001-10-02 Thread Thomas Janke
for your help. Yours Thomas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

AW: [PHP-DB] Re: Table to BIG to dump, how ?

2001-12-18 Thread Thomas Lamy
Hi, If it's a php script dumping the data, have a look at the "max_execution_time" config variable. IIRC the default is 30 seconds, which you can override from within the running script with ini_set ("max_execution_time", 100000); Hope this helps. Thomas >

[PHP-DB] iODBC module for PHP on linux

2002-01-21 Thread Thomas Spellman
e compiled with support for php? Thanks for any help, Thomas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Creating mySQL database

2003-03-18 Thread Thomas Tremain
Can I create a mySQL user and PW from PHP Thomas Tremain www.LiveHost.net <http://www.livehost.net/>

[PHP-DB] korean characters out of ms sql

2003-06-08 Thread Thomas Zibolowski
I try to build a small webserver using php in cgi mode connecting to a mssql database. It works allready with 11 different languages. But now I try to read hangul (korean chars). Under IIS (same php config, same script, same database) I got the right characters out of the database. Trying to use my

[PHP-DB] Re: SQL Server connection error.

2003-06-08 Thread Thomas Zibolowski
Try using mssql "Russell Roberts-Spears" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > Hi, > > I am new to PHP DB code and am currently struggling with the connection to > SQL Server 2000. I am using ODBC and have created a System DSN with > integrated NT security specifiying

[PHP-DB] AGONIZING Mysql Select DB issue.

2003-08-15 Thread Thomas Deliduka
ata from "db2"? This only happens when I'm connecting from Server 2 to server 1 it does not happen any other time. Incidentally it doesn't happen when I'm connecting from server 2 to another server running mySQL 3.23.54 there is no problem at all. I'm thinking it's a p

Re: [PHP-DB] AGONIZING Mysql Select DB issue.

2003-08-17 Thread Thomas Deliduka
> default; you can override this action by specifying which DB handle to use > for a given query. Replace $dbh with $dbh2 to select from tables on the > second database. > > Peter > > On Fri, 15 Aug 2003, Thomas Deliduka wrote: > >>

Re: [PHP-DB] AGONIZING Mysql Select DB issue.

2003-08-18 Thread Thomas Deliduka
> select * from table1 > > use: > > select * from database1.table1 > > if that works, and the php command doesn't that may mean the the mysql client > lib is broken, although, I've been using it with mysql 4 and it seems to work > fine. > > -Micah >

Re: [PHP-DB] AGONIZING Mysql Select DB issue.

2003-08-18 Thread Thomas Deliduka
ish a link as if mysql_connect() was called > without arguments, and use it. > > Every subsequent call to mysql_query() will be made on the active > database. > > Peter > > On Fri, 15 Aug 2003, Thomas Deliduka wrote: > >> The ONLY way I have been able to work a

Re: [PHP-DB] AGONIZING Mysql Select DB issue.

2003-08-18 Thread Thomas Deliduka
gt; socket anyways. >> >> Something else to check; if you're using two logins, one for remote, one for >> local, verify that their database permissions are the same. -- Thomas Deliduka IT Manager - Xenocast Street Smart Media Solutions http://www.xe

[PHP-DB] PostgreSQL error with php

2005-06-26 Thread Thomas Bonham
Hello All, I’m trying to get php to connect to my PostgreSQL database. The code that I’m using is below. Login Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "auth" in /var/www/html/thomas/cis166a

[PHP-DB] PostgreSQL error with PHP

2005-06-26 Thread Thomas Bonham
Hello All, I’m trying to get php to connect to my PostgreSQL database. The code that I’m using is below. Login Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "auth" in /var/www/html/thomas/cis166a

[PHP-DB] PostgreSQL error with PHP

2005-06-26 Thread Thomas Bonham
Hello All, I’m trying to get php to connect to my PostgreSQL database. The code that I’m using is below. Login Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "auth" in /var/www/html/thomas/cis166a

[PHP-DB] PostgreSQL with php error

2005-06-26 Thread Thomas Bonham
Hello All, I’m trying to get php to connect to my PostgreSQL database. The code that I’m using is below. Login Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "auth" in /var/www/html/thomas/cis166a

[PHP-DB] Re: PostgreSQL error with PHP

2005-06-26 Thread Thomas Bonham
I modafide the code some more and now with the following code I get this error. CODE: Login Parse error: parse error, unexpected '=' in /var/www/html/thomas/cis166ae/database/secretdb.php on line 8 Thanks Thomas Bonham wrote: Hello All, I’m trying to

Re: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-26 Thread Thomas Bonham
Thanks for the help. The code now looks like this. CODE: Login And now the error I get is the following. Warning: pg_connect(): Unable to connect to PostgreSQL server: FATAL: IDENT authentication failed for user "auth" in /var/www/html/thomas/cis166a

Re: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-26 Thread Thomas Bonham
refused Is the server running on host "thomas.example.com" and accepting TCP/IP connections on port 5432? in /var/www/html/thomas/cis166ae/database/secretdb.php on line 10 Could not connect Thomas Robbert van Andel wrote: You might need to include the hostname and port. ---

Re: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-26 Thread Thomas Bonham
server running on host "localhost" and accepting TCP/IP connections on port 5432? in /var/www/html/thomas/cis166ae/database/secretdb.php on line 11 Connected Successfully Thomas Thomas Bonham wrote: I add the hostname and port, then I configure postgresql.conf and enable the port 54

Re: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-26 Thread Thomas Bonham
I think so. I'm going to go there my book (agin) and I'm also going to ask the head IT guy. Thanks for all of your help! Thomas Robbert van Andel wrote: Can you log into the PostgreSQL server from the console or command line? Are you sure you are using the right username, passwo

Re: [PHP-DB] Re: PostgreSQL error with PHP

2005-06-27 Thread Thomas Bonham
-- # CONNECTIONS AND AUTHENTICATION #------- # - Connection Settings - # Thomas Bonham 06-25-2005 #tcpip_socket = false tcpip_socket = yes max_connections = 100 # note: increasing max_connections costs about 500 bytes of shared # memory per connection slot,

[PHP-DB] Postgre SQL query error with PHP

2005-07-01 Thread Thomas Bonham
Warning: pg_query(): Query failed: ERROR: permission denied for relation property in /var/www/html/thomas/cis166ae/database/web_users/dan/newrow.php on line 20 Warning: Wrong parameter count for pg_num_rows() in /var/www/html/thomas/cis166ae/database/web_users/dan/newrow.php on line 21 As it show abov

Re: [PHP-DB] Postgre SQL query error with PHP

2005-07-02 Thread Thomas Bonham
ng offset: 1 in /var/www/html/thomas/cis166ae/database/web_users/dan/newrow.php on line 27 Notice: Uninitialized string offset: 2 in /var/www/html/thomas/cis166ae/database/web_users/dan/newrow.php on line 28 Notice: Uninitialized string offset: 3 in /var/www/html/thomas/cis166ae/database/web_users

Re: [PHP-DB] Postgre SQL query error with PHP

2005-07-04 Thread Thomas Bonham
Thanks for the help. It is working like it should. Next on the query parameters. Again Thanks for the help. Thomas On 7/2/05, Martín Marqués wrote: > El Sáb 02 Jul 2005 14:21, John DeSoi escribió: > > > > On Jul 2, 2005, at 9:17 AM, Thomas Bonham wrote: > > > > >

Re: [PHP-DB] User authentication and redirect

2005-07-14 Thread Thomas Dodson
ectly! #This script assumes a database named DATABASE, and that user data is stored in a table called users, with (at least) fields user, password, and email. The password column must be char(32) type to accept the encrypted pwd #Thomas Dodson [EMAIL PROTECTED] 24 May 2005 function d

Re: [PHP-DB] User authentication and redirect

2005-07-15 Thread Thomas Dodson
which need access control, and then put the following code at the beginning of the script: if(login_check($user, $pass) { //allow access, main script body here } else { //deny access echo "you aren't supposed to be here"; exit; } i hope i understood your probl

[PHP-DB] Inserting a php file into a mysql database

2005-12-25 Thread Thomas Bonham
Hello, I am trying to insert a php page into a database. I need to know if there is something that I need to do when setting up the table, also is there something to do with the code. Thank You for your help Thomas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

[PHP-DB] RE : ezmlm response

2007-03-06 Thread Thomas Woerly
reading my request. Thomas ___ Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des intern

[PHP-DB] RE : Re: [PHP-DB] pg_escape_bytea missing despite Postgre v.7.4.14

2007-03-06 Thread Thomas Woerly
Hello, Thanks for you reply. Yeah, sorry for the subjet, wrong manipulation from me. With a phpinfo(), I have pgsql section. Is it ok ? My version of PHP is 4.4.2, so this is ok too. pgsql PostgreSQL Support enabled Active Persistent Links 0 Active Links

[PHP-DB] RE : [PHP-DB] Re: RE : Re: [PHP-DB] pg_escape_bytea missing despite Postgre v.7.4.14

2007-03-07 Thread Thomas Woerly
Not at all. No version number for Postgres there. --- Chris <[EMAIL PROTECTED]> a écrit : > Thomas Woerly wrote: > > Hello, > > > > Thanks for you reply. Yeah, sorry for the subjet, wrong manipulation from > me. > > > > With a phpinfo(), I have pgsq

[PHP-DB] Re: Query executing

2007-10-05 Thread Thomas Tschernich
How would I know if this mySQL query: DELETE FROM `table` WHERE `date_to_be_deleted` LIKE '$todays_date' actually deleted any rows from the table? www.php.net/mysql_affected_rows Greetings, Thomas Tschernich -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, v

[PHP-DB] pdo::mysql and unbuffered queries

2007-10-05 Thread Thomas Tschernich
st of both worlds? Big thanks in advance, Thomas Tschernich -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Special chars & UTF-8: sometimes ok, sometimes wrong

2007-10-18 Thread thomas Armstrong
Hi. Working with PHP 4.4 and mySQL 4.1, I've got some texts stored in a UTF-8 table with special chars. I serve a UTF-8 header within my HTML, Apache is configured to serve UTF-8 and PHP scripts are saved in UTF-8 charset. However, sometimes I get 'España' and other times 'Espa�a'. The differen

[PHP-DB] Problem with PDO Mysql and FETCH::ASSOC

2009-03-19 Thread Thomas Robitaille
-+--+-+-----+---+ 6 rows in set (0.00 sec) Does anyone have any ideas as to what I might be doing wrong? Thanks for any help! Thomas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem with PDO Mysql and FETCH::ASSOC

2009-03-20 Thread Thomas Robitaille
Does anyone have any ideas as to what I might be doing wrong? Thanks for any help! Thomas First of all check if you are actually connecting to the same database both times. Start with printing $GLOBALS['database'] and see if it connects where you really want. You mention

[PHP-DB] Re: [PHP] goto - My comments

2010-12-18 Thread Thomas Anderson
On Sat, Dec 18, 2010 at 11:44 PM, Robert Cummings wrote: > On 10-12-19 12:17 AM, Ethan Rosenberg wrote: >> >> Dear List - >> >> Thanks to all for your EXCELLENT comments.  I definitly agree that >> goto is a command to be avoided at all costs. > > Closed-minded drivel (or you're buttering up the p

Re: [PHP-DB] Subject Matter

2013-08-26 Thread Thomas Rudy
There are a lot of off topic emails sent. But there is far more whining and complaining. Good grief! On Fri, Aug 23, 2013 at 2:40 PM, Tamara Temple wrote: > > On Aug 23, 2013, at 7:32 AM, Jim Giner > wrote: > > > On 8/23/2013 4:52 AM, Matt Pelmear wrote: > >> On 08/23/2013 04:36 PM, Lester Cain

[PHP-DB] PHP4 and MS SQL 2000

2001-03-25 Thread Thomas W. Badera
h a trusted SQL Server connection. (severity 14) in D:\Webs\sportspotonline.com\listItems.php3 on line 27 Any suggestions would be greatly appreciated... Thanks, --TWB --- Thomas W. Badera WebTeam Manager Clarkson University < [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php

RE: [PHP-DB] chmod on win xp

2004-01-17 Thread Thomas J. Rudd
How exactly are you wanting to "chmod" the file attributes? (with a script or in general?) -Original Message- From: mayo [mailto:[EMAIL PROTECTED] Sent: Saturday, January 17, 2004 2:17 PM To: php Subject: [PHP-DB] chmod on win xp so I would like to write to file on my local box. I've lo

RE: [PHP-DB] i want to unsubscribe

2004-01-18 Thread Thomas J. Rudd
See To unsubscribe, visit: http://www.php.net/unsub.php -Original Message- From: Mrs.Jomon [mailto:[EMAIL PROTECTED] Sent: Sunday, January 18, 2004 10:03 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] i want to unsubscribe hi, i am not concentrating php now nd i have to unsubscribe f

[PHP-DB] uploading

2002-01-27 Thread Thomas \"omega\" Henning
Hello how can i upload something from my hdd to the webserver using php? note: don't have ftp on the machine!! Thanks Thomas "omega" Henning -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAI

[PHP-DB] Re: uploading

2002-01-28 Thread Thomas \"omega\" Henning
thanks alot it helped "Thomas "Omega" Henning" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello how can i upload something from my hdd to the webserver using php? > > note: don't have ftp on the

[PHP-DB] Problem

2002-04-22 Thread Thomas \"omega\" Henning
Ok i have a problem big one. I'm using php 4.0.6 and mysql 3.23 both win. And i use PhpMyAdmin to fill my database but MySQL reject every query i post to it any idea why? Thanks Thomas "omega" Henning -- PHP Database Mailing List (http://www.php.net/) To unsubscri

Re: [PHP-DB] Problem

2002-04-22 Thread Thomas \"omega\" Henning
o answer > - Original Message - > From: Thomas "omega" Henning <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, April 22, 2002 11:25 AM > Subject: [PHP-DB] Problem > > > Ok i have a problem big one. I'm using php 4.0.6 and mysql 3.23

Re: [PHP-DB] Problem

2002-04-23 Thread Thomas \"omega\" Henning
well sorry 2 say but it was just an incompability between php and mysql php 4.1.2 fixed it :) "David Robley" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > (Thomas \"O

[PHP-DB] Syncing two tables in mysql

2002-05-11 Thread Thomas \"omega\" Henning
Hey all, Is there a way i can sync two tables in mysql on two totaly different servers over the internet via php4 or mysql? I'm using php4.0.6 thanks Thomas "omega" Henning -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Syncing two tables in mysql

2002-05-11 Thread Thomas \"omega\" Henning
And how can i use it? "Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > On Sunday 12 May 2002 01:34, Thomas \"omega\" Henning wrote: > > Hey all, > > > > Is there a way i can sync two tables in mysql on two totaly diff

[PHP-DB] system help!

2002-07-03 Thread Thomas \"omega\" Henning
sol script that runs a linux command from a normal input text box. With that same command it executes it and makes the tt.sql. And im not using exec() because i need to see the results of it thats why i use system() help pls Thomas "omega" Henning -- PHP Database Mailing List (ht

[PHP-DB] Saving to local computer

2002-07-09 Thread Thomas \"omega\" Henning
192.168.10.11's computer to C:\program files\ dir. Any way i can do this?? Thomas Henning -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Need help urgent!!

2002-09-26 Thread Thomas \"omega\" Henning
I'm using PHP4.2.2 Win with MySQL 3.2.52 Win and PHP doesn't pass vars from 1 php to the other how i fix it? Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] wildcard in mysql search with php

2001-10-18 Thread Thomas \"omega\" Henning
Hello all, Is there a way to use wildcards in search in a mySQL db? e.g. I have a dbase of over 24000 records and i can only search exact matches is there a way to search something like this : *admin* in mySQL? Or i have to do it by hand in PHP? Thanks Sir Thomas "omega" Henning

[PHP-DB] Re: Highlighting search results ???

2001-10-18 Thread Thomas \"omega\" Henning
Thanks Tomy for the idia i could use the same code for my search programs Sir Thomas "omega" Henning "Chris Payne" <[EMAIL PROTECTED]> wrote in message news:000c01c15736$49ea31e0$0200a8c0@chris... Hi there everyone, I'm becoming regular on here hehehe :-) I have

Re: [PHP-DB] wildcard in mysql search with php

2001-10-18 Thread Thomas \"omega\" Henning
thanks "Dave Watkinson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... select from where like '%searchword%' RTFM!!! -Original Message- From: Thomas "omega" Henning [mailto:[EMAIL PROTECTED]] Sent

[PHP-DB] WildCard ok How bout search in blob?

2001-10-19 Thread Thomas \"omega\" Henning
Hello all again, I forgot to ask that with wild card i can search in blobs to? like select * from text where text like '%admin%' ?? Thanks Sir Thomas "omega" Henning -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additio

[PHP-DB] Re: [PHP-WIN] MSSQL connect

2001-12-26 Thread Thomas \"omega\" Henning
Here is the problem $sql != $sql_temp so the $result = NULL; because mssql_query(" ") has no query to send to the MsSQL server. This should work try it out!!! Thomas "omega" Henning -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTE

[PHP-DB] MyODBC on Linux or Windows

2001-12-26 Thread Thomas \"omega\" Henning
Hello All, I'v writen a program in PHP4.0.6+MySQL and its working on a linux machine. I'm trying to print from Crystal Report through MyODBC. Where i have to install MyODBC on my linux machine or windows machine? Thanks for all help Thomas "omega" Henning -- PHP Databas

  1   2   >