Re: [PHP-DB] Update multiple records

2005-01-11 Thread Martin Norland
('fieldname') was for last pulled rows value of this field or similar and was for pulling record by record. Cheers, - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research

Re: [PHP-DB] mysql - image storing

2005-01-18 Thread Martin Norland
this - such as the latest mysqli bind functions) - otherwise the query is invalid. You may be thinking of running 'htmlentities' when retrieving data - which is necessary in some cases, depending on where you're using it (most notably - in html where you don't want html output). Cheers, -- - Martin Norland, Database

Re: [PHP-DB] mysql - image storing

2005-01-18 Thread Martin Norland
option? Still, there are perfectly valid reasons to have multiple ''s. (why, there's one now - sort of...) Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's

Re: [PHP-DB] Returns Blank

2005-01-20 Thread Martin Norland
quoting to add the variables here: $query = SELECT credits FROM krypto WHERE user = '$user' AND pass = '$pass'; will work fine. Variables embedded in double quotes are expanded - though with arrays you will need to enclose them in {$curlies['foo']}. Cheers, -- - Martin Norland, Database / Web

Re: [PHP-DB] php5 busts php4 code

2005-01-20 Thread Martin Norland
, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] LEFT joins

2005-01-20 Thread Martin Norland
://dev.mysql.com/doc/mysql/en/EXPLAIN.html Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Returns Blank

2005-01-20 Thread Martin Norland
`user`='$user' AND `pass`='$pass'; You'll want to try to read your error messages a little harder in the future, FWIW. Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude

Re: [PHP-DB] Auto Responses?

2005-01-24 Thread Martin Norland
if anyone has a spare ...? Done. Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] last record

2005-01-25 Thread Martin Norland
new. Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] brackets []

2005-01-25 Thread Martin Norland
, instead of just reading the data you need from where it is. Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List

Re: [PHP-DB] Double Inserts

2005-01-25 Thread Martin Norland
you with utmost certainty that the solution is 42 /cant-help-myself [snip] In all fairness, I'd say Bastien is a frood who really knows where his towel is[1]. He's surely finishing up his apprenticeship. 1 http://hhgproject.org/entries/towel.html Cheers, -- - Martin Norland, Database / Web

Re: [PHP-DB] IIS, PHP, and session data

2005-01-25 Thread Martin Norland
, and that it's actually on in your testbed and you're mistaken. Someone with more IIS experience - please feel free to chime in. It could just be some horrible common problem. Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email

Re: [PHP-DB] storing images in database

2005-01-25 Thread Martin Norland
$of $single $quotes!'; // echo 'img src=./path/to/image.php?id='.$id.''; // echo 'img src=?id='.$id.''; } shed_light(); ? Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude

[PHP-DB] Notice for those running MySQL on Windows

2005-01-27 Thread Martin Norland
anyone would *want* on their box. Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Re: [PHP] Re: [PHP-DB] Developer needed in London

2005-01-28 Thread Martin Norland
day long - afaik it's fairly high traffic, yes?) Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http

Re: [PHP-DB] Hyphens and MySQL

2005-01-28 Thread Martin Norland
these values, you should be having no problem. e.g. INSERT into TABLE_FOO (colname) values ('-'); but this will error: INSERT into TABLE_FOO (colname) values (-); Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do

Re: [PHP-DB] odd results when running this

2005-01-28 Thread Martin Norland
, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] database connectivity problem

2005-02-01 Thread Martin Norland
php might need to store the connection record externally (if applicable) is writable? Unfortunately - you may not be alone: http://bugs.php.net/bug.php?id=30721 http://bugs.php.net/bug.php?id=17489 Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257

Re: [PHP-DB] Re: Warning: ocilogon(): _oci_open_server: รข in d:\program files\apachegroup\apache\htdocs\codebase\oci8test2.php on line 3

2005-02-01 Thread Martin Norland
- that is that the example code is there to make sure things are working, and then to start changing it - get a good baseline, and work from there. Sound advice - would that more heeded it. Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email

Re: [PHP-DB] database connectivity problem

2005-02-02 Thread Martin Norland
to the group. suExec might also be of some worth. I'm sure there are solutions other than running apache as user sybase. Still - glad it's working for you at least! Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do

Re: [PHP-DB] insert (database)

2005-02-02 Thread Martin Norland
attention to detail. (or in some cases newer versions of software, which explicitly allow only one statement per call). Finally - the concept of bind variables (or equivalent) are your friend (as Jochem already knows with firebird iirc). Cheers, -- - Martin Norland, Database / Web Developer

Re: [PHP-DB] Programmer required

2005-02-02 Thread Martin Norland
, was to find someone desperate - perhaps they've proposed this project multiple times and nobody wants to touch it :) I didn't know you could say off topic on this list... guess you just can't say its abbreviated form in the subject or - ah heck, who knows. Cheers, -- - Martin Norland, Database / Web

Re: [PHP-DB] mysql 4.1-4.0

2005-02-02 Thread Martin Norland
) from client where prim_id=1; Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] PHP5 classes mysql bug ?

2005-02-03 Thread Martin Norland
$this-mysql_result etc. dynamic variables are very handy however. You'll find yourself using them a lot if you have lots of similar tables/etc. that you need to write the same 'thing' for over and over again. Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s

Re: [PHP-DB] mysqli connection problem

2005-02-07 Thread Martin Norland
tell you what the default for your system is, but there are php functions to get configuration options, if you don't have it in any obvious places. Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily

Re: [PHP-DB] javascript and php

2005-02-08 Thread Martin Norland
sane packaged dropdown code should be explicit about requiring the user to use onload to instantiate things. Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's

Re: [PHP-DB] mysqli connection problem

2005-02-08 Thread Martin Norland
, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http

Re: [PHP-DB] Reg Exp to change c:\dir\dir\pic.jpg to dir/pic.jpg - to upload image path

2005-02-10 Thread Martin Norland
to go along with the images for your users, instead of trying to match their organization with yours. Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research

Re: [PHP-DB] Reg Exp to change c:\dir\dir\pic.jpg to dir/pic.jpg- to upload image path

2005-02-10 Thread Martin Norland
will agree. No browser I've ever seen sends C:\pics\subdir\pic1.jpg. It will *display* that to the user, but it doesn't submit the local path, it just uploads the file and gives the filename. Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained

Re: [PHP-DB] Reg Exp to change c:\dir\dir\pic.jpg to dir/pic.jpg-to upload image path

2005-02-10 Thread Martin Norland
searching archives and the likes. It's just polite :) (this is part of why I try to always set the reply-to to the list) Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those

Re: [PHP-DB] Join on single table

2005-02-11 Thread Martin Norland
, b.score FROM tablename AS a, tablename AS b WHERE a.app_id != b.app_id AND a.word = b.word; Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research

Re: [PHP-DB] Excel headers not working anymore

2005-02-11 Thread Martin Norland
, and (IE in particular) has real issues with storing the output of a no-cache'd https - you can't save it locally or open with an external application, because either way it has to store it somewhere other than memory, which would be caching. Cheers, -- - Martin Norland, Sys Admin / Database / Web

Re: [PHP-DB] Store $_SESSION in MySQL table

2005-02-11 Thread Martin Norland
a class to store this information, if you wanted - so long as you have the class include()'d before you unserialize the object. In all likelihood, however, you'll prefer just the straight $_SESSION. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257

Re: [PHP-DB] Excel headers not working anymore

2005-02-11 Thread Martin Norland
, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] Database visible via mysql CLI but not MOD_PHP with same username

2005-02-15 Thread Martin Norland
. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Re: checkbox into mysql using php input type=checkbox name=list

2005-02-17 Thread Martin Norland
the foreach's scope. Stick with the foreach imo, since you don't need the counter. (you can get it back by using your foreach, the counter is the $game = part - in my example I left it out since it's unnecessary. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach

Re: [PHP-DB] Intermittent odbc_connect() problem with iodbc/openlink

2005-02-17 Thread Martin Norland
that, and increase memory_limit in your php.ini if this is the case. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database

Re: [PHP-DB] Notice: Undefined index: op

2005-02-22 Thread Martin Norland
at the beginning of the line (no tabs/etc. :( ) ... EOF; it basically echo's until it sees that delimiter, that could be EOD or STOP or whatever (well, there might be reserved words issues - I could more easily check if I could remember the name of the quoting style...) Cheers -- - Martin Norland

Re: [PHP-DB] Notice: Undefined index: op

2005-02-22 Thread Martin Norland
for the first one. Bret Your vote is misplaced - the first one isn't what he wanted... with that statement, his form will never be printed and it can never be set. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within

Re: [PHP-DB] boolean values in postgresql

2005-02-23 Thread Martin Norland
want to use their boolean, is leaving the boolean and always selecting it as: SELECT (boolean_field = 't') AS boolean_field FROM table; of course, using a smallint will work 'universally' if you ever changed databases - which may or may not be of interest. Cheers, -- - Martin Norland, Sys Admin

Re: [PHP-DB] password in md5 to connect to mysql instead of clear password

2005-02-25 Thread Martin Norland
your password in an included file outside of the webroot. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database

Re: [PHP-DB] MySQLPHP decrypt(password)

2005-02-25 Thread Martin Norland
of authentication. Traditionally this is done with mailing a user a password reset link, and having that link only available for a short period of time. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do

Re: [PHP-DB] most popular places

2005-02-25 Thread Martin Norland
though. This should get you pointed in the right direction if you aren't already (note - sql is untested, and I always hose my GROUP BY's on the first try - but it should be close :) ) Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s

Re: [PHP-DB] password in md5 to connect to mysql instead of clear password

2005-02-25 Thread Martin Norland
to connect using this MD5 hash of the password - anyone who could read that script could similarly just connect using the MD5. Store your password in an included file outside of the webroot. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s

Re: [PHP-DB] Pear help

2005-02-28 Thread Martin Norland
somewhere. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] Pear help

2005-02-28 Thread Martin Norland
Craig Hoffman wrote: Thanks for getting back to me... Comments below - On Feb 28, 2005, at 10:49 AM, Martin Norland wrote: Craig Hoffman wrote: Hi There, I'm trying to configure my OS X box to work with PEAR. Everything seems to be working (updating PEAR libraries, etc.) except when I run my

Re: [PHP-DB] PHP form processing

2005-02-28 Thread Martin Norland
Ron Piggott wrote: Is there a way to find out the IP address of the computer submitting a form --- other than through a cookie. Is there a header command or something like this? Ron Response: rtfm / wrong list Answer: for Apache, $_SERVER['REMOTE_ADDR']; Cheers, -- - Martin Norland, Sys Admin

Re: [PHP-DB] Updating many records at a time

2005-03-01 Thread Martin Norland
you could just have an ORDER BY product_group, product_name or some such. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital

Re: [PHP-DB] php5-sessions next

2005-03-02 Thread Martin Norland
: ; Log errors to specified file. ;error_log = filename ; Log errors to syslog (Event Log on NT, not valid in Windows 95). error_log = syslog /longwindedrant Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained

Re: [PHP-DB] preg_match html tags

2005-03-02 Thread Martin Norland
clearer for the mailing list // also helps in case offsets are a little strange. $length = $end - $start; $what_i_want = $substr($fpRead($start,$length)); cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do

Re: [PHP-DB] php5-sessions next

2005-03-03 Thread Martin Norland
!), but it's just not feasible with my existing projects. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing

Re: [PHP-DB] Copying a set of database records

2005-03-04 Thread Martin Norland
, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] Shopping Cart

2005-03-07 Thread Martin Norland
without the human factor. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] data grabbing and mathematics!

2005-03-07 Thread Martin Norland
to ask is, will this be something that cycles yearly or regularly? If so, you'll want to be storing some identifier for the event/session/quarter/year/etc. - in which case any join option would be insanely further compliated, and all of your queries would need the chunk added. Cheers, -- - Martin

Re: [PHP-DB] regex question

2005-03-07 Thread Martin Norland
sitting here wondering if ?* and ?+ are interchangeable, and thinking so. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP

Re: [PHP-DB] Re:data grabbing and mathematics!

2005-03-07 Thread Martin Norland
(for example ;-) [snip] One should be indexing all their tables properly :P All good valid points, well said. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude

Re: [PHP-DB] Shopping Cart

2005-03-07 Thread Martin Norland
'GROUP BY' clause and have at it. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] mysql, php error

2005-03-07 Thread Martin Norland
- but that's the gist of it. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] mysql_num_rows

2005-03-08 Thread Martin Norland
as a number not as a select blah - it's a result resource, a pointer of sorts). More likely is the query is invalid, go ahead and print_r() the variable being passed to mysql_num_rows() on line 61 (put it before the mysql_num_rows call) and see what info you get back in there. cheers, -- - Martin

Re: [PHP-DB] big data base

2005-03-09 Thread Martin Norland
, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] Merge result set of query?

2005-03-09 Thread Martin Norland
but doesn't return the full result - instead it just returns a resource to the result, so you can get it as you need it. I suggest you start from that information and work forward. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s

Re: [PHP-DB] Merge result set of query?

2005-03-09 Thread Martin Norland
Jochem Maas wrote: Martin Norland wrote: ioannes wrote: My first attempt was to use $result=array_merge($result1,$result2) - doesn't work. 'not a valid resource' I have two databases with different connections, so MySQL UNION query would not work. How do I merge the result set of the queries

Re: [PHP-DB] Variable Variable Array

2005-03-10 Thread Martin Norland
to be analyzed in, especially when dealing with arrays and the likes. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP

Re: [PHP-DB] Variable Variable Array

2005-03-10 Thread Martin Norland
, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] grabbing data from other peoples sites

2005-03-16 Thread Martin Norland
may mistype things - new buildings are created - roads are renamed, etc. Someone should contact maps.google.com and see about adding this sort of information to that :) Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained

Re: [PHP-DB] grabbing data from other peoples sites

2005-03-17 Thread Martin Norland
fp, then move on to doing what you need - instead of doing your database stuff right away. */ echo fgets($fp, 4096); } //close fp - we are done with it fclose($fp); } Cheers, -- - Martin Norland, Sys

Re: [PHP-DB] grabbing data from other peoples sites

2005-03-17 Thread Martin Norland
the migraine of trying to read unsplit code. Cheers, Martin Norland wrote: Perry, Matthew (Fire Marshal's Office) wrote: I guess my real question is how to parse the output from someone else's site. Setting up the lookup procedure from data in my database and filling their form with the address is the easy

Re: [PHP-DB] Re: paginating : optimising queries

2005-03-22 Thread Martin Norland
. But if you get to page 99, you'll likely find this is faster. Feel free to do your own tests, many factors can change all of these findings, and it's best to match them to suit your own scenario. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257

Re: [PHP-DB] Re: paginating : optimising queries

2005-03-22 Thread Martin Norland
related to using pagination in a general sense - e.g. a class you create for pagination, that can paginate any manner of query cleanly. If you're dealing solely with hard-coded / hand-crafted queries, you can obviously build your pagination to fit. cheers, -- - Martin Norland, Sys Admin / Database

Re: [PHP-DB] Re: paginating : optimising queries

2005-03-22 Thread Martin Norland
On a side note, who's sick of seeing the word optimizing misspelled in the title? :) Ah, the things we do to keep a thread clean. -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent

Re: [PHP-DB] Re: paginating : optimising queries

2005-03-22 Thread Martin Norland
discussion... cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] Re: paginating : optimising queries

2005-03-22 Thread Martin Norland
/apologies to Scott Adams) cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Re: paginating : optimising queries

2005-03-22 Thread Martin Norland
the wider concern.) cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] database connection timeout

2005-03-24 Thread Martin Norland
long. Just be sure not to set_time_limit() for your whole set of scripts, unless you really want them to abort after the 5 or 10 second limit you're setting ocilogon (unlikely). cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained

Re: [PHP-DB] database connection timeout

2005-03-24 Thread Martin Norland
try the fsockopen connection test on the oracle port. Thanks for your help. Welcome to the list! cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's

Re: [PHP-DB] Why not ?

2005-03-24 Thread Martin Norland
.game1='H' AND round1.username=tipping.username AND tipping.username='jerry'; cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP

Re: [PHP-DB] Command Line Error

2005-03-28 Thread Martin Norland
.] cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Command Line Error

2005-03-28 Thread Martin Norland
Martin Norland wrote: 00 8-19/2 * * mon-fri /usr/bin/php /foo/backup_script.php I should have mentioned this - this runs twice an hour Monday through Friday, between the hours of 8am and 7pm. You would more likely prefer 05 1* * * your_command which would run at 1:05am every day. use

Re: [PHP-DB] Sybase CALL statement problems

2005-03-29 Thread Martin Norland
in the first place. definitely check all logs. twice. Incidentally, what is with the parameters to mladselmeans - it looks very strange :) cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily

Re: [PHP-DB] Sybase CALL statement problems

2005-03-29 Thread Martin Norland
. http://www.php.net/odbc_longreadlen mentions truncation, but it's talking about TEXT/BLOB and the likes, since you *can* get the full results, I doubt this is meaningful. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within

Re: [PHP-DB] Slow access Apache + PHP + MySQL

2005-03-30 Thread Martin Norland
a web browser running on it, and see if you still see the same issues (if possible). Try this after ruling out the important stuff, as these issues are unlikely if you literally just swapped a machine out with the config the same. cheers, -- - Martin Norland, Sys Admin / Database / Web

Re: [PHP-DB] Re: Just can't get it to work.. variables

2005-03-30 Thread Martin Norland
, Oct/Nov/Dec should have worked previously afaik, PHP is fairly forgiving. You can probably also get away with just using round() to get your integers where you need them, instead of the declaration above. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach

Re: [PHP-DB] find a value in entire table...

2005-04-06 Thread Martin Norland
into the user_department_interactions table, if you only ever want to store whether they interacted at all, you can set constraints and catch the error on insert, or search before inserting. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained

Re: [PHP-DB] using POST data for a readfile

2005-04-13 Thread Martin Norland
mel list_php wrote: Thank you very much! [snip] I didn't get the base tag though, what does that mean? It was merely a cautionary warning about sites that force a base href for relative URIs (including, of course, URLs) See: http://www.w3.org/TR/html4/struct/links.html#h-12.4 cheers, -- - Martin

Re: [PHP-DB] Counting HTML Lines

2005-04-15 Thread Martin Norland
you cater your output more to be predictable. Also, remember to account for htmlentities if that's an issue, = amp;, etc. Really not a fun solution to entertain, IMO. Good luck! cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s

Re: FW: [PHP-DB] mime-type related to extension?. .

2005-04-27 Thread Martin Norland
, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] Memory. .

2005-04-27 Thread Martin Norland
then have two copies of your entire data. If you need to pull your whole set of results out into an array, you can immediately use pg_free_result() or mysql_free_result() afterwards to free up the copy using memory in the database. cheers, -- - Martin Norland, Sys Admin / Database / Web

Re: [PHP-DB] php3 and oracle9i client libraries doesn't compile. .

2005-04-28 Thread Martin Norland
, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] php3 and oracle9i client libraries doesn't compile.... . .

2005-04-28 Thread Martin Norland
, it's happened before. Incidentally, why does PHP need: Professional Services Automation Personal Security Advisor Public Safety Announcement Python Software Activity Port Scan Attack ( 3 letter abbreviations are way too crowded :P ) cheers, -- - Martin

Re: [PHP-DB] Headers sent error msg on one server but not the other.... .

2005-04-28 Thread Martin Norland
kind of header, wrapper, server-side include, or anything around the script - or perhaps you're making use of output buffering and the server isn't allowing its use? cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within

Re: [PHP-DB] Headers sent error msg on one server but not the other ...... .

2005-04-29 Thread Martin Norland
(and how your backend is written) could throw someone or something into a state of confusion. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research

Re: [PHP-DB] URL question. .

2005-05-02 Thread Martin Norland
could also just alias it / etc. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Problems with a script. .

2005-05-02 Thread Martin Norland
. Once that's all fixed, go to step 5. 5) rewrite all the database accesses to prevent people from doing sql injection attacks and ruining everything. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email

Re: [PHP-DB] Transfering post data to a series of pages. .

2005-05-04 Thread Martin Norland
be turned into function calls or classes and called from Page4.php. You don't need to separate logic and display in separate scripts that you push everything at, just separate your logic out into function calls. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International

Re: [PHP-DB] Transfering post data to a series of pages. .. .

2005-05-04 Thread Martin Norland
Martin Norland wrote: include() :P seriously though, Page1.php and Page4.php are the only two pages that should exist, if any. Page2 and Page3 should pretty much guaranteed be turned into function calls or classes and called from Page4.php. You don't need to separate logic and display

Re: [PHP-DB] database synchronization. .

2005-05-12 Thread Martin Norland
or not the servers can always be on. Is it possible to have a delay on the updating of information - to have a master server for the writes, and local slave servers at each site for just reads - or are writes too common a change? Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer

Re: [PHP-DB] problems with a script. .

2005-05-12 Thread Martin Norland
, and might be better off looking for a new host or setting up php5 on your current host (either you or them installing it, more likely you'll have to if it's even allowed). cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within

Re: [PHP-DB] problems with a script. .

2005-05-16 Thread Martin Norland
variables that are coming from get/post - e.g. if (isset($submit)) { becomes if (isset($_POST['submit'])) { and the likes. It's odd that your PHP 5 installation has this enabled - the default changed to it being off in PHP 4.2.0, and certainly hasn't changed back. cheers, -- - Martin Norland

Re: [PHP-DB] php line error. .

2005-05-16 Thread Martin Norland
)? no. (but the line with the include() call counts normally 3. are d parts of the file that are not in php (i mean that are not contained within the php delimeters) also counted? yes. in short, it's the line number of the script as if it were a plain text file. cheers, -- - Martin Norland, Sys Admin

Re: [PHP-DB] php line error. .

2005-05-17 Thread martin . norland
)? no. (but the line with the include() call counts normally 3. are d parts of the file that are not in php (i mean that are not contained within the php delimeters) also counted? yes. in short, it's the line number of the script as if it were a plain text file. cheers, -- - Martin Norland

  1   2   >