[PHP] Field type for american money

Php - MySQL - newbie question - Field type for american money - int(11) seems to work fine - but also I tried decimal(10,2) Is one a better choice than another for american money usage? -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http

Re: [PHP] Redirect not working on server

Thank you Jay - Shawn & Paul for helping this newbie! -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Redirect not working on server

I found the answer here - I had --- whitespace & ... if http://www.phpbuilder.com/board/showthread.php?t=10310794 Blank space above the php tag or below the final php tag It is not intuitive but ... if http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Redirect not working on server

On 6/2/2009 12:41 PM, "revDAVE" wrote: >> [snip] >> I have this line at the end of 1 big php block... >> >> header('Location: mypage.php?id=' . >> $_SESSION['id'].'&cat='.$_SESSION['cat']); >> &

Re: [PHP] Redirect not working on server

THANK YOU JAY, BTW: I'm a newbie They seem to be fine - and have proper content I added this: error_reporting(E_ALL); If I put this on a page isn't it supposed to override other server setting and display errors? It's not - This the page is blank - except for the echo test BTW:

[PHP] Redirect not working on server

e is php 5 Server (not sure) might not be 5 - maybe v4 Could that be the problem? -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Newbie - Setting Up Some Basic Sendmail Scripts

Location: http://pear.php.net/package/Mail - - - - - Info: Current Release» Bug Summary 1.2.0b1 (beta) was released on 2008-07-02 (Changelog) 1.1.14 (stable) was released on 2006-10-11 (Changelog) -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (htt

[PHP] Newbie - Setting Up Some Basic Sendmail Scripts

tication - smtp - port - sending user / pass etc. Any hints how to get this to the next level? Thanks in advance - dave -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: htt

Re: [PHP] Setting Up A Directory For HTTPS Secure Certificate

GOAL : no one will be able to get to HTTPS directory VIA HTTP. So I make this little tester page that seems to work Later I'll add auto redirect Is this the kind of thing to add to various pages? Is there a better way to do this? -- Thanks - RevDave Cool @ hosting

[PHP] Setting Up A Directory For HTTPS Secure Certificate

older/ ? - Someone mentioned modifying the .htaccess file and add some redirects - I'll need some help with exactly how to do it - any ideas? - also I imagine I can write some PHP code to redirect pages... Q: what is the best way to accomplish this? Thanks for your help -- Thanks - RevDave Cool @ ho

Re: [PHP] Trying To Read - Show A Csv File Line By Line

On 3/20/2009 2:37 PM, "kirk.john...@zootweb.com" wrote: > revDAVE wrote on 03/20/2009 03:11:00 PM: > >> Newbie ... I'm trying to Trying to read / show a csv file line by line > ... > > fgetcsv is your friend. > > http://us.php.net/manual/en/funct

[PHP] Trying To Read - Show A Csv File Line By Line

in advance = '; } fclose($handle); } ?> -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Importing Data with Field Names

s) I could use some help getting started with this -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Dynamic Form 'on The Fly'

OST['$this']; $cnt++ Q: ANY Ideas? -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Summary Report With Details - Newbie Question

].' '.$a['id'].' - loc: '.$a['condition'].' 1'; } else { $count++; $productlast = $a['model']; $show = $show . $a['model'].' '.$a['id'].' - loc '.$a[' condition'].' 2 '; } } -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Summary Report With Details - Newbie Question

you correctly...), but I would like to have a title line (above) say: MODEL - 22-A - COUNT: 39 At the top ... Currently - the way I have it wants to display the *count BELOW* the line items - (when it's done counting) .. And I fooled with this line; echo ' COUNT: '.$count.' final previous'.''; Which 'sort of' shows at top - but doesn't really help the 1st item... Q: any way to improve this? -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: Summary Report With Details - Newbie Question

. 1 - on this line I get : Warning: Wrong parameter count for next() in /Libr... while($row = next()) - I tried this - with no errors while($row = mysql_fetch_assoc($getall)); // not sure if it's right? -- 2 - Then got error here: Warning: Cannot use a scalar value as an array in /Librar

Re: [PHP] Fatal error: Call to undefined function: mysqli_connect() in

all works fine now ... Not sure how godaddy does it... Maybe ask tech support How to set up Remote MySQL access -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] English Website That Can Display Some Chinese Text

ike this possible? If so how is this done...? Is there something special that needs to be done with PHP & mySQL? -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Summary Report With Details - Newbie Question

work fine. I was just wondering if there is a better way to construct queries to get the same result? Thanks in advance for your help... -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Dynamic Date List Newbie Problem

On 3/12/2009 12:25 PM, "Paul M Foster" wrote: > Crap, I hit the wrong button and sent this only to the OP... > > On Thu, Mar 12, 2009 at 09:24:48AM -0700, revDAVE wrote: > Thanks for your help Paul - that makes sense! > > Here is working code to do it bette

Re: [PHP] Dynamic Date List Newbie Problem

ot > sure how many days the previous month had (without doing another call to > find out). > > -TG SOLVED - Thanks so much Andrew & TG >From your examples - I was able to create this working table going back 2 years - thanks again! Dates

[PHP] Dynamic Date List Newbie Problem

7;,$nowts-(86400*28))."/1/".date('y',$nowts-(86400*28)); $m03 = date('m',$nowts-(86400*58))."/1/".date('y',$nowts-(86400*58)); $m04 = date('m',$nowts-(86400*88))."/1/".date('y',$nowts-(86400*88)); $m05 = date('m',$nowts-(86400*118))."/1/".date('y',$nowts-(86400*118)); $m06 = date('m',$nowts-(86400*150))."/1/".date('y',$nowts-(86400*150)); $m07 = date('m',$nowts-(86400*180))."/1/".date('y',$nowts-(86400*180)); Q: Any ideas how to fix this issue? (please try to keep it simple - 'cause I ain't no math wiz either) -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Re: Setting Up A Web Subscription Service

Thanks HallMarc & Nathan for the recommendations! -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Header - Redirect Command Not Working

> > This kills three birds with the same stone like so: > > 1.) It tries to use the header() location redirect. > 2.) It falls back on browser-based redirection. > 3.) It forces a flush() of the data to the client, regardless > of minimum size limits. &

[PHP] Header - Redirect Command Not Working

ommand/function) - or am I doing something wrong? -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Setting Up A Web Subscription Service

The basic need is to manage : - have customers sign up and get charged periodically - most likely monthly - yearly etc. - allow active members access to varied content pages. -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php

[PHP] Getting An Inventory Product Count

bie alert) - I would appreciate any ideas or URL links etc. - please keep is simple for this newbie.... -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Get a list of column field names from a MS Access table

Newbie question: I would like to get a list of column field names from a MS Access table and hopefully get them returned in the ORIGINAL order (as they appear in access) Is there a sql query I could do to get this result? -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09

Re: [PHP] Having Trouble With Session Variable in Query Statement

. $_SESSION[thisid]"; AHA - thanks much - that worked! -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Having Trouble With Session Variable in Query Statement

Hi folks, I'm trying to make an update query with a session variable... It creates this error: Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in ... Q: the session var shows ok on the page : ID - so how do I fix the error? ===

Re: [PHP] Re: Simple Search Logic Issue...

shes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); Here switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "

Re: [PHP] Re: Simple Search Logic Issue...

the passed in > value is set or not, and only include set values in the query. Not sure - but isn't that what this code is doing ...??? $mess_list1 = "-1"; if (isset($_GET['Message'])) { $mess_list1 = $_GET['Message']; } > > OT: sprintf syntax is so hard to read :-

[PHP] Simple Search Logic Issue...

{ $mess_list1 = $_GET['Message']; } mysql_select_db($database_test1, $test1); $query_list1 = sprintf("SELECT * FROM mytable WHERE Name LIKE %s and Message LIKE %s and Topic LIKE %s ORDER BY mytable.id desc", GetSQLValueString("%" . $name_list1 . "%", "

Re: [PHP] Creating A Unique List With Table Query

On 2/10/2009 11:45 AM, "Andrew Ballard" wrote: > SELECT DISTINCT Category FROM contacts Thanks folks - that was perfect! On 2/10/2009 11:46 AM, "Stephen" wrote: > Also, do you have a "Category" table? > No Stephen I don't. -- Thanks - Re

[PHP] Creating A Unique List With Table Query

. Question : How do I filter the query to only produce unique values? I was looking at: array_unique but I am not sure how to implement this in a MYSql table query Any help would be appreciated - thanks Dave -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General

Re: [PHP] Adding Records & Capture The New Record ID

- mysql_insert_id is right after the insert statement - is it 100% accurate - (in that no other insert from another user could get in the middle of this)? -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Adding Records & Capture The New Record ID

used database fields. Then, after I inserted the record - I would do a quick query that would retrieve the record ID by searching for the random number Q: is there a better way to retrieve the record ID from the newly added record? -- Thanks - RevDave Cool @ hosting4days . com [db-list

Re: [PHP] Re: DB Comparisons

ing language. And BTW - it seems as though myspace.com still is using coldfusion. I wonder what the backend db is? -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] DB Comparisons

& fast - (let me know if one is better ). Mostly I¹m concerned with the speed and power of the backend database as to how it functions on an enterprise scale ­ such as how many hits it can handle per hour ­ how many users before it starts to slow down etc. -- Thanks - RevDave Cool @ hosting4days .

Re: [PHP] Global Changes With Loop To Allow Nulls In A Table...

http://dev.mysql.com/doc/refman/5.1/en/alter-table.html ] The sql statement SHOW COLUMNSFROM `table`; [ http://dev.mysql.com/doc/refman/5.1/en/show-columns.html ] Thanks again -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net

[PHP] Global Changes With Loop To Allow Nulls In A Table...

$i++; endwhile; Thanks in advance -- Thanks - RevDave Cool @ hosting4days . com [db-lists 09] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Newbie - is there a function similar to the sql 'like' comparison operator?

don't see something 'like' or 'similar' to something else -- Thanks - RevDave Cool @ hosting4days . com [db-lists] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Newbie select statement questions 'WHERE'

irst like $_GET['p_First'] or p_Last like $_GET['p_Last']"; I tried various things that make errors: where p_First like '%$_GET['p_First ']%'"; where p_First like ".$_GET['p_First '].""; Etc... How can I make this work?

[PHP] Should This Newbie Learn From Dreamweaver?

ot an option right now. Interested in your thoughts... Dave Example get recordset query w DW: http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> http://www.w3.org/1999/xhtml";> Untitled Document Remember -- Thanks - RevDave Cool @ hosting4days . com [db-lists] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Alter Table newbie help needed ...

On 4/21/2008 2:04 PM, "revDAVE" <[EMAIL PROTECTED]> wrote: > : Is there a way to insure that it uses the right connection ( try1 - not > connect2 )? - seems to be ok now with this new db selector line... mysql_select_db($database_try1, $try1); // this new line

Re: [PHP] Alter Table newbie help needed ...

s some other one I set up for something else) Q: Is there a way to insure that it uses the right connection ( try1 - not connect2 )? -- On 4/20/2008 1:41 PM, "Jason Norwood-Young" <[EMAIL PROTECTED]> wrote: > revDave - can we see a bit more of the code in one bl

Re: [PHP] Alter Table newbie help needed ...

ses the right connection ( try1 - not connect2 )? BTW: I tried `try1.ztest` but it didn't like that: $sql = 'ALTER TABLE `try1.ztest` ADD `myfield2` VARCHAR(10) NOT NULL;'; -- Thanks - RevDave Cool @ hosting4days . com [db-lists] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Alter Table newbie help needed ...

check what's happening. -- Thanks - RevDave Cool @ hosting4days . com [db-lists] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] putting variables in a variable

['nowuser'].' Company: '.$_SESSION['now_co'].' Worker Info: '. $edit_result_row->getField('First').' '. $edit_result_row->getField('Last').' Thanks, '; --- -- Thanks - RevDave Cool @ hosting4days . com [db-lists] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] newbie needs help with session variables

nyone > help me with this? > > 2) I get the idea that one should NOT turn on register_globals, but, if > I don't do this, how do I share session variables between scripts (and > avoid this message)? > > Thanks for any help that anyone can provide. > > Rod Clay >

[PHP] Alter Table newbie help needed ...

do anything I must be missing something here Right? Maybe it doesn't know to use try1 connection? How do I add that? -- Thanks - RevDave Cool @ hosting4days . com [db-lists] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Importing / Adding Fields Into MySql From A List

se now but not quite sure ... http://dev.mysql.com/doc/refman/5.1/en/char.html http://dev.mysql.com/doc/refman/5.1/en/blob.html -- Thanks - RevDave Cool @ hosting4days . com [db-lists] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] LOGIN Endless Loop Problem - Newbie

eLogin'] = array('user'=>$user,'pass'=>$pass,'first'=>true); }else{ $_SESSION[$conn.'_login'] = array('user'=>$user,'pass'=>$pass,'first'=>true); } session_write_close(); header(

[PHP] Newbie - Undefined Index Variable

I have this: page1';}else{print 'page2';} ?> I will get the error: Notice: Undefined index: nowtoctype in ... If the variable has not yet been defined... Is there a way to check if this var is already defined? ... (and then I can define it - if not) -- Thanks - RevDave C

[PHP] PHP Newbie List

Rather than bug folks on this cool list for beginner questions - does anyone know of a good PHP Newbie email List? -- Thanks - RevDave Cool @ hosting4days . com [db-lists] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Date Calculation Help

I have segmented a year into four quarters (3 months each) nowdate = the month of the chosen date (ex: 5-30-07 = month 5) Q: What is the best way to calculate which quarter (1-2-3 or 4) the chosen date falls on? Result - Ex: 5-30-07 = month 5 and should fall in quarter 2 -- Thanks - RevDave

[PHP] Novice Question - Viewing Errors

see it? - - - - - From: PHP: Error Handling and Logging Functions - Manual Location: http://www.php.net/manual/en/ref.errorfunc.php - - - - - XXXIII. Error Handling and Logging Functions -- Thanks - RevDave [EMAIL PROTECTED] [db-lists] -- PHP General Mailing List (http://www.php.net/) To

[PHP] Creating 'Previous - Next Buttons' Logic - Novice Question

at type of thing Q: Is there any "open source" code template that I can check out like this? -- Thanks - RevDave [EMAIL PROTECTED] [db-lists] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Setting Up A Simple Shopping Cart

On 5/17/2007 7:05 AM, "revDAVE" <[EMAIL PROTECTED]> wrote: > Hello folks, > > I am a PHP NEWBIE. > > - I have the following three choices for shopping carts on my server: > > CubeCart > OS Commerce > Zen Cart > > Q: Does anybody have any

[PHP] Setting Up A Simple Shopping Cart

Hello folks, I am a PHP NEWBIE. - I have the following three choices for shopping carts on my server: CubeCart OS Commerce Zen Cart Q: Does anybody have any preferences for creating a simple store? -- Thanks - RevDave [EMAIL PROTECTED] [db-lists] -- PHP General Mailing List (http

Re: [PHP] Newbie Question - Form To Email Needed

base needed)) Name is: #form.name# Email is : #form.email# Thanks, US Q: is there some kind of mail command like this for PHP? > > Brad > > -Original Message- > From: revDAVE [mailto:[EMAIL PROTECTED] > Sent: Friday, May 04, 2007 10:36 PM > To: php-general@li

Re: [PHP] Newbie Question - Form To Email Needed

On 5/4/2007 7:29 PM, "Brad Sumrall" <[EMAIL PROTECTED]> wrote: > Where are the fields? Hi Brad, Just a basic form with a few fields inside like - name - address etc lie: -- Thanks - RevDave [EMAIL PROTECTED] [db-lists] -- PHP General Mailing List (http://www.php.n

[PHP] Newbie Question - Form To Email Needed

Hi folks, I have a form on page one - and would like to submit to a second page in PHP that could grab the fields and send it out as an e-mail. Are there any links that show how do this? Thanks in advance - Dave -- Thanks - RevDave [EMAIL PROTECTED] [db-lists] -- PHP General Mailing List

Re: [PHP] Novice PHP Question - Listing Folder Contents

Thanks to ALL ... Brad - Tijnema - TG - Richard and JMG! With a little fooling around - I actually got exactly what I wanted!!! Boy that was fun! And thanks for the incredibly quick responses! -- Thanks - RevDave [EMAIL PROTECTED] [db-lists] -- PHP General Mailing List (http://www.php.net

Re: [PHP] Novice PHP Question - Listing Folder Contents

b3b42b [25] => sess_196a3d41dcf968745b769fd0cc109027 [26] => sess_0a68937c12c590e4e888729a6f3b3909 [27] => sess_081964a8e938ed5ce96599ca69c3735f [28] => mysql.sock [29] => impattnZ83wN [30] => impatt8G6tEI [31] => horde_32001.log [32] => cpbandwidth [33] => 20070407-

[PHP] Novice PHP Question - Listing Folder Contents

- List/ display the contents on the same Web-page Q: I'm sure this is most likely doable - but I sure could use some help - any ideas how to do this? Example list: file1.php file2.php file22.txt file1.pdf - that sort of thing -- Thanks - RevDave [EMAIL PROTECTED] [db-lists] --

[PHP] Matching Proper Versions Of PHP and MySQL

o the minimum upgrade to ensure best compatibility with legacy code ( mySQL and NON php etc.). If it is OK to stay on mySQL version 4.0.27 ... That would be good to know. Q: Is PHP version 5.1.2 - relatively " stable " version of PHP 5? -- Thanks - RevDave [EMAIL PROTECTED] [db-lists]

[PHP] Nubie scripting question

cture to be loaded) Q: here is what I am unclear of: since I do not know PhP - how do I get the main display page to read this part of the URL? - how do I write this? thanks in advance for your help -- Thanks - RevDave [EMAIL PROTECTED] [db-lists] Check out some great Domain Names

Re: [PHP] Novice PHP Variable/Link Question

On 9/16/04 3:01 PM, "Greg Donald" <[EMAIL PROTECTED]> wrote: > > > > It worked great - thanks a lot. -- Thanks - RevDave [EMAIL PROTECTED] [db-lists] Check out some great Domain Names at: http://www.domains4days.com -- PHP General Mailing List (http://www.php

[PHP] Novice PHP Variable/Link Question

How can I use a PHP variable as the destination for a link? go here With var...? How do I write this? go here ?> -- Thanks - RevDave [EMAIL PROTECTED] [db-lists] Check out some great Domain Names at: http://www.domains4days.com -- PHP General Mailing List (http://www.php.net/)