Re: i almost hate queires, please help!!!

2002-10-29 Thread Randy Hammons
From: "David Gilmour" <[EMAIL PROTECTED]> To: "Randy Hammons" <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 8:31 PM Subject: Re: i almost hate queires, please help!!! > Randy, > > See below > - Original Message - > From: "Randy Hammons

i almost hate queires, please help!!!

2002-10-28 Thread Randy Hammons
here's my table syntax: create table Projects ( PjID int unsigned auto_increment not null primary key, PjNumber varchar(40) not null, PjName tinytext not null, PjDesc tinytext, PJEcd varchar(30), PJCost varchar(30), LastUpdate char(30) ); create table Managers ( MgrID int unsi

mysql access via php function, hlp with syntax

2002-10-27 Thread Randy Hammons
Can someone please tell me what is wrong with this function? I can't for the life of me see an error. But, for some reason I keep getting the following error: PARSE ERROR: parse error, unexpected $ in "d:\web.root\xx_db\inc\functions1.inc on line 28 function is: function dtb_qry_tbl_dsp($qry,

how do you define a relationship?

2002-10-20 Thread Randy Hammons
I think I've firmed my "theoritical" understanding of relationships enough to be dangerous. Now for the logical parthow do you actually define a relationship in mysql? For instance... table movies columns (movie id(pk) , movie title , year filmed) table directors columns (director id(p

content design / database design help

2002-10-19 Thread Randy Hammons
I'm new and I'm TOTALLY lost! Why am I here? To BEG for help! My office currently keeps track of our projects via an excel spreadsheet. We keep such info as project costing, status, points oif contact, name, description, number, last updated, etc... What I want to do is merge all that info