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
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
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'
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
Hi All,
I have a database of MP3's in mysql. The database contains MP3 name, artist,
date, size etc. I need to order the search results in both ascending and
descending order. For example if user wants to see the size of all mp3's in
ASC order he will click on size column and again if he wants to
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
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
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
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
--
PHP Database Mailing List (http://ww
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
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
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
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
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
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
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
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());
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
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'
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
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
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/
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
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/mysql.sock' (13) in
/va
Hello, all. I'm having a problem with a php/mysql app which is
probably in the SQL, so please don't get angry at me. Basically, I
have a CASE statement that works on my localhost, but doesn't seem to
get recognised on the production server (i'm running php/mysql 5.x on
my localhost, 4.x of both
Hi,
I'm running MySQL 5 on a Win2K3 machine (2x3.2Ghz 4Gb RAM)
Lately I experience some heavy login problems, "Can't connect to MySQL
server on 'localhost' (10048)" and Service error "ERROR: 10060 - A
connection attempt failed because the connected party did not properly
respond after a period
(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
MMAND = './configure' '--with-mysql'
'--with-apxs2=/usr/sbin/apxs2' '--with-zlib' '--with-xsl' '--with-imap-ssl'
Dude, I need to update!
-Jeff
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tue
I know this is probably the noobiest of questions but please help.
Fatal error: Call to undefined function mysql_connect() in
.. on line 112
This occurs when I try to access a MySQL application, specifically Invision
Power Boards.
I have PHP5 installed on my Apache 1.3.31, and I believe that m
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
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
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
> 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
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
Hello All,
This may be a bit off topic. If so, my apololgies.
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 t
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
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
Equipe Pratic Sistemas
Rodrigo Corrêa
Fone: (
The code below is my first attempt at a multiple SELECT. Is there a better way?
Thanks
Ken Brill
[EMAIL PROTECTED]
function TotalCountSongs($channel) {
// create a temp table to fill
a.. $sql = "CREATE TAB
>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
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 a inner
40 matches
Mail list logo