Re: [PHP-DB] Database question

2002-09-04 Thread Raquel Rice
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

Re: [PHP-DB] best way to stare true, false

2002-08-10 Thread Raquel Rice
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 are

Re: [PHP-DB] best way to stare true, false

2002-08-10 Thread Raquel Rice
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 table to find all

Re: [PHP-DB] Auto Increment Problems....

2002-07-29 Thread Raquel Rice
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 where I deleted

Re: [PHP-DB] Re: Storing Variable Function Info

2002-07-24 Thread Raquel Rice
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 $name.;

[PHP-DB] Storing Variable Function Info

2002-07-23 Thread Raquel Rice
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 to

Re: [PHP-DB] remove from db renumbering

2002-06-30 Thread Raquel Rice
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 their IDÂ’s

Re: [PHP-DB] Converting upper case letters to lower case because of db??

2002-02-07 Thread Raquel Rice
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 creating a php

Re: [PHP-DB] uploading

2002-01-27 Thread Raquel Rice
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 in this case

Re: [PHP-DB] How do I know when to

2002-01-11 Thread Raquel Rice
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 plain int.

Re: [PHP-DB] How do I know when to

2002-01-11 Thread Raquel Rice
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 that

Re: [PHP-DB] hiding blank MySQL results?

2002-01-05 Thread Raquel Rice
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 record has an

Re: [PHP-DB] php3-php4 mysql problem with nl2br coding

2001-11-24 Thread Raquel Rice
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 BR I get BR / and then my parsing fails on the display side (where I use

Re: [PHP-DB] Lost Access Logging Out why do you taunt me IE?

2001-11-12 Thread Raquel Rice
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 area with

Re: [PHP-DB] MySQL Query

2001-10-26 Thread Raquel Rice
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 MySQL said:

Re: [PHP-DB] connecting to msql... easy question!

2001-10-20 Thread Raquel Rice
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 server. I

Re: [PHP-DB] Sessions and Frames

2001-10-18 Thread Raquel Rice
-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, I am working on

Re: Re[2]: [PHP-DB] padding an id field

2001-10-04 Thread Raquel Rice
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 possible to

Re: [PHP-DB] Cybercash? or Who?

2001-10-03 Thread Raquel Rice
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.

Re: [PHP-DB] Re: MySQL Database Locking - needed?

2001-07-10 Thread Raquel Rice
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 still