RE: Need help with mysql prob

2009-04-20 Thread abdulazeez alugo
> Date: Mon, 20 Apr 2009 13:03:14 +0100 > From: andy-li...@networkmail.eu > To: defati...@hotmail.com > CC: mysql@lists.mysql.com > Subject: Re: Need help with mysql prob > > Hi Alugo, > > abdulazeez alugo wrote: > > > > Hi Andy, > > Thank you ver

Re: Need help with mysql prob

2009-04-20 Thread Andy Shellam
Hi Alugo, abdulazeez alugo wrote: Hi Andy, Thank you very much you have been really very helpful. All those mistakes you pointed at in the script about the apostrophe and others, are simple mistakes I just made in the rush of typing the message; and yes $conn is the result from mysql_connect

RE: Need help with mysql prob

2009-04-20 Thread abdulazeez alugo
> Date: Mon, 20 Apr 2009 08:06:05 +0100 > From: andy-li...@networkmail.eu > To: defati...@hotmail.com > CC: mysql@lists.mysql.com > Subject: Re: Need help with mysql prob > > Hi, > > abdulazeez alugo wrote: > > > >> Date: Sun, 19 Apr 2009 23:19:56

Re: Need help with mysql prob

2009-04-20 Thread Andy Shellam
Hi, abdulazeez alugo wrote: Date: Sun, 19 Apr 2009 23:19:56 +0100 From: andy-li...@networkmail.eu To: defati...@hotmail.com CC: mysql@lists.mysql.com Subject: Re: Need help with mysql prob Hi Alugo, Hi Andy, Thanks for your prompt response. However, since tbl1_id has an

RE: Need help with mysql prob

2009-04-19 Thread abdulazeez alugo
> Date: Sun, 19 Apr 2009 23:19:56 +0100 > From: andy-li...@networkmail.eu > To: defati...@hotmail.com > CC: mysql@lists.mysql.com > Subject: Re: Need help with mysql prob > > Hi Alugo, > > Hi Andy, > > > > Thanks for your prompt response. However, s

Re: Need help with mysql prob

2009-04-19 Thread Tom Nugent
Hi Abdul- you may want to check this thread out regarding the same issue... http://www.webmasterworld.com/php/3565843.htm On Apr 19, 2009, at 3:23 PM, abdulazeez alugo wrote: Hi guys, I'm having a really terrible problem with my mysql coding and I'ld appreciate any help I can get on this

Re: Need help with mysql prob

2009-04-19 Thread Andy Shellam
Hi Alugo, Hi Andy, Thanks for your prompt response. However, since tbl1_id has an auto_increment value in tbl1, mysql is actually generating the values for it automatically. Ah, I see your point. I'm guessing by your code you're using PHP? If so call mysql_insert_id() after you've inser

RE: Need help with mysql prob

2009-04-19 Thread abdulazeez alugo
> Date: Sun, 19 Apr 2009 22:50:20 +0100 > From: andy-li...@networkmail.eu > To: defati...@hotmail.com > CC: mysql@lists.mysql.com > Subject: Re: Need help with mysql prob > > Hi, > > Now I have successfully created a relationship between the two tables but >

Re: Need help with mysql prob

2009-04-19 Thread Andy Shellam
Hi, Now I have successfully created a relationship between the two tables but how do I make sure the value of tbl1_id in tbl1 is equal to the value of tbl1_id in tbl2??? MySQL handles this for you. Simply INSERT the value into tbl1, then INSERT the value of tbl1_id in tbl2. Then try INS

Re: Need Help With MySQL Query

2003-02-16 Thread Michael T. Babcock
Veysel Harun Sahin wrote: select vanNumber, sum(grossPay) from usertableDaily group by vanNumber; The above is the correct query, to save yourself some time. As for your problem: But when I execute I get this: Resource id#3 Resource id#4 This means you're using a resource resp

Re: Need Help With MySQL Query

2003-02-15 Thread Jerry
Are you referencing the result set correctly in php ? How are you dealing with what MySQL returns ? Looks like the info is there, you just not getting it out of the result set. - Jerry @ MetalCat.Net - - Original Message - From: "Guru Geek"

Re: Need Help With MySQL Query

2003-02-15 Thread Simon Windsor
Hi Interesting problem, normally to get a total by type, you would have a query like, select van, sum(pay) from ($usertableDaily) group by van; However you are individually quering each total, your approach is correct, but slower. The problem you have though is the return of Resource i

Re: Need Help With MySQL Query

2003-02-15 Thread Veysel Harun Sahin
select vanNumber, sum(grossPay) from usertableDaily group by vanNumber; [EMAIL PROTECTED] wrote: hello, I've performed searches on this site and php.net to try and figure out why this is occuring. I can't find any instance in my searches that helped me. So, I'm posting my very first question

Re: need help with mysql rpms

2001-12-10 Thread Shankar Unni
Raymond Norton wrote: > error: failed dependencies: > > MySQL conflicts with mysql-3.23.36-1 > > MySQL-server conflicts with mysql-server-3.23.36-1 Yeah, the MySQL rpms are incompatible with the mysql rpms (which are done by RedHat). Apparently the two camps each think the other's file sys

Re: need help with mysql rpms

2001-12-10 Thread Kelly Firkins
> >error: failed dependencies: > > MySQL conflicts with mysql-3.23.36-1 > > MySQL-server conflicts with mysql-server-3.23.36-1 > > >- Original Message - >From: "Kelly Firkins" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Monday, December

Re: need help with mysql rpms

2001-12-10 Thread Raymond Norton
day, December 10, 2001 4:20 PM Subject: Re: need help with mysql rpms > try just upgrading the RPMs using rpm -ivh > > -- > Kelly Firkins > [EMAIL PROTECTED] > > > >I need to remove a previous version of mysql and install the newest. When > >t

Re: need help with mysql rpms

2001-12-10 Thread Kelly Firkins
try just upgrading the RPMs using rpm -ivh -- Kelly Firkins [EMAIL PROTECTED] >I need to remove a previous version of mysql and install the newest. When >trying to remove the previous version it complains about dependencies . I >don't know what to do about it, so I end up with a

Re: Need help with mysql

2001-06-16 Thread Paul DuBois
At 6:23 PM -0400 6/16/01, Malkhaz Mangoshvili wrote: >Hello. I installed on my computer Red Hat Linux 7.0. After that I >started configuring >mysql. I upgraded mysql, added all necessary packages and I wanted >to run mysql server. Are you using RedHat's MySQL RPMs? If so, you should uninstal

Re: Need help with mysql

2001-06-16 Thread Trond Eivind Glomsrød
"Malkhaz Mangoshvili" <[EMAIL PROTECTED]> writes: > Hello. I installed on my computer Red Hat Linux 7.0. After that I started >configuring > mysql. I upgraded mysql, added all necessary packages and I wanted to run mysql >server. > Whenever I type mysql it gives me such an error message: "

Re: Need help with mysql startup problem

2001-03-12 Thread Charles L Hagen
This is a permissions issue. Check the directories mysql is located in and grant executable permissions. Also verify ownership requirements for each of these directories. Charles Hagen On Mon, 12 Mar 2001, Russ Heaton wrote: > > I just installed RH 7.0 selecting the 'install everything' optio