Hi,
Quick question.
I may be missing something but for years I've been processing the output of a
query into a new array using the unique(normally primary key) field in the
table as the index so I can pull data matches simply further into the script
without another loop through all the
Yes, I do have all reqd privs.
In fact, as long as a duplicate key situation isnt encountered, I am able
to invoke the stored proc from PHP alright and the record gets saved in the
database.
But when I try to re-do it using the same value (thereby I am expecting
that 1062-DUPLICATE KEY error
Do you have sufficient privileges to execute stored procedures (procs_priv)
on PHP's end?
On Tue, Feb 12, 2019 at 11:07 AM Venkat Hariharan
wrote:
> Can you take a look at the issue that I've described at
>
>
systems.
Bruce
-- Forwarded message --
From: Bastien Koert phps...@gmail.com
Date: Mon, Jun 29, 2015 at 7:21 PM
Subject: Re: [PHP-DB] PHP ODBC odbc_fetch_array returns uninitialized
values for Booleans
To: Bruce Bailey brucebailey...@gmail.com, php-db@lists.php.net
*Description*
The PHP function odbc_fetch_array returns uninitialized values for
PostgreSQL boolean values. On older systems, this function returned '1'
for true and '0' for false values. On our 64 bit system, the boolean
values appear to be uninitialized data.
*Additional information*
Is it a truly a three state field (true, false, null) or just T/F? Perhaps
a default value for the field might be better?
On Mon, Jun 29, 2015 at 11:42 AM Bruce Bailey brucebailey...@gmail.com
wrote:
*Description*
The PHP function odbc_fetch_array returns uninitialized values for
PostgreSQL
dear members
php x64 VC11 (experimental) does not yet support x64 firebird? When it will
support?
environment
Windows Server 2012 R2 Datacenter x64 = OK
Firebird 2.5.4 x64 = OK
Apache Lounge 2.4.12 VC11 x64 = OK
PHP 5.6.8 VC11 x64 = OK
In the php.ini file
extension=php_interbase.dll and
I was wondering if there is anyone who manager to compile the sqlsrv driver
for php 7.
I have tried, but I haven't been able to get it compiled yet.
Thanks,
John
Hello.
Since 5.6, all encrypted client streams now enable peer verification by
default.
The problem I faced is with MySQL connection: we're connecting to old MySQL
server with self-signed certificate, and are using simple SSL connection
without certificates:
mysql_connect(address, user,
Hi All.
I have:
- one devel application server with
php53-mysql-5.3.27-1
MariaDB-compat-5.5.32-1.x86_64
MariaDB-common-5.5.32-1.x86_64
MariaDB-shared-5.5.32-1.x86_64
MariaDB-client-5.5.32-1.x86_64
- one devel database server with
MariaDB-compat-5.5.30-1.x86_64
MariaDB-server-5.5.30-1.x86_64
I wish to send a SMS to a mobile no. thru PHP/HTML. Any suggestions Please?
--
Dr Vijay Kumar,
E 9/18 Vasant Vihar, New Delhi-110 057 Ph: 09868 11 5354, 011-2615 4488
Email :Dr Vijay Kumarvaibhavinformat...@gmail.com
On Wed, Sep 26, 2012 at 1:18 AM, Dr Vijay Kumar
vaibhavinformat...@gmail.com wrote:
I wish to send a SMS to a mobile no. thru PHP/HTML. Any suggestions Please?
Try an email - SMS gateway?
http://en.wikipedia.org/wiki/List_of_SMS_gateways
--
PHP Database Mailing List (http://www.php.net/)
To
I apologize, I may have been mistaken about the role of $_FILES but this -
http://dev.mysql.com/doc/refman/5.0/en/load-data.html confuses me. The use
of $_FILES with LOAD DATA is littered over the internet and manuals as a 1
shot deal. No hand off to another directory for storage till the next
Jim I believe your correct.
Upload the file to temp
move the file to your dir on your server
and rename file
you can also set the permissions of the file while moving it.
put url to file (not temp file) in database (not the file contents)
done
Best,
Karl
On Jul 26, 2012, at 4:50 PM, Brad
Drats, I think you are correct.
:)
-Original Message-
From: Karl DeSaulniers [mailto:k...@designdrumm.com]
Sent: Thursday, July 26, 2012 5:59 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] PHP-DB] Re: No data?
Jim I believe your correct.
Upload the file to temp
move the file
I have a situation where a query run from PHP/Zend Framework on a MySQL
database seems to hit the CPU harder than the same query run via the
MySQL command line.
The query is a simple SELECT statement querying 2 tables, 12 columns
with a short WHERE clause that filters the results to less than 100
Dear all,
I'm the author of LIXA project (http://lixa.sourceforge.net/) and I would
discuss a little about two phase commit transactions for PHP applications.
Two phase commit means I can write a program that uses two (or more) Resource
Managers (for example databases, like MySQL and PostgreSQL)
2012 15:10
To: php-db-lists.php.net; php-gene...@lists.php.net
Subject: [PHP-DB] [PHP] PHP Database Problems -- Code Snippets - Any more
Ideas?
I am sending this again to see if more ideas for solution of this problem
are available.
Ethan
===
Dear list -
Sorry for the attachment. Here
have a database
mysql describe Intake3;
++-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
++-+--+-+-+---+
| Site | varchar(6) | NO | PRI | | |
| MedRec | int(6) | NO |
: [PHP-DB] PHP Database Problems
have a database
mysql describe Intake3;
++-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
++-+--+-+-+---+
| Site | varchar(6) | NO | PRI
Dear list -
Sorry for the attachment. Here are code snippets ---
GET THE DATA FROM INTAKE3:
function handle_data()
{
global $cxn;
$query = select * from Intake3 where 1;
if(isset($_Request['Sex']) trim($_POST['Sex']) != '' )
{
if
On Thu, 2012-01-26 at 11:59 +, Lester Caine wrote:
David McGlone wrote:
On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote:
David McGlone wrote:
can anyone suggest any good up to date books out there on php
adodb.
The only documentation on ADOdb is the website
David McGlone wrote:
I started with PHP just before PHP5 was finally released, so never used PHP4,
and found ADOdb very early on so have never used anything else. One gets
stuck
in one's way when something simply works ... Probably why I'm finding PDO
such a
backwards step having been
On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote:
David McGlone wrote:
can anyone suggest any good up to date books out there on php adodb.
The only documentation on ADOdb is the website
http://adodb.sourceforge.net/#docs ... has ANYBODY seen it described in a php
book?
While I
David McGlone wrote:
On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote:
David McGlone wrote:
can anyone suggest any good up to date books out there on php adodb.
The only documentation on ADOdb is the website
http://adodb.sourceforge.net/#docs ... has ANYBODY seen it
On Thu, Jan 26, 2012 at 12:06 PM, David McGlone da...@dmcentral.net wrote:
On Thu, 2012-01-26 at 08:45 +, Lester Caine wrote:
David McGlone wrote:
can anyone suggest any good up to date books out there on php adodb.
The only documentation on ADOdb is the website
can anyone suggest any good up to date books out there on php adodb.
--
David M.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
could someone tell me what I need to install and how to configure
everything so that I can connect with PHP and PDO to a MS-SQL server?
I have an OpenSuse 11.4 installation. I added the Apache-PHP repository
and upgraded to PHP 5.3.8.
php-mssql, -php-odbc, libfreetds and the
]
Sent: 21 October 2011 04:04
To: php-db@lists.php.net
Subject: [PHP-DB] PHP + SQLite - Issues with update
Hello,
I am running into some issues trying to update a column in a table in a
SQLite database using PHP on Windows and was hoping could get some help on
this mailer.
Here is the create
Message-
From: n.a.mor...@brighton.ac.uk [mailto:n.a.mor...@brighton.ac.uk]
Sent: Friday, October 21, 2011 2:33 AM
To: Prashant Prabhudesai (pprabhud); php-db@lists.php.net
Subject: RE: [PHP-DB] PHP + SQLite - Issues with update
Try using the query:
$db-query(update SERVER set Token
Hello,
I am running into some issues trying to update a column in a table in a
SQLite database using PHP on Windows and was hoping could get some help on
this mailer.
Here is the create and insert statement -
CREATE TABLE SERVER (
IPAddress varchar(100) not null unique primary key,
Token
Hello All,
Happy pre independence for my American PHPers. And good health to all
others.
Have a quick question..
I have this code I use for the end of line characters used in my
mailers.
[Code]
// Is the OS Windows or Mac or Linux
if (strtoupper(substr(PHP_OS,0,5)=='WIN')) {
On Jul 2, 2011, at 3:01 AM, Karl DeSaulniers wrote:
Hello All,
Happy pre independence for my American PHPers. And good health to
all others.
Have a quick question..
I have this code I use for the end of line characters used in my
mailers.
[Code]
// Is the OS Windows or Mac or Linux
if
I have been trying to figure out how to add delete confirmation for
the bellow snippet of code. I would prefer not to use javascript. Can
anyone offer any advise on how to right the delete confirmation in
PHP?
Thank you in advance.
P.S. I apologize for the indention. For some reason gmail messes
Hi,
I installed mysql and php. Its OK. After I install php-mysql, the
following messages come out.
PHP Warning: PHP Startup: Unable to load dynamic library
'/usr/lib/php/modules/mysql.so' - libmysqlclient.so.15: cannot open
shared object file: No such file or directory in Unknown on line
Are you getting any error msg while installing it. Try to get a new copy of
php-mysql from internet and install it.
On Tue, Mar 8, 2011 at 4:17 PM, Scott Wen wen.xue...@gmail.com wrote:
Hi,
I installed mysql and php. Its OK. After I install php-mysql, the
following messages come out.
Hello,
http://arado.sf.net is a URL database / Open Source Websearch Engine
and RSS Reader, in c++ /qt using sqlite.
the urlbase.sql is currently addressed by a Qt gui. There is as well
the code for a php interface to address the urlbase.sql.
The PDO does not interact proper, has anyone experience
Hello Everyone
Apologies if I have not done this in the correct way, this is the first time I
have turned to your for help so I am unaware if I have to submit this according
to a certain protocol, if that is the case then please let me know and I will
go through the proper channels. My
On Mon, Nov 29, 2010 at 14:35, Don Wieland d...@dwdataconcepts.com wrote:
Hi all,
Is there a list/form to get some help on compiling mySQL queries? I am
executing them via PHP, but do not want to ask for help here if it is no the
appropriate forum. Thanks ;-)
Yes.
For MySQL queries,
Sanjay Mantoor wrote:
Twaha,
I found PHP manual is best.
Refer http://www.php.net/manual/en/
On Fri, Oct 31, 2008 at 1:49 PM, Twaha Uddessy udde...@yahoo.com wrote:
Hello all,
Iam new here,trying hard to study PHP.Can anyone help me with a link
where I can get PHP exercises
Hello,
without further information, it is not really possible to give any kind
of indication that a web app can replace the original app. We do not
know what the original app is supposed to do, how it works, ...
Having said that, I think most apps would be possible to transform to
some web app.
Thanks for your reply Maarten, Its a hotel management application for a
hotel..
Thanks,
Vinay
On Fri, Aug 6, 2010 at 1:03 PM, maarten maarten.fo...@edchq.com wrote:
Hello,
without further information, it is not really possible to give any kind
of indication that a web app can replace the
Actually there is no customer registrations happening, its just a resturant
and there wouldnt be any registrations and stuff, its a valid point of
hosting it on a webserver and building it like any web app, but then
internet connection might also be a problem in that area, and if the
internet
Hi,
I need some help and its actually got nothing to do with any coding help.
My friend owns a business and has been using a software developed on VB6.0
installed on a Windows XP it is a bit outdated though and I personally feel
the company which sold the software has overdone the sales, coz I
*Hello everyone,*
*I just want to develop a big ERP applications.Can anyone tell me which
framework will be better for ERP
(HR,Finance,Inventory,Production,Administration etc etc) means
CakePHP,Codeigniter and also database PostgreSql or Mysql or shall i go with
Core PHP?
Thanks in advance
Hello!
You should look at same good stable ERP's PHP based, and start your
new project from one of them.
By example:
* BlueErp
* Dolibarr
* GNU Enterprise
* WebERP
Cheers,
Adriano Laranjeira.
On Mon, 28 Jun 2010 17:17:26 +0530
Mohamed Hashim nmdhas...@gmail.com wrote:
*Hello everyone,*
Hi,
I recently decided to setup my mac for some php developments.
OS X 10.5 already ships with Apache, PHP and I chose PostGreSQL as DB
server. I picked a package link from the official website and I installed
it. The DB server is running smoothly.
Now, as OS X's php module is not
To try to solve this issue, I grabed the sources for PHP (5.3.2) and
libiodbc (3.52.7). When ran under GDB, I can observe the following:
odbc_exec() [PHP code] calls SQLAllocStmt() [libiodbc code], which calls
some internal function that tries to call SQLAllocStmt(), in some indirect
recursive
Hello,
i am writing a small login script for a website.
The username and passwort are stored in a database in two separate columns.
I have it like this:
while($dbbenutzer = mysql_fetch_row($sqlbenutzername))
while($dbpasswort = mysql_fetch_row($sqlpasswort)){
echo
Hi,
Maybe try...
$benutzername = $_GET['username'];
$pass = $_GET['password'];
$result = SELECT * FROM usertable WHERE
sqlbenutzername='$benutzername';
while($r = mysql_fetch_row($result)) {
$dbbenutzer = $r[sqlbenutzername];
$dbpasswort = $r[sqlpasswort];
}
On 29 April 2010 15:00, Karl DeSaulniers k...@designdrumm.com wrote:
Hi,
Maybe try...
$benutzername = $_GET['username'];
$pass = $_GET['password'];
$result = SELECT * FROM usertable WHERE sqlbenutzername='$benutzername';
Don't use values from $_GET without sanitizing first. If using
Yes. You are correct. Did not include that part, sry.
Dont forget mysql_real_escape_string.
:)
Karl
On Apr 29, 2010, at 9:37 AM, Peter Lind wrote:
On 29 April 2010 15:00, Karl DeSaulniers k...@designdrumm.com wrote:
Hi,
Maybe try...
$benutzername = $_GET['username'];
$pass =
On 29 April 2010 16:44, Alexander Schunk asch...@gmail.com wrote:
Hello,
i have it now as follows:
while($dbbenutzer = mysql_fetch_assoc($sqlbenutzername))
while($dbpasswort = mysql_fetch_assoc($sqlpasswort)){
You have things very twisted. Check the code posted by Karl - you only
php-db-unsubscr...@lists.php.net
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
Why don't you just try the following:
$query = SELECT * FROM foo WHERE UserID = .$uID . ORDER BY bar;
$result = mysql_query($query);
//get the first row
$row = mysql_fetch_object($result);
//get the next row
while ($next = mysql_fetch_object($result)) {
//do something with row/next
On 12 February 2010 23:46, Paul Hollingworth devine...@msn.com wrote:
Thanks for the code Eric, it seems to loosely provide the functionality that
I'm after.
Just out of interest though, is there no other way to find the next result
row in an object apart from dumping it into an array?
Hi all,
I'm currently having a problem correctly formatting a table within a
while loop. I'm using an object to store the results of a query, and
using the while to iterate through it each row to produce the output:
$query = SELECT * FROM foo WHERE UserID = .$uID . ORDER BY bar;
$result =
On Sat, Feb 13, 2010 at 3:26 AM, Paul devine...@msn.com wrote:
Hi all,
I'm currently having a problem correctly formatting a table within a while
loop. I'm using an object to store the results of a query, and using the
while to iterate through it each row to produce the output:
$query =
Thanks for the code Eric, it seems to loosely provide the functionality
that I'm after.
Just out of interest though, is there no other way to find the next
result row in an object apart from dumping it into an array?
Thanks,
Paul
Eric Lee wrote:
On Sat, Feb 13, 2010 at 3:26 AM, Paul
Hi Paul,
Can't you just?
$query = SELECT DISTINCT bar FROM foo WHERE UserID = .$uID;
$result = mysql_query($query);
while($obj = mysql_fetch_assoc($result) {
$bar = $obj['bar'];
if ($bar == something) {
//do this
}
}
I'm some what a beginner, so sorry if this
On Sat, Feb 13, 2010 at 7:46 AM, Paul Hollingworth devine...@msn.comwrote:
Thanks for the code Eric, it seems to loosely provide the functionality
that I'm after.
Just out of interest though, is there no other way to find the next result
row in an object apart from dumping it into an array?
I have used session classes before and am at a loss as to why I cannot
for the life of me get this to work... Any help is appreciated.
I might just be confused with the database connection handles in order
to pull and store session information as there was some information
posted on php.net
Hey nagendra,
I tried to post this a while ago, but it may be too long for the list.
?php
if ($Submit) { // perform search only if correct form was entered.
$db = mysql_connect ($Host, $User, $Password);
mysql_select_db ($DBName) or die (Cannot connect to database);
//check if the
Hello,
I have a little problem with a sql command string
$q = UPDATE episodes SET episode_title = '$_POST[episode_title]' ,
episode_scheduleddate = .strtotime($_POST['episode_scheduleddate']).
, episode_description = '$_POST[episode_description]' WHERE episode_id
= $_POST[episode_id];
I keep
try ..
$q = addslashes(UPDATE episodes SET episode_title = '$_POST[episode_title]'
,
episode_scheduleddate = .strtotime($_POST['episode_scheduleddate']).
, episode_description = '$_POST[episode_description]' WHERE episode_id
= $_POST[episode_id]);
or try
$q = UPDATE episodes SET episode_title =
Manu Gupta wrote:
try ..
$q = addslashes(UPDATE episodes SET episode_title = '$_POST[episode_title]'
,
episode_scheduleddate = .strtotime($_POST['episode_scheduleddate']).
, episode_description = '$_POST[episode_description]' WHERE episode_id
= $_POST[episode_id]);
or try
$q = UPDATE episodes
$query = UPDATE `clients` SET `company` = '$company', `contact` =
'$contact', `phone` = '$phone', `city` = '$city' WHERE
`clients`.`reference` =$client LIMIT 1;
$client_result=mysql_query($query);
// now check for errors
mysql_error() mysql_errno()
Sudheer Satyanarayana wrote:
On Tuesday 03
How do I test if an UPDATE query worked
$query = UPDATE `clients` SET `company` = '$company', `contact` =
'$contact', `phone` = '$phone', `city` = '$city' WHERE
`clients`.`reference` =$client LIMIT 1;
$client_result=mysql_query($query);
???
Ron
Ron Piggott wrote:
How do I test if an UPDATE query worked
$query = UPDATE `clients` SET `company` = '$company', `contact` =
'$contact', `phone` = '$phone', `city` = '$city' WHERE
`clients`.`reference` =$client LIMIT 1;
$client_result=mysql_query($query);
???
Hi Ron,
Have a look at http://www.php.net/manual/en/function.mysql-info.php
- Original Message -
From: Ron Piggott ron@actsministries.org
To: PHP DB php-db@lists.php.net
Sent: Monday, November 02, 2009 11:59 PM
Subject: [PHP-DB] PHP Update query
How do I test if an UPDATE query
On Tuesday 03 November 2009 11:29 AM, Ron Piggott wrote:
How do I test if an UPDATE query worked
$query = UPDATE `clients` SET `company` = '$company', `contact` =
'$contact', `phone` = '$phone', `city` = '$city' WHERE
`clients`.`reference` =$client LIMIT 1;
$client_result=mysql_query($query);
I am working on a shopping cart ... specifically writing about the
delivery time lines.
I thought I would include the information pages (like store policies,
contact us, about us) for my shopping cart within a mysql table.
But I ran into a challenge when I got to the Delivery time line
Hello,
I've been programming on PHP for almost a year now, many examples that I've
gone through or some of the reference books that I've read and many websites
which show examples of PHP pgramming seem to be using PEAR package, and I've
never used PEAR or any other Package, I was wondering whats
Vinay Kannan wrote:
Hello,
I've been programming on PHP for almost a year now, many examples that I've
gone through or some of the reference books that I've read and many websites
which show examples of PHP pgramming seem to be using PEAR package, and I've
never used PEAR or any other Package,
I am wondering if I can put PHP into a mySQL table.
When I tried doing:
echo stripslashes(mysql_result($article_titles_result,0,article));
The PHP coding displays, not rendered PHP.
Any suggestions?
Ron
Ron Piggott wrote:
I am wondering if I can put PHP into a mySQL table.
When I tried doing:
echo stripslashes(mysql_result($article_titles_result,0,article));
The PHP coding displays, not rendered PHP.
You'd need to 'eval' it (http://www.php.net/eval), though be very
careful as any php
Hello list
Can someone suggest me a php mysql calender, easy configurable for
special needs?
I found some googling but the most of them query records form a specific
table and its impossible to change the sql query.
Thank you in advance
Nikos
Everyone,
I have never used the PHP mssql functions before, I am versed in MySql instead,
I cannot get the following code to return any records.
The variables $dbserver, $dbuser, $dbpasswd are defined in a config file and
are being read and the connection is being made because I can change any
Daniel,
Now that is just funny stuff...
Have you tried
http://lmgtfy.com/?q=access+denied+for+user+odbc+localhost
or the newer
http://www.lmbify.com/search.php?s=access+denied+for+user+odbc+localhost
Daniel Brown danbr...@php.net wrote in message
Hi folks,
since I am providing an opensource dbms called cego
( more information about cego on my home page www.lemke-it.com ),
I am interested in the integration of the database into PHP.
Is there anyone out there who can support this and give me some hints ?
Thanks in advance for any comment
GOOD afternon,to alll
I am new to php,mysql
i want to create user login account in a page please help me ,,,
_
Drag n’ drop—Get easy photo sharing with Windows Live™ Photos.
Dear all,
When I try to retrive data from two tables using JOIN OR INNER JOIN it
display error message
given below;
Warning: mysql_query() [function.mysql-query]: Access denied for user
'ODBC'@'localhost' (using password: NO) in
C:\wamp\www\ap_v5\inc\profile.inc.php on line
On Thu, Jun 18, 2009 at 2:00 AM, Bjoern Lemkele...@lemke-it.com wrote:
Hi folks,
since I am providing an opensource dbms called cego
( more information about cego on my home page www.lemke-it.com ),
I am interested in the integration of the database into PHP.
Is there anyone out there who
On Thu, Jun 18, 2009 at 6:03 AM, NADARAJAH SIVASUTHAN
NADARAJAHnsivasut...@live.com wrote:
Dear all,
When I try to retrive data from two tables using JOIN OR INNER JOIN it
display error message
given below;
Warning: mysql_query() [function.mysql-query]: Access denied for user
On Thu, Jun 18, 2009 at 06:03, NADARAJAH SIVASUTHAN
NADARAJAHnsivasut...@live.com wrote:
Warning: mysql_query() [function.mysql-query]: Access denied for user
'ODBC'@'localhost' (using password: NO) in
C:\wamp\www\ap_v5\inc\profile.inc.php on line 285
Hello,
I tried all day yesterday to setup a brand new machine with a fresh
Linux install; with apache 2.2.10 (from source) php 5.2.9 (from source)
and PostgresQL 8.3.7 (from the very neat one-click installer provided by
Enterprisedb) ; everything compiles and installs fine but when trying to
Do you have postgres module for PHP installed? This will probably be the
cause.
Didier Gasser-Morlay napsal(a):
Hello,
I tried all day yesterday to setup a brand new machine with a fresh
Linux install; with apache 2.2.10 (from source) php 5.2.9 (from
source) and PostgresQL 8.3.7 (from the
Lester,
Sorry, I should have said:
Yes: Postgres is up running happily on the machine
yes : Postgres is listed in phpinfo; with the correct version; php was
connecting fine to the dababase, this message only happens on the 1st
query which is when the function pg_escape_string is called.
Lester,
Sorry, I should have said:
Yes: Postgres is up running happily on the machine
yes : Postgres is listed in phpinfo; with the correct version; php was
connecting fine to the dababase, this message only happens on the 1st
query which is when the function pg_escape_string is called.
I need a simple php mysql image upload script with display script too and to
make this easier the mysql database table to use
On Thu, May 28, 2009 at 4:19 PM, Wilson Osemeilu engrwi...@yahoo.comwrote:
I need a simple php mysql image upload script with display script too and
to make this easier the mysql database table to use
STFW
--
Bastien
Cat, the other other white meat
I have copied the queries into psql and wrapped them in a BEGIN and
COMMIT. Even from psql the queries appear to work but don't store the
information. There don't appear to be errors in the log either.
Thanks for your help,
Carol
km_tezt=# begin;
BEGIN
km_tezt=# INSERT INTO
To all who helped.
Thank you very much. I found the problem. There is a leading blank
on the last name field that I couldn't see. It was coming from my
program code.
Thanks for all your help.
Carol
On May 11, 2009, at 4:23 PM, Carol Walter wrote:
I have copied the queries into psql
Glad that you found the problem :)
Carol Walter napsal(a):
To all who helped.
Thank you very much. I found the problem. There is a leading blank
on the last name field that I couldn't see. It was coming from my
program code.
Thanks for all your help.
Carol
On May 11, 2009, at 4:23 PM,
I'd suggest you to copy the echoed queries and run them directly in
terminal (if you have access). Also if you have remote access to the
database and can use tools like pgAdmin or Navicat, that could help you
with testing. Or send me the table structure and I'll try them myself ;)
Carol
Hello,
I have a PHP program that contains a number of postgres queries. At
the end of the program, it needs to write data to a database. You can
see the code that I'm using below. I have die clauses on all the
queries and I have the program echoing the queries that it runs to the
Thanks for all the suggestions. I just going to keep my head down and keep
learning and practicing, I probably be sending many more questions
conor
_
Windows Live™ SkyDrive™: Get 25 GB of free online storage.
Hello Everyone,
I am a beginner with PHP and Mysql and have dived into a project that may be to
much for me right now. I am still learning php and do not have enough
knowledge to accomplish what I am trying to.
I have been looking into PHP code generators and was wondering if anyone has
any
Most code generators are bloated, poorly designed, and just plain trouble.The
only code generator that I currently like, is the one for CakePHP, but
you'll have to do some heavy reading to get up-to-speed on how to develop
with Cake (especially considering it uses Object Oriented development
Dreamweaver has some php generation. That's how I started to learn. I am
not an expert by any means, and I am sure that experts will not like the
code, but for a beginner, I found it totally fine
On 4/28/2009 12:40 PM, conor mahaney wrote:
Hello Everyone,
I am a beginner with PHP and Mysql
1 - 100 of 1759 matches
Mail list logo