Well, if the uid is a numeric datatype, you could use:

SELECT COUNT(uid) FROM tracking WHERE uid = $trackuid

If not numeric, you'll have to surround with quotes:

SELECT COUNT(uid) FROM...

I will restrain from lecturing on normalization (http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html). I assume you've probably never heard of it but I'd highly recommend looking...

Count is an aggregate function. It's not going to return anything from the database. It's only going to count the number of records matching your criteria and return the total.

If you have phpmyadmin, you can also upload the csv through it.

You could start off with basic data validation. Pumping all of the fields into the db without checking even one of them? That's just asking for injection.

Also, if you have phpmyadmin, you can just upload the csv instead of writing a script.

I'd guess that it would be http://localhost/phpmyadmin

Post the code and error messages.

SQL injection is an attack on the database. Basically, injectors take an educated guess about your query design and try to manipulate it. Let's take a look at the following login:

$query =...

Michael Kofler wrote a VBA module that will do this. You'll need Excel, Word, or a MS program that can run VBA. Here (http://www.kofler.cc/mysql/mssql2mysql.txt) is the script with commented...

Do you have phpmyadmin? If so, create a table with the appropriate rows, save the excel file as a csv, and import to the table.

Yes, the best way is to just save the image path. You can save the image into the database as a blob but, most say it's a bad idea. Have a read here (http://www.phpriot.com/articles/images-in-mysql)...

Man, I still don't understand what you are asking. If your db is showing up in the phpmyadmin panel and you need to get the source files for the db, check in mysql/data.

Your host should have supplied you an admin panel. Inside should be phpadmin. It is a web application GUI that allows you to make changes to the db. If you don't have phpmyadmin in your console,...

Wow, a big fan of run-on sentences myself. Are you asking about wamp on your local machine? Most versions of wamp come with phpmyadmin installed. Try putting this in the url: ...

Glad to hear

Datetime is in the YYYY-MM-DD HH:MM:SS format so, Friday, August 28, 2015 at 8:00PM would be:
2015-08-28 20:00:00

You could either concatenate all of the values and store them in one field or you could create three fields to store each value separately.

Yes mysqldump will do this. Read more at http://articles.techrepublic.com.com/5100-10878_11-1044663.html

I've done this for an RSS feed. It queries the db, populates variables, and outputs everything as xml. Here (http://www.ibm.com/developerworks/xml/library/x-phprss/index.html#c2) is the link.

Yes, Oracle is a beast and a memory hog. My favorite comparison was made by Charles Phillips, President of Oracle:
"We're both in the transportation business," Mr Phillips said. "We have a 747, and...

Most don't use MySql unless it is coordinated with open source (php or java) scripts/languages. In these cases ODBC is not necessary. If MySql won't work with a .net or coldfusion server, who cares....

You shouldn't compare the two. It's like comparing a school bus (Oracle) to a Corvette (MySql). Oracle can deliver tons of data in a reasonable amount of time consistently. MySql can deliver smaller...

Could be wrong but I think this will require some type of middleware like PHP to communicate between them.