I was going to guess:
echo ($_GET['OrderNumber']);
But I don't use that form. I use
echo $_GET['OrderNumber'];
But now I need to check out that quoted URL ... ?'OrderNumber'=TEST222808
as well.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
I just tested ?'OrderNumber'=TEST222808
and it works with and without quotes.
The problem is you have
echo (['OrderNumber'])
when you need
echo $_GET['OrderNumber'];
or possibly
echo ($_GET['OrderNumber']);
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Hopefully your only issue is the keyword global versus globals ?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Dec 3, 2007 10:26 AM, julian [EMAIL PROTECTED] wrote:
Dee Ayy wrote:
Hopefully your only issue is the keyword global versus globals ?
Not sure what you mean. global $db should bring to local scope a
reference to the object that has the data base connection.
PHP complaints
no worries I give up. It is really weird I know Hope some day I
will get enlighted.
In one file, any method within a class is happy with the global
$db...on a different (same file !!!) class no method is happy with
accessing $db via global...
So you confirmed that you are using
Normally I'd say, If it's been working fine for 3 months; then just
stopped working; don't get angry at the PHP programmer; check with the
network admin as to what changed.
But it's interesting that your error came from an MS Windows machine,
while you have links at the bottom from an Apple
The only thing that comes to my mind about this is to create a table
index. Just a thought.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Is there something which can perform a query across different database systems?
It would extend the database.table.field notation to maybe
dbms.database.table.field and allow queries across MySQL and MSSQL
such as:
//$sql =
SELECT MySQLidentifier.aDatabase.aTable.aField,
Wow! I just found the Federated Storage Engine.
http://dev.mysql.com/tech-resources/articles/mysql-federated-storage.html
It's not in our SHOW ENGINES though.
I still welcome comments.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
How do I avoid having so much fun using utf8_encode throughout my document?
I was thinking of using output buffering and then making 1 call to
utf8_encode, but I think a better question is, how do I stop using
utf8_encode completely?
The docs say that utf8_encode Encodes an ISO-8859-1 string to
Has anyone ever seen a partial execution of an UPDATE statement?
I'm using Perl DBI to update a table in MySQL.
The strangest thing to me is that a varchar(35) field which holds a custom
date/time format was updated correctly, but other tinyint(1) fields were not
set correctly, and 1 of 3 text
http://php.he.net/manual/en/mssql.installation.php Installation
The MSSQL extension is enabled by adding extension=php_mssql.dll to php.ini.
To get these functions to work, you have to compile PHP with
--with-mssql[=DIR], where DIR is the FreeTDS install prefix. And FreeTDS
should be compiled
As you already know, you will dynamically create the $contents.
See if you can dynamically create the entire prepare statement which
includes the $contents, as well as dynamically create the bindValue
statement; then see if you can eval those dynamically created statements.
$commandPrepare =
A database was designed with the following tables:
Incidents
_
id (auto incremented int)
...
Calls
_
id (auto incremented int)
incidentId (foreign key)
status (varchar 32)
...
The status of the last Call is the status of the related Incident.
Statuses can be Not started through
On Fri, Aug 8, 2008 at 5:25 PM, Micah Gersten [EMAIL PROTECTED] wrote:
How about select Incidents.* from Incidents inner join Calls on
Incidents.id=Calls.incidentid where Calls.status='Open'?
...
Dee Ayy wrote:
...
The status column never has the text Open.
...
--
PHP Database Mailing List
On Sat, Aug 9, 2008 at 1:32 AM, Niel Archer [EMAIL PROTECTED] wrote:
Hi
You do not say how you identify the last call (there is no date/time
field for example), so a complete answer is not really possible
With the id (auto incremented int), the last record of either table
would be the
What I would do is change
var tinyMCEImageList = new Array(\n;
to have a space and then the newline character at the end like so
var tinyMCEImageList = new Array( \n;
then change your last $out line
$out .= );\n;
to strip the last 2 characters (which always gets called) and closes
the Array
When using mysql_query, the SQL string to be executed should not end
in a semicolon. Your initial post did not have a semicolon (but you
obviously edited it to make it generic). Perhaps this was the initial
problem? Subsequent posts had you terminating your queries with a
semicolon.
--
PHP
On Wed, Sep 3, 2008 at 1:05 PM, Evert Lammerts [EMAIL PROTECTED] wrote:
On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts [EMAIL PROTECTED] wrote:
On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy [EMAIL PROTECTED] wrote:
When using mysql_query, the SQL string to be executed should not end
in a semicolon
On Wed, Sep 3, 2008 at 8:35 PM, David DURIEUX [EMAIL PROTECTED] wrote:
Bonjour,
I have always the problem, select = 0 rows and it delete it like if
delete is before the select :/
Cordialement,
David DURIEUX
Your SELECT has a terminating semicolon. Your DELETE does not. Some
I don't think my trigger likes a comparison with a variable which is
NULL. The docs seem to have a few interesting variations on playing
with NULL and I was hoping someone would just throw me a fish so I
don't have to try every permutation (possibly using CASE, IFNULL,
etc.).
If my ShipDate
On Fri, Oct 31, 2008 at 11:09 AM, Dee Ayy [EMAIL PROTECTED] wrote:
...
IF OLD.ShipDate != NEW.ShipDate AND NEW.ShipDate IS NOT NULL THEN
...
The following seems to work. Is it correct and not too verbose?
IF (OLD.StatusShipDate IS NULL AND NEW.StatusShipDate IS NOT NULL
On Sat, Jan 24, 2009 at 7:01 AM, Emiliano Boragina
emiliano.borag...@gmail.com wrote:
I want to insert a JPG image ($creacion) with the ID (from the data base,
MEDIUMINT AUTOINCREMENT): 23image.jpg in the data base, and send the
information to a e-mail addres. How do I do that?
Thanks a lot,
On Fri, Feb 6, 2009 at 5:10 AM, G tjmad...@gmail.com wrote:
I've done extensive web searches, read all of the PHP manual pages beginning
with mysql_, wasted days on trial-and-error experimenting (signal handling
etc.), seen the [PHP-DB] Long running db queries and the STOP button
thread from
It sounds like you are wanting to transpose rows and columns. But
you used the terms convert and fields, so google may not be helping
you.
I found this:
http://forums.mysql.com/read.php?86,23026,25752#msg-25752
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Please advise the proper settings (Apache/PHP/HTML/MySQL/Anything else
I missed) to allow a specific byte size upload and to deny 1 byte over
with error reporting in LAMP/AJAX. I've heard of Flash and Gears
solutions, but these require additional installs for the user -- just
to know the file
words: use the Flash/Gears solution, or just decide you don't mind
if a large file is uploaded. In the last case you can always reject the file
afterwards.
- Tul
On 20-01-2012 18:15, Dee Ayy wrote:
Please advise the proper settings (Apache/PHP/HTML/MySQL/Anything else
I missed) to allow
['attachment'].
Thanks for all your help Jim.
On Fri, Jan 20, 2012 at 2:38 PM, Maciek Sokolewicz
maciek.sokolew...@gmail.com wrote:
Answers are inside the mail
On 20 January 2012 21:18, Dee Ayy dee@gmail.com wrote:
Obviously I don't want a Flash/Gears solution.
FYI: Your #6 should
I would like a query that lists records where a column has not taken
on a specific value when grouped by another column.
N V
n1 v1
n1 v2
n2 v1
n2 v2
n2 v3
n3 v1
If v3 has ever been set for N, do not list N. So the result would be n1, n3
If v2 has ever been set for N, do not list N. So the
On Mon, Jun 18, 2012 at 6:26 PM, Matijn Woudt tijn...@gmail.com wrote:
On Mon, Jun 18, 2012 at 11:56 PM, Dee Ayy dee@gmail.com wrote:
I would like a query that lists records where a column has not taken
on a specific value when grouped by another column.
N V
n1 v1
n1 v2
n2 v1
n2 v2
30 matches
Mail list logo