I am using following code to connect to MySql Db but it gives error. please help me "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified " string ConnStr = @"Driver={MySQL ODBC 3.51 Driver};" + "Server=192.168.100.10/phpmyadmin/;Database=piggylock;uid=root;pwd=htroot...
How do I store an uploaded swf file in a mysql database using php? basic coding plz ...
I need to create a PHP class that would send e-mails to all members of the website. Simple mysql_fetch_array and loop doesn't fit because my client wants a class and I actually don't know much about classes and what he exactly wants. Can you explain or give me any hints? ...
Hi all, I was thinking of using TIMESTAMP to store the date+time, but I read that there is a limitation of year 2038 on it. Instead of asking my question in bulk, I preferred to break it up into small parts so that it is easy for novice users to understand as well. So my question(s): What exactly is the Year 2038 problem? Why does it o...
i want to display my images which are located in a mysql database in a browser using php , myadmin // exactly i am talking about wampserver/ now ho do i retrieve images from database in a browser using php ...
List the differences between the following MySql commands. drop table tablename; truncate table tablename; delete from tablename where 1; Also from your experiences please tell me typical usage scenario for each. ...
I use MAMP for PHP/MySQL. What do I need for RoR? I am using OS X Leopard. I have already installed Ruby, Gems and Rails. ...
I'm using: MySqlCommand comHash = new MySqlCommand("MY_FUNCTION", con); comHash.CommandType = CommandType.StoredProcedure; // ?? comHash.Parameters.AddWithValue("my_parameter", "value1"); comHash.???? I need return the value from function. ...
Is there a way to select entries from fulltext index in MySQL? ...
The code: $msr = db_query("SELECT * FROM users WHERE username='$username'"); if (db_num_rows($msr) == 0) return null; When function db_query($query) { return mysql_query($query) or die(mysql_error() . " when querying: $query"); } function db_num_rows($queres) { return mysql_num_rows($queres) or die(mysql_error()); } Shows...
When I do a print_r, I get a number 1 between the array blocks. I have no idea where it is coming from. This is causing errors in my log. I can fix this by testing with is_array but I want to know where this is coming from. I'm making two queries but yet I have a third array in there. What is going on????? mysqli_result Object ( [...
Is there any way to get mysql queries to not take any locks on myisam tables? My problem seems to be that my Sphinx Search indexer takes a lock on one of my myisam tables for over 60s which seem to make update statements wait on the locks to be released which in turn makes other queries wait for the update statements to complete. The i...
Is it possible to put GROUP_CONCAT in a MYSQL WHERE clause? I have two tables (one for members and one for payment info). For example Members Table num, memNumber, fullName, coporateName, surname 001, mem0010, Joe Bloggs, NULL, Bloggs 002, mem0015, NULL, BBC 003, mem0017, John Peters, NULL 004, mem0101, Emma Jane, NULL Payment Tabl...
I know there's got to be a way to do this, but for the life of me I can't figure it out: I have 3 tables I want to join together (simplified to illustrate): users uid mail 1 [email protected] 2 [email protected] 3 [email protected] profile_fields fid name label 1 full_name Full Name 2 phone Phone profile_values uid fid value 1 1 ...
I have several procedures on this machine and this is the only query that is giving me a boolean value (at least I think it is a boolean value) in my PHP code. When I substitute this procedure with another one, this value goes away. Is there a problem with this code the way I have it? CREATE DEFINER=`root`@`%` PROCEDURE `phoneIsRegister...
Hi - I am attempting to delete all rows in two dependent tables based on a third tables ID. Table structure: Transaction -Transaction_ID (primary) -Timestamp Purchase -Item_ID -Transaction_ID -Purchase_ID (primary) Item -Item_ID (primary) -Client_ID I would like to delete all rows from transaction/purchase that match the Client_ID...
Does anyone know how rightmove.co.uk is made? What technologies, databases, programming languages are they using? PHP? Ruby? Python? I can see that it is using Apache. I would really love to know what database they use. Thank you in advance ;-) ...
We're trying to rename a column in MySQL (5.1.31, InnoDB) that is a foreign key to another table. At first, we tried to use Django-South, but came up against a known issue: http://south.aeracode.org/ticket/243 OperationalError: (1025, "Error on rename of './xxx/#sql-bf_4d' to './xxx/cave_event' (errno: 150)") AND Error on ren...
Hey, I'm having the exact issue as described in this question: http://stackoverflow.com/questions/354194/mysql-installation-troubles. Unfortunately none of the answers helped me (and it's closed). I try to learn Ruby on Rails and don't get MySQL working (so it is programming related). I typed: rake db:create and got: !!!The bundled m...
Hi, I have two tables table1 = records, table2 = duplicates. Both tables contain a variable number of columns at any given time and they both contain the exact same columns with the exception of table2 having and additional "ID" column... Both tables contain a column, "user_id". The data comes from a CSV import. If the "user_id" alread...