Phpmyadmin And Php And Mysql tutorial

[farsiscript 0]

hi
i think phpmyadmin is nice script (3rdparti) to learn php and mysql , you can add database and then make tabel with rows and columns then you can customise (search , show rows , show columns , add rows , delete rows) tabel in phpmyadmin
when you are customise phpmyadmin , this script show you php code . you can use this code for browse in database .
for example :

showing tabel :

SELECT * FROM `tabelname` LIMIT 0 , 30

searching :

SELECT `columns` FROM `tabel` LIMIT 0 , 30

you can use with while loop

showing Ascending:

SELECT * FROM `tabelname` ORDER BY `id` ASC LIMIT 0 , 30

Showing Descending :

SELECT * FROM `tabelname` ORDER BY `id` DESC LIMIT 0 , 30

write in tabel :

mysql_query("INSERT INTO tabelname (columns1,columns2) VALUES ('Your text you want to put in columns1','Your text you want to put in columns2')");

[kittycatlover763 0]

nice tutorial :]but this is best put into the tutorial section of the Xisto forums.& advise i give you on improving the understanding of future readers of this tutorial : DON'T FORGET THE NULLS