Re: [PHP-DB] Help with mysql data sorting using php

2010-05-17 Thread kesavan trichy rengarajan
take a look at this: http://datatables.net/examples/data_sources/server_side.html On Mon, May 17, 2010 at 5:30 PM, nagendra prasad wrote: > Hi Artur, > > I am a beginner to this stuff. So, If you or anyone can give me some > example > codes or may be some links for my reference that would be a gr

Re: [PHP-DB] Help with mysql data sorting using php

2010-05-17 Thread nagendra prasad
Hi Artur, I am a beginner to this stuff. So, If you or anyone can give me some example codes or may be some links for my reference that would be a great help. Best, Guru. On Mon, May 17, 2010 at 12:57 PM, Artur Ejsmont wrote: > Hehe. Then a method: ) just make a query builder method like 'findS

Re: [PHP-DB] Help with mysql data sorting using php

2010-05-17 Thread Artur Ejsmont
Hehe. Then a method: ) just make a query builder method like 'findSongs' with all the params ( optional or mandatory ) like page, limit, sortby, filters etc. then inside build SQL based on args. Just be careful - SQL injection is your enemy here. From app pass all the args from get/ post and that'

Re: [PHP-DB] Help with mysql data sorting using php

2010-05-17 Thread nagendra prasad
DB is like more then 500MB and it will grow day by day :) On Mon, May 17, 2010 at 12:46 PM, Artur Ejsmont wrote: > If the DB is very small use tablesorter plugin of jquery. Otherwise > custumizable query method. > > On 17 May 2010 07:56, "nagendra prasad" wrote: > > Hi All, > > I have a datab

Re: [PHP-DB] Help with MySql float

2008-02-17 Thread Chris
Daniel Brown wrote: On Feb 17, 2008 10:59 AM, Velen <[EMAIL PROTECTED]> wrote: Hi Guys, When inserting a value like 123567.8956 in my table it is rounding it to 2 decimal place. The field type is set as float. Can anyone tell me why it's not taking all the decimals? and How to insert the numb

Re: [PHP-DB] Help with MySql float

2008-02-17 Thread Daniel Brown
On Feb 17, 2008 10:59 AM, Velen <[EMAIL PROTECTED]> wrote: > Hi Guys, > > When inserting a value like 123567.8956 in my table it is rounding it to 2 > decimal place. The field type is set as float. > > Can anyone tell me why it's not taking all the decimals? and How to insert > the number with all

Re: [PHP-DB] Help with MySql float

2008-02-17 Thread Tobias Franzén
Velen wrote: Hi Guys, When inserting a value like 123567.8956 in my table it is rounding it to 2 decimal place. The field type is set as float. Can anyone tell me why it's not taking all the decimals? and How to insert the number with all the decimals? Thanks Velen Hello Velen, Your qu

Re: [PHP-DB] help with mysql connect error

2007-02-11 Thread Chris
Tim McGeary wrote: Chris wrote: Tim McGeary wrote: Stut wrote: Ok, so I did the recommended process of: mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') -> WHERE Host = 'some_host' AND User = 'some_user'; mysql> FLUSH PRIVILEGES; This allows the CLI script to run successf

Re: [PHP-DB] help with mysql connect error

2007-02-09 Thread Tim McGeary
Chris wrote: Tim McGeary wrote: Stut wrote: Ok, so I did the recommended process of: mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') -> WHERE Host = 'some_host' AND User = 'some_user'; mysql> FLUSH PRIVILEGES; This allows the CLI script to run successfully, but the web ph

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Chris
Tim McGeary wrote: Stut wrote: Tim McGeary wrote: But I do have a MySQL 5 client: [EMAIL PROTECTED] html]# rpm -qa MySQL* MySQL-shared-compat-5.0.27-0.rhel3 MySQL-client-standard-5.0.27-0.rhel3 MySQL-python-0.9.1-6 MySQL-server-standard-5.0.27-0.rhel3 MySQL-devel-standard-5.0.27-0.rhel3 or ar

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: But I do have a MySQL 5 client: [EMAIL PROTECTED] html]# rpm -qa MySQL* MySQL-shared-compat-5.0.27-0.rhel3 MySQL-client-standard-5.0.27-0.rhel3 MySQL-python-0.9.1-6 MySQL-server-standard-5.0.27-0.rhel3 MySQL-devel-standard-5.0.27-0.rhel3 or are you saying that th

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Stut
Tim McGeary wrote: Thank you for the link. I think that's probably the best way to go in this case, since it's only on a dev/test server. When I build the production server, I should probably upgrade to PHP5 anyhow. I assume that should not have this problem, right? It might. PHP5 can be b

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: But I do have a MySQL 5 client: [EMAIL PROTECTED] html]# rpm -qa MySQL* MySQL-shared-compat-5.0.27-0.rhel3 MySQL-client-standard-5.0.27-0.rhel3 MySQL-python-0.9.1-6 MySQL-server-standard-5.0.27-0.rhel3 MySQL-devel-standard-5.0.27-0.rhel3 or are you saying that th

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Stut
Tim McGeary wrote: But I do have a MySQL 5 client: [EMAIL PROTECTED] html]# rpm -qa MySQL* MySQL-shared-compat-5.0.27-0.rhel3 MySQL-client-standard-5.0.27-0.rhel3 MySQL-python-0.9.1-6 MySQL-server-standard-5.0.27-0.rhel3 MySQL-devel-standard-5.0.27-0.rhel3 or are you saying that the PHP libs ha

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: Oh, duh! Ok. I wrote this: mysql_connect($hostname, $username, $password) or die(mysql_error()); mysql_select_db($dbname) or die(mysql_error()); $result = mysql_query("SELECT * FROM Requestor_type") or die(mysql_error());

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Stut
Tim McGeary wrote: Oh, duh! Ok. I wrote this: mysql_connect($hostname, $username, $password) or die(mysql_error()); mysql_select_db($dbname) or die(mysql_error()); $result = mysql_query("SELECT * FROM Requestor_type") or die(mysql_error()); while($row = my

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: Tim McGeary wrote: Stut wrote: Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web page I am building: Warning: mysql_connect(): Can'

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Stut
Tim McGeary wrote: Please include the list in replies. Sorry, I meant to, but hit the wrong button. Tim McGeary wrote: Stut wrote: Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following er

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Please include the list in replies. Sorry, I meant to, but hit the wrong button. Tim McGeary wrote: Stut wrote: Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Tim McGeary
Stut wrote: Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web page I am building: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/

Re: [PHP-DB] help with mysql connect error

2007-02-08 Thread Stut
Tim McGeary wrote: I am new to this list today, so if I should be sending this to another specific PHP list, please let me know. I am getting the following error via the PHP web page I am building: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mys

Re: [PHP-DB] help with mySQL- Fatal error: Call to undefined function mysql_connect()...

2004-08-17 Thread Jeffrey Moss
(http://www.macromedia.com/devnet/mx/dreamweaver/articles/php_iis.html) -Jeff - Original Message - From: "Jeffrey Moss" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 17, 2004 12:08 PM Subject: Re: [PHP-DB] help with mySQL- Fatal error: Call to undef

Re: [PHP-DB] help with mySQL- Fatal error: Call to undefined function mysql_connect()...

2004-08-17 Thread Jeffrey Moss
Gotta recompile php with the --with-mysql option (or something like that). Try running configure --help You can see what options you compiled with by grepping for CONFIGURE in your Makefile. Here's what I got: [EMAIL PROTECTED] php-5.0.0b4 # grep CONFIGURE Makefile CONFIGURE_COMMAND = './configu

RE: [PHP-DB] Help with MySQL Logic

2003-03-04 Thread Rankin, Randy
3 10:30 AM > To: Rankin, Randy; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Help with MySQL Logic > > > A client of mine, a rail car storage company, has asked that I create a > > PHP/MySQL application in which they will maintain and track rail cars. I > am > > havin

RE: [PHP-DB] Help with MySQL Logic

2003-03-03 Thread Hutchins, Richard
andy Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Help with MySQL Logic Heh. Sounds like a programming class homework project. I would say through the clever use of where clauses's, like: UPDATE position SET posistion = (position-1) WHERE position > $idremoved; Would work, assuming $idr

Re: [PHP-DB] Help with MySQL Logic

2003-03-03 Thread bbonkosk
What about two tables, one would have this: carID carCompany carPayload etc... the second this: position carID This table would be static and if a car was not present in certain conditions they would contain (-1) for the carID. Then finding an empty slot to place an incoming car should be doab

Re: [PHP-DB] Help with MySQL Logic

2003-03-03 Thread 1LT John W. Holmes
> A client of mine, a rail car storage company, has asked that I create a > PHP/MySQL application in which they will maintain and track rail cars. I am > having a bit of trouble however working through one of thier requirements. > They need to know in what position the rail car is on each track. Fo

Re: [PHP-DB] Help with MySQL Logic

2003-03-03 Thread Adam Voigt
Heh. Sounds like a programming class homework project. I would say through the clever use of where clauses's, like: UPDATE position SET posistion = (position-1) WHERE position > $idremoved; Would work, assuming $idremoved containted the position of the car removed. On Mon, 2003-03-03

Re: [PHP-DB] Help with MySQL

2003-01-19 Thread leo g. divinagracia iii
Rodrigo Corrêa wrote: I´m new with MySQL, i´m just wondering if there is a way to get the IP from a MySQL Server, since i acess this by localhost in the webserver even if you could, the MYSQL admin probably set your account to access your data with a LOCALHOST permission only... so if you

Re: [PHP-DB] Help with mysql and php 4.03

2001-05-09 Thread Bob Hall
>Hi I'm trying to put up some php files I have created that is working >normaly at php local server with php 4.04 and mysql 3.23.36 > >but it won¥t work at the servr where the client will have it >with php 4.03 and mysql 3.22.32 > >the thing that won¥t work is when I got a sql query that contains