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
- 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
- except for the echo
test
--
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
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
...@example.com' . \r\n;
mail($to, $subject, $message, $headers);
?
--
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
- - - - -
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 (http://www.php.net/)
To unsubscribe, visit
/
?
- 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 @ hosting4days
{
?
a href=?php
echo 'https://'.$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'];
??php
echo 'https://'.$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'];
?/a
?php
}
?
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists 09]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit
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
$handle = fopen(try3.csv, r);
if ($handle) {
while (!feof($handle)) {
// $buffer = fgets($handle, 4096); // tried w w/o 4096 length
$buffer = fgets($handle);
echo $buffer.'br/br/';
}
fclose($handle);
}
?
--
Thanks - RevDave
Cool
On 3/20/2009 2:37 PM, kirk.john...@zootweb.com kirk.john...@zootweb.com
wrote:
revDAVE c...@hosting4days.com 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
?
like:
$cnt = 1;
?php echo $_POST['thisline$cnt']; ? Doesn't work...?
?php echo $_POST['thisline'].$cnt; ? Doesn't work...?
Not this either...
$this = 'thisline'.$cnt;
echo $_POST['$this'];
$cnt++
Q: ANY Ideas?
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists 09
= 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
/Library/WebServer
$items[$row['model']][$row['id']] = $row['condition'];
Q: How can I fix this?
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists 09
/ COUNT: '.$count.' final previous'.'br/br/';
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
'].' 2 br/';
}
}
--
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
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
. 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
? 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
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
= 0;
do { ?
tr
td?php
$m[$i] = date(m/d/y, mktime(0,0,0,$currmonth-$i, 1, $curryear));
echo $m[$i].'br /';
$i++ ?
/td
/tr
?php } while ($i 25); ?
/table
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists 09]
--
PHP General Mailing List (http://www.php.net
On 3/12/2009 12:25 PM, Paul M Foster pa...@quillandmouse.com 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 better:
// get your
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
) - 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
.) 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.
4.) It forces the script to exit with a non-error code of 0.
--
Thanks - RevDave
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.net
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
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
- RevDave
Cool @ hosting4days . com
[db-lists 09]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
!
--
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
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 :-)
I agree - especially for this newbie...
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists 09]
--
PHP General Mailing List
(mysql_real_escape_string) ?
mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
Here
switch ($theType) {
case text:
$theValue = ($theValue != ) ? ' . $theValue . ' : NULL;
break;
etc.
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists 09
and Message
LIKE %s and Topic LIKE %s ORDER BY mytable.id desc, GetSQLValueString(% .
$name_list1 . %, text),GetSQLValueString(% . $mess_list1 . %,
text),GetSQLValueString(% . $top_list1 . %, text));
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists 09]
--
PHP General Mailing List (http
.
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
On 2/10/2009 11:45 AM, Andrew Ballard aball...@gmail.com wrote:
SELECT DISTINCT Category FROM contacts
Thanks folks - that was perfect!
On 2/10/2009 11:46 AM, Stephen stephe...@rogers.com wrote:
Also, do you have a Category table?
No Stephen I don't.
--
Thanks - RevDave
Cool
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-lists 09
% 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
- (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 . com
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
;
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
://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
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
['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?
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists]
--
PHP General Mailing List (http
);
?
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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 block and not broken
up? Makes it a bit easier to see what you're
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
New ...
?php
$sql = 'ALTER TABLE
.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
Right? Maybe it doesn't know to use
try1 connection? How do I add that?
?php
$sql = 'ALTER TABLE `ztest` ADD `myfield2` VARCHAR(10) NOT NULL;';
---or---
$sql = 'ALTER TABLE `ztest` RENAME TO `ztest2`;';
?
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists]
--
PHP General Mailing
this, how do I share session variables between scripts (and
avoid this message)?
Thanks for any help that anyone can provide.
Rod Clay
[EMAIL PROTECTED]
*
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http
,
';
---
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
- RevDave
Cool @ hosting4days . com
[db-lists]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
://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
,'first'=true);
}
session_write_close();
header('Location: '.$from);
exit();
}
if(isset($_GET[errorMsg]) $_GET[errorMsg] != '') {
return $_GET[errorMsg];
}else{
return '';
}
}
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists]
--
PHP General
is already defined? ... (and then I can
define it - if not)
--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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
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
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
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
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
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 preferences for creating a simple store?
Both OS Commerce Zen Cart
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
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:
form action=sendmail.php method=post
input name=name type=text
input name=email type=text
/form
--
Thanks - RevDave
[EMAIL
Message-
From: revDAVE [mailto:[EMAIL PROTECTED]
Sent: Friday, May 04, 2007 10:36 PM
To: php-general@lists.php.net
Cc: Brad Sumrall
Subject: 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
- 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
-202.180.53.58-request_body-cIifAH [36] = .. [37] = . )
--
Thanks - RevDave
[EMAIL PROTECTED]
[db-lists]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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
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 General
(will carry the name of the picture 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?
img src=??? Url.pic ??? alt=deals - how do I write this?
thanks in advance for your help
--
Thanks - RevDave
[EMAIL
How can I use a PHP variable as the destination for a link?
? $mylink = 'thispage.htm'
a href=thispage.htmgo here/a
With var...? How do I write this?
a href=??? $mylink ???go here/a
?
--
Thanks - RevDave
[EMAIL PROTECTED]
[db-lists]
Check out some great Domain Names at:
http
On 9/16/04 3:01 PM, Greg Donald [EMAIL PROTECTED] wrote:
a href=?php echo $url;??php echo $url;?/a
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
69 matches
Mail list logo