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
Ron,
If this is a display issue, have you tried running
stripslashes($outputstring) on the output from the database? That is the
usual way to handle it
Bastien
On Thu, Jun 4, 2015 at 7:29 AM Ron Piggott ron.pigg...@actsministries.org
wrote:
On 03/06/15 09:37, Aziz Saleh wrote:
On Wed, Jun
Combine them in SQL and loop through the dataset
select c.*, cd.*
from customers c
inner join customer_details cd on c.id = cd.customer_id
[where clause as needed]
loop thru the recordset from that query just as you would with a query from
a single table and link the id to the edit page
while
:
On 02/06/2015 02:45 PM, Bastien Koert
wrote:
Hold on, so you've written a point of
sale app that exists on the
client
machine as
whole?
Does
Generally input names shouldn't have spaces, use underscores if needed
On Tue Feb 17 2015 at 4:34:55 PM rahul bhola rb1223334...@gmail.com wrote:
Can you post some code snippet here
cheers
Rahul
PM, Ethan Rosenberg
erosenb...@hygeiabiomedical.com wrote:
On 02/05/2015 11:04 AM, Bastien Koert wrote:
I'm with the two Richard's on this, those users shouldn't have telnet
access to the host server at all. Users should be using the browser to
access your site.
Other than that, the most
I'm with the two Richard's on this, those users shouldn't have telnet
access to the host server at all. Users should be using the browser to
access your site.
Other than that, the most important thing you can do is to regularly back
up your code and database to another location so that if
another post to the UNIX list, this works.
script type=text/JavaScript
!--
window.open(HandleFood.php,_self)
//--\
/script
and the SESSION variables transfer.
Sorry for bothering you with such trivia.
Ethan
--
On 01/01/2015 11:21 PM, Bastien Koert wrote:
Ethan,
As was explained
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/
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
Hi All,
Below is a situation I ran into recently. To me, the decision made
shows how to not solve a problem but merely compound the issue.
Scenario: There is an app currently running on a highly loaded 4.11
MySQL db. Customers are complaining about the slow performance.
The app has 3 important
On Mon, Sep 10, 2012 at 9:48 AM, Jim Giner jim.gi...@albanyhandball.com wrote:
Reading up on the pdostatement class. Wondering what the intent of the
columnCount function is. I mean, aren't the number of columns in a result
known when you write the query? Granted, you might have some very
On Fri, Sep 7, 2012 at 10:54 AM, Jim Giner jim.gi...@albanyhandball.com wrote:
Experimenting with prepared statements - trying out for the first time.
I keep getting a fatal error on this statement:
mysqli_connect(.)
Message is:
Fatal error: Call to undefined function mysqli_connect()
On Fri, Aug 24, 2012 at 8:34 PM, Gary Chambers gwch...@gwcmail.com wrote:
David,
The database gets updated with a record, but all the fields end up being
empty in the db. Can anyone see what's out of whack here? I'd appreciate
the help. http://pastebin.com/y8kcymnN
There isn't much context
On Tue, Aug 21, 2012 at 4:44 PM, Matt Pelmear mjpelm...@gmail.com wrote:
Amit,
Thanks for the suggestion. Unfortunately, even when I explicitly enable
E_WARNING or even E_ALL error reporting in php I still do not receive any
indication that data was truncated on insert.
-Matt
On
On Mon, Nov 28, 2011 at 9:19 PM, Phil Dobbin phildob...@gmail.com wrote:
On 29/11/11 02:08, Jason Pruim pru...@gmail.com wrote:
PostgreSQL?
;-)...
In all seriousness... Would it help or change it in anyway? :)
I am free to use what I want (I believe) on this project...
It's well worth
On Tue, Nov 8, 2011 at 1:33 PM, Bastien Koert phps...@gmail.com wrote:
On Tue, Nov 8, 2011 at 1:31 PM, Ron Piggott
ron.pigg...@actsministries.org wrote:
What is the preferred method used to export mySQL to Excel within the
context of PHP? I have looked on Google and found a wide variety
On Tue, Mar 8, 2011 at 11:16 AM, Ron Piggott
ron.pigg...@actsministries.org wrote:
I am wondering if there is a way to do an UPDATE query where only some of the
text changes.
The column I need to modify is named “toll_free”
What I need to search for is: 800-
I need it to replace it with is
On Mon, Jan 31, 2011 at 8:06 AM, Ron Piggott
ron.pigg...@actsministries.org wrote:
Does mySQL have the ability to figure out if it is leap year? If so, what is
the correct syntax for:
AND `day` 366 unless it is leap year
Ron
The Verse of the Day
“Encouragement from God’s Word”
On Sun, Jan 30, 2011 at 2:27 PM, Ron Piggott
ron.pigg...@actsministries.org wrote:
I have a question about the mySQL query below. The purpose is to find the
last 15 days Bible reading for an RSS feed.
In the table each day’s reading is assigned the day # in the year (between 1
and 365).
On Fri, Jan 14, 2011 at 2:15 PM, Cristiano Di Buduo
cristiano_di_bu...@hotmail.com wrote:
I just downloaded both PHP and MySQL, both newest stable versions, both are
working well, but when i try{} to :
$dbh = new PDO('mysql:host=localhost;dbname=test', user, passwd);
i catch{} a could
On Fri, Jan 7, 2011 at 9:46 AM, Toby Hart Dyke t...@hartdyke.com wrote:
On 1/7/2011 12:10 AM, Fahim M wrote:
Hi
I have a certain number of mysql tables(relation), say 50, some of them
having 5 fields and some with 6 fields. a particular search item may be
found in multiple tables with
On Tue, Dec 14, 2010 at 4:53 PM, Ron Piggott
ron.pigg...@actsministries.org wrote:
What change is needed to this query so if “currently_in_rss” is NULL it will
be assigned a value of 0
SELECT `reference`, COUNT(`reference`) AS currently_in_rss FROM
`ministry_profiles` WHERE
On Fri, Dec 3, 2010 at 4:42 AM, Neil Jackson n...@webcoza.co.za wrote:
Hi,
I am designing a website that requires storing data in 3 different languages,
English, Portuguese and Tetum.
When I read the data from the database the accented characters are displayed
as a ? in Firefox and Opera, a
On Wed, Nov 17, 2010 at 8:51 AM, Vinay Kannan viny...@gmail.com wrote:
Hello PHP Gurus,
I need your help on an insert query.
I wanted to know if there is way to insert an array of values into a DB. An
eg would explain this better :
If I have 2 tables in a DB, 1) users has 3 columns 2)
On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg eth...@earthlink.net wrote:
At 03:40 AM 10/28/2010, Max E.K wrote:
From: Ethan Rosenberg eth...@earthlink.net
To: rquadl...@googlemail.com, Ethan Rosenberg eth...@earthlink.net
Cc: php-db-lists.php.net php-db@lists.php.net
Sent: Thursday,
: Thursday, October 28, 2010 2:02 PM
To: Bastien Koert
Cc: Max E.K; php-db-lists.php.net; rquadl...@googlemail.com
Subject: Re: [PHP-DB] Incrementing Primary Key
At 01:17 PM 10/28/2010, Bastien Koert wrote:
On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg eth...@earthlink.net
wrote:
At 03:40 AM
On Mon, Aug 30, 2010 at 12:14 PM, nagendra prasad
nagendra802...@gmail.com wrote:
Hi All,
Thanks for all your replies. I have found what I needed. I used Dreamweaver
to show the database in 3 different columns. However now I don't know how to
add a search engine to it. Right now its showing
On Wed, Jun 30, 2010 at 10:52 AM, nagendra prasad
nagendra802...@gmail.com wrote:
Hi All,
I have a huge set of MP3 database. My problem is that when I try to search
in my database its getting very slow. I was wondering if I split that
database into 2 or more tables. Will this improve the
On Wed, Jun 9, 2010 at 10:28 PM, win.a win@gmail.com wrote:
It's known that the IE browser share on session in the same APP
How about cookie ,the same ?or use its own?
Thanks in advacne!
All you best
What we are struggling for ?
The life or the life ?
--
On Tue, May 18, 2010 at 2:51 PM, Niel Archer n...@chance.now wrote:
Is there a different syntax to the mysql delete statement when the WHERE
clause points only to half of the primary key?
The structure is as follows:
CREATE TABLE IF NOT EXISTS ` table1` (
`id1` int(10) unsigned NOT
On Tue, May 11, 2010 at 12:26 PM, Barry Zimmerman
barryzi...@googlemail.com wrote:
I have a login script that is great and I want to expand on this but not
sure where to place my new code I have written, I have placed it where I
thought but keep getting errors for else and others when
[snip]
Here's an example of a tough query (there are lots of Smiths!).
SELECT voter1.County, voter1.`First Name`, voter1.`Middle Name`,
voter1.`Last Name`, voter1.`Residential ZipCode`,voter1.`House Number`,
voter1.`Mailing Address`, voter1.`Street Name`, voter1.`Residential City`,
On Thu, Feb 25, 2010 at 9:52 AM, nagendra prasad
nagendra802...@gmail.com wrote:
Hi All,
I have a mysql database file of around 1 GB in size. Is their any tool which
which I can see all the database without uploading it on phpmyadmin on
localhost. I have tried to upload it on localhost but it
On Thu, Feb 18, 2010 at 4:40 PM, Ron Piggott ron@actsministries.org wrote:
I am wondering what others do for a login query. I think there could be
two results: correct e-mail password; correct e-mail wrong password
So far my login query is:
SELECT * FROM `member` WHERE `email` =
[snip]
[/snip]
PS We will now proceed to fire some 20,000 employees as they will no
longer be needed.
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Mon, Jan 25, 2010 at 1:48 PM, listread listr...@cze.com wrote:
Has anyone considered a way to run a script or automatically access a php
page when a user leaves a site without logging off?
The idea is to gracefully end that user's session.
Thanks!
--
PHP Database Mailing List
I developed an implementation that combines roles with fine grained
access. Each role is given a set of permissions ( the current set is
global to the app, the next will be per application) in it, I specify
a db field ( varchar 255) that holds a binary permission scheme. I.E.
10001 etc
The easiest thing to do is either
A) store the author name in a session for the duration of the searches
B) add the name to the pagination url so that its passed along withe
the page number
On 1/23/10, Joe Keenan heresia...@btopenworld.com wrote:
I am using php and mysql.
The problem which
On Tue, Dec 15, 2009 at 12:48 PM, Vinay Kannan viny...@gmail.com wrote:
Hi,
I have 2 pages on php, the first page has a small form to accept a
membership number from the user, which checks for membership number in the
DB, if the membership no does not exist, gives an error saying 'you are not
, Christoph Rosse c...@okto.tv wrote:
you could also validate the form in a seperate php file with no output and
then redirect to the error and the another page ?
Bastien Koert schrieb:
On Tue, Dec 15, 2009 at 12:48 PM, Vinay Kannan viny...@gmail.com wrote:
Hi,
I have 2 pages on php, the first
On Tue, Dec 8, 2009 at 12:54 PM, Philip Thompson philthath...@gmail.com wrote:
Hi all.
We are wanting to create an app that contains multiple clients. Each clients
has anywhere from 1 user to more than a hundred. We had the idea of
separating each client into its own database schema. This
On Tue, Nov 10, 2009 at 4:14 PM, Timothy Legg php_l...@timothylegg.com wrote:
Hello,
Is it wrong to have mysql_connect() called twice within a single PHP
document, such as this? I have been running into some fairly annoying
query failures that commute when I change the order of these two
On Sun, Aug 2, 2009 at 8:02 PM, Govindagovinda.webdnat...@gmail.com wrote:
You need to do this on the mysql side, not in php - php can't summarize
the data before processing it, so you need to use something like the date()
function in mysql on your timestamp column.
On Sun, Aug 2, 2009 at 10:15 PM, Chrisdmag...@gmail.com wrote:
Neil Jackson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I host a number of running clubs websites. They are all hosted on
different domains on a hosting service.
They all share a common database table of
On Sun, Aug 2, 2009 at 11:13 PM, Govindagovinda.webdnat...@gmail.com wrote:
What does the resultset look like?
I am getting every record in the table back
my bad, i reversed the mysql and php date function formats
try
SELECT distinct(
DATE_FORMAT( fieldname, '%Y-%m-%d' )
)
FROM table
ORDER
On Wed, Jul 15, 2009 at 9:21 AM, Govindagovinda.webdnat...@gmail.com wrote:
Reading docs.. I want to be sure of things... have your verification of my
understanding(s)-
Does setting a mysql db column (say myPrimarykeyID) with the 'primary_key'
'auto_increment' flags totally negate the
On Wed, Jul 15, 2009 at 4:40 PM, Govindagovinda.webdnat...@gmail.com wrote:
On Jul 15, 2009, at 7:37 AM, Bastien Koert wrote:
On Wed, Jul 15, 2009 at 9:21 AM, Govindagovinda.webdnat...@gmail.com
wrote:
Reading docs.. I want to be sure of things... have your verification of
my
[snip]
Sorry my question... but why I must use JOIN if I can use SELECT * FROM
table1 AND table2 AND table3 WHERE table1.id=table2.id=table3 not?
thanks
+ _
[/snip]
select table1.field1, table1.field2, table2.field3,
On Mon, Jul 13, 2009 at 11:52 AM, Patrick Moloneywebpa...@gmail.com wrote:
I've had no success trying to execute any stored procedure from php.
I'm just trying to follow the example for multi-query in the php manual, and
have tried an example from Artfulsoftware.com. I have one input and one
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
2009/6/3 Martin Zvarík mzva...@gmail.com:
SELECT * FROM xxx WHERE primary_id=123 LIMIT 1
Is it useless (LIMIT 1) ?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
It doesn't do anything...you are already returning just the one row
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
On Fri, May 22, 2009 at 4:24 PM, Dee Ayy dee@gmail.com wrote:
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
On Mon, May 11, 2009 at 9:07 PM, Joey Hendricks
j.hendrick...@comcast.netwrote:
Hi everybody, I have a paging question. I have a page where you can view a
persons 'profile'. And I have a list taken from the db of there books. I can
get all the books on one page but I can't figure out the WHERE
On Fri, May 8, 2009 at 6:23 PM, Bogdan Stancescu gu...@moongate.ro wrote:
Hello all,
I asked this question on php-general last month
(http://marc.info/?t=12404923034r=1w=2), and received some answers
-- but I was directed to this list, so here.
My question is: can I tell
On Mon, Apr 27, 2009 at 10:19 AM, Miller, Terion
tmil...@springfi.gannett.com wrote:
I need help/advice figuring out why my query dies after 2 records. Here is
the query:
// Build your INSERT statement here
$query = INSERT into `warrants` (wid, name, age, warrant, bond, wnumber,
On Fri, Mar 6, 2009 at 1:06 PM, Joao Gomes Madeira jpcg@gmail.comwrote:
Hi Sashi:
You're incurring in this error because the headers for the page have
already been issued in the head section of your page.
When you issue the php header() function, it will generate an error.
Anyway, you
On Wed, Mar 4, 2009 at 5:45 AM, mrfroasty mrfroa...@gmail.com wrote:
Hello guysis there any tool that can create data relation from sql
document?I have seen phpmyadmin, but still I am looking for other
software to see what they have to offer...
Thanks
--
Extra details:
OSS:Gentoo
On Wed, Mar 4, 2009 at 9:42 AM, Yves Sucaet yves.suc...@usa.net wrote:
The professional version of SQLyog (http://www.sqlyog.com) has this
capability. It's not free though.
If you're looking for a free tool, I think the standard out there is
DBDesigner: http://www.fabforce.net/dbdesigner4/
On Sun, Feb 22, 2009 at 4:43 PM, Chris dmag...@gmail.com wrote:
This is the page called
~~~
?php
#phpinfo(); # phpinfo displays the correct info.
#exit;
$sqldb= $_POST[sqldb];
$sqluser = $_POST[sqluser];
$sqlpass = $_POST[sqlpass];
$sqlhost =
On Sat, Feb 21, 2009 at 8:44 AM, Heddon's Gate Hotel
ho...@heddonsgate.co.uk wrote:
Hello,
(I hope I am posting to the PHP databases mailing list. I have tried
getting automated help and contacting the list owner, but I just get weird
automated replies. If I am not going about this
On Sun, Dec 21, 2008 at 7:56 PM, Ron Piggott ron.pigg...@actsministries.org
wrote:
One more thing ... Bible is stored by verses, t is the text of the verse
On Sun, 2008-12-21 at 19:52 -0500, Ron Piggott wrote:
I am working on a web based Bible searching query. So far I am able to
On Tue, Dec 9, 2008 at 10:33 AM, Alex Moen [EMAIL PROTECTED] wrote:
OK, sounds good, what am I looking for? I don't see the module being
declared in my php.ini file on either of my servers.
Alex
Fortuno, Adam wrote:
Alex:
It sounds like the MySQL extension module isn't loading. Here
On Fri, Nov 28, 2008 at 5:52 PM, Fergus Gibson [EMAIL PROTECTED] wrote:
On Thu, Nov 27, 2008 at 11:19 AM, Bastien Koert [EMAIL PROTECTED] wrote:
2. It is possible to use the application to handle the keys instead of
the
database, it involves more work around key checking / validation before
On Thu, Nov 27, 2008 at 1:36 PM, Fortuno, Adam
[EMAIL PROTECTED]wrote:
Mr. Froasty,
From your note, it sounds like you want to use foreign keys; as Daniel
pointed out. I think an example would be helpful here. The subject of
foreign keys is bigger than a bread box so I'll just touch on the
On Mon, Oct 20, 2008 at 7:59 AM, Jason Pruim [EMAIL PROTECTED] wrote:
Good morning everyone!
[snip][/snip]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I would suggest breaking the client and contacts into two tables. Its likely
On Sun, Oct 12, 2008 at 5:54 PM, Chris [EMAIL PROTECTED] wrote:
Ron Piggott wrote:
When I do the following command:
$number_of_entries=mysql_numrows($blog_activity_result);
and there are no rows I get an error (Warning: mysql_numrows(): supplied
argument is not a valid MySQL result
On Sun, Oct 12, 2008 at 6:10 AM, Velen [EMAIL PROTECTED] wrote:
Hi
I have 3 frames on my index page using frameset. I want to display another
content in the other frames when a user has logged in successfully.
My code is like that:
## if user exists and have corresponding password
On Thu, Oct 2, 2008 at 6:50 AM, Jack van Zanen [EMAIL PROTECTED] wrote:
I am not up to scratch with innodb, but in oracle
you would have a Primary key on both the id fields in the Car and person
table and a Foreign key on PersonId linking it to Id in the Person table.
IN your select an
On Sun, Sep 28, 2008 at 6:28 PM, Chris [EMAIL PROTECTED] wrote:
Yves Sucaet wrote:
Hi Jack,
I'm expecting less than 10 records in the resulting set.
The BlockUnit table contains 337,253 records; the InteractionParts table
contains 279,953 records.
It takes currently 8.3 seconds to
On Fri, Sep 26, 2008 at 11:22 AM, muhsin [EMAIL PROTECTED] wrote:
Could you guys share your development setup, like what kinds of software
(IDE's/Editors) you are using for developing php scripts?
It might sound silly but I am just curios, as I just got started in php
programming en i have
On Mon, Sep 15, 2008 at 1:33 PM, Stephen Wellington
[EMAIL PROTECTED] wrote:
You probably want something like this:
SELECT * FROM chico as c, harpo as h WHERE c.operator = Bill OR
c.operator =
Jessica OR h.operator = Bill OR h.operator =Jessica
However if those tables really are identical
On Tue, Aug 5, 2008 at 4:33 PM, Ben Miller [EMAIL PROTECTED]wrote:
Figured there had to be an easier way. Thank you so much.
-Original Message-
From: Simcha Younger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2008 2:48 PM
To: php-db@lists.php.net
Subject: RE: [PHP-DB] Date
On Sun, Aug 10, 2008 at 4:23 PM, Darron Butler [EMAIL PROTECTED] wrote:
Thanks for your thoughts. To answer your first question, I'm using
extract()
because this is a page where admins and super users can edit the
permissions
of others for the site. Therefore, I have to query the database to
On Wed, Jul 23, 2008 at 4:48 AM, Chris [EMAIL PROTECTED] wrote:
Steven Macintyre wrote:
Hi all,
Below is the query we are getting a slow response on ... 2seconds ...
with 4 records we were hoping to get it much quicker.
Can someone advise if i can optimise this?
SELECT
On Wed, Jul 9, 2008 at 1:32 PM, Bonger O [EMAIL PROTECTED] wrote:
Hi,
I have set up an environment on my Vista laptop comprising of Apache 2.2,
MySQL Server 5.1 and Php 5.2.5.
I'm using a simple php program that I found in a PHP/SQL book. The PHP
program queries a MySQL table and traverses
On Fri, Jul 4, 2008 at 11:35 PM, Ron [EMAIL PROTECTED] wrote:
Hi,
I dont know if this question is allowed here:
i have a web interface that let's user upload file, but i have 2 servers
and use dns round-robin. when a user uploads a file, it will only be
uploaded on one of the servers.
On Sat, Jul 5, 2008 at 5:50 PM, Roberto Carlos García Luís
[EMAIL PROTECTED] wrote:
Ron,
You can use a Editor that have the service.
For example Dreamweaver or create a link to a ftp server.
El 05/07/2008, a las 10:52 a.m., Ron escribió:
Is it possible to upload directly on a remote
On Sun, Jun 29, 2008 at 11:07 AM, Nasreen Laghari [EMAIL PROTECTED]
wrote:
Hi,
I have an HTML form which has more then one fields. User can precise its
search using one or more input fields E.g GigName,Date, Genre,Venue.
The data is coming from 3 tables. Below Query brings one tables record
On Tue, Jun 24, 2008 at 11:00 AM, A. Joseph [EMAIL PROTECTED] wrote:
Which company in India or USA can you recommend to design a complex
website for my company.
The site will be a social site, will include, Blog, Articles, Shops,
Music, Movie, Directory, Pre-paid card system, Culture and
On 5/30/08, Ron Piggott [EMAIL PROTECTED] wrote:
I don't understand what is going wrong:
CREATE FULLTEXT INDEX
ON shopping_cart_product(product_name, product_description)
gives me this error:
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your
On 5/24/08, Ron Piggott [EMAIL PROTECTED] wrote:
Is it possible to do a conditional INNER JOIN ?
So far I have
SELECT * FROM ( shopping_cart_orders INNER JOIN
shopping_cart_sales_shipping_address ON
shopping_cart_orders.shipping_address_reference =
at 19:40 -0400, Bastien Koert wrote:
On 5/24/08, Ron Piggott [EMAIL PROTECTED] wrote:
Is it possible to do a conditional INNER JOIN ?
So far I have
SELECT * FROM ( shopping_cart_orders INNER JOIN
shopping_cart_sales_shipping_address
On Thu, May 22, 2008 at 5:27 PM, Dee Ayy [EMAIL PROTECTED] wrote:
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
On Thu, Apr 24, 2008 at 2:54 PM, Peter Westergaard [EMAIL PROTECTED]
wrote:
Rick Taylor wrote:
I'm new to PHP and having issues. We have seperate servers for them. We
can use ODBC to test the connection and it works fine. However, when we try
to run the site we get a message of *** Error:
generate a new password and email that to the user
bastien
Date: Tue, 26 Feb 2008 22:52:01 -0800 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] Password Reset Hi, I have
encrypted password in database and I encrypted using MD5(). As it is a
one-way Hash so I cant
try using htmlentitites first to conver the ' to #39; instead
bastien
Date: Mon, 25 Feb 2008 21:46:17 -0500 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] pg_escape with copy I have data
that I'm running through pg_escape_sting in php and then adding to stdin for
a
do you mean that you have a primary key on table a with an fk to table b? and
on table b you have a primary key and an fk to table a?
if so, you've created a circular referential integrity constraint. The table
deadlocks since the values must exist in the other (tables a and b) table.
There
That just sounds like such recipe for disaster. What about running multiple
divs with each data set in that 'window'? Then you could pass each datasets
relevant ids along to keep thing separate...
Another option could to create multiple [i]frames and do the same thing?
Bastien To:
i use
if (!($conn=mysql_connect($host, $username, $pwd))) {notify(error
connecting to DB);die(); }else{ return $conn; }
in a function
bastien
Date: Wed, 6 Feb 2008 02:07:11 -0800 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] About
$text = nl2br($text);
bastien
Date: Fri, 1 Feb 2008 08:07:17 -0500 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] Formatting in Text Area I have a
customer description text area field on my form which feeds through php to
FMP, and spits out a confirmation page and
with it, and then I'm still not sure what it does),
if you want to have all rows in tour regardless of the join condition with NULL
values for angler_results.result where tour.record_id is not in
angler_results.tour_id. To leave out the NULL values use an INNER JOIN
instead. Evert Bastien Koert wrote
sorry, went to bed
getting a sql error 1064 error in syntax
bastien Date: Thu, 31 Jan 2008 15:48:02 +1100 From: [EMAIL PROTECTED] To:
[EMAIL PROTECTED] CC: php-db@lists.php.net Subject: Re: [PHP-DB] A little SQL
help Bastien Koert wrote: Hi All,Got myself stuck in a little sql
here
After some playing and a little sleep
This is the corrected query
SELECT tour.event_start_date, tour.event_end_date, tour.event_name, CASE WHEN
result IS NULL THEN 'N/A'ELSE resultEND FROM tourLEFT OUTER JOIN angler_results
ON angler_results.tour_id = tour.record_idWHERE (
Hi All,
Got myself stuck in a little sql here and can't seem to work out what I am
doing wrong
SELECT
DISTINCT (tour.record_id), tour.event_start_date, tour.event_end_date,
tour.event_name,CASE WHEN result is NULLTHEN 'N/A'ELSE angler_results.resultEND
CASE
FROM
tourLEFT OUTER JOIN
Hi ben,
You are creating the same table each time you run the code which would throw an
error the second time you run the code since the table is already there.
You have two choices here:
1. remove the table creation script and the call to create it since the table
only needs to be created
assuming that the data sits in a table, right align the cell
or use a css class to do the same thing
bastien
Date: Tue, 1 Jan 2008 14:56:34 +0600
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] align
hi,
i hav fall in a
www.php.net/date will show you all the possibilities of formatting the date
bastien
Date: Sat, 22 Dec 2007 17:54:07 +0600
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] date format problem
my problem is with date format
1 - 100 of 720 matches
Mail list logo
