Re: [PHP] MySQL Newbie

-- 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 shell can access my database and view all information

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

Re: mySQL : 3 or 4?

- 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 wrote: Hi If i were in your position i would use 3.23.x mainly because that's

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

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

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

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

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 PM Subject: RE: Order By number of rows returned ? I'm not sure

Re: Order By number of rows returned ?

temporary _fileS_ will create a lot of disk unnecessary disk i/o. depending on how busy your DB is, I would use tables in memory vs. files on disk... just my .02c -CB -Original Message- From: sherzodR [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 11:25 AM To: Girish Nath