Posts Tagged ‘mysql table’

If I try to select the index column in a mysql table using php, I get the following error:

"mysql_fetch_array() expects parameter 1 to be resource, boolean given in"

Is it not possible to fetch the index value?

instead of an input box i would rather want a drop down list and it contains items from the mysql table it is connected from

Hi,
I have a MySQL table on my website that automatically updates once an item drops in my TF2 server and it then clears the data after a month. I was wondering if there is a way I can get it to export the data automatically to an Excel document before all data is wiped?

How do I export a MySQL table from Yahoo Web Hosting without phpMyAdmin? The table I’m dealing with is too large, so I get an apache timeout when I try to export via phpMyAdmin.

I have a mysql table with more than 30,000 rows. There is a field that contains URLs. I want to check the validity of these URLs and remove that are no more existing. Can someone give me an sql command or php script to do this?

Right now as a workaround I’ve literally made a table of questions with questionID as primary key, nextQuestion and prevQuestion pointing to other questionIDs. Basically I’ve made a two way linked list from scratch. Is there anything built into MYSQL that implements this?

I’m running MySQL 5.1 and Windows 2008. No problem creating partitions on a single disk…but seems impossible to partition across multiple disks on Windows using MySQL InnoDB setup. Tried manually creating symlinks. Can’t find anything on web. Is it not possible to partition a MySQL table across multiple disks on Windows?

I want to insert a list of names from a text file (or csv), into a mysql table that has more columns . I only want to introduce the names in the second column of the table leaving all other fields default.