Be careful when using this words as mysql table name. If you want to use anyway, don’t forget to add DATABASE.columnname in your sql command for example if you have a table with named desc, here is insert query; insert into USER(user.desc) values(‘example’) Otherwise you’ll get something like that … mysql syntax error near unexpected … Read more
mysql_insert_id() is a very usefull function.. what does it do ? it returns id generated from previous insert query. Could you give some example ? mysql_query(“insert into product (name) values(aflower)”); if you want to print id of “aflower” you can use mysql_insert_id echo mysql_insert_id(); !: to use mysql_insert_id your cloumn should be an auto_increment cloumn
On ubuntu and kubuntu systems you can install php5 apache2 mysql and phpmyadmin with this command sudo apt-get install apache2 php5 php5-mysql php5-gd mysql-server phpmyadmin To enable mod_rewrite run this: sudo ln -sfn /etc/apache2/mods-available/rewrite.load /etc/apache2/mods-enabled/ sudo /etc/init.d/apache2 restart
Q. How do I change MySQL root password under Linux, FreeBSD, OpenBSD and UNIX like operating system over ssh / telnet session? A. Setting up mysql password is one of the essential tasks. root user is MySQL admin account. Please note that Linux / UNIX login root account for your operating system and MySQL root … Read more
Follow by feedburner
Copyright © 2010 All rights reserved.
Designed by 
