[PHP-DB] Re: Record Update Link

2001-07-28 Thread Al Savage
(posted & emailed) > I seem to be having difficulty creating a hypertext link between the > results of a sql query, ie a a formated page with a contact record > (FirstName, LastName, etc.) to a page that will allow for editing. I think that I'm doing what you're trying to do. See my demo at: h

[PHP-DB] Re: Probably a stupid home server question

2001-07-18 Thread Al Savage
** Reply to note from [EMAIL PROTECTED] 18 Jul 2001 14:24:27 - Hello, Chris: > I currently run a unix web server from a company in the UK, i'm > getting a cable modem soonish and was wondering if I can run a > server from home rather than hiring one as I am now? If so what > will I need? I

[PHP-DB] RE: php: $array["fieldname"] gives "undefined index" err

2001-06-23 Thread Al Savage
** Reply to note from Jonathan Hilgeman <[EMAIL PROTECTED]> Fri, 22 Jun 2001 14:44:57 -0700 Jonathan asks: > Whats your query look like? Do you perform any joins? Hmmm . . . everything after "$query" got chopped off, and didn't display in the digest version I received. Well, I'll try again

[PHP-DB] Re: Extracting enum/set values from database

2001-06-23 Thread Al Savage
** Reply to note from [EMAIL PROTECTED] 23 Jun 2001 06:24:11 - Hello, Todd: > Is there a way to dynamically build an option list from an enum/set > type? In other words, if I don't know the possible values of the > enum or set field ahead of time, how can I retrieve that information > at ru

[PHP-DB] RE: php: $array["fieldname"] gives "undefined index" err

2001-06-23 Thread Al Savage
** Reply to note from Jonathan Hilgeman <[EMAIL PROTECTED]> Fri, 22 Jun 2001 14:44:57 -0700 Jonathan asks: > Whats your query look like? Do you perform any joins? $query = "SELECT * FROM $table WHERE CustNo='$CustNo'"; Pretty vanilla stuff. [ . . . ] > BUT! If the field is NULL, php spit

[PHP-DB] php: $array["fieldname"] gives "undefined index" error

2001-06-22 Thread Al Savage
Hello: I've got a table with 34 fields: (best viewed using a non-proportional font) mysql> describe contacts; +-+--+--+ | Field | Type | Null | +-+--+--+ | CustNo | int(10) unsigned |