Re: [PHP] MySQL Newbie

irish -- www.girishnath.co.uk - Original Message - From: "Ben Clumeck" <[EMAIL PROTECTED]> To: "Girish Nath" <[EMAIL PROTECTED]> Sent: Tuesday, January 29, 2002 1:51 AM Subject: RE: [PHP] MySQL Newbie I am under the understanding that anyone who has shel

Re: update index ...

Hi The indexes are updated when you insert data, you don't need to update it manually. However, you may want to find out about the 'optimize' function out of interest. http://www.mysql.com/doc/O/P/OPTIMIZE_TABLE.html Regards Girish - Original Message - From: "Chuck Lidderdale" <[EMA

Re: Changing Ports

Hi If you want to change port from eg 3306 to 3308 then edit the [mysqld] section in the my.ini file in \winnt to : [mysqld] port=3308 Save the file, then restart the service. To check if the port opened succesfully do "netstat -a" in the command prompt. If that doesn't work, then email me ba

Re: mySQL : 3 or 4?

get used to it :) Regards Girish - Original Message - From: "John Snippe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 05, 2002 8:36 PM Subject: Re: mySQL : 3 or 4? > On 1/5/02, regarding" Re: mySQL : 3 or 4? ", Girish Nath wrot

Re: mySQL : 3 or 4?

Hi If i were in your position i would use 3.23.x mainly because that's what the majority of hosting facilities use as their platform right now. It's a pain to develop something with all the latest and greatest features then realise you have to deploy your app on something not so upto date, if you

When were user variables introduced ?

Hi I'm trying to use user variables such as @myvar within a query which I've got running perfectly on a 3.23.35a server , however, i can't get the same query to run on 3.22.32 server :( Does anyone know if 3.22.32 supports user variables ? Thanks Girish -

Re: [PHP] mysql_query() problem

Hi Try the following to find out what's happening : $result = mysql_query($query,$conn) or die (mysql_error()); Or try echo'ing $result to see what it contains. It should contain something like this if everything is working fine : Resource id #2 Regards Girish - Original Message -

Shopping project with quantity/customer discounts

Hi I'll be working on a shopping site project which involves a complex pricing model with discounts by product quantity threshold, product range as well as customer specific pricing. Has anyone got experience of this or point me in the right direction/articles regarding the database layout and t

Re: Order By number of rows returned ?

dR [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 14, 2001 11:25 AM > To: Girish Nath > Cc: Johnny Withers; [EMAIL PROTECTED] > Subject: Re: Order By number of rows returned ? > > > > Create temporary files instead, in that case you don't have to worry > about D

Re: Order By number of rows returned ?

Hi Thanks for that, it works really well :) Best Regards Girish - Original Message - From: "Johnny Withers" <[EMAIL PROTECTED]> To: "'Girish Nath'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, December 14, 2001 3:03

Order By number of rows returned ?

Hi I'm trying to do some sorting by relevance on a query. Essentially, i'd like to know if there is way to order the results by number of rows returned or if this is the best i can get and do the rest within PHP? mysql> SELECT web_account, code_short FROM lookup WHERE code_short IN ('U', 'S', 'G