This question is intended to be open ended, and references to online or published manuals are very welcome. What are the best practices for MySQL documentation?
In other words, if I crea...
I have a set of checkboxes (see screenshot) which provide the user with the ability to set the visibility of the related document in a listing elsewhere on the site. I have reviewed a number o...
I'm getting two errors on my phpmyadmin page.
The first error says "The additional features for working with linked tables have been deactivated". I attatched a screen capture of what I get...
Hello all,
I've successfully setup AppServ on Windows 7 RC, enabled php_mssql extension, updated ntwdblib.dll, and wrote code to connect to an mssql database. If I run my code in a command ...
Warning: odbc_connect() [function.odbc-connect]: SQL error: Specified driver could not be loaded due to system error 1114 (Oracle in OraClient10g_home1)., SQL state IM003 in SQLConnect in C:\I...
The coding below is to allow members of my site the oppertunity to upload 12 pictures to thier profile. It did work well, for the first few days, now it's telling every member that they have r...
Hi There,
I found code that will upload files to a spcified directory. I'm passing a session variable to the script but it does not create the folder. How can I create the folder if it does...
What is the difference between Primary, Unique, Foreign and Index keys? When would I want to use each one? What are the advantages of using one over another?
I have seen question 23675343 which deals with the insertion of multiple checkbox values and I am looking to do a similar thing but updating rows rather than inserting them. To do this I need ...
I have small images of state maps that I want to display whenever a user selects the state from a dropdown on my site. I am thinking of storing the images in the MySQL DB that I use to drive t...
Getting the error message of:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
Line number 52 is what it's referring to. Thoughts?
I have a busy application with many new inserts going into the data base and it is growing to the point that I perceive an increasing risk of concurrent inserts. For a variety of reasons, I h...
I have a page on which I can make selections and display the values of those selection (selected checkboxes).
For example, on the page I have checkboxes 1 till 6, and 2, 4, 5 are checked, t...
I have been trying to figure it out how to read from and write to a .dbf table created with FoxPro using PHP. The problem is that "dbase" library does read dbf tables but only those of type dB...
Problem: A PHP/MySQL-driven website basically runs on mobile devices, but session variables don't.
In adapting my educational site for students to access from cell phones, I find that sessi...
I am trying to import sample data into Magento using .sql file and PHP My admin. However, I keep getting this error mesage.
Error
SQL query:
ALTER TABLE `admin_rule` ADD CONSTRAINT `F...
I found some code to get colum headers from a MySQL table using PHP, which I like because it was short and neat:
for($i = 0; $i< mysql_num_fields($res)-1; $i++) {
print '<th>' . mysql_fiel...
I've got a form built in Dreamweaver CS3 that is supposed to post to a database when it's submitted. Ive used dreamweaver's Insert Record server behavior and found this to work quite well. T...
The problem is as following. I'd like to reduce size of picture and save reduce sized picture into mysql. The code is as shown below. The problem is that imagejpg function can only save reduce...
I have a font family select box drop down list - in the admin of a Wordpress plugin - where people can choose a font family. The font family choice is neatly injected as CSS into the website u...
I have some large csv files that I am importing into a mysql database table and there are two columns for latitude and longitude.
After looking at the data, There is a missing decimal point...
Hello,
Looking for any ideas on what would be the best solution for this issue.
I have a pretty huge xsd file which describes the data and its structure.
I need to be able to create an ...
What's the most efficient way to convert an xml file that is nearly 800MB into utf-8 encoding. I assume the file must be opened, encoded, then saved. In saving the file could the white space b...
hello,
We need to make contact list grabber in order to send invitations from users of our website. I found some of Facebook, gmail, msn, myspace etc. list grabbers but only msn grabber is ...
I've been working to understand MySQL injection. I've been told that when you "query" the database, you need to make sure all user information is properly filtered.
Of all of the examples I...
