Re: [PHP-DB] Update multiple records

2005-01-11 Thread Martin Norland
r you need to access the property of the object that stores the whole result set/etc.). Whatever the case - I'm like 95% sure that ->Fields('fieldname') was for "last pulled rows value of this field" or similar and was for pulling record by record. Cheers, - Martin Norl

Re: [PHP-DB] ssh tunneling with phpmyadmin

2005-01-11 Thread Martin Norland
Graham Anderson wrote: Wow that actually worked :) and was quite easy...too easy ! now even the relational features work installed on my local laptop one last question on this matter... is there an automatic script you can run that gives the password too... something I can put in my startup items ?

Re: [PHP-DB] mysql - image storing

2005-01-18 Thread Martin Norland
#x27;re not using a mechanism that already handles 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 (m

Re: [PHP-DB] mysql - image storing

2005-01-18 Thread Martin Norland
for Sybase and CSV yes, otherwise no (in general). Maybe it's a compatibility 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 o

Re: [PHP-DB] Returns Blank

2005-01-20 Thread Martin Norland
;" . $pass . "'"; Just as a point of information, you don't need to break out of your quoting to add the variables here: $query = "SELECT credits FROM krypto WHERE user = '$user' AND pass = '$pass'"; will work fine. Variables embedded in

Re: [PHP-DB] php5 busts php4 code

2005-01-20 Thread Martin Norland
we'll see if we can't help you better. 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://www.php.net/unsub.php

Re: [PHP-DB] LEFT joins

2005-01-20 Thread Martin Norland
as help you in optimizing indices and queries. http://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 Hospi

Re: [PHP-DB] Returns Blank

2005-01-20 Thread Martin Norland
to backtick the database fields themselves. $query = "SELECT credits FROM krypto WHERE `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,

Re: [PHP-DB] Auto Responses?

2005-01-24 Thread Martin Norland
ig into their madhatter javascript used in the clientside interface and learn a few tricks. so 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.

Re: [PHP-DB] last record

2005-01-25 Thread Martin Norland
row, then move to 0 and do your while. Neat - learned something 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 Ma

Re: [PHP-DB] brackets []

2005-01-25 Thread Martin Norland
like you're over-munging your data trying to get something out of it formatted just so, 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 necessari

Re: [PHP-DB] Double Inserts

2005-01-25 Thread Martin Norland
lution is 42 [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 Developer, International Outreach x3257 The o

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

2005-01-25 Thread Martin Norland
your problem *is* register_globals being off, 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, Internation

Re: [PHP-DB] storing images in database

2005-01-25 Thread Martin Norland
o '$wont $output $variables $values $because $of $single $quotes!'; // echo ''; // echo ''; } shed_light(); ?> Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily repres

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

2005-01-27 Thread Martin Norland
thing 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.ph

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

2005-01-28 Thread Martin Norland
'at the ready' for support all 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 Rese

Re: [PHP-DB] Hyphens and MySQL

2005-01-28 Thread Martin Norland
a string in PHP? If you're quoting 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

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

2005-01-28 Thread Martin Norland
o print just once, and have a counter that sets the image to load (and if the counter goes beyond 3 - either have it not display the image, or add more images :), or limit the query to only return the latest three (add "limit 0, 3" to the query) ) Cheers, -- - Martin Norland, Database /

Re: [PHP-DB] database connectivity problem

2005-02-01 Thread Martin Norland
], and that wherever 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, Internat

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
the suggestion that he check whether he should be passing more arguments to the function. You make a good point - 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 i

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 em

Re: [PHP-DB] insert (database)

2005-02-02 Thread Martin Norland
itly 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, International Outreach x3257 The opinion(s) contained within this email do not neces

Re: [PHP-DB] Programmer required

2005-02-02 Thread Martin Norland
w years, 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, -- -

Re: [PHP-DB] mysql 4.1-4.0

2005-02-02 Thread Martin Norland
e),id) 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 u

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

2005-02-03 Thread Martin Norland
e class. Namely, $this->who_fricking_knows. (technically $this->null I suppose... interesting question, don't feel like creating a dummy class just to find out though). $this->$mysql_link should have been $this->mysql_link $this->$mysql_result should have been $this->mysql_result

Re: [PHP-DB] mysqli connection problem

2005-02-07 Thread Martin Norland
sqli.default_socket to the same as the mysql.default_socket. I can't 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, Internatio

Re: [PHP-DB] javascript and php

2005-02-08 Thread Martin Norland
probably can find better. Any 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 repres

Re: [PHP-DB] mysqli connection problem

2005-02-08 Thread Martin Norland
l 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 represent

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
viding keywords, categories, folders or labels 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

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
owser 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 opini

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
s / solutions / clarification when 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

Re: [PHP-DB] Join on single table

2005-02-11 Thread Martin Norland
.app_id, b.resource_id, b.word, 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 o

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

2005-02-11 Thread Martin Norland
because sessions force no-cache, 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, --

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

2005-02-11 Thread Martin Norland
even create 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, Int

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

2005-02-11 Thread Martin Norland
ate'); header('Pragma: private'); // allow private caching header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // set to be modified 'now' session_cache_limiter("private, must-revalidate"); // allow private caching, but

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

2005-02-15 Thread Martin Norland
sql server. Apologies that this may not be very useful, but your problem is extremely odd - if it's *not* a permissions / database error. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not

Re: [PHP-DB] Re: checkbox into mysql using php

2005-02-17 Thread Martin Norland
and the for($i= code above are both there to accomplish the same thing, but $value stores the last seen value, so it would have looked as if you were still inside 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,

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

2005-02-17 Thread Martin Norland
te # bytes " type message in the error log. Check 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

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

2005-02-22 Thread Martin Norland
<< ... the rest of your stuff, then on its own line right 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

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

2005-02-22 Thread Martin Norland
_POST['op']) || $_POST['op'] != 'ds') I vote 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 / We

Re: [PHP-DB] boolean values in postgresql

2005-02-23 Thread Martin Norland
ou have, if you really 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 interes

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 Dat

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

2005-02-25 Thread Martin Norland
her method 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 thi

Re: [PHP-DB] most popular places

2005-02-25 Thread Martin Norland
sible 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 x325

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

2005-02-25 Thread Martin Norland
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
ur own custom, or some frameworks?). You may also try changing it to require_once, in case something is already require'ing it. The error is clearly stating that there's already a "class DB" defined. It's defined somewhere. Cheers, -- - Martin Norland, Sys Admin /

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 ru

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,

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

2005-03-01 Thread Martin Norland
ated ordering, they're manually ordered for some reason? If it's not 'we want to manually order them' - In a products database, I would think you could just have an "ORDER BY product_group, product_name" or some such. Cheers, -- - Martin Norland, Sys Admin / Databas

Re: [PHP-DB] php5-sessions next

2005-03-02 Thread Martin Norland
--- you'll want to couple this with some of the following: ; 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 / We

Re: [PHP-DB] preg_match html tags

2005-03-02 Thread Martin Norland
fpRead, "Purpose"); $end = strpos($fpRead, "", $start); // make what we're doing 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 /

Re: [PHP-DB] php5-sessions next

2005-03-03 Thread Martin Norland
ove to turn it on for a new project (though I might end up turning it right back off!), 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 necess

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

2005-03-04 Thread Martin Norland
n of insert and select? [snip] Optionally, you could do it in multiple queries using a temporary table. Yes it's not a single mysql query, but it doesn't have to pop out and do any iteration in PHP, which does keep it cleaner and more organized. Cheers, -- - Martin Norland, Sys Admin /

Re: [PHP-DB] Shopping Cart

2005-03-07 Thread Martin Norland
rt. Your interface won't get the testing it would otherwise, but it will sure save a huge heap of hours, for someone at least. If you get updates in digital form, you can always diff them and just add the new bits. The error rate approaches zero much faster without the human factor. Cheers, -- -

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

2005-03-07 Thread Martin Norland
pliated, and all of your queries would need the chunk added. 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 Ma

Re: [PHP-DB] regex question

2005-03-07 Thread Martin Norland
- but rest assured, that's your problem. now I'm 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 repres

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

2005-03-07 Thread Martin Norland
es up no space if a (new) user hasn't completed any rounds (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 w

Re: [PHP-DB] Shopping Cart

2005-03-07 Thread Martin Norland
M student -> GROUP BY student_name; """ The default separator is the comma. Just toss in a 'GROUP_CONCAT(year) AS year' and appropriate 'GROUP BY' clause and have at it. Cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International

Re: [PHP-DB] mysql, php error

2005-03-07 Thread Martin Norland
; Without the exact code, I can only give you examples of about how it should look - 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

Re: [PHP-DB] mysql_num_rows

2005-03-08 Thread Martin Norland
rint_r 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 t

Re: [PHP-DB] big data base

2005-03-09 Thread Martin Norland
It all depends on the system requirements, your budget, and your time. 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 Hosp

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

2005-03-09 Thread Martin Norland
your query to the database, the database does the query 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

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

Re: [PHP-DB] Variable Variable Array

2005-03-10 Thread Martin Norland
#x27;woopsie!'; to the top of your script and running it. - echo ${$VarName}['second']; is what you want - you want to be very clear what order these things need to be analyzed in, especially when dealing with arrays and the likes. Cheers, -- - Martin Norland, Sys Admin / Dat

Re: [PHP-DB] Variable Variable Array

2005-03-10 Thread Martin Norland
no clue if that's the 'accepted' term for them. Makes sense to me, though. 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 Res

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

2005-03-16 Thread Martin Norland
nt covered address on file, people 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 Outr

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 Admin / Datab

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

2005-03-17 Thread Martin Norland
avoid 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 wit

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

2005-03-22 Thread Martin Norland
than just running the single query. 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 /

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

2005-03-22 Thread Martin Norland
- any standard sql engine will support the same features) My statements were always 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

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 repr

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

2005-03-22 Thread Martin Norland
sense, honest!) Now back to your regularly scheduled international 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 Hosp

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

2005-03-22 Thread Martin Norland
y. Elbonian spelling. (tribute/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 Ma

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

2005-03-22 Thread Martin Norland
es I know it (the correct British spelling) is still English - but it does open 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 Chil

Re: [PHP-DB] database connection timeout

2005-03-24 Thread Martin Norland
set_time_limit() to make sure it doesn't run too 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 Devel

Re: [PHP-DB] database connection timeout

2005-03-24 Thread Martin Norland
s prematurely]. Definitely try the fsockopen bit first, and give it a few go's if it's not working. I'll 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, In

Re: [PHP-DB] Why not ?

2005-03-24 Thread Martin Norland
ERE round1.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 Childre

Re: [PHP-DB] Command Line Error

2005-03-28 Thread Martin Norland
from cron and pass it this script. (In either case, 00 8-19/2 * * mon-fri /usr/bin/php /foo/backup_script.php [if you aren't suppressing output properly, you can also do this] 00 8-19/2 * * mon-fri /usr/bin/php /foo/backup_script.php > /dev/null [though it's better to suppress output p

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
Anthony Robins wrote: When retrieving ODBC results from Sybase SQL Anywhere 6 and 9 from a CALLed procedure, the output to the browser is being arbitrarily truncated. $DataSourcePassword = "pass"; $DataSourceName = "source"; $ODBCConnect = odbc_connect($DataSourceName,$DataSourceUserID,$DataSou

Re: [PHP-DB] Sybase CALL statement problems

2005-03-29 Thread Martin Norland
ly screams it's a buffering problem IMO. 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, Inte

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

2005-03-30 Thread Martin Norland
problem - like a bum cable, a bad hub, or a conflicting IP address. Try using the system locally, off 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 mac

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

2005-03-30 Thread Martin Norland
gt; "Jun", "07" => "Jul", "08" => "Aug", "09" => "Sep", "10" => "Oct", "11" => "Nov", "12" => "Dec"); ... incidentally, Oct/Nov/Dec should ha

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

2005-04-06 Thread Martin Norland
ert a single row 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

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 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, -- - M

Re: [PHP-DB] Counting HTML Lines

2005-04-15 Thread Martin Norland
ob_* functions, remember though - you're just analyzing, don't leave the html out unless you really want to!). - except it changes to have you cater your output more to be predictable. Also, remember to account for htmlentities if that's an issue, & => &, etc. Re

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

2005-04-27 Thread Martin Norland
est (if it's a concern) you might want to. 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 Ma

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
g what psa is, I have to run to a meeting but I may try looking again later. 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] php3 and oracle9i client libraries doesn't compile.... . .

2005-04-28 Thread Martin Norland
ts it to be there still. Could be wrong, 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

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

2005-04-28 Thread Martin Norland
sending output before your scripts even start. Is there any 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 Develo

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

2005-04-29 Thread Martin Norland
idn't go through. This will only increase load on your server and, depending on what the users are doing (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 x3

Re: [PHP-DB] URL question. .

2005-05-02 Thread Martin Norland
iciently static, though in that case you 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 Ho

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

2005-05-02 Thread Martin Norland
hem should in fact be UPDATE statements. You'll want to fix that before your data gets *too* sparse. 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 No

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

2005-05-04 Thread Martin Norland
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 Ou

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 displ

Re: [PHP-DB] database synchronization. .

2005-05-12 Thread Martin Norland
doing now - depending on whether 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 Norla

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

2005-05-12 Thread Martin Norland
o try migrating down, 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 x3

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

2005-05-16 Thread Martin Norland
you'll have to set about changing any 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, a

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

2005-05-16 Thread Martin Norland
o "line counted"(sic)? 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.

  1   2   >