February 2009

February 27, 2009

How can I check if my Hosting company is running MySQL MyISAM or InnoDB?

mysql
Uncle Rico asked:


Is it possible that they are using neither?

I’d like to know how I can check for myself what kind of database engine is being used.

Filed under Programming & Design by administrator

Permalink Print 3 Comments

PHP MySQL

SullivanSoftware posted video:


PHP MySQL data entry applications FREE

Filed under Howto by administrator

Permalink Print 2 Comments

February 25, 2009

How can i learn MySQL without a server setup?

mysql
Scottie”T” asked:


If i just have my stand alone computer, how can i practice using MySQL and viewing the web pages?

Filed under Programming & Design by administrator

Permalink Print 4 Comments

How do I export excel into mysql database?

mysql
ken asked:


Is there a program that will convert any excel spreadsheet into mysql. I don’t want a program that has to connect to the database from my computer, but more like a converter that will change the data of the spreadsheet to text like: “INSERT INTO `table` VALUES (”") etc…” Any ideas? thanks.
My website host does not allow remote connection to their databases.

Filed under Software by administrator

Permalink Print 3 Comments

February 20, 2009

How do I add a table row after counting mysql data with php?

mysql
project96gsr asked:


After I do a mysql_num_rows to count the database how would I echo a
at the start of the count and a

at the end of the count? I have something like this but it doesn’t seem to work:

if ($count_gallery == 0) {
echo ‘
‘;
}

echo “ $gallery

“;

if ($count_gallery == 3) {
echo ‘

‘;
}

Filed under Programming & Design by administrator

Permalink Print 2 Comments

February 18, 2009

How to make secure login script using mysql?

mysql
Googlesteve asked:


I need to make a secure login script containing registration as well. I don’t have any knowledge in mysql so is there any tutorial that will give me detailed step by step instructions to using mysql and making this script?

Filed under Programming & Design by administrator

Permalink Print 1 Comment

How are lie breaks stored in a MySQL database and how do I get rid of them?

mysql
winkelthorp asked:


Normally line breaks in code are “\n” but how are they stored in a MySQL database? I need to take them out so that I can properly display some content. No, I do not mean a “
” I mean a line break in the CODE. Thx in advance!

Filed under Programming & Design by administrator

Permalink Print 1 Comment

February 17, 2009

Aula 1274 banco de dados SQL MySQL - concat

nerineitzke posted video:


Aqui mais de 1.600 vídeo aulas no site www.informaticon.com.br. Desenvolvido pelo professor Neri Aldoir Neitzke, pós-graduado em Desenvolvimento para Web, professor da Universidade Ulbra e proprietário da Informaticon, email
videoaulas@informaticon.com.br 0xx543330-1222 Carazinho-RS Brasil Obs.: No youtube.com, as video aulas não estão nítidas e apenas a metade das vídeo aulas estão aqui. Caso queira, posso enviar um dvd com centenas de vídeo aulas originais com alta
qualidade, e você ainda vai receber todo o código fonte.

Filed under Education by administrator

Permalink Print

February 16, 2009

Out of the two methods below, what’s the fastest way to server a lot of MySQL data on a Linux Server?

mysql
Brooke asked:


What’s easier on a server? What requires less CPU and/or RAM?

Method 1. Having sixty 10 MB MySQL databases with 1 table each?

Method 2. Having one 600 MB MySQL database with sixty 10 MB tables?

Filed under Programming & Design by administrator

Permalink Print 1 Comment

MySQL question - how can users access my database through my website?

mysql
Bert P asked:


My webhost supplies MySQL databases. Once I have stored data in the database, how can I allow others to access said database via my website?

Filed under Programming & Design by administrator

Permalink Print 1 Comment