On Tue, 20 Aug 2002 18:34:48 -0500
"Shiloh Madsen" <[EMAIL PROTECTED]> wrote:
> I was wondering if there were any good documents out there about
> good database design...I know the basics of creating tables,
> setting data types and such, and now i want to know how to use it
> to the best effect.
On Sat, 10 Aug 2002 17:41:56 +0200
"andy" <[EMAIL PROTECTED]> wrote:
> > > Hi there,
> > >
> > > I am searching for the best way to store true or false inside
> > > a MySQL DB. With best I mean the most data efficient way and
> > > in the same time the best for fast searching later on the
> > > t
On Sat, 10 Aug 2002 16:46:54 +0200
"andy" <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> I am searching for the best way to store true or false inside a
> MySQL DB. With best I mean the most data efficient way and in the
> same time the best for fast searching later on the table to find
> all which
On Mon, 29 Jul 2002 20:44:54 -0700
Georgie Casey "Georgie Casey" <[EMAIL PROTECTED]> wrote:
> rite,
>
> my primary key column ("id") is set to auto_increment as usual
> which is very
> handy. But when I delete a row, the auto_increment just keeps
> incrementing
> and there's this 'hole' left whe
On Wed, 24 Jul 2002 16:49:38 -0400
Martin Clifford "Martin Clifford" <[EMAIL PROTECTED]> wrote:
> You're trying to use double quotes, in which the variable is
> evaluated and the stored value is shown, right? Try using single
> quotes. For example, with $name = "Martin".
>
> echo "My name is $
On Wed, 24 Jul 2002 13:23:54 +1200
David Robley David Robley <[EMAIL PROTECTED]> wrote:
> In article <[EMAIL PROTECTED]>,
> [EMAIL PROTECTED] says...
> > I've run out of ideas. I want to store a variable name and a
> > function call in a text column of a MySQL database and have them
> > interpr
I've run out of ideas. I want to store a variable name and a
function call in a text column of a MySQL database and have them
interpreted at runtime, but I can't figure out how to do it.
Examples:
"This is the $nbrtimes you've asked."
and
"$answer is the square root of sqrt($nbr)."
I've tried
On Sun, 30 Jun 2002 20:21:18 -0400
Chris Payne "Chris Payne" <[EMAIL PROTECTED]> wrote:
> Hi there everyone,
>
> I have my id field auto incrementing (Of course) and I have a
> utility
> that allows me to remove items from it, the problem is when I
> remove
> something the items after it keep t
On Thu, 7 Feb 2002 17:07:35 +0100
Andy "Andy" <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> I have a tabel with 250 entries showing a country code lik "CA"
>
> Now my application does not work on linux, because they have to be
> in lower
> case.
>
> Can I make anyhow an bufix, or even better crea
On Sun, 27 Jan 2002 13:04:09 +0200
Thomas \ "Thomas \"omega\" Henning" <[EMAIL PROTECTED]> wrote:
> Hello how can i upload something from my hdd to the webserver
> using php?
>
> note: don't have ftp on the machine!!
>
> Thanks
>
> Thomas "omega" Henning
I usually don't like saying this, but
On Fri, 11 Jan 2002 17:21:28 -0800
Jerry Leonard "Jerry Leonard" <[EMAIL PROTECTED]> wrote:
> Okay this is the way I understand the statement below. The uid
> will be a
> number from 1 to 10, max length of ten digits say starting at 1
> then as the
> next user registers it will automatically make
On Fri, 11 Jan 2002 15:02:00 -0800
Jerry Leonard "Jerry Leonard" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am really new to MySQL and am wondering this:
>
> I understand how to make a database and tables but what I don't
> understand
> is when to make a row an "int" with auto_increment or just a p
On Sat, 5 Jan 2002 01:12:21 -
Nathon Jones "Nathon Jones" <[EMAIL PROTECTED]> wrote:
> Hi.
>
> I have a PHP page calling a set of results from a MySQL database.
> They
> appear in the following format on the results page:
>
> Title
> Description
> Link
>
> Problem I'm having. When a db r
On Mon, 3 Dec 2001 17:31:30 -0500
Thomas "Thomas" <[EMAIL PROTECTED]> wrote:
> I have looked into some source code that I found, but I'm a newbie
> at this,
> and don't understand..
>
> if ( 0 == $this->link_id) {
>
> In this statment, what does the '->' repersent? this statment
> (operator?)
On Fri, 23 Nov 2001 14:04:00 -0600
Terry Romine Terry Romine <[EMAIL PROTECTED]> wrote:
> I seem to have run into a strange bug where when I enter text
> through a
> form, and use the nl2br call in PHP, instead of getting "" I
> get
> "" and then my parsing fails on the display side (where I
>
On Tue, 13 Nov 2001 04:30:06 +0800
Brian Tegtmeier "Brian Tegtmeier" <[EMAIL PROTECTED]> wrote:
> Sup all. I'm currently running into a problem (can send source if
> needed) with this news script called "PHP-News" at
> http://www.hotscripts.com/Detailed/7145.html where if I login to
> the admin a
On Sat, 27 Oct 2001 13:36:57 +1000
"Andrew Duck" <[EMAIL PROTECTED]> wrote:
> Error
> SQL-query :
>
> CREATE TABLE mail (
> from int(32) NOT NULL default '0',
> to int(32) NOT NULL default '0',
> subject varchar(80) NOT NULL default '',
> message text NOT NULL
> ) TYPE=MyISAM
>
>
>
On Sat, 20 Oct 2001 09:16:26 -0400
David Bedingfield <[EMAIL PROTECTED]> wrote:
> ...still no luck with this... any help?
>
> David Bedingfield wrote:
>
> > With a basic php document, I am trying to create a table. I have
a good
> > code for the table (I think) but I cannot connect to the SQL
s
> > -Original Message-
> > From: TJayBelt <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> > Date: Thursday, October 18, 2001 8:28 AM
> > Subject: [PHP-DB] Sessions and Frames
> >
> >
> > >I have a site that is successfully using sessions and
authentication.
> > >However
On Thu, 4 Oct 2001 14:17:22 -0300
WebDev <[EMAIL PROTECTED]> wrote:
> Thursday, October 04, 2001, 1:13:59 PM, you wrote:
>
> RR> When you define your auto-incrementing column, can't you
specify
> RR> "ZEROFILL"? I believe it pads to the left with zeroes.
>
> Hello Raquel,
>
> Yes, but is it p
On Wed, 3 Oct 2001 09:49:20 -0600
Ricky Theil <[EMAIL PROTECTED]> wrote:
> I just recently started using Cardservice International for all my
> precessing. The only drawback was that I had to purchase an API
wrapper,
> but it is a PHP wrapper. It was $95. It's extremely fast, and
easy to use.
Tom Peck wrote:
> >
> >How about writing a text file that would be your "lock" file, rather
> >than depending upon MySQL to do it for you?
> >
> >--
> >Raquel
>
> So what you mean is:
>
> If someone clicks on a car to edit, a txt file is written (maybe called the
> carID.txt). Then if someone e
Tom Peck wrote:
>
> Thanks for the reply Manual.
>
> The updating IS done with one single query - but the problem is that if two
> people are editing the same car, the second update will overwrite the
> first. Not a huge problem - and the chance of it happening is almost nil -
> but there is st
23 matches
Mail list logo
