Re: What's wrong with this mysql statement?
- From: "Niran" <public.niran@xxxxxxxxx>
- To: <programmingblind@xxxxxxxxxxxxx>
- Date: Mon, 18 Aug 2008 09:26:33 +0530
Change it to the following:
$x = 0;
"SELECT name, email, age FROM contacts ORDER BY age DESC LIMIT " . $x . "," .
($x+29)
The $x + 29 should be enclosed in (), that way the adition will be performed
first and then added to the sql string after automaticly converting it to
string.
HTH
Nirandas
Website: http://www.nirandas.com
----- Original Message -----
From: BlueScale
To: programmingblind@xxxxxxxxxxxxx
Sent: Monday, August 18, 2008 9:11 AM
Subject: What's wrong with this mysql statement?
This is a piece of code from a php script I am working on. The mysql
statement keeps giving me an error "not a valid result".
$x = 0;
SELECT name, email, age FROM contacts ORDER BY age DESC LIMIT " . $x . "," .
$x+29
Thanks
BlueScale
Other related posts:
