RE: [PHP-DB] Corn job anomaly

2016-09-27 Thread Ford, Mike
\"' at line 1 I don't think INTERVAL works like that - you probably need something like: ... cf.Earliest_Pickup <= DATE_ADD(CURDATE(), INTERVAL ".($Num_Days_Away+1)." DAY) AND ... Incidentally, as I understand it CURDATE() does exactly the same as DATE(NOW()), a

Re: [PHP-DB] Newbie Question $2

2014-06-16 Thread Mike Stowe
t; I'd also really suggest looking at using PDO or even the mysqli extension tho instead of just plain mysql (believe this has been deprecated). Sorry for the quick reply, on mobile. But feel free to email me directly and I'll be happy to help out more. - Mike Sent from my iPhone &

RE: [PHP-DB] Re: Formatting

2012-11-26 Thread Ford, Mike
ous. > > $args[] = &$_POST[$k]; // Note the addition of the ampersand here That's a perfectly valid reference assignment. Please see the Fine Manual at: http://php.net/manual/language.references.whatdo.php Cheers! Mike -- Mike Ford, Electronic Information Developer, Libraries

RE: [PHP-DB] SELECT

2011-10-21 Thread Ford, Mike
> -Original Message- > From: tamouse mailing lists [mailto:tamouse.li...@gmail.com] > Sent: 20 October 2011 21:37 > > On Tue, Oct 18, 2011 at 5:36 AM, Ford, Mike > wrote: > >> -Original Message- > >> From: Ron Piggott [mailto:ron.pigg...@actsm

RE: [PHP-DB] SELECT

2011-10-18 Thread Ford, Mike
essages` WHERE (month>`start_month` AND month<`end_month`) OR (month=`start_month AND day>=`start_day`) OR (month=`end_month` AND day<=`end_day`); Cheers! Mike -- Mike Ford, Electronic Information Developer, Libraries and Learning Innovation, Portland PD507, City

RE: [PHP-DB] Configuring PHP with GD and JPEG support

2011-01-15 Thread mike dorian
Just tried it with the following but still fails. All I'm getting is a blank page. > From: k...@designdrumm.com > Date: Mon, 10 Jan 2011 17:10:35 -0600 > To: php-db@lists.php.net > Subject: Re: [PHP-DB] Configuring PHP with GD and JPEG support > > > On Jan 10, 201

[PHP-DB] Configuring PHP with GD and JPEG support

2011-01-10 Thread mike dorian
Hello, Questions with regards to compiling PHP to support GD with JPEG on 64-bit CentOS 5.5. 1) Specifying folder for jpeg library When I execute the following command, am I saying the full path to libdir is at /usr/source/lib64? ./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-gd

RE: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-04 Thread Ford, Mike
$_POST[prid], > > > '%s',". > > You need double-quotes here, > \"%s\", No, he doesn't. Single quotes are fine. Doubles would more than likely be a SQL error. > > > parseNull($_POST['Company']).", > > >

RE: [PHP-DB] losing MySQL resource

2009-11-11 Thread Ford, Mike
n in the script. Is this incorrect? Yes. It has to be before any actual *output*, but it would be perfectly valid to have umpteen thousand lines of PHP before session_start() so long as all the output came after it. Cheers! Mike -- Mike Ford, Electronic Information Developer, Libraries

RE: [PHP-DB] newbie: how to return one iteration *per unique date (DAY!)* in a timestamp column?

2009-08-05 Thread Ford, Mike
as in the GROUP BY column. So: SELECT count(*) AS `CountUniqueDatesInMyTbl`, date(solarAWDateTime) AS `uniqueDate`, 'aweber_7solar_aw' AS `tableAlias` FROM aweber_7solar_aw GROUP BY `uniqueDate`; That's how I'd write it, anyway. Cheers! Mike -- Mike Ford, Elec

RE: [PHP-DB] Postgres query failing, not enough info for debugging...

2009-06-17 Thread Ford, Mike
On 16 June 2009 15:57, Carol Walter advised: > Hello, > > I'm using PHP 5 and PostgreSQL 8.3.6. I have a query that is failing > and I don't know how to troubleshoot the problem. The error message > that it is giving is quite vague. The error message is as follows: > > > Warning: pg_query_pa

RE: [PHP-DB] Re: PHP and table/view names with '$'

2009-04-23 Thread Ford, Mike
On 23 April 2009 11:36, Mark Casson advised: > Hi Guys, > > Thanks to you both - you are spot on! > > Shame this is not better documented somewhere. I don't know how much better documented it can be than at http://php.net/language.types.string ... ;) Cheers! Mike -- Mi

Re: [PHP-DB] Building WHERE SQL clauses

2008-09-17 Thread Mike Sullivan
"Chris" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Mike Sullivan wrote: >> Hi all thanks for the responses! What I have is a 6 table db that has >> each >> >> table created from the output of 6 identical laboratory machines (chic

Re: [PHP-DB] Building WHERE SQL clauses

2008-09-16 Thread Mike Sullivan
tor = "Bill" OR operator = "Jessica" but that apparently is a SQL syntax error. Thanks again for the insight and any other suggestions you might have. --- Mike ""Bastien Koert"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Mon,

[PHP-DB] Building WHERE SQL clauses

2008-09-15 Thread Mike Sullivan
ifferent syntax (JOIN, UNION, ...)? If not are there available some canned code snippets that build these types of strings from values passed in the $_POST array. Thanks for any insights on this. --- Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] ? "SELECT TABLE" Command

2007-09-10 Thread Mike W.
're trying to check that the mysql user you connected as has access to that table. It really feels like a command I may have used in the SQLite analyzer or something. However, I’m sure I copied it from an example script in a book. I’ ve put holds on all the books on PHP and (My)SQL at the l

Re: [PHP-DB] date problems

2007-09-06 Thread Mike Gohlke
Argh, make sure you add the closing paren for the date_add since I forgot it. Mike... Mike Gohlke wrote: It's much better to use add_date instead of to_days since mysql isn't smart enough to do it for you. Such as: SELECT yourEventFields FROM theTable WHERE theEventDate BETWEEN

Re: [PHP-DB] date problems

2007-09-06 Thread Mike Gohlke
y convert them to static values. If there's an index on theEventDate it will be used. Mike... Instruct ICC wrote: From: rDubya <[EMAIL PROTECTED]> My problem is that I have events dated for Sep 2007 and on, and yet they all come up as being on Dec 7 to 9, 2006.. any ideas? rDub

[PHP-DB] Re: [PHP] Re: [PHP-DB] Re: [PHP] Passing variables to a PHP script on clicking a hyperlink

2007-08-26 Thread mike
> I'll say it again: > > regsiter_globals has *NOTHING* to do with $_REQUEST. > > Zero. > Zilch. > Nada. > Zip. To me it allows for the same [lazy] behavior. Period. I've had other people agree. Say what you want about it. > No, it only relies on one "Designer" who wants their request to look > l

[PHP-DB] Re: [PHP] Re: [PHP-DB] Re: [PHP] Passing variables to a PHP script on clicking a hyperlink

2007-08-26 Thread mike
On 8/26/07, Richard Lynch <[EMAIL PROTECTED]> wrote: > This is *SO* not correct at all! > > $_REQUEST[] is merely array_merge($_GET, $_POST, $_COOKIE); Yes and it mimics being lazy - allowing overriding values from $_POST vs. $_GET vs. $_COOKIE depending on what the programmer wants to "trust" I

[PHP-DB] Re: [PHP] Re: [PHP-DB] Re: [PHP] Passing variables to a PHP script on clicking a hyperlink

2007-08-24 Thread mike
On 8/24/07, Suamya Srivastava <[EMAIL PROTECTED]> wrote: > Hi.. > > in the settings, session.use_cookies is turned ON but session.trans_sid is > turned OFF. do i need to enable this as well? > by doing this can i disable the register_globals? > - suamya You need to make sure session_start() is ca

Re: [PHP-DB] Re: [PHP] Passing variables to a PHP script on clicking a hyperlink

2007-08-24 Thread mike
t an in-browser method of collecting data and sending the key/value pairs in POST or GET... IMHO the HTML portion should already be known before someone steps into the realm of PHP and server-side programming) - mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP] Passing variables to a PHP script on clicking a hyperlink

2007-08-24 Thread mike
On 8/23/07, Suamya Srivastava <[EMAIL PROTECTED]> wrote: > Hello, > > How can I pass variables on clicking a hyperlink to a PHP script? I have 5 > hyperlinks, all pointing to the same PHP script. However, on clicking each > hyperlink a different value of the variable needs to be passed to the PHP >

Re: [PHP-DB] Read more link with HTML code

2007-05-08 Thread Mike van Hoof
tml_arr_close); if($key !== false){ unset($html_arr_close[$key]); } else { $not_closed_tags[] = $tag; } } $closed_tags_str = ''; foreach($not_closed_tags as $tag){ $closed_tags_str .=

Re: [PHP-DB] Re: Read more link with HTML code

2007-05-08 Thread Mike van Hoof
Hey, a client can type anything in the field, so all kind of HTML tags can be inserted... - Mike Medusa, Media Usage Advice B.V. Science Park Eindhoven 5216 5692 EG SON tel: 040-24 57 024 fax: 040-29 63 567 url: www.medusa.nl mail: [EMAIL PROTECTED] Uw bedrijf voor Multimedia op Maat

Re: [PHP-DB] Read more link with HTML code

2007-05-07 Thread Mike van Hoof
ney!Bonus"Gbongay has been rewarded by nature. It wasgiven the local bee, which is extremely prolific, anabundance of bee flora and a favourable climatefor beekeeping -- making this initiative a lucrativeone."Mariama Fawundu, Local Representative With kind regards Mike Medusa, Media Usage Adv

[PHP-DB] Read more link with HTML code

2007-05-07 Thread Mike van Hoof
then the rest off the page is also bold. somebody got a solution ? Thanks for reading. Mike -- Medusa, Media Usage Advice B.V. Science Park Eindhoven 5216 5692 EG SON tel: 040-24 57 024 fax: 040-29 63 567 url: www.medusa.nl mail: [EMAIL PROTECTED] Uw bedrijf voor Multimedia op Maat

RE: [PHP-DB] variable with NULL value

2007-05-04 Thread Ford, Mike
On 03 May 2007 16:22, OKi98 wrote: > Hi, > > one more question. > > Why the variable, that contains NULL value appears to be not > set. U -- because that's how it's defined?? (http://php.net/isset) Cheers! Mike --

RE: [PHP-DB] weird comparsion

2007-05-03 Thread Ford, Mike
r, BUT (int)$foo===(int)$bar It's exactly when you *don't* want this kind of automatic type-conversion shenanigans going on that you should use the === operator to make your intent entirely clear -- otherwise you have to be extremely aware of the context in which you are evaluating y

Re: [PHP-DB] weird comparsion

2007-05-03 Thread Mike van Hoof
http://nl3.php.net/manual/en/language.operators.comparison.php try using === (3x =) for comparison - Mike OKi98 schreef: Hello, Why does anything compared to 0 return true? I know it might seem to be a bit off-topic, but for me it is important for detecting if NULL value in table has been

Re: [PHP-DB] PHP_AUTH_USER & .htaccess

2007-03-06 Thread Mike van Hoof
This must be set on "On", because in a directory where the .htaccess file doesn't exist it works, or can that setting also be set to on? - Mike bedul schreef: - Original Message ----- From: "Mike van Hoof" <[EMAIL PROTECTED]> To: Sent: Tuesday, March 06

[PHP-DB] PHP_AUTH_USER & .htaccess

2007-03-06 Thread Mike van Hoof
ecause i can't find a solution. - Mike|

[PHP-DB] Re: SQL Query - Using variable from another SQL Query

2007-02-12 Thread Mike Morris
I think you don't need to break this into two queries... this is really a SQL question, not a PHP question... Just do a "join" on the two tables: * where table1.cal_id = table2.cal_id and then have a where clause that does all your filtering: * and table1.Date > now() and table2.cal_cate

Re: [PHP-DB] MYSQL REGEXP question

2007-01-10 Thread Mike van Hoof
That is it almost :) SELECT 'oer bv b' REGEXP 'b[^v]$|b[^v]\s?'; gives me 0 as a result, while it shoud give me 1, because there is a b in there which is not bv. Mike Medusa, Media Usage Advice B.V. Science Park Eindhoven 5216 5692 EG SON tel: 040-24 57 024 fax

[PHP-DB] MYSQL REGEXP question

2007-01-09 Thread mike
. But now followed by a v(line end) or a v followed by a space. so it should match: 'b test' 'test b' 'test b bv' 'bv b test' and NOT 'test bv' 'bv test' Any idea's?! Thanks, mike --

[PHP-DB] MYSQL REGEXP question

2007-01-08 Thread Mike van Hoof
. But now followed by a v(line end) or a v followed by a space. so it should match: 'b test' 'test b' 'test b bv' 'bv b test' and NOT 'test bv' 'bv test' Any idea's?! Thanks, mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: EXISTS syntax for SELECT INTO?

2006-10-11 Thread Mike Morris
irst. Does SQL support the EXISTS > keyword for SELECT INTO statements (I'm running PG7)? > > If not, is there another way to do it in SQL? I'd rather not do it > programmatically. > > Thanks in advance, > Tony > Mike Morris The Music Place 161

RE: [PHP-DB] detecting negative numbers

2006-07-17 Thread Ford, Mike
amount is negative If I were reading your code, I would find both if(($quant-$amount)<0) and if(neg_num($quant-$amount)) more obfuscating than if($quant<$amount). Cheers! Mike ----- Mike Ford, Electronic Information Servi

[PHP-DB] Need Help Compiling PHP5 With MS SQL Support

2006-07-03 Thread Mike
next step is to get the PHP source for PHP 5.1.4. From here on I do not understand clearly by reading the docs I have searched for on the Internet through Google. Is there a place that has a VERY clear, step by step process to compile PHP? Any and all help is GREATLY appreciated. TIA. Mike

RE: [PHP-DB] PHPSESSID how to append and access

2006-05-25 Thread Ford, Mike
syntax to append > the Session ID to the URL specified in the header so that it > is available header("Location: http://dv-medical/phpscripts/test.php?".SID) That's what the SID constant is for. You can even use it with impunity when cookies are in use, since it is

RE: [PHP-DB] Displaying results from a query properly.

2006-03-27 Thread Ford, Mike
sHTML = substr($sHTML, 0, strlen($sHTML)-1); You don't need a strlen() call here, as substr understands "count from the right" notation: $sHTML = substr($sHTML, 0, -1); ... or, with Alex's correction: $sHTML = substr($sHTML, 0, -2); Cheers! Mike -

RE: [PHP-DB] Quick question

2005-12-09 Thread Ford, Mike
they must be set in an appropriate config file (php.ini, httpd.conf, .htaccess, etc.) as permitted. Cheers! Mike ----- Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning & Information Servic

RE: [PHP-DB] problem of transmiting variabl into another page?

2005-12-07 Thread Ford, Mike
$j == Z) { > > break; > > } > > } ?> 1. You have unquoted strings -- should be 'A' and 'Z'. 2. The test condition in your for is wrong (and either that or the break is redundant). Here's how I'd write it: for ($j='A'; $

Re: [PHP-DB] pg_insert tyro question

2005-08-22 Thread mike burnard
I certainly agree with that Micah. array_pop only removes that last item. If you are in a an open environment you definitely want to include security checks and form validation. -mike On Aug 22, 2005, at 4:07 PM, Micah Stevens wrote: This is tenuous and insecure, you have no control over

Re: [PHP-DB] mysql INNER JOIN

2005-05-29 Thread Mike Bellerby
have a look at http://www.webmasterworld.com/forum88/3653.htm hope this helps! Mike ioannes wrote: I usually use INNER JOIN to link tables together in a straight line, like a branch. Can I use it to link tables like twigs stemming off the branch. If so, do I use: SELECT TABLE1.FIELD

RE: [PHP-DB] Problem with foreach looping...

2005-04-07 Thread Mike Johnson
[0]\n"; > } > > Is my PHP somehow broke, or am I just missing something here? > Thanks. mysql_fetch_array() only fetches one record of the result set at a time. Thus, the code's doing what you told it to. The while() loop is what you want. Why do you need to use a foreach()

[PHP-DB] MYSQL row position.. is it possible (urgent)

2005-03-04 Thread Mike
ontains thousands of entries, and it's simply not possible do do it that way. Thanks Mike

[PHP-DB] How-to pass informational mysql messages to the browser

2005-02-25 Thread Mike Millner
message to the browser: Query OK, 1 row affected (0.01 sec) Any help would be appreciated, Thanks, Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] How-to pass informational mysql messages to the browser

2005-02-25 Thread Mike Millner
message to the browser: Query OK, 1 row affected (0.01 sec) Any help would be appreciated, Thanks, Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: boolean values in postgresql

2005-02-21 Thread Mike Morris
about a CHAR(1) with "Y"/"N" (or "T"/"F") and use a trigger to enforce it. Or you could use the small int and have 0/1... the validating trigger's the point... Mike Morris The Music Place 1617 Willowhurst Avenue San Jose, CA 95125 (408) 445

[PHP-DB] Re: Newbie Setup Trouble

2005-02-07 Thread Mike Rondeau
that, and the use of "search" as Jerry suggested, I bet all will go much more smoothely now, hehe. Just wanted to affirm to you all that your assistance was appreciated :) ~Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] timestamp

2005-02-01 Thread Ford, Mike
quot; format). (Ilia)" So I guess you need at least PHP 4.3.3 for this to work correctly for you. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning & Informati

RE: [PHP-DB] mysql - image storing

2005-01-18 Thread Ford, Mike
haracters in the retrieved value to be stripslashes()ed. Hope that's clearer than mud, and helps you understand what's going on better. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support

RE: [PHP-DB] php latest release!

2005-01-10 Thread Ford, Mike
th PHP 4.3.10, and exhibit various incorrect behaviours -- in particular, foreach produces the wrong results. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning & Infor

RE: [PHP-DB] PHP query to mysql database returns emtpy data, but Query Browser shows records

2005-01-07 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 07 January 2005 03:25, Jason Walker wrote: > Graeme - you were moving in the right direction. Since the > data in the field > is varchar(250), the only thing that changes is the

RE: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-07 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 06 January 2005 21:10, Norland, Martin wrote: > > -Original Message- > > From: Ford, Mike [mailto:[EMAIL PROTECTED] > > Sent: Thursday, Januar

RE: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Ford, Mike
t' is spelled 'Persistent' Oh dear, as a fully-paid-up pedant, I'm afriad I can't resist this one: Doesn't affect the answer, but this occurrence of 'effect' should be 'affect'. ;) Cheers! Mike --

Re: [PHP-DB] Filling Drop-Down Box.

2004-12-25 Thread Mike S.
http://www.netmask.com/php-db/sample-dropdown.html Good luck! :Mike S. :Austin TX USA -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] data is not entering in created database

2004-12-24 Thread Mike S.
is NOT a secure way to do this!!! And I'm sure there's plenty of folks groaning out there because it is a BIG security hole. You really would want to do this on a development machine and network, and remove the debug code for production. That really should go without saying. Good luck. :Mike S. :Austin TX USA -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] still Parse errors ,,, can you. impart me about it.

2004-12-23 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 23 December 2004 18:04, amol patil wrote: > hallo Mike, > > thanks for reply, but i want a bit more help, again Please keep this on-list -- someone else may have time

RE: [PHP-DB] _POST, _GET, _REQUEST not working

2004-12-23 Thread Ford, Mike
> causing the problem? Absolutely -- this is the Command-Line Interface. As this is intended for command-line scripting, it has no notion of being used in a Web context and does not even attempt to fill the $_POST or $_GET (or most of the other $_) arrays. You need to use eithe

RE: [PHP-DB] _POST, _GET, _REQUEST not working

2004-12-22 Thread Ford, Mike
else $var2 ='undefined'; > > // Various HMTL tags removed for simplicity > echo $var1 > echo $var1 Is this a direct paste from your original? If so, there's an obvious error here -- one of those should be $var2,'cos as it is you're never even echoing

RE: [PHP-DB] Parse errors ,,, can you. impart me about it.

2004-12-22 Thread Ford, Mike
omewhere in the preceding 378 lines -- most likely a missing }. (If PHP was complaining about a variable reference, the message would refer to "unexpected T_VARIABLE".) Cheers! Mike - Mike Ford, Electronic Inform

RE: [PHP-DB] PHP 4.3.10RC2 - Any change in the way rows are fetch ed ?

2004-12-16 Thread Ford, Mike
the Zend Optimiser -- if you are using this, try disabling it, and if your application then works ok upgrade to the latest version. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Lear

RE: [PHP-DB] date conversions

2004-12-16 Thread Ford, Mike
ve is returning the equivalent of the 11th day of the 30th month of 2004! You can use other PHP functions, as has been suggested, but you might also investigate the mySQL date formatting functions, as I believe they work perfectly well

RE: [PHP-DB] Question: For no results

2004-12-03 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 03 December 2004 15:26, Stuart Felenstein wrote: > --- "Ford, Mike" <[EMAIL PROTECTED]> wrote: > > > Well, your taste seems to be to use {

RE: [PHP-DB] Question: For no results

2004-12-03 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 03 December 2004 15:26, Stuart Felenstein wrote: > --- "Ford, Mike" <[EMAIL PROTECTED]> wrote: > > > Well, your taste seems to be to use {

RE: [PHP-DB] Question: For no results

2004-12-03 Thread Ford, Mike
he print_r, I closed the tags. Yes, but you didn't include the { } to indicate the scope of the if -- so it terminated at the ?>. > I'm not sure how to use the endif. Well, your taste seems to be to use { }, so :-endif is irrelevant. Cheers! Mike --

RE: [PHP-DB] Question: For no results

2004-12-03 Thread Ford, Mike
gt; using either {-} or > > :-endif, according to your taste. > > > The reason the close is there is because the next line > of code is the print_r , and I put some html in there. Nothing wrong with having the closing ?> the

RE: [PHP-DB] Question: For no results

2004-12-03 Thread Ford, Mike
?> Which, of course, means that the scope of the if doesn't extend to anything beyond this point. You need to mark the block controlled by the if, using either {-} or :-endif, according to your taste. Cheers! Mike - Mi

RE: [PHP-DB] mysql_array_array

2004-12-03 Thread Ford, Mike
xecute: if (list($row) = mysql_fetch_array($res)) { The mysql_fetch_array() complains with the error you have seen. After any database operation, you should check for failure and echo out any error message -- see mysql_errno() (http://php.net/mysql_errno) and mysql_error(

RE: [PHP-DB] Multi-User Update Problem

2004-12-01 Thread Ford, Mike
lue; in either case, unlock the record. This methodology keeps both the lock and unlock in the same script (and potentially within a single database transaction), so no need for any external checks for locked records, and minimizes the am

RE: [PHP-DB] Error Help

2004-11-30 Thread Mike Johnson
t'll fail with the same error message if their internet connection is fine but $dbhost is unavailable. I'm not entirely certain if PHP can gracefully detect a local internet connection, actually. For your purposes, though, this should do the job. HTH! -- Mike Johnson Sma

RE: [PHP-DB] Transaction suddenly not working

2004-11-29 Thread Ford, Mike
this last line, with no value in between -- this is your syntax error. > , 4, 26, , 2004-02-02)01062 : Duplicate entry '0-f' for key 1 And again on this line -- twice, in fact, since the previous line ends with a comma, too. Track down whatever is outputting thes

RE: [PHP-DB] Re: Subject: Javascript Question (Was PHP / Javascri pt question)

2004-11-16 Thread Ford, Mike
n't -- it should read if (df[i].checked) { More efficient, more readable, and, more important, The Right Way (TM)! ;) Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learn

RE: [PHP-DB] PHP / Javascript question

2004-11-16 Thread Ford, Mike
because the tickboxes information is stored in a PHP > Array called del[] > I am having major problems getting it to work. You shouldn't be, since any good JavaScript text will tell you that, by definition, x.y is identical to x['y']; so: document.removeitems[

Re: [PHP-DB] IIS and php sessions

2004-11-15 Thread Mike Smith
I'm pretty sure this is enabled by default in PHP for Windows, I think you'll need to check the IUSR_[machine_name] persmissions on the sessions folder. I'm headed in the other direction. I'm re-writing an app with a database abstraction layer with hopes of moving to postgres. -- PHP Database Mai

RE: [PHP-DB] Persistent Connections to Oracle databases

2004-11-15 Thread Ford, Mike
ne 100 times (100 connections at the end). Potentially, if you have Apache configured to run 100 children or more. If you configure it to run only 50 children, that's the maximum number of Oracle connections you will get. Cheers! Mike ---

RE: [PHP-DB] Re: [EMAIL PROTECTED] November 2, 2004

2004-11-02 Thread Ford, Mike
ent in those countries!). I, personally, would be equally irritated about a reminder to vote in British elections, even though it would apply to me, since, again, it is wholly off-topic in this list. Cheers! Mike ----- Mike Ford,

RE: [PHP-DB] Forms list from database

2004-11-02 Thread Ford, Mike
gs -- these should be present around each value extracted from the database, so: while ($check=mysql_fetch_array($result)){ print "{$check['LNAME']},{$check['FNAME']}({$check['CID']})\n"; } Cheers! Mike -

RE: [PHP-DB] can i display an image _directly_ from postgres db storage?

2004-11-01 Thread Mike
Philip, Typically, it's infinitely more performance-friendly to simply store your files on the hard disk and use the database to refer to that location. For instance, assume your root web dir is /www. Inside there you have an /images directory. If you religiously put all files inside of /images

RE: [PHP-DB] Problems with mysql_num-rows()

2004-11-01 Thread Ford, Mike
user where > name=\'$userid\' and pass=password(\'$password\')" This is complete BS. The whole string is in double quotes -- the presence of single quotes within it has no effect whatsoever on the expansion of variables, nor is it n

Re: [PHP-DB] php code on sqlite

2004-10-20 Thread Mike Smith
Add after your closing On Wed, 20 Oct 2004 11:50:29 -0700 (PDT), Aravalli Sai <[EMAIL PROTECTED]> wrote: > hi > this is php code for inventory management system > which is done using SQLite.this is an user > interface where an user wil giv values to the text > boxes and it should be sav

[PHP-DB] SSL connection between PHP4 & PostgreSQL ???

2004-10-05 Thread Mike Morris
.g., "requiressl=true", etc... If not possible in PHP4, is it in PHP5? Any help greatly appreciated! MikeM Mike Morris The Music Place 1617 Willowhurst Avenue San Jose, CA 95125 (408) 445-ARTS (2787) Your Free Historical Quote: Above all

[PHP-DB] Re: Safe / Secure Login Script

2004-10-05 Thread Mike Morris
m that I've guessed a valid username, then I can go about guessing the password. If I don't know which is wrong, the number of possibilities is increased geometrically. Mike Morris The Music Place 1617 Willowhurst Avenue San Jose, CA 95125 (408) 445-ARTS (2787) -

RE: [PHP-DB] What is PHPBB?

2004-10-02 Thread Mike
Google is your friend: http://www.google.com/search?hl=en&ie=UTF-8&q=PHPBB&btnG=Google+Search -Original Message- From: Lic. Daniel Alfredo Betancourt Reboso [mailto:[EMAIL PROTECTED] Sent: Saturday, October 02, 2004 9:22 AM To: '[PHP-DB] Mailing List' Subject: [PHP-DB] What is PHPBB? Hi

RE: [PHP-DB] Convert plain text to HTML tagged text

2004-09-28 Thread Ford, Mike
? http://www.php.net/str_replace should be all you need -- no need for regexps for such a simple replace. Cheers! Mike ----- Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning & Inform

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-24 Thread Ford, Mike
ng set at all, I couldn't begin to count. (ii) As a variation of the above, put *lots* of debugging echos in your script: echo the value of every variable frequently and redundantly -- it can help sometimes just to have the reassurance that a value really hasn't changed, even though y

RE: [PHP-DB] Using PHP to generate SQL statement

2004-09-23 Thread Ford, Mike
ystemID = '{$webpage->SystemID}'"; } Or: $where = '' foreach (array('CategoryID', 'CompanyID', 'SettingID', 'SystemID') as $field): if ($webpa

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-23 Thread Ford, Mike
ems or just one > > if (is_array($_POST['state'])) >$sql .= "state='".implode("' OR state='", > $_POST['state'])."'"; > $sql .= ")"; > }else{ > $_POST['job'] is not a

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-22 Thread Ford, Mike
> -Original Message- > From: Stuart Felenstein [mailto:[EMAIL PROTECTED] > Sent: 22 September 2004 16:45 > > --- "Ford, Mike" <[EMAIL PROTECTED]> wrote: > > > >if (is_array($_POST['state'])){ > > > $sql .= "(

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-22 Thread Ford, Mike
> -Original Message- > From: John Holmes [mailto:[EMAIL PROTECTED] > Sent: 22 September 2004 16:39 > > From: "Ford, Mike" <[EMAIL PROTECTED]> > >>if (is_array($_POST['state'])){ > > > > This check isn't really necess

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-22 Thread Ford, Mike
if > > if (isset($_POST['job'])){ > if (isset($_POST['state'])){ $sql .= " AND "; } //add in > the AND if the > state is set > //check to see if the states is an array (multiple items or

[PHP-DB] where can I post some mysql related questions?

2004-09-19 Thread Mike
hi, I've currently been looking for a mysql news server where I could post some questions on mysql database design (cause they shurely wouldn't fit here) and I have yet to find one. Can anyone help? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/un

RE: [PHP-DB] Inserting a ' into mySQL

2004-08-20 Thread Ford, Mike [LSS]
if an ' is keyed why it wouldn't save > and that line would create an error --- How do you work around this? That's what mysql_real_escape_string() is for -- http://www.php.net/mysql_real_escape_string. Cheers! Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: Checkboxes in a table

2004-08-20 Thread Ford, Mike [LSS]
> -Original Message- > From: Ford, Mike [LSS] > Sent: 21/08/04 01:57 > foreach ($_POST['checkbox'] as $key=>$irrelevant): > // checkbox[$key] was checked > endif; OK, it's 2a.m. here and I'm about asleep, whioch is why t

RE: [PHP-DB] Re: Checkboxes in a table

2004-08-20 Thread Ford, Mike [LSS]
t will only ever see checkboxes which are checked -- unchecked ones won't be trnsmitted. So just foreach() over the received array, and the indexes you see are for the checked boxes: foreach ($_POST['checkbox'] as $key=>$irrelevant): // checkbox[$key] was checked end

RE: [PHP-DB] I have a CR-LF problem when pulling stuff out of my DB

2004-08-19 Thread Ford, Mike [LSS]
On 19 August 2004 17:02, Michael Cortes wrote: > ctrl-m is a carriage return. Does anyone know what ctrl seqence is > line feed? ctrl-j (CR and LF are ASCII codes 13 and 10, so ctrl+ the 13th and 10th letters of the alphabet respectively!) Cheers!

RE: [PHP-DB] Check Boxes

2004-08-18 Thread Ford, Mike [LSS]
On 18 August 2004 15:53, John Holmes wrote: > Ford, Mike [LSS] wrote: > > > > $chkboxes = $_POST['ch']; > > > $sql = 'SELECT '; > > > foreach($chkboxes as $k => $v) > > > { > > > $sql .= $

RE: [PHP-DB] Check Boxes

2004-08-18 Thread Ford, Mike [LSS]
} > } > $sql .= ' FROM form'; $sql = 'SELECT ' . implode(', ', $chkboxes) . 'FROM form'; Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Servi

  1   2   3   4   5   >