RE: Need help with mysql prob

> 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

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

> 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

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

> 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

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

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

> 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

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

Need help with mysql prob

Hi guys, I'm having a really terrible problem with my mysql coding and I'ld appreciate any help I can get on this cause it's really driving me crazy. I have two tables and I've succeeded in creating a one to many relationship between both table but the problem I'm having is that I dont know ho

Need help with mysql search engine

Hi, I currently have a table with 2 text fields, both of which are marked as fulltext. I'm using the full-text boolean search method with fairly good results. My problems however are: 1. I am on a shared host provider so I can't tweak the full-text search options such as stop words or minimu

Re: Need Help With MySQL Query

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

Geek" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 15, 2003 10:09 AM Subject: Need Help With MySQL Query > 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 i

Re: Need Help With MySQL Query

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

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

Need Help With MySQL Query

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 to this list Here's my table ($usertableDaily): vanNumber|grossPay -

Re: need help with mysql rpms

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

> >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

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

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

need help with mysql rpms

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 successful install of the new version. Any help would be appreciated rpm -e mysql-3.23.36-1 error:

Re: Need help with mysql

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

"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: "

Need help with mysql

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: "ERROR 2002: Can't connect to MYSQL server through socket /v

Re: Need help with mysql startup problem

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

Need help with mysql startup problem

I just installed RH 7.0 selecting the 'install everything' option. Now when I use safe_mysqld, it starts then ends immediately with the following message in the log. 010310 12:43:30 mysqld started 010310 12:43:30 Can't start server : Bind on unix socket: Permission denied 010310 12:43:30 Do y