OK, Ive got my site all up - just not working. ahah. I need (I think) the correct code for a connection string to my database etc. I'm using ColdFsuion and Mysql. My code for the connection string is as follows: <CFQUERY NAME="cfGossip" DATASOURCE="mysqlcf_bridgettip" USERNAME="<bridgettip>" PASSWORD="<*******>" > </CFQUERY>...
$result=mysqli_fetch_array(mysqli_query($link, $query)); the IF MAYOR image is not working i guess there is a confilct with the original db call? In addition to email reminders, you can also LEND WITH CONFIDENCE because I have have a VERIFIED ACCOUNT and neigh*borrow will GUARANTEE that I return this item or they will replace it up...
I want my search results to be in order of string position from smallest to greatest. For example, searching for "banana" returns: Babyfood, plums, bananas and rice, strained Bananas, dehydrated, or banana powder Bananas, raw Bread, banana, prepared from recipe, made with margarine CAMPBELL Soup Company, V8 SPLASH Juice Drinks, St...
I have a long mysql queue. I have 1 worker script that processes each queue. but as this worker is running, the database may be updated or get new row inserts. an example worker script get_current_queue = SELECT from queue... while(get_current_queue) { update_current_row_from_queue "processing" //some cpu intensive processing here ...
In the below procedure I want to set title_id into @v_title_id variable so that I can use it in the procedure. Any ideas thanx in advance. I'm using InnoDB engine type. DELIMITER // DROP PROCEDURE IF EXISTS sp_Title_SplitGenres // CREATE PROCEDURE sp_Title_SplitGenres ( p_genre_id INT, p_genre_str VARC...
I want to delete data from a table after a time interval has been passed and fill it with NULL value. I basically want that data to get expired after a certain interval of time. Is there any way to do it using Php. database is in Mysql. Thanks. ...
Hello. This question has been asked many times in many forums but I haven't seen a confident conclusive answer. So I'll try my luck again. I want to know whether and how is it possible to use MySQL as the persistence node (configuration and content) for SharePoint. As of now, I am only interested to know about WSS (I guess same would ...
I have a few classes that perform some MySQL queries and prepared statements. However, I am lost in how to incorporate my PDO object within those classes. For example, I want to do something like this: <?php $dbh = new PDO(...); class Foo extends PDO { public $dbh; public function bar() { $this->dbh->prepare('SELECT...
I am designing a php mysql webapp. In that, a database usage log has to be maintained , which will record 1.User ip 2.Timestamp 3.operation performed(Add,edit or delete) 4.Colmns changed 5.rowid 6.old value 7.new value Please suggest any example scripts. ...
I'm currently working on creating my own blog section.. After brainstorming a little while I realized I'm a little stumped. I'm working with php and mysql (with codeigniter framework). The front blog page would show the top 5 post; this I can easily do. How would I go about creating a navigation that allows you to see the years that ...
I am looking for help in writing a query of retrieving the values from 2 tables in MySQL. The scenario is Table A ID Name Marks =================== 23 John 67 45 Mark 45 12 Ram 87 Table B has the following Structure ID Name Evaluation Marks ============================== 45 Mark 34 78 Chris...
A colleague asked me to explain how indexes (indices?) boost up performance; I tried to do so, but got confused myself. I used the model below for explanation (an error/diagnostics logging database). It consists of three tables: List of business systems, table "System" containing their names List of different types of traces, table "Tr...
hi..i wanted to know if there is a possibility to debug stored procedures in mysql..engine type = InnoDB ...
Which is the best recommended algorithm to use for encrypting passwords in php/mysql ...
Hello, I am new to sql query optimization and i would like to know if there is anyone can suggest a profiling and optimization tool that i can use. I am trying to optimize queries running on mysql. Thanks for any help. ...
Hai guys, I have two tables Incharge and property. My property table has three fields 1stIncharge,2ndIncharge and 3rdIncharge. InchargeId is set as foreign key for all the above fields in the property table.. How to write a select statement that joins both the table.. I ve tried a bit but no result select P.Id,P.Name,P.1stIncharge,P....
Hi, Would ENUM('1','2','3','4','5') be a sensible datatype for a product rating which must be between 1 and 5? Thanks! ...
I store Markdown code in MySQL, and I’m worried about how to convert it back to HTML without transferring it through the WMD control and using massive data transfer. ...
Hi, Is it possible to print out (PHP) all my blog posts + associated comments via one sql query? If so, how? I was thinking in this direction: SELECT p.post_id, p.title, c.comment_body FROM posts p LEFT JOIN comments c ON c.parent_id = p.post_id But this didn't work out as I expected ...
Hi all, I’m looking to get the max discrepancy between two tables per day, per id. I have the following data in a mysql database insert into test.foo values ('2010-01-10', 1, 10); insert into test.foo values ('2010-01-10', 1, 5); insert into test.foo values ('2010-01-10', 2, 10); insert into test.foo values ('2010-01-10', 2, 10); inse...