Re: [PHP] Change tracking

2008-10-31 Thread Mike Smith
Thanks Steven/Tony for your replies. I'll consider this a bit more before I jump in. I appreciate different perspectives. And I'll have to digest Tony's solution. Thanks, Mike Smith

[PHP] Change tracking

2008-10-31 Thread Mike Smith
le solutions or problems with these (probably the second one). Thanks, Mike Smith

Re: [PHP] Count

2008-01-17 Thread Mike Smith
Steve, Check out the while loop (http://us.php.net/manual/en/control-structures.while.php). It'll do what you need. -- Mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Another form handling posting question

2007-12-05 Thread Mike Smith
I'm trying to -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Another form handling posting question

2007-12-05 Thread Mike Smith
I am trying to recursively send data to the same form. Based on the data, I want to determine which "action" is to be processed. It appears that the $_POST is not being cleared out or cached once it is sent to the server. Here is my code that I'm trying to test with. It doesn't seem to consi

Re: [PHP] [Linux] PHP and SQL Server

2007-05-21 Thread Mike Smith
On 5/21/07, David BERCOT <[EMAIL PROTECTED]> wrote: Hi Mike, Le Mon, 21 May 2007 10:24:52 -0400, "Mike Smith" <[EMAIL PROTECTED]> a écrit : > David, > > Is MSDE running in mixed mode authentication? I believe by default it > only uses Windows authentication. If

Re: [PHP] web form data to arrays?

2007-01-17 Thread Mike Smith
s it create a sub-array of $_POST? And is it documented somewhere in the manual? Greets Zoltán Németh On sze, 2007-01-17 at 10:54 -0500, Mike Smith wrote: > > > *note the []. > > -- > Mike > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] web form data to arrays?

2007-01-17 Thread Mike Smith
*note the []. -- Mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] MSSQL Server 2005

2006-04-03 Thread Mike Smith
I am currently working on a project using SQL Server 2000. I don't think there would be a big advantage to switching to sql server 2005 for this project, but is anyone using 2005 (or one of the Express versions) with PHP? Looks like it only uses the "native client"? -- Thanks, Mik

Re: [PHP] Zoomable map

2006-03-08 Thread Mike Smith
I bought the Beta PDF of Pragmatic Ajax (http://www.pragmaticprogrammer.com/titles/ajax/?ajaxian). It actually has a chapter that walks you through creating a zooming movable map (ala Google Maps). Nice intro to Ajax too (and Frameworks). If you don't find a tutorial online somewhere I'd recommend

Re: [PHP] form & get vars

2006-02-03 Thread Mike Smith
Change: blue to: blue//You don't need the value="blue" in this case Mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] wiki question

2006-01-30 Thread Mike Smith
...dang, hit the reply, not the reply to all...Sorry about that Jay. http://sourceforge.net/projects/phpwiki/ I haven't tried it, but it looks like phpwiki supports adodb/pear, so if you've got you mssql extension loading you should be able to use it. How's that for a product end

Re: [PHP] Regex help

2006-01-13 Thread Mike Smith
Eric, thanks for replying. I couldn't quite get that to work. Albert, I'm currently working with what you suggested, though the unit names are not that consistent: $vals = preg_split(' ?X? ',$unit[1]); echo "".$unit[1]."\n"; echo "Panel: ".$vals[0]."Width: ".$vals[1]."Height: ".$vals[2]."\n"; 202

[PHP] Regex help

2006-01-13 Thread Mike Smith
ch); print_r($match); echo "Panel: ".$match[0]; } The $match array is empty. Actually looking at the data there are so many typos (imported from Excel) that I will probably have to update by hand, but out of curiosity now what would be a good regex for the info give

Re: [PHP] Is there a way to display data from database for Select Options in a form?

2006-01-10 Thread Mike Smith
On 1/10/06, Sue <[EMAIL PROTECTED]> wrote: > Hello, > > We have a form that contains a Select option for a listing of available > dates for the user to choose from. Right now we have to manually change the > dates within the form's Selection list as new dates become available to > choose from. We

Re: [PHP] Mathmatical formula

2005-12-20 Thread Mike Smith
> Let's do an experiment. Place these two lines of code in a page, then load > it in a browser; > > > $foo = (36.0*58.0)/144; > echo $foo; > > ?> > > works fine for me. If you change > > > > to > > > Yep, that does work. Thanks Jay. Mike -- PHP General Mailing List (http://www.php.net/

Re: [PHP] Mathmatical formula

2005-12-20 Thread Mike Smith
> Try; > > $foo = preg_replace($find,$replace,$partFormula); > return $foo Unfortunately no. I also tried making the formula look like this: and returning it with: eval('?>' . $a . 'http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Mathmatical formula

2005-12-20 Thread Mike Smith
I have an application that allows the users to input a formula: (Width*Height)/144 This formula gets updated with a part's specific width & height and actually returns: (36.0*58.0)/144 I use preg_replace to replace Width and Height with values from the following array: [Width] => 36.000

[PHP] Re: בעניין: Re: [PHP] Hi!

2005-12-20 Thread Mike Smith
On 12/20/05, Nanu Kalmanovitz <[EMAIL PROTECTED]> wrote: > > Thanks! > > Since I am a newbie with the Apache \ PHP \ MySQL, can u tell me what file > and what shall I add\change in it? > > TIA > > Nanu > Google for install php netware Try: http://developer.novell.com/ndk/whitepapers/namp.htm -- PH

Re: [PHP] Decision table/business rule parser?

2005-11-21 Thread Mike Smith
I'm not aware of any. I am kind of developing my own for my current Materials System. We purchase aluminum and glass from multiple suppliers. The costing of those materials can vary supplier to supplier. I'm working on an interface that will basically let the Material dept work with a Part Profile

[PHP] Combining recordsets

2005-07-20 Thread Mike Smith
I'm wondering if someone has a better solution then I've come up with. I've got a few reports that pull from various tables. Some times I'm not able to put all the tables into a single query/view. So I end up with a master query and 1 (or more) supporting queries. I'm using MSSQL 2000/IIS/PHP4/ADOD

[PHP] Include and extending classes

2005-06-16 Thread Mike Smith
I'm trying to consolidate code in a new project. My dirs are: / /inc core.class.php /mods /mods/system system.class.php //extends core.class.php user.class.php //extends system.class.php In core.class.php I have my generic special html methods and my db connection. I'm having trouble a

Re: [PHP] Retrievable weather service info?

2005-06-15 Thread Mike Smith
How about: http://www.capescience.com/webservices/globalweather/index.shtml -- Mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Re: Barcodes [Solved]

2005-05-07 Thread Mike Smith
Hi JAson, I'm leaving tomorrow for CA to do some of the testing and workflow. I'll let you know how it turns out. -- Mike On 5/6/05, Jason Barnett <[EMAIL PROTECTED]> wrote: > Mike Smith wrote: > > On 4/18/05, Eric Wood <[EMAIL PROTECTED]> wrote: > > >

Re: [PHP] Having problems connecting to MS SQL2000 server on PHP5

2005-04-29 Thread Mike Smith
Check your php.ini. It seems you are running this on Windows w/Apache. Make sure php_mssql.dll (or php_mssql.so if you are on Linux) is NOT commented out. Also, I think you'll need a SQL account. Is the SQL Server in mixed mode or Windows authentication? Look in Enterprise MAnager or the registry (

Re: [PHP] Retrieving query from MSSQL Table

2005-04-28 Thread Mike Smith
Thanks Richard, That did the trick. That and one query was in another database, that my users didn't have rights to...Doh! Works well. Thanks, Mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Retrieving query from MSSQL Table

2005-04-28 Thread Mike Smith
On 4/28/05, Richard Lynch <[EMAIL PROTECTED]> wrote: > I'm betting dollars to doughnuts that you've got a newline at the end of > $sql1 which is messing you up. You're right! Give that man a doughnut! When I tested the query in Query Analyzer. I hit [Enter] to format the query and make it readable

[PHP] Retrieving query from MSSQL Table

2005-04-27 Thread Mike Smith
t;){ $this->xq = $sql; $r = $this->db->Execute($sql1);//This doesn't work $r = $this->db->Execute($sql2);//This does work } } $sql1 & $sql2 are one and the same. Any ideas what I'm missing? Thanks, Mike Smith -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Re: Barcodes [Solved]

2005-04-18 Thread Mike Smith
On 4/18/05, Eric Wood <[EMAIL PROTECTED]> wrote: > - Original Message - > From: "Mike Smith" > I'm using a script to generate the barcodes (3 of 9 or Code39): > http://www.sid6581.net/cs/php-scripts/barcode/ > > This script seems to limit t

[PHP] Re: Barcodes [Solved]

2005-04-18 Thread Mike Smith
On 4/15/05, Mike Smith <[EMAIL PROTECTED]> wrote: > I just ordered a CueCat from eBay to play with reading Barcodes. Of > course we'll use a Symbol or some other reader when we implement this > in production, but I thought this would be a start. There are several > cl

[PHP] Re: Barcodes

2005-04-15 Thread Mike Smith
Thanks Jason, I'll pass along any info I come across. I can generate barcodes easily enough. I guess I'll wait until I get the CueCat and see what troubles I run into. Our suppliers seem willing to cooperate in terms of putting whatever barcode we tell them to. Thanks, Mike -- PHP General Mailin

[PHP] Barcodes

2005-04-15 Thread Mike Smith
);" would handle reading the barcode and submitting it. I'm assuming we would need to have all our barcodes in a single format (codabar, code39, etc). Would I then need to store barcode data. The barcodes will be generated from unique part numbers so I'm thinking I can generate them (and comp

[PHP] Creating Reports with PHP

2005-03-09 Thread Mike Smith
to be able to use MSSQL,Postgres or MySQL (ADODB or PEAR). TIA, Mike Smith -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Apache and PHP

2005-02-28 Thread Mike Smith
For Apache2.x: http://www.php.net/manual/en/install.windows.apache2.php For Apache1.x: http://www.php.net/manual/en/install.windows.apache1.php Mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Storing formulas

2005-02-17 Thread Mike Smith
as that require such modifications? TIA, Mike Smith -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Multiline data Insert Into table from a generated form?

2005-02-03 Thread Mike Smith
Change: > while ($c=0;$chttp://us2.php.net/for, http://us3.php.net/while, http://us4.php.net/foreach) I'm not sure what you mean by "form is posted to itself". Do you have the function at the top of the page with the form? If so, you can do something like if($_POST['var']){ add_to_database( $t

Re: [PHP] Multiline data Insert Into table from a generated form?

2005-02-02 Thread Mike Smith
> Code: > print ' align="center">'; > print ''; > $i = 1; > while ($i <= $tour_days) { > print ''; > print ''; > $days = ("Day 0".$i); > print $days; > print ''; > print ''; > print ''; > print ''; > print ''; > print ' wrap="virtual">'; > $i++; > } > print ''; > print

Re: [PHP] Re: Procedural to OOP

2005-01-24 Thread Mike Smith
Thanks Matthew, I appreciate your feedback. I'll be working on it this morning, and I might take a look at Smarty too. Thanks, Mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Procedural to OOP

2005-01-21 Thread Mike Smith
7;poman/class.php'); $po = new PO; $parts = $po->PartList(); echo "\n"; foreach($parts AS $part){ echo "$part\n"; } echo "\n"; //index.php Any suggestions or I do I have the general idea? TIA Mike Smith -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] PHP in MS-DOS

2005-01-17 Thread Mike Smith
On Mon, 17 Jan 2005 09:23:19 -0600, Shawn McKenzie <[EMAIL PROTECTED]> wrote: > I have not been successful with running PHP under DOS (no windows). Is > this possible? > > TIA, > Shawn Have you downloaded the PHP zip file and added c:\php (or wherever you extract it) to your path? Mike -- PH

Re: [PHP] Setting Up PHP

2005-01-06 Thread Mike Smith
You'll need to modify your httpd.conf. Depending on you OS/Apache version it will be different. For Windows/Apache1.3.x: http://us2.php.net/manual/en/install.windows.apache1.php For Windows/Apache2.x: http://us2.php.net/manual/en/install.windows.apache2.php For Linux/Apache1.3.x: http://us2.php.

Re: [PHP] first letter

2004-12-20 Thread Mike Smith
echo $name[0]; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Refreshing page after form submission

2004-12-17 Thread Mike Smith
Would something like this work If($_POST['submit']){//add error checking for whatever critical fields echo "Thank you for filling out my form.\n"; } else { //display form with a } -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Can't install PHP 5.02 with Apache2

2004-12-15 Thread Mike Smith
I think you need the httpd-devel package. Mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Differences in arrays

2004-12-02 Thread Mike Smith
> Yes, I did that and it works correctly now. I was > tryin g to better understand why the difference in the > behaviour. > > Stuart The first array is created by selecting individual elements from a muli-select list (My multi-select is a little hazy, but I think it's something like...) One (S

Re: [PHP] Differences in arrays

2004-12-02 Thread Mike Smith
How about: if ( is_array($_SESSION['schools'] ) ) { foreach($_SESSION['schools'] as $h) { If($h!=""){ //First added line $query = "INSERT INTO Prof_Schools (ProfID, School) VALUES ('$LID', '$h')"; $res6 = run_query($query); echo $query; } //End added line } } -- PHP General Mailing List

[PHP] Array to $_GET variable

2004-11-10 Thread Mike Smith
I am trying to cache a database recordset so users can sort, etc without hitting the database everytime. I'm using ADODB to access a MSSQL database. $s = "SELECT id, part, description FROM parts\n"; $r = $db->Execute($s); $parts = array(id=>array(),part=>array(),desc=>array()) while(!$r->EOF){

Re: [PHP] Sessions question

2004-10-21 Thread Mike Smith
ndreds of methods how several users log in, upload, log > out etc. so I can not test them all... :( > > It seems that sometimes the $_SESSION['user_id'] of the several users > get mixed and this may not happen. > > I don't know if this is a known bug or if there

Re: [PHP] Sessions question

2004-10-21 Thread Mike Smith
On Thu, 21 Oct 2004 11:39:23 +0200, Reinhart Viane <[EMAIL PROTECTED]> wrote: > Hey all, i'm new to this list so forgive me if i make any huge > mistakes. > I'm in a beginning stage of learning php and i hope you guys can help me > out with this question: > > in a file named checkuser i do this w

Re: [PHP] url

2004-10-20 Thread Mike Smith
My guess is your client has the latest version of PHP (>4.2.0) whiile the old server had an older version (pre 4.2.0). register_globals = off in the php.ini http://us2.php.net/manual/en/ini.sect.data-handling.php#ini.register-globals Change to On Wed, 20 Oct 2004 10:07:38 -0700 (PDT), Dan McC

[PHP] OOP design question

2004-01-05 Thread Mike Smith
) $po everytime the page reloads? $po = new PO; } If($_POST['submit']){ $po->AddItem(); } ...form fields and a submit button... $po->DisplayItems(); ?> Is this a good basic methodology (aside from checking the form fields for valid characters). Thanks, Mike Smith

[PHP] Re: mssql_connect problem

2003-12-17 Thread Mike Smith
quot;; $password = "dbpassword"; mssql_connect($server,$user,$password); Check php.ini, uncomment out extension=php_mssql.dll If your running php on a server that does not have SQL Server on it, I think at least you need to install the SQL client tools. Good luck! Mike Smith -- PHP Gener

[PHP] Re: Starting OOP

2003-12-16 Thread Mike Smith
class and setting it in the constructor function. "Mike Smith" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] I've been doing procedural coding for a few month's, but perceive the need for OOP for some of the projects I've done. I'm starting

[PHP] Starting OOP

2003-12-15 Thread Mike Smith
I've been doing procedural coding for a few month's, but perceive the need for OOP for some of the projects I've done. I'm starting out and and would like some feedback, before I tread down the wrong path. The books I'm looking at Professional PHP (Wrox), and Visual QuickStart PHP have examples

[PHP] Re: connect to MAS 90 & 200 with PHP

2003-07-07 Thread Mike Smith
I have used MAS90. If you're using MAS90 you'll need to create an ODBC connection (http://us3.php.net/manual/en/ref.odbc.php). If it's MAS200 (SQL) use mssql functions (http://us3.php.net/manual/en/ref.mssql.php). By installing the MAS90 client software you install the necessary ODBC drivers assumi

RE: [PHP] Subtotal

2003-03-19 Thread Mike Smith
tamps. -Original Message- From: Adam Voigt [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 8:37 AM To: Mike Smith Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Subtotal Umm, add: SUM([rushqty]) AS 'rushsub' To your select, wouldn't that work? On Wed, 2003-03-19

RE: [PHP] Subtotal

2003-03-19 Thread Mike Smith
Original Message- From: Marek Kilimajer [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2003 8:19 AM To: Mike Smith Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Subtotal SELECT *, SUM(units) subtotal FROM table GROUP BY date - do you mean this? Mike Smith wrote: >I'm tryin

[PHP] Subtotal

2003-03-18 Thread Mike Smith
$body .= "\n"; $body .= "$row[8]\n"; $body .= "\n"; $body .= "\n"; $body .= "$row[9]\n"; $body .= "\n"; $body .= "\n"; $body .= "$row[10]\n"; $body .= "\n"; $body .= "\n"; } ... //close table, html ?> Any help is appreciated. Thanks, Mike Smith -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Wrapping SQL results in 2 tables

2003-01-21 Thread Mike Smith
Mike Smith; [EMAIL PROTECTED] Subject: Re: [PHP] Wrapping SQL results in 2 tables --- Mike Smith <[EMAIL PROTECTED]> wrote: > I'm trying to present a phone directory in a > printable format that will make "most" people > happy. What I need to do is take the results

[PHP] Wrapping SQL results in 2 tables

2003-01-21 Thread Mike Smith
I'm trying to present a phone directory in a printable format that will make "most" people happy. What I need to do is take the results from our database and "break" it into two tables. ie. Extension FName LName Dept. ...25x Extension FName LName Dept. ...Records 26+ This is what I have don

RE: [PHP] Escaping '#' Sign

2002-12-13 Thread Mike Smith
ome up with a simple Edit form (custmaint.php) with a list of customers below the form. When you click on the edit.gif it links to itself ($PHP_SELF really). I've actually come a long way since I've started scripting in PHP, but would appreciate any pointers. Thanks for pointing me in the rig

RE: [PHP] Escaping '#' Sign

2002-12-12 Thread Mike Smith
--+ |company T/T | ++ *Note lack of #29 which I do see in the HTML table. If I save (UPDATE WHERE id=$id) this record cust will now be company T/T All the other fields fill in correctly. Is it seeing the # as a comment? -Original Message- From: Ric

[PHP] Escaping '#' Sign

2002-12-11 Thread Mike Smith
I have a string I'm returning from a database. Some entries have # signs in the names ie (COMPANY #42, COMPANY #43...). When I display results all I have is COMPANY. Everything after the # is dropped off. I tried: If ($cust) { $cust2=ereg_replace('#','no',$cust); //tried $cust2=ereg_replace("

[PHP] Re: Forms

2002-12-10 Thread Mike Smith
Set the FORM ACTION="script.php" and METHOD="POST" ie... John Mary script.php: Beauford.2002 wrote: Hi, I'm sending this to both lists as I'm not sure where the problem is, but I believe it is an issue with my HTML form. Here's the problem: I have a drop-down menu form on my webpage wit

Re: [PHP] Fractions

2002-12-10 Thread Mike Smith
Stephen wrote: I found how it works, and it doesn't put it into a mixed number. I work on it this week and see if I can't fix it. Thanks for all the help people! - Original Message - From: "Andrew Brampton" <[EMAIL PROTECTED]> To: "Stephen" <[EMAIL PROTECTED]> Sent: Monday, December 09,

[PHP] Re: Echo Regular Expression Pattern

2002-10-10 Thread Mike Smith
Nevermind. This works: ereg("Q+[0-9]{6}",$Data[$n],$qarticle); $GetLine = explode("\r", ereg_replace("Q+[0-9]{6}","http://support.microsoft.com/default.aspx?scid=kb;[LN];$qarticle[0]\"; target=\"blank\">$qarticle[0]",$Data[$n]));

[PHP] Echo Regular Expression Pattern

2002-10-10 Thread Mike Smith
xt of the link. The script runs but produces: http://support.microsoft.com/default.aspx?scid=kb;[LN];Q+[0-9]{6} and echos Q+[0-9]{6} as the clickable link. Thanks, Mike Smith -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Variable Variables

2002-09-11 Thread Mike Smith
ble are for Recvd qty and Back Order Qty. The problem is I could have 1 line item or I could have 10 line items. So if I have 1 item and my SQL is "UPDATE tbl_podetail SET bkorder=$bkord WHERE id=$detid" that will work fine, but if I have 10 items, the same UPDATE statement will only upd