Re: [PHP-DB] newbie help

2007-10-01 Thread nhadie
to store for whatever your webapp does? -TG - Original Message - From: nhadie [EMAIL PROTECTED] To: php-db@lists.php.net Date: Fri, 28 Sep 2007 23:49:23 +0800 Subject: Re: [PHP-DB] newbie help Thanks for your reply, which solution would be faster and not put too much load

RE: [PHP-DB] newbie help

2007-10-01 Thread Daevid Vincent
This may be overkill for what you're doing, but based upon your layout, you might consider a nested set. Since you're a newb, it may be too complex to code: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html This is how you setup products and categories for example I think your

Re: [PHP-DB] newbie help

2007-09-29 Thread Bob Chatman
data do you need to store for whatever your webapp does? -TG - Original Message - From: nhadie [EMAIL PROTECTED] To: php-db@lists.php.net Date: Fri, 28 Sep 2007 23:49:23 +0800 Subject: Re: [PHP-DB] newbie help Thanks for your reply, which solution would be faster and not put too

Re: [PHP-DB] newbie help

2007-09-29 Thread TG
. Always willing to learn new things if they are, indeed, better. -TG - Original Message - From: Bob Chatman [EMAIL PROTECTED] To: TG [EMAIL PROTECTED] Cc: nhadie [EMAIL PROTECTED], php-db@lists.php.net Date: Fri, 28 Sep 2007 23:23:41 -0700 Subject: Re: [PHP-DB] newbie help

Re: [PHP-DB] newbie help

2007-09-28 Thread nhadie
Thanks for your reply, which solution would be faster and not put too much load on the resources of the server? single or multiple database? If i use a single database, would i be having same tables for each customer, e.g. if i have customerinfo table for customers of A, would i also have

Re: [PHP-DB] newbie help

2007-09-28 Thread TG
storing for your customers and your customer's customers? And what other data do you need to store for whatever your webapp does? -TG - Original Message - From: nhadie [EMAIL PROTECTED] To: php-db@lists.php.net Date: Fri, 28 Sep 2007 23:49:23 +0800 Subject: Re: [PHP-DB] newbie help

RE: [PHP-DB] Newbie help

2003-09-06 Thread Rich Hutchins
http://www.php.net/manual/en/install.windows.php -Original Message- From: Nicola Hartland [mailto:[EMAIL PROTECTED] Sent: Saturday, September 06, 2003 4:29 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Newbie help I need some help to install and configure php I have tried downloading it a

RE: [PHP-DB] Newbie Help: Searching

2001-09-05 Thread Beau Lebens
have a form with something like input type=text name=TechContact value= then submit it to a page that might do something like $Query = SELECT * FROM enet WHERE TechContact LIKE '%$TechContact%' AND AdminContact LIKE '%'; which will locate anything CONTAINING what the user enters in the text

Re: [PHP-DB] newbie help

2001-03-25 Thread CC Zona
In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Matt Coyne) wrote: I have been trying to detect if the variable holds any value and then building a query by concatenating like this: if(!empty($foo)) { ... } $result=@mysql_query($concatsql, $connection) or die ("bugger...!");

Re: [PHP-DB] newbie help

2001-03-25 Thread Dean Bennett
It looks like your checks are reversed, and you end up with 2 ANDs between the sex and height clauses. Like someone else pointed out, it is very helpful to echo the generated query so you can see what you've got. A simpler solution, assuming that both fields are optional: $sql = "SELECT ref,

Re: [PHP-DB] newbie help

2001-03-25 Thread Matt Coyne
: : :t h r e e z e r o From: CC Zona [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Sun, 25 Mar 2001 10:39:23 -0800 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] newbie help In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Matt Coyne) wrote: I have been