: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 10, 2003 5:40 PM
To: James Johnson; [EMAIL PROTECTED]
Subject: Re: MySQL field data type for ISBN numbers
James Johnson wrote:
Hi,
I have a MySQL database for books. The ISBN field is set as varchar(15)
and I've put a test ISBN number
, thanks to everyone's help, I have it working now.
James
-Original Message-
From: Paul Chvostek [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 10, 2003 6:08 PM
To: James Johnson
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL field data type for ISBN numbers
On Sun, Aug 10, 2003 at 05:25:05PM
-Original Message-
From: Tomasz Korycki [mailto:[EMAIL PROTECTED]
Sent: 11 August 2003 05:26
To: [EMAIL PROTECTED]
Subject: OT: Re: MySQL field data type for ISBN numbers
At 21:08 2003-08-10, you wrote:
On Sun, Aug 10, 2003 at 05:25:05PM -0700, James Johnson wrote
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, 10 Aug 2003 17:25:05 -0700, James Johnson wrote:
$ISBN = $_GET['isbn'];
$query = SELECT * FROM book_details WHERE ISBN = '$ISBN';
Try using where isbn like '$ISBN'
- --
jimoe at sohnen-moe dot com
pgp/gpg public key:
data type for ISBN numbers
James Johnson wrote:
Hi,
I have a MySQL database for books. The ISBN field is set as varchar(15)
and I've put a test ISBN number in of 1--111-11. Can someone tell
me why this SQL query isn't working?
$ISBN = $_GET['isbn'];
$query = SELECT * FROM book_details
James Johnson wrote:
Hi,
I have a MySQL database for books. The ISBN field is set as varchar(15) and
I've put a test ISBN number in of 1--111-11. Can someone tell me why
this SQL query isn't working?
$ISBN = $_GET['isbn'];
$query = SELECT * FROM book_details WHERE ISBN = '$ISBN';
Since the
-Original Message-
From: Tomasz Korycki [mailto:[EMAIL PROTECTED]
Sent: 11 August 2003 05:26
To: [EMAIL PROTECTED]
Subject: OT: Re: MySQL field data type for ISBN numbers
At 21:08 2003-08-10, you wrote:
On Sun, Aug 10, 2003 at 05:25:05PM -0700, James Johnson wrote:
I
At 21:08 2003-08-10, you wrote:
On Sun, Aug 10, 2003 at 05:25:05PM -0700, James Johnson wrote:
I have a MySQL database for books. The ISBN field is set as varchar(15) and
I've put a test ISBN number in of 1--111-11.
Note that ISBN numbers are a maximum of 13 characters, not 15. Ten
digits,
On Sun, Aug 10, 2003 at 05:25:05PM -0700, James Johnson wrote:
I have a MySQL database for books. The ISBN field is set as varchar(15) and
I've put a test ISBN number in of 1--111-11.
Note that ISBN numbers are a maximum of 13 characters, not 15. Ten
digits, three dashes. If you really
Hi,
I have a MySQL database for books. The ISBN field is set as varchar(15) and
I've put a test ISBN number in of 1--111-11. Can someone tell me why
this SQL query isn't working?
$ISBN = $_GET['isbn'];
$query = SELECT * FROM book_details WHERE ISBN = '$ISBN';
Since the field is a varchar,
[EMAIL PROTECTED]
CEO Gurix Web Professionals
www.gurix.com
- Original Message -
From: James Johnson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, August 10, 2003 8:58 PM
Subject: RE: MySQL field data type for ISBN numbers
Hi Daniel,
Here's what is echoed back. It looks valid
11 matches
Mail list logo