query works in mysql(phpmyadmin) but not in php

[Tinus]

Hi

This query works in mysql

SELECT id
FROM FILE WHERE created = (
SELECT max( created )
FROM FILE ) 

But not in php

tried

$getid= " SELECT id FROM file WHERE created = (SELECT max(created) FROM file) ";

and

$getid= " SELECT 'id' FROM 'file' WHERE 'created' = (SELECT max('created') FROM 'file') "

;

but it does not work.

please help.

[zorgi]

Since it works in phpmyadmin I can only assume its your PHP that creates the problem. Can you show us PHP code that handles the query. BTW you could also try

SELECT id FROM file ORDER BY created DESC LIMIT 1

[Tinus]

$getid= "SELECT 'id' FROM 'file' ORDER BY 'created' DESC LIMIT 1 ";

is giving
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT 'id' FROM 'file' ORDER BY 'created' DESC LIMIT 1' at line 3

PHP

// Create the SQL query 
        $query = " INSERT INTO `file` (`name`, `mime`,`size`,`data`,`created` ) 
                     VALUES ('{$name}','{$mime}',{$size},'{$data}',NOW())"; 
        $result = $dbLink->query($query); 
        $getid= "SELECT 'id' FROM 'file' ORDER BY 'created' DESC LIMIT 1 ";
        $theid=$dbLink->query($getid);

[zorgi]

An identifier may be quoted or unquoted. If you are quoting identifier than use backtick (“`”) not single quotes.

[Tinus]

Still getting
Success! Your file was successfully added!Error! Query failed:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `id` FROM file ORDER BY created DESC LIMIT 1' at line 3

query sqlq is no good. File 'C:\Documents and Settings\Administrator\My Documents\Downloads\shares.txt' not found (Errcode: 2)

With

$getid= "SELECT `id` FROM file ORDER BY created DESC LIMIT 1 ";
        $theid=$dbLink->query($getid);

and

$getid= "SELECT `id` FROM `file` ORDER BY `created` DESC LIMIT 1 ";