txtSQL

when i use

$sql->select(array('db' => 'test',
'table' => 'testtable',
'order by' => array('id','DESC')));

they having an wrong order

i use txtsql 2.2 final

and i have one question :
about $sql->last_insert_id(); how does it work,
can you show sample tag for me

about my site it's powered by txtsql, my all database is use txtsql
thank for this project.

Remove the space between the words "order and by"

Code: Select all

'order by' => array('id','DESC')));

should be

Code: Select all

'orderby' => array('id', 'DESC')));

as for the last_insert_id() function -- if you have a table with a field that is auto_increment (an "ID" column for example) you can get the value of the latest entry. So say I added two entries to a table with a field "ID" (that was auto_increment) -- when i've added the two entries and try to use the function, it would return the value "2" because it was the LAST ID to be generated.

If you have a website, you should post a link

how to use ,

like this ?

$sql->last_insert_id('testTable','testDB');

yup exactly... and if there are more than two auto_increment fields in a table, you can specify which one to look the index for like this

$sql->last_insert_id('table', 'db', 'column');

thanks alot.

http://www.fashion-products.com [url=http://www.fashion-products.com ]is a sell air force one,
air jordan,bape,kicks,nike,Jerseys,Shoes,Clothing,Bag,Glasses,Caps&Hats,sneakers,sunglasses,
watches,Jewelry,Electronics,NBA,NFL,NHL,MLB[/url]
shoes
clothing
Handbags Wallets
Hat
Sunglasses
Belts
Watches
Jewelry