alternative to sql server 2005
Hi, I got used to the xml support and recursive common table expressions of sql server 2005. I am just wondering whether any free dbs like mysql support these requirements nowadays? Thanks. Christian ...
mysql
mod rewrite, title slugs and htaccess
I have been taken in to provide some SEO guidance on a website which has been running since 2005. My problem is I want to use clean URLs. The code that handles the URL is hidden away in some class file. And with over a few thousand lines of code its a struggle to rewrite it. So I'm think, I have gone through all the products and create...
mysql query performance help
Hi I have a quite large table storing words contained in email messages mysql> explain t_message_words; +----------------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------+------+-----+---------+----------------+ | mwr_key | int(11...
PHP:Wrong Login info does not redirect to the specific page
<?php include 'lib/db_conn.php'; $uid=$_REQUEST['uid']; $pass=$_REQUEST['pass']; if(($uid==NULL && $pass==NULL) ||($uid==NULL) ||($pass==NULL)) { header("location:index.php?msg=Fields can't be left blank.."); } $pass=md5($pass); $sql1="SELECT * FROM `tb_user` WHERE `email`='$uid' AND `pass`='$pass'"; $rs1=mysql_query($sql1) or die (...
How to create a Dynamic Phonebook with Groups functionality
Hi... I want to create an online phone book where user can add as many contact as he want and he must be able to create and divide those contact into groups. For eg. Friends, Family etc. All the groups must be created or deleted by the user. Can anyone help me.. Any good tutorial or a book reference will do. I will be using PHP, MySQL ...
Combining IN and NOT IN in SQL as single result
I apologize for the vague title. I am attempting to write a query that returns an alias column with matching values (resulting from an IN) as well as an alias column with values that do not match (using NOT IN). I want the result set to have: userId | matches | nonmatches. I currently have the following query which returns the matches as...
The entity framework and database agnostic programming, possibilities?
We want to use the Entity Framework (.NET 4.0) to build applications that can deal with Sql Server, MySQL and Oracle. And maybe Sqlite too. It should be easy to switch the db vendor by some setting in a config file. Is this possible? I prefer real life examples! What kind of providers did you use? ...
Convert tax like IRS function to SQL
Trying to convert this tax-like IRS function http://stackoverflow.com/questions/1817920/calculating-revenue-share-at-different-tiers to SQL. The assumption is the table would be one column (price) and the tiers will be added dynamically. My first attempt has some case statements that didn't work out well. I have since scrapped it :) Tha...
NHibernate MySQL Password Function
I am trying to create a custom application that allows for adding and removing and changing passwords of users. How would I create the hash that MySQL uses to stored password in? I know MySQL has a Password() function but I can't figure out how to use this function in NHibernate. Anyone know how to do this? ...
How can I determine if a specified string is in a specific MySQL column? (and also perhaps a tutorial site?)
This is a fairly simple question. Basically, I'm having a program send HardWare ID's to my PHP script as GET data. I need the PHP script check to make sure that HardWare ID is in a specific MySQL column, and if it is, { continue the script, } else { exit(); } Problem is I'm not too good with MySQL and have no idea how to do this. Howeve...
MySQL don't want to store unicode charecter
Why MySQl don't wont to store unicode character ? Yes, it is rare hieroglyph, you wouldn't see it in the browser. UTF16 is U+2B5EE Warning: #1366 Incorrect string value: '\xF0\xAB\x97\xAE' for column 'ch' at row 1 Is it possible to store this character in MySQL? ...
MYSQL count all rows per table for in one query
Is there a way to query the DB to find out how many rows there are in all the tables ie table1 1234 table2 222 table3 7888 Hope you can advise ...
Constant Push of SQL Server data to MySQL
Is there a way I can have a constant update of my SQL Server data going to a MySQL database? ...
MySQL -- How to do this better?
$activeQuery = mysql_query("SELECT count(`status`) AS `active` FROM `assignments` WHERE `user` = $user_id AND `status` = 0"); $active = mysql_fetch_assoc($activeQuery); $failedQuery = mysql_query("SELECT count(`status`) AS `failed` FROM `assignments` WHERE `user` = $user_id AND `status` = 1"); $failed = mysql_fetch_assoc($failedQuery); ...
How can I use cURL to open multiple URLs simultaneously with PHP?
Here is my current code: $SQL = mysql_query("SELECT url FROM urls") or die(mysql_error()); //Query the urls table while($resultSet = mysql_fetch_array($SQL)){ //Put all the urls into one variable // Now for some cURL to run it. $ch = curl_init($resultSet['url']); //load the urls curl_setopt($...
SQL Query Math Gymnastics
I have two tables of concern here: users and race_weeks. User has many race_weeks, and race_week belongs to User. Therefore, user_id is a fk in the race_weeks table. I need to perform some challenging math on fields in the race_weeks table in order to return users with the most all-time points. Here are the fields that we need to m...
MySQL select using datetime, group by date only
Is is possible to select a datetime field from a MySQL table and group by the date only? I'm trying to output a list of events that happen at multiple times, grouped by the date it happened on. My table/data looks like this: (the timestamp is a datetime field) 1. 2010-03-21 18:00:00 Event1 2. 2010-03-21 18:30:00 Event2 3. 2010-03-30...
How to optimise MySQL query containing a subquery?
I have two tables, House and Person. For any row in House, there can be 0, 1 or many corresponding rows in Person. But, of those people, a maximum of one will have a status of "ACTIVE", the others will all have a status of "CANCELLED". e.g. SELECT * FROM House LEFT JOIN Person ON House.ID = Person.HouseID House.ID | Person.ID | Person...
DotNetNuke MySQL
Windows Server 2003. I have an existing DotNetNuke website. SQL Server is currently running and is being used by DotNetNuke. I want to use MySQL for other purposes. Would installing MySQL on the same server interfere with DotNetNuke? It seems that shortly after installing DotNetNuke our website stopped populating pages. ...
dotConnect LINQ to MySQL Issue
I am using dotConnect LINQ to MySQL and i have the following error. what would be the cause for this issue annot convert parameter value of type 'System.String' to MySQL type 'MySqlType.TimeStamp'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more informa...