[PHP-DB] Printing Forms

2004-05-21 Thread Mike Koponick
the MySQL data into that form. I didn't see a real easy way to do this, and was hoping that someone may have some insight on how to do this. Thanks in Advance, Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: SV: [PHP-DB] Drawing table by while

2004-05-26 Thread Mike S.
not checked the specific code above for spelling or other typographic errors. The example code posted earlier (see below) had a small error in that the counter was incremented twice if it was the first column, therefore only printing 4 columns. :Mike S. :Austin TX USA Something like

[PHP-DB] Sample Code

2004-06-15 Thread Mike Koponick
figure out. The part I'm having trouble with is exporting the data and selecting between two dates. I'm running PHP4 and MySQL 4.1. Thank in advance for your help. Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-22 Thread Ford, Mike
; } $sql .= ); }else{ //$_POST['job'] is not an array $sql .= job = '.$_POST['job'].' ; }//end if Ditto for the job field. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning

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 necessary in PHP, since $_POST['state'] will *always* be an array if the form field

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 .= (; $x = 0; foreach ($_POST['state'] as $state) if ($x == 0

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-23 Thread Ford, Mike
'].' ; } //end if Given the moderate complexity of this code, I'd strongly recommend echo-ing out $sql immediately before it's used whilst you're in testing mode. When your query fails, you'll already be one step ahead in working out what the problem is. Cheers! Mike

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

2004-09-23 Thread Ford, Mike
-$field}'; endif; endforeach; if ($where): $sql = select ID from products where$where; ... else: // no where information -- major error endif; Cheers! Mike - Mike Ford, Electronic Information Services

RE: [PHP-DB] MultSelect ListBox hell!

2004-09-24 Thread Ford, Mike
calculated (and how, and maybe even why). It's especially important to echo your final complete SQL statement just before it's executed, so that if it produces an error message you've got the actual relevant SQL right in front of you. Hope this helps. Cheers! Mike

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

2004-09-28 Thread Ford, Mike
for such a simple replace. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan University, Headingley Campus, LEEDS

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

2004-10-05 Thread Mike Morris
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) Your Free Historical Quote

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

2004-10-05 Thread Mike Morris
, 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, I know there is a Supreme Being who rules the affairs of men

Re: [PHP-DB] php code on sqlite

2004-10-20 Thread Mike Smith
Add ? } } ? after your closing /html 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

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

2004-11-01 Thread Ford, Mike
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 necessary to escape them. Cheers! Mike

RE: [PHP-DB] Forms list from database

2004-11-02 Thread Ford, Mike
option{$check['LNAME']},{$check['FNAME']}({$check['CID']})/option\n; } Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham

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

2004-11-15 Thread Ford, Mike
). 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 - Mike Ford, Electronic Information Services

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

RE: [PHP-DB] PHP / Javascript question

2004-11-16 Thread Ford, Mike
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['del[]'] will get you started. Cheers! Mike

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

2004-11-16 Thread Ford, Mike
[i].checked) { More efficient, more readable, and, more important, The Right Way (TM)! ;) Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125

RE: [PHP-DB] Transaction suddenly not working

2004-11-29 Thread Ford, Mike
)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 these null values, fix it, and you should be good to go (well, at least less bad!). Cheers! Mike

RE: [PHP-DB] Error Help

2004-11-30 Thread Mike Johnson
! -- Mike Johnson Smarter Living, Inc. Web Developerwww.smarterliving.com [EMAIL PROTECTED] (617) 886-5539 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2004-12-01 Thread Ford, Mike
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 amount of time for which any one record is locked. Cheers! Mike - Mike

RE: [PHP-DB] mysql_array_array

2004-12-03 Thread Ford, Mike
)) { 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() (http://php.net/mysql_error). Cheers! Mike

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

2004-12-03 Thread Ford, Mike
the block controlled by the if, using either {-} or :-endif, according to your taste. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham

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

2004-12-03 Thread Ford, Mike
of code is the print_r , and I put some html in there. Nothing wrong with having the closing ? there -- please re-read my response. If it's still unclear to you, please ask specific questions. Cheers! Mike - Mike Ford

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

2004-12-03 Thread Ford, Mike
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 - Mike Ford, Electronic Information Services Adviser, Learning Support Services

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 { }, so :-endif is irrelevant. Alright it's

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 { }, so :-endif is irrelevant. Alright it's

RE: [PHP-DB] date conversions

2004-12-16 Thread Ford, Mike
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 on input dates as well as output ones. Cheers! Mike - Mike

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

2004-12-16 Thread Ford, Mike
. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan University, Headingley Campus, LEEDS, LS6 3QS, United

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

2004-12-22 Thread Ford, Mike
about a variable reference, the message would refer to unexpected T_VARIABLE.) Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham

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

2004-12-22 Thread Ford, Mike
? If so, there's an obvious error here -- one of those should be $var2,'cos as it is you're never even echoing the value of the $_GET parameter. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support

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

2004-12-23 Thread Ford, Mike
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 either the CGI SAPI, or the Apache module. Cheers! Mike

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 to reply

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

2004-12-24 Thread Mike S.
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] Filling Drop-Down Box.

2004-12-25 Thread Mike S.
at: 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] Trying to connext to MySQL with PEAR

2005-01-06 Thread Ford, Mike
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 - Mike Ford, Electronic Information Services Adviser, Learning

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, January 06, 2005 1:13 PM Subject: RE

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] php latest release!

2005-01-10 Thread Ford, Mike
various incorrect behaviours -- in particular, foreach produces the wrong results. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James

RE: [PHP-DB] mysql - image storing

2005-01-18 Thread Ford, Mike
going on better. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan University, Headingley Campus, LEEDS

RE: [PHP-DB] timestamp

2005-02-01 Thread Ford, Mike
for this to work correctly for you. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan University, Headingley

[PHP-DB] Re: Newbie Setup Trouble

2005-02-07 Thread Mike Rondeau
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

[PHP-DB] Re: boolean values in postgresql

2005-02-21 Thread Mike Morris
/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-ARTS (2787) Your Free Quote: And that, in my

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

2005-02-25 Thread Mike Millner
: 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
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

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

2005-04-07 Thread Mike Johnson
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() loop? At that point, there's nothing to foreach() through. No array has been constructed. HTH! -- Mike Johnson Smarter Living, Inc. Web

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] 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] problem of transmiting variabl into another page?

2005-12-07 Thread Ford, Mike
. 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'; $j!='AA'; $j++): echo | ba href='alpha.php?artist=$j'$j/a/b |; endfor; Cheers! Mike - Mike Ford

RE: [PHP-DB] Quick question

2005-12-09 Thread Ford, Mike
, httpd.conf, .htaccess, etc.) as permitted. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan University

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

2006-03-27 Thread Ford, Mike
: $sHTML = substr($sHTML, 0, -1); ... or, with Alex's correction: $sHTML = substr($sHTML, 0, -2); Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information

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

2006-05-25 Thread Ford, Mike
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 set to the empty string in that case. Cheers! Mike

RE: [PHP-DB] detecting negative numbers

2006-07-17 Thread Ford, Mike
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 Services Adviser, Learning Support Services, Learning Information

[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

RE: [PHP-DB] weird comparsion

2007-05-03 Thread Ford, Mike
intent entirely clear -- otherwise you have to be extremely aware of the context in which you are evaluating your variables in order to avoid hidden surprises like this. Cheers! Mike - Mike Ford, Electronic Information Services

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 - Mike Ford

Re: [PHP-DB] date problems

2007-09-06 Thread Mike Gohlke
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? rDubya How about having

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 now

Re: [PHP-DB] ? SELECT TABLE Command

2007-09-10 Thread Mike W.
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 library and will check them all. -- Mike W. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Building WHERE SQL clauses

2008-09-15 Thread Mike Sullivan
, ...)? 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] Building WHERE SQL clauses

2008-09-16 Thread Mike Sullivan
= 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, Sep 15, 2008 at 1:33 PM, Stephen Wellington [EMAIL PROTECTED] wrote: You

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 (chico, harpo, ...). The out put is a text file which I import

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 -- Mike Ford, Electronic

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

2009-06-17 Thread Ford, Mike
INTO brdgMediaCallsEvents (mediumId, eventId, rank) VALUES (currval('tblMedia_mediumId_seq'), currval('tblCallsEvents_eventId_seq'), $1) SQL , array($ev_rank)); Cheers! Mike -- Mike Ford, Electronic Information Developer, C507, Leeds Metropolitan University, Civic

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

2009-08-05 Thread Ford, Mike
`, 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, Electronic Information Developer, Libraries and Learning Innovation, Leeds Metropolitan

RE: [PHP-DB] losing MySQL resource

2009-11-11 Thread Ford, Mike
. 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 and Learning Innovation, Leeds

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

2010-08-04 Thread Ford, Mike
[Phone]', '$_POST[Email]' ), mysql_real_escape_string($_POST['Registrant'])); -- Simcha Younger sim...@syounger.com Cheers! Mike -- Mike Ford, Electronic Information Developer, Libraries and Learning Innovation, Leeds Metropolitan University, C507 City Campus, Woodhouse

[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] Configuring PHP with GD and JPEG support

2011-01-15 Thread mike dorian
); } create_image(); ? 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, 2011, at 9:35 AM, mike dorian wrote: Hello, Questions with regards to compiling PHP to support GD

RE: [PHP-DB] SELECT

2011-10-18 Thread Ford, Mike
=`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 Campus, Leeds Metropolitan University, Portland Way, LEEDS,  LS1 3HE,  United Kingdom E: m.f

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 m.f...@leedsmet.ac.uk wrote: -Original Message- From: Ron Piggott [mailto:ron.pigg...@actsministries.org] Sent: 17

RE: [PHP-DB] Re: Formatting

2012-11-26 Thread Ford, Mike
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 and Learning Innovation, Portland PD507, City Campus

Re: [PHP-DB] Newbie Question $2

2014-06-16 Thread Mike Stowe
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 On Jun 16, 2014, at 7:58 PM, Ethan Rosenberg

RE: [PHP-DB] Corn job anomaly

2016-09-27 Thread Ford, Mike
d\"' 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()), and is pro

RE: [PHP-DB] Re: Array not supported for strings???

2002-01-08 Thread Ford, Mike [LSS]
it definitely refer to this particular line? Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan University

RE: [PHP-DB] Oracle date conversion

2002-01-08 Thread Ford, Mike [LSS]
-YY HH:MI:SS') AS DATE_TIME FROM TBL Look up the definition of the TO_CHAR function for the full list of format elements available for formatting DATEs. Cheers! Mike - Mike Ford, Electronic Information Services Adviser

RE: [PHP-DB] oracle connectivity problem

2002-01-08 Thread Ford, Mike [LSS]
) which gives you the ORA_ series of functions? Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan

RE: [PHP-DB] mysql_num_rows

2002-01-08 Thread Ford, Mike [LSS]
is that it contains something unexpected which, when inserted into the query, causes it to fail (or at least return no rows!). Otherwise, I can see no reason for the addition of the WHERE clause to cause this error. Cheers! Mike - Mike

RE: [PHP-DB] mysql_num_rows

2002-01-08 Thread Ford, Mike [LSS]
guess is Sorry, that should be $bookid...!! that it contains something unexpected which, when inserted into the query, causes it to fail (or at least return no rows!). Otherwise, I can see no reason for the addition of the WHERE clause to cause this error. Cheers! Mike

RE: [PHP-DB] mysql_num_rows

2002-01-08 Thread Ford, Mike [LSS]
practice? Depends on whether $bookid is a string or a number. If your id values are always numeric, there's really no point in quoting them in the query. On the other hand, if they can be strings it's pretty vital to quote them!! Cheers! Mike

Re: [PHP-DB] passing array through $PHP_SELF

2002-03-18 Thread Mike de Libero
to form again. Hope this helps. -Mike de Libero [EMAIL PROTECTED] http://www.soreye.com - Original Message - From: John Hughes, Jomari Works [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 18, 2002 5:27 PM Subject: [PHP-DB] passing array through $PHP_SELF I have a page

[PHP-DB] Creating a good search engine

2002-03-22 Thread Mike de Libero
. Hope you guys can help. -Mike de Libero [EMAIL PROTECTED] http://www.soreye.com

Re: [PHP-DB] using multiple checkboxes to delete from db

2002-03-30 Thread Mike de Libero
it helps. -Mike [EMAIL PROTECTED] http://www.soreye.com - Original Message - From: wesley grubbs:. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 30, 2002 4:58 AM Subject: [PHP-DB] using multiple checkboxes to delete from db i've been playing half the day

Re: [PHP-DB] Database search question

2002-03-30 Thread Mike de Libero
sure it is IN. Go to Zend.com and phpbuilder.com for some good resources on search engines you can modify it to suit your needs. I this helps a little bit. -Mike - Original Message - From: Chris Payne [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 30, 2002 7:15 PM

[PHP-DB] Using OCI, can I retrieve multiple values from DELETE/UPDATE RETURNING?

2002-05-01 Thread Ford, Mike [LSS]
such a useful feature to get the same result in a single statement. Cheers! Mike Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Beckett

RE: [PHP-DB] Retrieving a date from Oracle. Please help!

2002-05-23 Thread Ford, Mike [LSS]
haven't tried this either, as I don't have administrative control of my Oracle database!). Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James

RE: [PHP-DB] Retrieving a date from Oracle. Please help!

2002-05-23 Thread Ford, Mike [LSS]
haven't tried this either, as I don't have administrative control of my Oracle database!). Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James

RE: [PHP-DB] MySQL/PHP dropping characters

2002-09-24 Thread Ford, Mike [LSS]
, you should turn it off -- search the bug database for the appropriate bugs, which will give you more information than my brain can! Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services

RE: [PHP-DB] getting mysql_fetch_row into array

2002-09-24 Thread Ford, Mike [LSS]
time, just create a reference to it: $b = $a[0]; then $b[$x] is the same as $a[0][$x]. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125

RE: [PHP-DB] Oracle connection problem after call to unserialize()

2002-09-24 Thread Ford, Mike [LSS]
for Oracle -- all the databases supported in PHP that I've looked at work the same way.) Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James

RE: [PHP-DB] Session understanding

2002-09-26 Thread Ford, Mike [LSS]
scripts look pretty much like this: ?php ini_set('include_path', '../../dir-not-in-http-space/include'); require 'the_real_script.php'; ? Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning

RE: [PHP-DB] Current row of query

2002-09-26 Thread Ford, Mike [LSS]
= mysql_fetch_array($result) ) { if ($rowNum++ % 2) { $bgCol = #EADBC6; } else { $bgCol = #EFE1CE; } echo ..; } And, having got this far, I'd probably then go on to rewrite the if line using the ?: operator instead: $bgCol = ($rowNum++ % 2) ? #EADBC6 : #EFE1CE; Cheers! Mike

RE: [PHP-DB] echo printing a cookie

2002-10-15 Thread Ford, Mike [LSS]
is $_COOKIE[cookiename]/p; } if (isset($_COOKIE['cookiename'])) { echo pyour cookie is {$_COOKIE['cookiename']}/p; } Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services

RE: [PHP-DB] Oracle problem

2002-10-16 Thread Ford, Mike [LSS]
averse to magic (well, other people's, anyway!). Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan

RE: [PHP-DB] losing my session variables

2002-10-30 Thread Ford, Mike [LSS]
! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan University, Beckett Park, LEEDS, LS6 3QS, United Kingdom

RE: [PHP-DB] Passing multiple form variable in PHP

2002-11-12 Thread Ford, Mike [LSS]
['icon'] will be an array of the selected values. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan

RE: [PHP-DB] HTML Forms question...

2002-11-19 Thread Ford, Mike [LSS]
as: document.form[system[]][0] document.form[system[]][1] document.form[system[]][2] etc... I know this works because I've been using it for years (even before I started programming with PHP!). Cheers! Mike - Mike Ford

[PHP-DB] RE: Access to Oracle db from PHP script

2002-11-28 Thread Ford, Mike [LSS]
I hope do not trouble you and thanks for your help. Ciao franco www.infocamere.it Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James

RE: [PHP-DB] php session

2002-12-02 Thread Ford, Mike [LSS]
, I don't see the point. Cheers! Mike - Mike Ford, Electronic Information Services Adviser, Learning Support Services, Learning Information Services, JG125, James Graham Building, Leeds Metropolitan University, Beckett Park

<    1   2   3   4   >