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
wrote:
> *Description*
>
> The PHP function odbc_fetch_array returns uninitialized values for
> PostgreSQL boolean values. On o
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
wrote:
>
> On 03/06/15 09:37, Aziz Saleh wrote:
> > On Wed, Jun 3, 2015 at 12:25 AM, Ron Pi
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 (
; > PHP code.
> >
> > On Fri, Feb 13, 2015 at 12:03 AM, Ethan
> Rosenberg
> > >
> > <mailto:erosenberg@ <mailto:erosenberg@>__
> hygeiabio__medical.com
> > <htt
Generally input names shouldn't have spaces, use underscores if needed
On Tue Feb 17 2015 at 4:34:55 PM rahul bhola wrote:
> Can you post some code snippet here
>
> cheers
> Rahul
>
5 at 11:24 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 brow
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 somethin
ables to be transferred.
>
> From another post to the UNIX list, this works.
>
>
> <!--
> window.open("HandleFood.php","_self")
> //-->\
>
>
> and the SESSION variables transfer.
>
> Sorry for bothering you with such trivia.
>
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 wrote:
> Besides the usual suspects that are 3rd party, a common solution I've seen
> is Solr/Lucene:
> https://lucene.apache.org/solr/
>
>
> -Matt
>
>
> On 0
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 wrote:
> > Hello.
> > I am newbie in this and need som basic help.
> >
> > I have a form witch checkbox'es with diffe
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 f
On Mon, Sep 10, 2012 at 9:48 AM, Jim Giner 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 complex
> query that you may
On Fri, Sep 7, 2012 at 10:54 AM, Jim Giner 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() in
> /home/albany/php
On Fri, Aug 24, 2012 at 8:34 PM, Gary Chambers 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 to your r
On Tue, Aug 21, 2012 at 4:44 PM, Matt Pelmear 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 08/21/2012 07:09 A
On Mon, Nov 28, 2011 at 9:19 PM, Phil Dobbin wrote:
> On 29/11/11 02:08, "Jason Pruim" 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 looking into. P
On Tue, Nov 8, 2011 at 1:33 PM, Bastien Koert wrote:
> On Tue, Nov 8, 2011 at 1:31 PM, Ron Piggott
> 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 of
>> options
On Tue, Nov 8, 2011 at 1:31 PM, Ron Piggott
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 of options. Ron
>
> Ron Piggott
>
>
>
> www.TheVerseOfTheDay.info
>
phpmyadmin supports this easily
--
On Tue, Mar 8, 2011 at 11:16 AM, Ron Piggott
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 1-800-
> - BUT I don’t
On Mon, Jan 31, 2011 at 8:06 AM, Ron Piggott
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”
> http://www.TheVerseOfThe
On Sun, Jan 30, 2011 at 2:27 PM, Ron Piggott
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). But if the query is ran o
On Fri, Jan 14, 2011 at 2:15 PM, Cristiano Di Buduo
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 not find driver" er
On Fri, Jan 7, 2011 at 9:46 AM, Toby Hart Dyke 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 multiple rows
On Tue, Dec 14, 2010 at 4:53 PM, Ron Piggott
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 `rss_feed_include` = 1 GROUP BY `rss_fee
On Fri, Dec 3, 2010 at 4:42 AM, Neil Jackson 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 square in IE
On Wed, Nov 17, 2010 at 8:51 AM, Vinay Kannan 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) hobbies = 5 co
gt; Sent: 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
> w
On Thu, Oct 28, 2010 at 1:00 PM, Ethan Rosenberg wrote:
> At 03:40 AM 10/28/2010, Max E.K wrote:
>
>> From: "Ethan Rosenberg"
>> To: rquadl...@googlemail.com, "Ethan Rosenberg"
>> Cc: "php-db-lists.php.net"
>> Sent: Thursday, October 28, 2010 4:55:34 AM GMT +01:00 Amsterdam / Berlin
>> / Bern /
On Mon, Aug 30, 2010 at 12:14 PM, nagendra prasad
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 all the records in my
On Wed, Jun 30, 2010 at 10:52 AM, nagendra prasad
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 speed of searching? Is
>
On Wed, Jun 9, 2010 at 10:28 PM, win.a 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 ?
>
> --
> PHP Data
On Tue, May 18, 2010 at 2:51 PM, Niel Archer 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 N
On Tue, May 11, 2010 at 12:26 PM, Barry Zimmerman
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 attempting to add
> this.
>
> Th
[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`,
> vote
On Thu, Feb 25, 2010 at 9:52 AM, nagendra prasad
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 said the file size
On Thu, Feb 18, 2010 at 4:40 PM, Ron Piggott 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` = '$my_email' AND `pass` L
[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
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
On Mon, Jan 25, 2010 at 1:48 PM, listread 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 (http://www.php.n
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 wrote:
> I am using php and mysql.
>
> The problem which I am hoping someone can
Christoph Rosse 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
On Tue, Dec 15, 2009 at 12:48 PM, Vinay Kannan 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
> a member c
On Tue, Dec 8, 2009 at 12:54 PM, Philip Thompson 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 reduces the single
On Tue, Nov 10, 2009 at 4:14 PM, Timothy Legg 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 blocks of
> code. I
On Sun, Aug 2, 2009 at 11:13 PM, Govinda 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 BY field DESC
--
Ba
On Sun, Aug 2, 2009 at 10:15 PM, Chris 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 fixtur
On Sun, Aug 2, 2009 at 11:08 PM, Govinda wrote:
>> On Sun, Aug 2, 2009 at 8:02 PM, Govinda
>> 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
On Sun, Aug 2, 2009 at 8:02 PM, Govinda 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.
>>
>>
>> http://dev.mysql.com/doc/refman/5.0/en/
Sorry for top posting, a little flaw in the web version of gmail.
Restart the web server to get the ini change to take effect
bastien
On Thursday, July 23, 2009, Ankur Singh wrote:
> Please add mysql dll to you php extension directory
>
> 2009/7/23 yi wang :
>> Hi, all!
>>
>> I have intalled ap
On Wed, Jul 15, 2009 at 4:40 PM, Govinda wrote:
>
> On Jul 15, 2009, at 7:37 AM, Bastien Koert wrote:
>
>> On Wed, Jul 15, 2009 at 9:21 AM, Govinda
>> wrote:
>>>
>>> Reading docs.. I want to be sure of things... have your verification of
>>> my
&g
On Wed, Jul 15, 2009 at 9:21 AM, Govinda 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 logic for ever having to
On Mon, Jul 13, 2009 at 1:33 PM, Patrick Moloney wrote:
> Bastien Koert wrote:
>>
>> On Mon, Jul 13, 2009 at 11:52 AM, Patrick Moloney
>> wrote:
>>>
>>> I've had no success trying to execute any stored procedure from php.
>>> I'm just tryi
On Mon, Jul 13, 2009 at 11:52 AM, Patrick Moloney 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
> output parameter
[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.field
On Thu, Jun 18, 2009 at 6:03 AM, NADARAJAH SIVASUTHAN
NADARAJAH 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
> 'ODBC
On Thu, Jun 18, 2009 at 2:00 AM, Bjoern Lemke 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 can support t
2009/6/3 Martin Zvarík :
> "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
since th
2009/6/3 Martin Zvarík :
> "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
>
>
--
Bastien
Cat, the other other white meat
--
PHP Database Mailing List
On Thu, May 28, 2009 at 4:19 PM, Wilson Osemeilu wrote:
> 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 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 Database
On Mon, May 11, 2009 at 9:07 PM, Joey Hendricks
wrote:
> 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 from the get.
> This i
On Fri, May 8, 2009 at 6:23 PM, Bogdan Stancescu wrote:
> Hello all,
>
> I asked this question on php-general last month
> (http://marc.info/?t=12404923034&r=1&w=2), and received some answers
> -- but I was directed to this list, so here.
>
> My question is: can I tell programatically whether
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,
On Fri, Mar 6, 2009 at 1:06 PM, Joao Gomes Madeira wrote:
> 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 are storing
On Wed, Mar 4, 2009 at 9:42 AM, Yves Sucaet 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/
>
> Alternativel
On Wed, Mar 4, 2009 at 5:45 AM, mrfroasty 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 Linux-2.6.
On Sun, Feb 22, 2009 at 4:43 PM, Chris wrote:
>
> This is the page called
>> ~~~
>>
>> > #phpinfo(); # phpinfo displays the correct info.
>> #exit;
>>
>> $sqldb= $_POST["sqldb"];
>> $sqluser = $_POST["sqluser"];
>> $sqlpass = $_POST["sqlpass"];
>> $sqlhost = $_POST["sq
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 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
> > generate:
> >
> > SELECT * FRO
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 lo
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
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
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. It
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 MySQ
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 passwo
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 a
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
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 ha
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 real
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 datab
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-
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?
> >
>
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 t
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 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 serv
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
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 a
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
erence =
> shopping_cart_sales_shipping_address.reference
>
> On Sat, 2008-05-24 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
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 =
> shopping_cart_sales_shipping_a
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 co
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 *
Hey Ron
Sure can with the BINARY keyword
http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html
Bastien> From: [EMAIL PROTECTED]> To: php-db@lists.php.net> Date: Thu, 6 Mar
2008 22:45:09 -0500> Subject: [PHP-DB] Case sensitive query> > Is it possible
to do a case sensiti
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
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 a
try using htmlentitites first to conver the ' to ' 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
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: php-db@li
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 m
$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
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 (
angler_results.an
1 - 100 of 772 matches
Mail list logo
