I can currently not use FULLTEXT indexes to search whole words because my server wont allow less characters than 4 in a search string. I need a workaround then from you guys. I want to be able to enter 'bmw 330' and then get results from mysql with whole matches like 'bmw 330'. Should I consider a third party search engine for this? ...
I am creating a search function of my classifieds on my website. Here is some of the criteria I need to meet: When searching for 'bmw 520' only matches where these two words come in exactly this order is returned. not matches for only 'bmw' or only '520'. When searching for 'bmw 330ci' results as the above will be returned, but, WITH A...
I have created two tables in MySQL which are called "birthTable" and "deathTable". When I add a person in deathTable which she/he was in birthTable, I want to delete his/her name and family from birthtable because I add him/her in deathTable. But I don't know how I can do that? ...
Hello, I am working on a project which needs to insert the member birthday's into MySQL database. But i am confused. Actually i am using it like that: int(10) So i change the format e.g. "27/06/1960" to unix time using PHP and use the function date() to show the birthday. Is there any better solution? and is there any good resource you...
The only php page that I see with the code is the index.php, so I replace it with a backup and everyday I see it change to: Parse error: syntax error, unexpected '<' in /nfs/c05/h02/mnt/73056/domains/essinteractive.com/html/index.php on line 93 I am in the process of deleting the site and reinstalling Joomla with all its plugins. Wil...
I'm pulling some data with the WPDB class in Wordpress, however - the data is being retrieved as raw data, without any markup. How can I automatically add this markup? ...
Hi, I'm trying to pass through an adodb connection to a class constructor but in doing so get this error: mysql_error(): supplied argument is not a valid MySQL-Link resource So to put it into context, I have instantiated a new adodb connection like this: // establish database connection $db = ADONewConnection($dsn); if (!$db) die(m...
hi, i would like to know how this can be done. lets say i have this in my database "first" and if i want to update and add the "second" in which i can have this format "first, second". i used this UPDATE table SET number="second" but it removes the "first". i am using php and mysql, thank you ...
hi!! i've two columns in mysql db table votes : accept and reject i want to query only the top result after the accept-reject column values table : votes ================= accept | reject ================= 7 | 9 5 | 1 2 | 15 5 | 1 i want just the positive and top value, here 5-1 = 4 actually, i've lo...
I'd like to accomplish something like the following in a MySQL Create table action date_created datetime NOT NULL DEFAULT CURRENT_DATETIME, date_updated datetime NOT NULL ON UPDATE CURRENT_DATETIME, Once again, this is a MySQL create table action and these are two of the fields in my table. ...
Hi folks, so far in my 10+ years experience with linux, all the permission problems I've ever encountered, have been successfully solved with chmod -R 777 /path/where/the/problem/has/occured (every lie has a grain of truth in it :) This time the trick doesn't work, so I'm turning to you for help. I'm compiling mysql server from scratc...
Hi, I have a basic cms that stores pages in a table in a mysql database - is it possible for me to include PHP in a page and then have PHP process it rather than just output it as-is? ...
$dbhost = "10.21.47.198"; $dbuser = "xxxxx"; $dbpass = "xxxxx"; $dbname = "xxxxxx"; $prefix = "art_"; // you can change this prefix but not necessary $cdomain = $_SERVER['SERVER_NAME']=='xxxxxxxxx' ? '' : ".$_SERVER[xxxxxxxxxxx]"; //.yoursite.com $date_format = "F d, Y"; $admin_email = "[email protected]"; the above code is ...
I have three tables: project (idproject, name) color (idcolor, name) project_has_color (idproject, idcolor) Now I need to select projects connected with set of colors, for example: blue (1), red (2), green (3): SELECT p.idproject, p.name FROM project p, project_has_color c WHERE p.idproject=c.idproject AND c.idcolor IN (1,2,3) gi...
Hello All, Using the wysiwyg CKEditor I stored the following into MySql: <p> Here is the information that we would like to have show</p> <p> </p> <p> Project:<?php echo $project; ?></p> I need to echo this content as $content and have the $project variable populate from _POST data. When I do this however the result looks l...
I've been looking into non-blocking servers for python (tornado, twisted etc) but a lot of the benefits seems to be lost if there's no non-blocking connection to the database. Does anyone know if there are any projects that take care of this? (by non-blocking a la node.js) Edit: Clarified my question ...
Are these functions the same? If not, what is an appropriate php equivalent to mysql's radians() ...
How do I get the array to increment to the next row? I am making a table of labels 3 wide and ten high. The result that I am getting is three repeats in each row. How can I bump to the next row for each table cell. $i =0; for ($i = 1; $i <= 3; ++$i){ while($row = mysql_fetch_array($result)){ $company = $row['company']; $comp_strt = $r...
Is there a way/tool/technique to calculate the processor and memory cost of a specific MySQL query? ...
Does index on a varchar column make the query run slower? I can make that be int. and I don't need to do the LIKE % comparison. ...