I see. Ok thanks Matt. Will look into that if I start working with those size
databases.
My apology Ethan, wasn't aware of the scope.
Best,
Karl DeSaulniers
Design Drumm
http://designdrumm.com
On Sep 3, 2014, at 12:09 AM, Matt Pelmear mjpelm...@gmail.com wrote:
Karl,
This works for
On Sep 3, 2014, at 12:13 AM, Karl DeSaulniers k...@designdrumm.com wrote:
Dear List -
This works:
mysql describe Purchases;
+---+-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
/***/
$fp = fopen('filename.txt', 'a+');
// The correct thing to do is:
if (! $fp)
throw new Exception( 'Something went wrong opening the file' );
// Otherwise, you can also check with:
if (! is_resource($fp))
throw new Exception( 'Something went
On 08/26/2014 06:21 AM, Jim Giner wrote:
On 8/26/2014 12:20 AM, Ethan Rosenberg wrote:
Dear list -
When I use fopen, the file owner and group are both www-data.
How can I ensure that the owner and group will be ethan?
TIA
Ethan
Why should ownership be a concern when you are simply
What are you trying to achieve? Or to put it more clearly, why do you need the
filw owner to be ethan?
Jasper
Verstuurd vanaf mijn iPad
Op 26 aug. 2014 om 06:20 heeft Ethan Rosenberg
erosenb...@hygeiabiomedical.com het volgende geschreven:
Dear list -
When I use fopen, the file
On 8/26/2014 11:26 AM, Matt Pelmear wrote:
fopen() can create files if they don't exist.
I should have read the manual b4 replying. :(
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Do you check whether $fh2 is a resource after you fopen()?
btw, a better way than:
$ chown ethan:ethan filename.txt
Might be:
$ chown ethan:www-data filename.txt
$ chmod 664 filename.txt
This way you own the file, the server can write to it (assuming your server
has group www-data), and it is
On Tue, Aug 26, 2014 at 12:20 AM, Ethan Rosenberg
erosenb...@hygeiabiomedical.com wrote:
Dear list -
When I use fopen, the file owner and group are both www-data.
How can I ensure that the owner and group will be ethan?
TIA
Ethan
--
PHP Database Mailing List (http://www.php.net/)
On Aug 25, 2014, at 11:20 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com
wrote:
Dear list -
When I use fopen, the file owner and group are both www-data.
How can I ensure that the owner and group will be ethan?
TIA
Ethan
Are we talking about file permissions?
Best,
Karl
Another, safer, thing to consider would be setting a sticky bit on whatever
directory the files will be in:
http://computernetworkingnotes.com/managing-file-system-security/sticky-bit.html
I've used sticky bits in a number of situations with multiple groups and
users co-habiting environments
On 02/07/14 04:43, Ethan Rosenberg, PhD wrote:
while ($row31 = mysqli_fetch_row($result31)) {
printf (%s %s %s %s %s\n, $row31[0], $row31[1], $row31[2], $row31[3]);
Try
print_r( $row31 );
} // no output
How can I loose a db connection in the middle of a program?
This is not showing
Once again you have provided the group with RANDOM pieces of code,
completely out of context since you have already shown me that your
query and db connection are being used in a function, hence your loss of
$cxn.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
On Tue, Jul 1, 2014 at 10:02 AM, Jim Giner jim.gi...@albanyhandball.com
wrote:
How about just showing us the section of code instead of disjoint pieces
that WE cannot be sure are applied correctly?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
On 7/1/2014 10:26 AM, Aziz Saleh wrote:
On Tue, Jul 1, 2014 at 10:02 AM, Jim Giner jim.gi...@albanyhandball.com
wrote:
How about just showing us the section of code instead of disjoint pieces
that WE cannot be sure are applied correctly?
--
PHP Database Mailing List (http://www.php.net/)
To
On Jun 24, 2014, at 12:27 AM, Ethan Rosenberg erosenb...@hygeiabiomedical.com
wrote:
Dear List -
I know I have a mistake here, but I cannot find it.
This is a part of a switch.
The switch is fed with a formatted phone number [123-456-7890], which is then
tested for validity, and if
On Jun 24, 2014, at 2:46 AM, Karl DeSaulniers k...@designdrumm.com wrote:
On Jun 24, 2014, at 12:27 AM, Ethan Rosenberg
erosenb...@hygeiabiomedical.com wrote:
Dear List -
I know I have a mistake here, but I cannot find it.
This is a part of a switch.
The switch is fed with a
On Jun 24, 2014, at 2:53 AM, Karl DeSaulniers k...@designdrumm.com wrote:
On Jun 24, 2014, at 2:46 AM, Karl DeSaulniers k...@designdrumm.com wrote:
On Jun 24, 2014, at 12:27 AM, Ethan Rosenberg
erosenb...@hygeiabiomedical.com wrote:
Dear List -
I know I have a mistake here, but I
I don't recognize your error reporting configuration. Try this instead:
error_reporting(E_ALL | E_NOTICE);
ini_set('display_errors','1');
As for php startup errors, if you are not running your own installation,
you don't need that.
So - if 'here3' is never echoed, then your code does NOT
Looking at your code again, I think that your query failed and your lack
of error reporting isn't showing the error that occurred when you tried
to access a property of the result which is not a resource but merely a
value of 'false'.
One should ALWAYS check the result of operations before
On 06/24/2014 08:12 PM, Ethan Rosenberg, PhD wrote:
On 06/24/2014 01:55 PM, Jim Giner wrote:
Looking at your code again, I think that your query failed and your lack
of error reporting isn't showing the error that occurred when you tried
to access a property of the result which is not a
Sent from losPhone
On Jun 19, 2014, at 12:40 AM, Oriole Computing oriolecomput...@gmail.com
wrote:
dear List,
we have the following var_dump output from a soap response
array(1) {
[return]=
array(3) {
[responseCode]=
string(1) 3
[responseMessage]=
string(39)
If you have the response in a variable, $response:
$responseCode = $response[return]['responsecode'];
$responseMessage = $response[return]['responseMessage'];
$transactionID = $response[return]['transactionID'];
This isn't really the right list to ask this question - nothing to do
with
Hi Toby,
my response is in variable $result so i run the code as below
$responseCode = $result[return]['responsecode'];
but getting this error: PHP Parse error: syntax error, unexpected
T_RETURN, expecting ']
Warm Regards
*SUPPORT TEAMORIOLE COMPUTING*
*1938 B1 MUNGWI ROAD*
My error! This:
$responseCode = $result[return]['responsecode'];
should have been
$responseCode = $result['return']['responsecode'];
The other responses have been rather more elegant, though I think my
solution is a little more readable - i.e., I had to think about what was
happening for
On Thu, Jun 19, 2014 at 10:09 AM, Toby Hart Dyke t...@hartdyke.com wrote:
My error! This:
$responseCode = $result[return]['responsecode'];
should have been
$responseCode = $result['return']['responsecode'];
The other responses have been rather more elegant, though I think my
Now it says PHP Notice: Undefined index: responsecode
Warm Regards
*SUPPORT TEAMORIOLE COMPUTING*
*1938 B1 MUNGWI ROAD*
*LUSAKAZAMBIA*
*Skype:* oriolecomputing | *Url:* oriolecomputing.blogspot.com
http://generalcomputing.blogspot.com/
On Thu, Jun 19, 2014 at 4:09 PM, Toby Hart Dyke
Sorry team, i guess am in the wrong mailing list. The good news is that it
has now worked thanks to Toby's solution.. the error was my typing problem
...
Thanx Tobby!!!
Warm Regards
*SUPPORT TEAMORIOLE COMPUTING*
*1938 B1 MUNGWI ROAD*
*LUSAKAZAMBIA*
*Skype:* oriolecomputing | *Url:*
On 6/18/2014 12:31 AM, Ethan Rosenberg, PhD wrote:
On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote:
Hi Ethan,
Here are some things to clean up your code:
Your line:
$phn = $_POST[phone];
should use quotations as follows:
$phn = $_POST['phone'];
Your line:
$sql1 ='select Lname, Fname
Sent from losPhone
On Jun 18, 2014, at 7:56 AM, Jim Giner jim.gi...@albanyhandball.com wrote:
On 6/18/2014 12:31 AM, Ethan Rosenberg, PhD wrote:
On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote:
Hi Ethan,
Here are some things to clean up your code:
Your line:
$phn =
On Wed, Jun 18, 2014 at 2:13 PM, Karl DeSaulniers k...@designdrumm.com
wrote:
Sent from losPhone
On Jun 18, 2014, at 7:56 AM, Jim Giner jim.gi...@albanyhandball.com
wrote:
On 6/18/2014 12:31 AM, Ethan Rosenberg, PhD wrote:
On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote:
Hi
On 6/18/2014 2:16 PM, Aziz Saleh wrote:
On Wed, Jun 18, 2014 at 2:13 PM, Karl DeSaulniers k...@designdrumm.com
wrote:
Sent from losPhone
On Jun 18, 2014, at 7:56 AM, Jim Giner jim.gi...@albanyhandball.com
wrote:
On 6/18/2014 12:31 AM, Ethan Rosenberg, PhD wrote:
On 06/17/2014 12:02
Can we kill this thread? Or can you guys continue the conversation between
yourselves. We now have 8 emails pertaining to the technical question, and
8 emails ranting about him asking it.
I understand that some people do not believe this is the appropriate forum
for that question - but personal
On 17/06/14 15:04, Jim Giner wrote:
We're all so eager to help out poor Ethan (who many of you know is NOT a
newbie) but nowhere does Ethan say what difficulty he is having.
The suggestions made so far are great but what are we solving?
I see you have spotted the original question :)
The
On 6/17/2014 10:51 AM, Lester Caine wrote:
On 17/06/14 15:04, Jim Giner wrote:
We're all so eager to help out poor Ethan (who many of you know is NOT a
newbie) but nowhere does Ethan say what difficulty he is having.
The suggestions made so far are great but what are we solving?
I see you
IMO a newbie is someone who read the docs and understood them (at least in
theory) before they attempt to write code, which doesn't seem to be the
case.
On Tue, Jun 17, 2014 at 10:04 AM, Jim Giner jim.gi...@albanyhandball.com
wrote:
We're all so eager to help out poor Ethan (who many of you
Hi Ethan,
Here are some things to clean up your code:
Your line:
$phn = $_POST[phone];
should use quotations as follows:
$phn = $_POST['phone'];
Your line:
$sql1 ='select Lname, Fname from Customers where Phone = $Phn ';
Should use double quotes if you need the variable to be
On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote:
Hi Ethan,
Here are some things to clean up your code:
Your line:
$phn = $_POST[phone];
should use quotations as follows:
$phn = $_POST['phone'];
Your line:
$sql1 ='select Lname, Fname from Customers where Phone = $Phn ';
Should use
On Jun 16, 2014, at 9:58 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com
wrote:
Dear List -
I have the following code:
The input from the form is a 10 digit string [1234567890] which is converted
to phone number format [123-456-7890]
$phn = $_POST[phone];
$phn = (string)$phn;
On Mon, Jun 16, 2014 at 10:58 PM, Ethan Rosenberg
erosenb...@hygeiabiomedical.com wrote:
Dear List -
I have the following code:
The input from the form is a 10 digit string [1234567890] which is
converted to phone number format [123-456-7890]
$phn = $_POST[phone];
$phn = (string)$phn;
On Jun 16, 2014, at 10:05 PM, Karl DeSaulniers k...@designdrumm.com wrote:
On Jun 16, 2014, at 9:58 PM, Ethan Rosenberg
erosenb...@hygeiabiomedical.com wrote:
Dear List -
I have the following code:
The input from the form is a 10 digit string [1234567890] which is converted
to phone
Oh a few quick things.
First, you can use substr to break up the phone instead of grabbing characters-
might be a little easier to read long term.
Secondly, mysql_real_escape_string will return the cleaned string, but doesn't
change the original variable. So you'll need $phn =
Hi again,
It's an Access 2000 database and I've changed the password to a single a,
still no show :(
The database is downloaded on a regular basis and I need to extract some
data from it, so I have no control over version or password.
Thanks a lot
/Kjell
Richard Quadling skrev i
I think the code you translated might be for the .accdb file. In your
translated code I noticed .mdb so per that page, this apples for .mdb
With database password (mdb file)
This is the connection string to use when you have an Access 97 - 2003 database
protected with a password using the Set
Did you read the notes regarding password length, password content and
Access version issues?
Do any of these apply to you?
I suspect one of them does.
On 4 June 2014 21:48, Kjell Hansen kj...@kejpa.com wrote:
Hi,
I'm trying to connect to a MS Access database that has a database password
...@kejpa.com
Cc: php-db php-db@lists.php.net
Subject: Re: [PHP-DB] MS Access Connection with database password
Did you read the notes regarding password length, password content and Access
version issues?
Do any of these apply to you?
I suspect one of them does.
On 4 June 2014 21:48, Kjell Hansen
wordpress has a built in search as well. It depends on what you what you
are wanting to do
On Thu, Mar 13, 2014 at 2:46 PM, Matt Pelmear mjpelm...@gmail.com wrote:
Besides the usual suspects that are 3rd party, a common solution I've seen
is Solr/Lucene:
https://lucene.apache.org/solr/
Besides the usual suspects that are 3rd party, a common solution I've
seen is Solr/Lucene:
https://lucene.apache.org/solr/
-Matt
On 03/13/2014 11:44 AM PT, Olivier Austina wrote:
Hi,
I am new to website search engine area.I would like to do a survey of
popular search engine used for a
Vinay Kannan wrote:
I am getting stuck at the DB structuring part for this.
1) I can have all the different types of workouts entered into the DB with
the number of days / sessions thats included in a particular package.
2) and then when a member pays the fees eg: for 3 months (12 sessions) so
If any query failed inside a transaction then PDO will not issue a
rollback, It will left the decision on you that you want to ignore the
failed query it or want a rollback.
You can find the examples of handing of query failure inside a transaction
at
On Fri, Jan 10, 2014 at 10:13 AM, Jim Giner jim.gi...@albanyhandball.comwrote:
History:
I'm trying to help a friend who is hosting his domain with the same
company that I use. I've been using this company for several years and
have used a certain 'connection' script all the time. Part of it
Vinay Kannan wrote:
Currently the DB structure stores the following : 1) Customer details. 2)
Membership ID and the payment paid at the time of signing up (I am thinking
i might not need the signing up amount to be stored in the customer DB in
the first place, and have them seperate in a table
Ron,
You could use the same technique here if you want to do the work in PHP:
=== php code ===
assert( convertToGMT('2013-11-01 00:00:00') == '2013-11-01 04:00:00' );
// EST offset by four hours
assert( convertToGMT('2013-11-07 23:59:59') == '2013-11-08 04:59:59' );
// EDT offset by five
On Nov 10, 2013, at 10:26 AM, Ron Piggott ron.pigg...@actsministries.org
wrote:
I normally use the following code to convert between time zones. But I don’t
know how to calculate what time it is in GMT time zone when it is midnight in
the users time zone X days ago, or midnight on
A suggestion I was given is to use the mySQL CONVERT_TZ command with the
PHP time zone names. But when I do:
SELECT CONVERT_TZ( `journal_entry`.`occurance_date` , 'GMT',
'America/Bahia' ) FROM `journal_entry`
I am receiving NULL as the resulting date. Does mySQL accept PHP time
zone
Typically, yes.
It is possible you don't have the time zone tables populated.
America/Bahia works for me, so I suspect that is the case.
The relevant manual page to load this data (assuming your server is
running in a unix environment) is here:
On Fri, Aug 23, 2013 at 4:21 AM, Matijn Woudt tijn...@gmail.com wrote:
The problem is: there is no maintainer;)
Sure there is.
--
/Daniel P. Brown
Network Infrastructure Manager
http://www.php.net/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Op 27 aug. 2013 18:06 schreef Daniel Brown danbr...@php.net het
volgende:
On Fri, Aug 23, 2013 at 4:21 AM, Matijn Woudt tijn...@gmail.com wrote:
The problem is: there is no maintainer;)
Sure there is.
--
/Daniel P. Brown
Network Infrastructure Manager
http://www.php.net/
Uh,
On Tue, Aug 27, 2013 at 12:10 PM, Matijn Woudt tijn...@gmail.com wrote:
Uh, you're right. I meant moderator..
Yeah, as far as moderation, we only do in extreme circumstances.
--
/Daniel P. Brown
Network Infrastructure Manager
http://www.php.net/
--
PHP Database Mailing List
There are a lot of off topic emails sent. But there is far more whining and
complaining. Good grief!
On Fri, Aug 23, 2013 at 2:40 PM, Tamara Temple tamouse.li...@gmail.comwrote:
On Aug 23, 2013, at 7:32 AM, Jim Giner jim.gi...@albanyhandball.com
wrote:
On 8/23/2013 4:52 AM, Matt Pelmear
*There are a lot of off topic emails sent. But there is far more whining
and
**complaining. Good grief!
+1*
Let's remember that not everyone on the list is an expert programmer or
someone with years of DBA experience. The purpose of the list (IMHO) is to
HELP others with their PHP/DB questions,
On Aug 26, 2013, at 11:19 AM, Michael Stowe wrote:
*There are a lot of off topic emails sent. But there is far more whining
and
**complaining. Good grief!
+1*
Let's remember that not everyone on the list is an expert programmer or
someone with years of DBA experience. The purpose of
Ethan Rosenberg wrote:
I'm probably wrong, but in some contexts; eg, sql query, $ signs are not used.
I tried and added the incorrect $ sign, and Netbeans did not complain. If
anyone knows of an editor that will able to spot this kind of error, please
inform the list.
You do need to take a
Simply install wamp server and save yourself from separate installation of
MySQL,PHP,Apache server,phpMyAdmin and sqlite.
Check the link below.
http://wampserver.com
On 23 August 2013 01:29, Ethan Rosenberg erosenb...@hygeiabiomedical.comwrote:
Dear List -
How do I configure Bluefish for
Ethan Rosenberg wrote:
Dear List -
How do I configure Bluefish for PHP? I am running version 2.2.4 of Bluefish.
I'd forgotten about bluefish. You should not need to do anything. PHP files are
just processed as PHP? But it's more an HTML editor and geared to producing and
verifying HTML so
Install Komodo IDE or Adobe Dreamweaver. They'll highlight errors and
warnings.
On 23 August 2013 08:20, Lester Caine les...@lsces.co.uk wrote:
Ethan Rosenberg wrote:
Dear List -
How do I configure Bluefish for PHP? I am running version 2.2.4 of
Bluefish.
I'd forgotten about bluefish.
If your on a PC I would just get Eclipse. But if you have netbeans, you can set
the syntax highlighting for the different scripts you write in the preferences.
PHP, java, javascript, etc...
Best,
Karl DeSaulniers
Design Drumm
http://designdrumm.com
--
PHP Database Mailing List
Komodo is very nice.
Karl DeSaulniers
Design Drumm
http://designdrumm.com
On Aug 23, 2013, at 2:58 AM, Michael Oki wrote:
Install Komodo IDE or Adobe Dreamweaver. They'll highlight errors and
warnings.
On 23 August 2013 08:20, Lester Caine les...@lsces.co.uk wrote:
Ethan Rosenberg
On Fri, Aug 23, 2013 at 10:15 AM, Matt Pelmear mjpelm...@gmail.com wrote:
Hello all,
I am subscribed to this list because of my interest in PHP's database
integration. At this point only a small percentage of the messages are
related to that.
I am not sure who runs the list, whether they
Michael Oki wrote:
Install Komodo IDE or Adobe Dreamweaver. They'll highlight errors and warnings.
Last time I looked neither were free?
Eclipse has served me well for many years and while it has it's problems often
someone comes up with a new plugin to sort it. My problem is dealing with the
Karl DeSaulniers wrote:
If your on a PC I would just get Eclipse. But if you have netbeans, you can set
the syntax highlighting for the different scripts you write in the preferences.
PHP, java, javascript, etc...
But the problem tha5 has been identified will never be flagged by simple
Matt Pelmear wrote:
I am not sure who runs the list, whether they care about off-topic posts,
or whether anyone else cares about it.
The php lists are only loosely moderated, but comments like yours usually bring
things under control. I'd refer you to my recent post thought as to why the
On 08/23/2013 04:36 PM, Lester Caine wrote:
Matt Pelmear wrote:
I am not sure who runs the list, whether they care about off-topic
posts,
or whether anyone else cares about it.
The php lists are only loosely moderated, but comments like yours
usually bring things under control. I'd refer
Matt Pelmear wrote:
On 08/23/2013 04:36 PM, Lester Caine wrote:
Matt Pelmear wrote:
I am not sure who runs the list, whether they care about off-topic posts,
or whether anyone else cares about it.
The php lists are only loosely moderated, but comments like yours usually
bring things under
On 8/22/2013 8:08 PM, Ethan Rosenberg wrote:
Ethan Rosenberg, PhD
/Pres/CEO/
*Hygeia Biomedical Research, Inc*
2 Cameo Ridge Road
Monsey, NY 10952
T: 845 352-3908
F: 845 352-7566
erosenb...@hygeiabiomedical.com
On 08/22/2013 06:56 PM, Jim Giner wrote:
On 8/22/2013 4:14 PM, Ethan Rosenberg
On 8/23/2013 4:32 AM, Lester Caine wrote:
Karl DeSaulniers wrote:
If your on a PC I would just get Eclipse. But if you have netbeans,
you can set the syntax highlighting for the different scripts you
write in the preferences. PHP, java, javascript, etc...
But the problem tha5 has been
On 8/23/2013 4:52 AM, Matt Pelmear wrote:
On 08/23/2013 04:36 PM, Lester Caine wrote:
Matt Pelmear wrote:
I am not sure who runs the list, whether they care about off-topic
posts,
or whether anyone else cares about it.
The php lists are only loosely moderated, but comments like yours
usually
On Aug 23, 2013, at 7:32 AM, Jim Giner jim.gi...@albanyhandball.com wrote:
On 8/23/2013 4:52 AM, Matt Pelmear wrote:
On 08/23/2013 04:36 PM, Lester Caine wrote:
Matt Pelmear wrote:
I am not sure who runs the list, whether they care about off-topic
posts,
or whether anyone else cares about
To: Daniel Krook/White Plains/IBM@IBMUS
Cc: PHP Database List php-db@lists.php.net
Date: 08/21/2013 11:59 PM
Subject: Re: [PHP-DB] mysql query
On 08/21/2013 11:30 PM, Daniel Krook wrote:
Ethan,
It's hard to tell from the code formatting in your email what the
exact problem might
:
From: Ethan Rosenberg erosenb...@hygeiabiomedical.com
To: Daniel Krook/White Plains/IBM@IBMUS
Cc: PHP Database List php-db@lists.php.net
Date: 08/21/2013 11:59 PM
Subject: Re: [PHP-DB] mysql query
On 08/21/2013 11:30 PM, Daniel Krook wrote:
Ethan,
It's hard to tell from
Jim, I know this is a stupid question to be asking this far into PHP
Development, maybe was a bit lazy, or just got too used to Notepad++, which
editor for PHP are you using? The feature which you mentioned for a good
php editor, sounds exciting, offcourse i would be looking only at the free
ones
Notepad++ will do syntax highlighting. Go to Language P PHP with a
PHP file open, and see the colours change! It should be automatic - are
you using something other than 'php' as a file extension?
Toby
On 8/22/2013 5:27 PM, Vinay Kannan wrote:
Jim, I know this is a stupid question to
Thanks Toby, Using Notepad ++ with the language selected to PHP, the syntax
coloring is on
On Thu, Aug 22, 2013 at 11:00 PM, Toby Hart Dyke t...@hartdyke.com wrote:
Notepad++ will do syntax highlighting. Go to Language P PHP with a PHP
file open, and see the colours change! It should
Vinay Kannan wrote:
Jim, I know this is a stupid question to be asking this far into PHP
Development, maybe was a bit lazy, or just got too used to Notepad++, which
editor for PHP are you using? The feature which you mentioned for a good
php editor, sounds exciting, offcourse i would be looking
On 08/22/2013 09:51 AM, Jim Giner wrote:
On 8/21/2013 7:48 PM, Ethan Rosenberg wrote:
Dear List -
I can't figure this out
mysql describe Inventory;
+-+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
On 08/22/2013 11:54 AM, Jim Giner wrote:
On 8/22/2013 9:52 AM, Jim Giner wrote:
On 8/21/2013 7:48 PM, Ethan Rosenberg wrote:
Dear List -
I can't figure this out
mysql describe Inventory;
+-+-+--+-+-+---+
| Field | Type| Null | Key
Ethan Rosenberg, PhD
/Pres/CEO/
*Hygeia Biomedical Research, Inc*
2 Cameo Ridge Road
Monsey, NY 10952
T: 845 352-3908
F: 845 352-7566
erosenb...@hygeiabiomedical.com
On 08/22/2013 06:56 PM, Jim Giner wrote:
On 8/22/2013 4:14 PM, Ethan Rosenberg wrote:
On 08/22/2013 11:54 AM, Jim Giner wrote:
1) What is the error message?
2) This has an error:
values ('$upc', $qnt,'$mnf','$itm', odrpt, 0, $stk)
Missing '$' in front of 'odrpt'.
Toby
On 8/22/2013 12:48 AM, Ethan Rosenberg wrote:
Dear List -
I can't figure this out
mysql describe Inventory;
On 08/21/2013 07:52 PM, Toby Hart Dyke wrote:
1) What is the error message?
2) This has an error:
values ('$upc', $qnt,'$mnf','$itm', odrpt, 0, $stk)
Missing '$' in front of 'odrpt'.
Toby
On 8/22/2013 12:48 AM, Ethan Rosenberg wrote:
Dear List -
I can't figure this out
mysql
Ethan,
It's hard to tell from the code formatting in your email what the exact
problem might be, but a few reasons that this might fail in PHP rather
than when sent to MySQL with hardcoded values:
1. var_dump/print_r $_POST to see what you're getting as input is what
you expect (and
@IBMUS
Cc: PHP Database List php-db@lists.php.net
Date: 08/21/2013 11:59 PM
Subject: Re: [PHP-DB] mysql query
On 08/21/2013 11:30 PM, Daniel Krook wrote:
Ethan,
It's hard to tell from the code formatting in your email what the
exact problem might be, but a few reasons that this might fail
Emiliano,
This question is totally out of scope for this mailing list. It has
nothing to do with databases at all.
Also, you should _almost never_ use 0777 for permissions.
You probably want 0644. (Owner can read/write, all others can read.)
Regarding your question in general, it sounds like
As someone else say, is problem of DB design, probably you can do all the
necessary queries in only one transaction.
Un saludo,
Jorge.
2013/8/9 Karl DeSaulniers k...@designdrumm.com
Probably with separate queries I would say. Query store 1, move to truck
then query truck and move to store 2.
Hello.
I am newbie in this and need som basic help.
I have a form witch checkbox'es with different serialnumbers.
The serialnumbers reflect different products and every product category
have their own tables.
This sounds like a database design question more than a PHP one.
I can
Why do you have to tables with products? Couldn't you have a type or
category column and then have to only query one table?
Bastien
On Fri, Aug 9, 2013 at 11:52 AM, Niel Archer n...@chance.now wrote:
Hello.
I am newbie in this and need som basic help.
I have a form witch checkbox'es
Probably with separate queries I would say. Query store 1, move to truck then
query truck and move to store 2.
Best,
Karl
Sent from losPhone
On Aug 9, 2013, at 10:13 AM, Jim Giner jim.gi...@albanyhandball.com wrote:
On 8/9/2013 10:56 AM, Karl-Arne Gjersøyen wrote:
Hello.
I am newbie in
Hi, Andrew!
On Mon, 8 Jul 2013 11:17:14 -0400, andrew.jar...@gmail.com (Andrew
Jarcho) wrote:
1) You're not stupid
Let's hope. :-D
2) You're not too old to accomplish what you want to accomplish.
A couple of good books (preferably fairly short ones) by people who
know what they're talking
1) You're not stupid
2) You're not too old to accomplish what you want to accomplish.
A couple of good books (preferably fairly short ones) by people who
know what they're talking about *and* know how to write should
help a great deal.
Like you, I cut my programming teeth in BASIC stored on
On Thu, Jul 4, 2013 at 6:09 PM, Toni Moreno toni.mor...@gmail.com wrote:
Hi.
I have a found a very strange and big concurrence problem after develop a
CLI tool which parallelizes data processing by using pcntrl_fork, ( If
we run the same executions sequentially the result is correct)
Alexander Pletnev pletnev.rusa...@gmail.com wrote:
Hi everyone, im new here, so please correct me if i created or formated
topic incorrectly.
I found a problem. I have a simple query for my needs:
$stmt = $dbh-prepare(SELECT concat(first_name,' ',last_name) as
full_name,t.* FROM
$stmt = $dbh-prepare(SELECT concat(first_name,' ',last_name) as
full_name,t.* FROM `specialists` `t` HAVING full_name like '%:query%');
How about '%:$query%' instead of '%:query%' ? Does that solve the problem?
Thanks,
On Thu, Jun 27, 2013 at 5:21 PM, Alexander Pletnev
201 - 300 of 21034 matches
Mail list logo
