RE: [PHP-DB] MultSelect ListBox hell!

-Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: 22 September 2004 15:27 [] //base sql statement $sql = select * from jobs where record_deleted = 'NO' ; if (isset($_POST['states'])){ //check to see if the states is an array (multiple items or just

RE: [PHP-DB] MultSelect ListBox hell!

-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!

-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!

On 22 September 2004 18:45, Stuart Felenstein wrote: Just to confirm, This is what I'm going to start with: Yeah, I'd say you've pretty much got it, except... //base sql statement $sql = select * from jobs where record_deleted = 'NO' ; if (isset($_POST['states'])){ Your SQL is going to

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

On 23 September 2004 07:47, Ed Lazor wrote: I keep looking at the following code and thinking there's gotta be a better way. I've been in front of the computer all day tho and I'm drawing a blank. Any ideas? Seems to me we've just answered a very similar question to this (and I'd be

RE: [PHP-DB] MultSelect ListBox hell!

On 23 September 2004 20:53, Stuart Felenstein wrote: So here is what I have: //Here is defines the field variable and uses //CodeCharge function to grab the variable $s_Industry = CCGetParam(s_Industry, ); $s_LocationState = CCGetParam(s_LocationState, ); $s_TaxTerm =

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

On 28 September 2004 18:15, [EMAIL PROTECTED] wrote: To the list: I've googled and searched the manual, but I'm still looking for a simple solution to a simple problem. I have a MySQL database of text stories in longtext MySQL fields. These stories have simple returns (\r) in them and no

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

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 01 November 2004 05:01, Doug Thompson wrote: The variables are not being expanded. As a minimum, you need to escape the single quotes. $query = SELECT * from user where

RE: [PHP-DB] Forms list from database

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 01 November 2004 21:11, Jason T. Davidson wrote: Here is the code: form name=form1 method=post action=staff_code/add_code.php table width=600 border=0 align=center

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

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 11 November 2004 19:11, Patrick David wrote: My understanding of persistent connections was that using the ociplogon function a connection would be opened to the database and

RE: [PHP-DB] PHP / Javascript question

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 16 November 2004 03:03, Chris Payne wrote: This is OT, really, but because it's an easy answer: if ( document.removeitems.del.value == ) BUT because the tickboxes

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

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 16 November 2004 15:12, Neil Smith wrote: That if (df[i].checked=true) { should of course read if (df[i].checked==true) { No it shouldn't -- it should read if

RE: [PHP-DB] Transaction suddenly not working

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 29 November 2004 13:19, Stuart Felenstein wrote: Now the printout of the query is this: 0: INSERT INTO Table1 (LurkID, ProfileName, Edu, WorkAuth, WorkExp, CarLev, Secu,

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

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 30 November 2004 14:45, SCALES, Andrew wrote: Thanks very much for your help. The main difficulty I was having really was unlocking the record again if the user crashed out

RE: [PHP-DB] mysql_array_array

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 03 December 2004 13:15, Yemi Obembe wrote: $sql = SELECT * FROM arcadia WHERE email=$v; $sql_in = INSERT INTO arcadia ('email') VALUES ('$v'); Spot the difference: you

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

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 03 December 2004 14:39, Stuart Felenstein wrote: I want to send back a message when no matches are found on my search page. Basically No matches found. I assumed that

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

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:06, Stuart Felenstein wrote: The closing ? of a PHP segment also implies an end-of-statement semicolon -- so the above is equivalent to: if

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

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:16, Stuart Felenstein wrote: --- Stuart Felenstein [EMAIL PROTECTED] wrote: The reason the close is there is because the next line of code is the

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

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

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

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 16 December 2004 06:00, neil wrote: Hi I am needing to convert a d/m/y date such as 30/11/2004 into the format that mysql can use ie. 2004-11-20 If I try the following:

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

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 16 December 2004 12:51, Vincent KONIECZEK wrote: Hi there, I was testing PHP 4.3.10RC2 with a well-tested web application when I saw it failed badly. After a little

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

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 21 December 2004 07:58, amol patil wrote: hallo friend, i have developed simple and small database website using php ,html and java script. but i am getting these three

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

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 20 December 2004 21:50, Warren wrote: Hello, I am running PHP 4.39 as a CGI under Tomcat 5.025, Linux 2.4.20-31.9. Configure = './configure'

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

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 23 December 2004 01:12, Keane, Warren A FIN:EX wrote: I did try if (empty($_GET)) { parse_str($_SERVER['QUERY_STRING'],$_GET); } which worked so I guess I should be able

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

then on 102 thank you. Ford, Mike [EMAIL PROTECTED] wrote: To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 21 December 2004 07:58, amol patil wrote: hallo friend, i have developed simple and small database

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

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 06 January 2005 16:39, Jochem Maas wrote: Hutchins, Richard wrote: echo $dsn; $isPersistant = TRUE; doesn't effect the code but 'Persistant' is spelled 'Persistent' Oh

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

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

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!

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 10 January 2005 09:28, JeRRy wrote: With PHP latest release from http://php.net/ do we require to update Zend Optimizer? Yes. People are claiming some scripts previously

RE: [PHP-DB] mysql - image storing

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm On 18 January 2005 17:11, Joseph Crawford wrote: Jason, can you explain why stripslashes should not be used on data taken from the db? when you store data in the db i thought it

RE: [PHP-DB] timestamp

To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm -Original Message- From: Balwant Singh [mailto:[EMAIL PROTECTED] Sent: 01 February 2005 08:08 on echoing $timestamp i m getting Fri Jan 28 19:53:09 2005 but on

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

On 02 December 2005 13:06, Bastien Koert wrote: ?php for ($j=ord('A'); $j = ord('Z'); $j++) { echo | ba href='alpha.php?artist=.chr($j).'.chr($j)./a/b ; } ? You need to use the ORD function to get the numerical ascii equivalent of the letter and the CHR function to go back the

RE: [PHP-DB] Quick question

On 08 December 2005 20:53, Chris Payne wrote: Hi there everyone, How do I set the following items with ini_set()? I looked at the manual but when I try nothing happens: * file_uploads * upload_max_filesize * max_input_time * memory_limit *

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

On 24 March 2006 16:40, Alex Major wrote: Thanks, works like a charm (had to make is -2 instead of -1 as it added a space after each result). Hadn't thought of something so simple. On 24/3/06 16:22, Bastien Koert [EMAIL PROTECTED] wrote: Build it up as a string and remove the trailing

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

On 25 May 2006 12:12, Girish Agarwal wrote: Hi All, I am using header(Location: http://dv-medical/phpscripts/test.php;) function to hop from one Page to Another in My Web Application My Problem is I have been unable to get the exact syntax to append the Session ID to the

RE: [PHP-DB] detecting negative numbers

On 17 July 2006 01:07, Dave W wrote: No, I get it. I just thought that there might have been some built in function like if(neg_num($quant - $amount)) or something like that. I know how to do it, but I thought that there might have been an alternate method. Just because I asked a simple

RE: [PHP-DB] weird comparsion

On 03 May 2007 12:30, OKi98 wrote: I know about identity operator (===) but with == operator 0 is false and foo is true No, that's not correct. , try this: $foo=0; $bar=bar; if ($foo) echo($foo is true, ); else echo($foo is false, ); if ($bar) echo($bar is true, ); else

RE: [PHP-DB] variable with NULL value

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] Re: PHP and table/view names with '$'

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...

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_params()

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

-Original Message- From: Govinda [mailto:govinda.webdnat...@gmail.com] Sent: 05 August 2009 01:41 Taking this: SELECT count(*) AS `CountUniqueDatesInMyTbl`, date(solarAWDateTime) AS `uniqueDate`, 'aweber_7solar_aw' AS `tableAlias` FROM aweber_7solar_aw GROUP BY

RE: [PHP-DB] losing MySQL resource

-Original Message- From: Nehemias Duarte [mailto:ndua...@aflac.com] Sent: 11 November 2009 14:25 To: Stan; php-db@lists.php.net Subject: RE: [PHP-DB] losing MySQL resource I was under the impression that session_start() had to be the FIRST thing ran in the script. Is this

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

-Original Message- From: Simcha Younger [mailto:sim...@syounger.com] Sent: 04 August 2010 08:19 paul_s_john...@mnb.uscourts.gov wrote: THE INPUT: $sql_insert_registration = sprintf(INSERT INTO Registrations ( Class_ID, prid, Registrant,

RE: [PHP-DB] SELECT

-Original Message- From: Ron Piggott [mailto:ron.pigg...@actsministries.org] Sent: 17 October 2011 18:38 I need help creating a mySQL query that will select the correct introduction message for a website I am making. The way I have designed the table I can’t wrap my mind around

RE: [PHP-DB] SELECT

-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

-Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: 26 November 2012 08:48 To: php-db@lists.php.net Subject: Re: [PHP-DB] Re: Formatting Ethan, is this valid PHP? What is the ampersand for? What is it doing? Just curious. $args[] = $_POST[$k]; // Note

RE: [PHP-DB] Corn job anomaly

> -Original Message- > From: Karl DeSaulniers [mailto:k...@designdrumm.com] > Sent: 25 September 2016 09:59 > To: PHP List Database > Subject: Re: [PHP-DB] Corn job anomaly > > Now I am getting an error with mysql syntax. > > "SELECT otn.*, cf.* FROM ".ORDER_TABLE."

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

-Original Message- From: Andy [mailto:[EMAIL PROTECTED]] Sent: 04 January 2002 20:24 To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Array not supported for strings??? $stmt= SELECT country from $DB2.$geo_T1 where country_code = '$country_id[$i]' ;

RE: [PHP-DB] Oracle date conversion

-Original Message- From: David C. Norris [mailto:[EMAIL PROTECTED]] Sent: 26 December 2001 17:00 Oracle DATEs are retrieved (by ora_fetch_into($cursor, $row, ORA_FETCHINTO_NULLS), for example) as plain dates (e.g., '26-DEC-01'), losing the time of day (as in '26-DEC-01 12:34:56').

RE: [PHP-DB] oracle connectivity problem

-Original Message- From: Rajiv Khandelwal [mailto:[EMAIL PROTECTED]] Sent: 27 December 2001 10:59 hi, I am facing a strange problem. I have oracle 8.1.6 (server) installed on linux and am trying to access it thru PHP from a client machine (again Linux). I was successful in

RE: [PHP-DB] mysql_num_rows

-Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: 06 January 2002 20:10 I am pretty sure that the query is correct. here is the actual query: $query=select distinct(nodeid), nodename from books where bookid=$bookid;

RE: [PHP-DB] mysql_num_rows

-Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: 06 January 2002 20:10 I am pretty sure that the query is correct. here is the actual query: $query=select distinct(nodeid), nodename from books where bookid=$bookid;

RE: [PHP-DB] mysql_num_rows

-Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: 08 January 2002 14:10 don't know if this makes a difference, but i've always used WHERE bookid = '$bookid'; - single quote round the $bookid variable - not sure if that's the problem, or if it's just good

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

Using the Oracle OCI interface, as far as I can see if I do the following: $stmt = OCIParse($conn, 'DELETE FROM TITLES' . ' WHERE TAG0' . ' RETURNING ID INTO :T_ID'); there seems to be no way of picking up more than one ID when

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

-Original Message- From: maxim [mailto:[EMAIL PROTECTED]] Sent: 23 May 2002 17:00 Hi all! The problem is I can't get expected datetime value from SELECT query on Oracle table that has a field of type DATE. Seems like datetime looses its time part. The default format for

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

-Original Message- From: maxim [mailto:[EMAIL PROTECTED]] Sent: 23 May 2002 17:00 Hi all! The problem is I can't get expected datetime value from SELECT query on Oracle table that has a field of type DATE. Seems like datetime looses its time part. The default format for

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

-Original Message- From: Micah Stevens [mailto:[EMAIL PROTECTED]] Sent: 23 September 2002 18:09 I've been running into a strange problem on my server with scripts that take form input and reformat it into SQL. It only happens with statements that insert or update data, the

RE: [PHP-DB] getting mysql_fetch_row into array

-Original Message- From: LSC Exhibits Department [mailto:[EMAIL PROTECTED]] Sent: 23 September 2002 18:17 Going through brain-lock here. From this query Select count(deptid) from maintenance group by deptid ,I get 11 rows. What I need to do is get an array like

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

-Original Message- From: Valantis Kamayiannis [mailto:[EMAIL PROTECTED]] Sent: 24 September 2002 12:37 I made a class called OracleCon that is used to connect to an Oracle server and provide some certain queries to the database When i create an object of that class and serialize

RE: [PHP-DB] Session understanding

-Original Message- From: Griffiths, Daniel [mailto:[EMAIL PROTECTED]] Sent: 26 September 2002 16:09 as long as that same session code is present at the top of all the included files that are put in later. basicaly you need to put the session code in every page (even if you only

RE: [PHP-DB] Current row of query

-Original Message- From: Patrick Lebon [mailto:[EMAIL PROTECTED]] Sent: 26 September 2002 16:20 This is how im currently doing it... $rowNum = 0; while ( $row = mysql_fetch_array($result) ) { $rowNum++; if ($rowNum % 2) { $bgCol = #EADBC6; } else { $bgCol = #EFE1CE; }

RE: [PHP-DB] echo printing a cookie

-Original Message- From: Steve Dodkins [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 14:22 To: Php-Db (E-mail) Hi I'm trying to print the contents of a cookie (php 4.2.3) the syntax below is wrong but what should it be? if ($_cookie[cookiename]== TRUE) { echopyour cookie

RE: [PHP-DB] Oracle problem

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 16 October 2002 08:51 To: [EMAIL PROTECTED] Has anyone out there using PHP and Oracle come across this problem? I have a text area that allows free-form text that I store in a varchar2 column. I

RE: [PHP-DB] losing my session variables

-Original Message- From: Peter Beckman [mailto:beckman;purplecow.com] Sent: 30 October 2002 04:09 To: Seabird Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] losing my session variables Put session_start() somewhere in your code. .. but make sure that somewhere is before you do any

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

-Original Message- From: Stephen Rhodes [mailto:stephen.rhodes;scils.co.uk] Sent: 12 November 2002 16:32 Wanting to use select multiple ... in a html form and pass multiple value into a php variable but does not work. I only get a single value. Can you tell me what I am doing

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

-Original Message- From: Rich Gray [mailto:[EMAIL PROTECTED]] Sent: 20 November 2002 01:13 If you name the checkbox as name=system[] then PHP will automatically create an array of the checkbox values which can be subsequently accessed via $_POST['system'][n] - be warned however

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

Sorry, I think you'd be better off asking this on the php-db mailing list, so I've copied it into this reply -- I didn't set up the Oracle I connect to, and I just make use of connect functions written for the purpose by the Oracle expert on the next desk! I have find your e-mail at this

RE: [PHP-DB] php session

-Original Message- From: Chris Barnes [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 02:14 On Mon, 2002-12-02 at 02:43, John W. Holmes wrote: No, it shouldn't. So, the links are correct on one page, and they disappear on the second page? Is there a reason you're

RE: [PHP-DB] RE: adding in arrays

-Original Message- From: Martin Allan Jensen [mailto:[EMAIL PROTECTED]] Sent: 10 December 2002 12:41 But, now i need to make another loop where it takes the key [2000] and put's it into $year and takes the value 300 and put it into $value Can you help me with it, am really not

RE: [PHP-DB] Global variables

-Original Message- From: Jim [mailto:[EMAIL PROTECTED]] Sent: 10 December 2002 18:51 Can I define a global variable in a function and then successfully reference it in the rest of the page? Yes. (Why didn't you just try it?) Cheers! Mike

RE: [PHP-DB] Final question of the week :-)

-Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED]] Sent: 10 December 2002 23:10 I use the following code to collect date from multiple tickboxes on my form: if (count($selection) = 1) { for ($i=0;$icount($selection);$i++) { echo $selection[$i]; }};

RE: [PHP-DB] Sessions problems

-Original Message- From: Sabina Alejandr Schneider [mailto:[EMAIL PROTECTED]] Sent: 05 January 2003 20:17 Hello everybody I was trying to use Sessions, but I had some problems. I have an old version of the Apache, that comes with the Red Hat 7.2. when executing this in

RE: [PHP-DB] Concatenate two strings

-Original Message- From: Bruno Pereira [mailto:[EMAIL PROTECTED]] Sent: 15 January 2003 14:48 How can i join two strings. My code is something like: $valor1=bruno; $valor2=Pereira; $valor=$valor1 + + $valor2 Can someone help me. Thanks.

RE: [PHP-DB] getting client browser info

-Original Message- From: Mignon Hunter [mailto:[EMAIL PROTECTED]] Sent: 20 January 2003 16:32 Question: Why is it that from an IE client I get the following: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) Why does it say mozilla ??? The clue here is in the next word:

RE: [PHP-DB] getting client browser info

-Original Message- From: Mignon Hunter [mailto:[EMAIL PROTECTED]] Sent: 20 January 2003 17:05 Does anyone know of script or tutorial to point me to that can obtain client browser info, (got that part) but then using php, be able to use if statements to distinguish what they're

RE: [PHP-DB] getting client browser info

-Original Message- From: Mignon Hunter [mailto:[EMAIL PROTECTED]] Sent: 20 January 2003 18:40 Ah, but I wasnt at a mozilla browser, I was accessing this script from a ie browser client. Let me repeat -- that was the IE browser *masquerading* as Mozilla-compatible. ALL versions

RE: [PHP-DB] Re: problems with variables

-Original Message- From: Mark [mailto:[EMAIL PROTECTED]] Sent: 04 February 2003 14:38 Just a quick correction... if the q part is static, I believe you should use $(q$i) rather than ${$q . $i} Well, actually, I think you want ${'q'.$i} -- or even ${q$i} Cheers! Mike

RE: [PHP-DB] More help with mysql -- solved (bizarre)

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 18 February 2003 08:26 If I remove the '|| die' part from the mysql_query() statement, it works fine. This is bizarre, but there it is. ie, if I have: $result = mysql_query(SELECT * FROM SOME_TABLE);

RE: [PHP-DB] Final Date Question :-)

-Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED]] Sent: 20 February 2003 01:52 OK here is a final date question. It's complex (Atleast to me :-( but i'm totally stumped. Here's what I need to do. Say September is Summer and October is winter, now getting the

RE: [PHP-DB] Re: Does Php support Flash files ?

-Original Message- From: Matthew Moldvan [mailto:[EMAIL PROTECTED] Sent: 19 March 2003 18:32 I am assuming English isn't your first language. Yes, fuck is definitely swearing, cursing, or whatever else you would like to call it. And yes, it is considered rude in our culture.

RE: [PHP-DB] Re: deleting records using a checkbox

-Original Message- From: Paul Burney [mailto:[EMAIL PROTECTED] Sent: 20 March 2003 15:22 on 3/20/03 1:45 AM, olinux at [EMAIL PROTECTED] appended the following bits to my mbox: [ and ] are illegal characters. #javascript I'm coming into this a bit late, so I'm not sure

RE: [PHP-DB] while - if - problem

-Original Message- From: Earl [mailto:[EMAIL PROTECTED] Sent: 04 June 2003 22:04 To: PHP-DB FYI this was beginning to bug me out... so I decided to try the trim function and walla... it worked. Thanks for ya'll assistance. I was going to say this even before you added

RE: [PHP-DB] Multiple inserts revisited

-Original Message- From: Becoming Digital [mailto:[EMAIL PROTECTED] Sent: 28 May 2003 23:38 My other option, as I saw it, was to loop through the items, appending value data to the query text with each iteration. If that seems cryptic, here's a basic idea of what I mean. ?

RE: [PHP-DB] Array Pointer

-Original Message- From: Ian Fingold [mailto:[EMAIL PROTECTED] Sent: 03 June 2003 16:58 Ok I'm trying to write this function to up date some fields in my database so i'm grabbing some info from a query and throwing it into an array (with mysql_fetch_array). one of the values

RE: [PHP-DB] PHP sort from a database variable..?

-Original Message- From: heilo [mailto:[EMAIL PROTECTED] Sent: 03 June 2003 23:35 sorry, needed some time to hack this one ::) as your print_r shows that you have to sort an array which includes objects (in this case an ingress-class - whatever this is). i tried to simulate

RE: [PHP-DB] Is this query even possible?

-Original Message- From: Susan Ator [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 16:18 This is what I am trying to do: if ($FUNC==(USERPOST) || $FUNC==(MODU)) { $sql = UPDATE newdacs SET emailfwd='$emailfwd',

RE: [PHP-DB] Count database-values

-Original Message- From: Becoming Digital [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 12:15 I screwed up my own code. Silly me. It should read: Surely your first attempt is the right one? There's only ever going to be 1 Total, so why waste a while loop trying to read more than

RE: [PHP-DB] Is this query even possible?

-Original Message- From: Matthew Moldvan [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 16:50 As for the line breaks, I've used SQL formatted that way before and it hasn't cause me any problems. It's a matter of preference, but I prefer to keep my query strings as lean as possible

RE: [PHP-DB] Help Please!! Oracle/PHP connection

-Original Message- From: Matthew Moldvan [mailto:[EMAIL PROTECTED] Sent: 11 June 2003 01:03 Have you tried the built in Oracle functions in PHP? http://us3.php.net/oracle That's only for Oracle up to version 7. For Oracle 8 or 9, use the OCI extension http://www.php.net/oci8.

RE: [PHP-DB] setting session variables via a form

-Original Message- From: Hutchins, Richard [mailto:[EMAIL PROTECTED] Sent: 16 June 2003 17:08 session_start(); session_register(isRegistering); $_SESSION[isRegistering] = true; B't! If you're using the $_SESSION array, then you MUST NOT use

RE: [PHP-DB] moving though an array..SOLVED

-Original Message- From: Aaron Wolski [mailto:[EMAIL PROTECTED] Sent: 26 June 2003 16:12 Solved my problem! Here's the code in case anyone really cares :P $col = explode(,,$threadsColumn); $col_search = (; for ($i=0;$icount($col);$i++) {

RE: [PHP-DB] error checking question

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 26 June 2003 20:22 What I would like to do is somehow have a redundant error check on the server side and then display an error message above the form on the main page should fields be left blank or

RE: [PHP-DB] latest version of php only cgi?

-Original Message- From: Doug Finch [mailto:[EMAIL PROTECTED] Sent: 26 June 2003 21:12 Is the newest version of php 4 only available as a cgi-based program? DF No. Cheers! Mike - Mike Ford, Electronic

RE: [PHP-DB] problem with starting a session

-Original Message- From: Ahmed Abdelaliem [mailto:[EMAIL PROTECTED] Sent: 15 July 2003 08:54 i have a problem with starting a session in the page that validates the user input and sends it tothe database, when the user clicks register he gets this error Warning:

RE: [PHP-DB] Searching a file for text surrounded by brackets

-Original Message- From: Jamie Saunders [mailto:[EMAIL PROTECTED] Sent: 16 July 2003 11:20 Hi, I need a way of searching a file for text between two brackets, below is an example of a couple of lines from the file I'm searching: trtdfont size=2{L_LOGIN}/font/td/tr trtdfont

RE: [PHP-DB] Maximum execution time of 30 seconds exceeded

On 11 August 2003 07:02, Michael Cortes wrote: I am using the Konqueror browser and browing to http://localhost/my.php Howerver, the script I wrote, doing various queries and lookups, inserts, etc.. takes a while to complete. That is fine with me. I'll wait. However, the server

RE: [PHP-DB] Populating an array from mysql db

On 28 August 2003 17:25, mike karthauser wrote: on 28/8/03 5:00 pm, CPT John W. Holmes at [EMAIL PROTECTED] wrote: Thanks for this - I ended up rehashing my query to this: ? $result = mysql_query(SELECT * FROM dates WHERE bookcode = '$bookcode' ORDER BY date1,$db);

RE: [PHP-DB] Beta 2 of plPHP released.

On 29 August 2003 05:27, Joshua D. Drake wrote: Hello, Beta 2 of plPHP has been released. This version contains many bug fixes. For example, if you write bad plphp code and try to execute it, the code will no longer crash PostgreSQL ;). It would be nice if you told us what plPHP

RE: [PHP-DB] weird php error

On 29 August 2003 06:39, OpenSource wrote: Hi guys, This is weird to me.. I got this script --- ?php if ($_GET[login] == 'forgot') { echo Sorry I forgot my password; } else { echo you are

  1   2   >