correct file order in DnS gallery
$30-80 USD
$30-80 USD
Paid on delivery
Task - correct file sorting in gallery system. We have a wrong order here <[login to view URL]>
Wrong: 1 10 11 12 13 14 2 3 ... 8 9.jpg. This is the order we want: 1 2 3 4 ... 9 10 11 [login to view URL] ...
We need to fix a database query in function listAllRecordsInGroupOrdered or write a new function for this script : <[login to view URL]> )
something like:
public function listAllRecordsInGroupOrdered($groupId, $order) {
$sql = "SELECT * from upload WHERE group_id=" . $groupId . " ORDER BY " . $order;
$result = mysql_query ( $sql );
if (! $result) {
throw new Exception ( "database query failed: " . mysql_error () );
}
$num = mysql_numrows ( $result );
$listRecords = array ();
$i = 0;
while ( $i < $num ) {
$rid = mysql_result ( $result, $i, "upload_id" );
$remoteFile = mysql_result ( $result, $i, "remote_file" );
$originalSize = mysql_result ( $result, $i, "original_size" );
$record = new UploadRecord ();
$record->setId ( $rid );
$record->setRemoteFile ( $remoteFile );
$record->setOriginalSize ( $originalSize );
array_push ( $listRecords, $record );
$i ++;
}
Joshua Scott photographer - [[login to view URL]][1]
Project ID: 2784952
About the project
15 proposals
Remote project
Active 11 yrs ago
Looking to make some money?
Benefits of bidding on Freelancer
Set your budget and timeframe
It's free to sign up and bid on jobs
15 freelancers are bidding on average $63 USD for this job
$45 USD in 14 days
5.0 (315 reviews) $51 USD in 14 days
4.9 (343 reviews) $42.50 USD in 14 days
5.0 (71 reviews) $50.15 USD in 14 days
4.9 (139 reviews) $65 USD in 14 days
5.0 (51 reviews) $17 USD in 14 days
5.0 (21 reviews) $50.15 USD in 14 days
5.0 (23 reviews) $255 USD in 14 days
4.5 (31 reviews) $68 USD in 14 days
5.0 (9 reviews) $50.15 USD in 14 days
5.0 (8 reviews) $42.50 USD in 14 days
5.0 (4 reviews) $60.35 USD in 14 days
0.0 (1 review) $50 USD in 14 days
0.0 (0 reviews) $25.50 USD in 14 days
0.0 (0 reviews)