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 s
;
Cc: nhadie <[EMAIL PROTECTED]>, php-db@lists.php.net
Date: Fri, 28 Sep 2007 23:23:41 -0700
Subject: Re: [PHP-DB] newbie help
This is definitely not the best advice in the world. The truth is you could
staple your eye lids open and never blink, but it wouldn't be very
beneficial. I h
ibly wrong and give a better solution, please enlighten. 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@li
e server. It'd be the same
> idea when dealing with multiple customers.
>
> Just make sure that the prefix you use for a customer doesn't use
> characters
> that are bad for table names.
>
> What kind of data are you thinking about storing for your customers and
> y
for a customer doesn't use characters
that are bad for table names.
What kind of data are you thinking about 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: nha
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 custo
You could do separate databases if you want. It all depends on how you want
to organize your data (keeping in mind data backup strategies and stuff).
Using separate databases on the same server, you might have another database
for the 'common' data. Any variables you store in the database th
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
d
Probably you are using windows. In the php.ini there is a setting where session files
have to be stored. The default is /tmp
which under windows is relative to the current drive where is php installed. I see
that you changed this parameter. I think that
there is no such directory /Temp on the dr
have a form with something like
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 field
HTH
Beau
// -Original Mes
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Matt Coyne) wrote:
> now does anyone know about getting ages from dates of birth (previous post
> of mine) and also searching by age group when you only have dates of birth
> in the table!!
See the MySQL manual's chapter on date/time functions
co.uk
: : :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]>,
> [EMA
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,
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...!");
14 matches
Mail list logo
