Hi, I'm basically a newbie, and still have a lot to learn. Someone told me that for what I'm trying to do, I need an SQL Join, like this: SELECT title FROM recipes, categories …

I come from a Networking background so please excuse if this is a really straight forward question as I have no experience of Access or VB and am on a steep learning curve with thi …

please could someone help me I need to get sql to talk to php code is: <?php $host = ""; $username = ""; //connection to db $password = ""; $db_name = ""; $tbl_name="Ite …

I want to query delayed deliveries from our company... We should ship the goods within 4 workdays. I have created a filter in the end of this SQL query... >4 We do only count wor …

I have 5000 records for 200 patients weight records in the past 10 years. 00001 134.5 11/9/2009 00001 123.34 9/02/2009 00002 123.45 11/5/2009 00002 127.89 11/5/2007 00003 …

Database: MySQL I'm looking for a way to sort data randomly. I.e. I got a list of blog posts. "select name from post" gives me an unsorted list: name ------------------- title 1 …

I can't use DISTINCT because any row have "dateCreated" field and won't be duplicate, but these rows can hold same data and I want to skip them

I followed your steps to connect to our MS SQL database and it doesn't appear to even pass the mssql_connect statement. Our php environment showed a fourth parameter of bool $new_ …

Can anyone tell how to use two columns for IN operator? like Select * From EmployeeAddressTable Where FirstName, LastName IN (('Mary', 'Sam') ,('Johnson','Roden')) Database: SQL …

Hi, Is it possible to create 2 tables in the same query? (in SQL-Access 2003) Many thanks, cris

set_magic_quotes_runtime(0); $connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS) or die(mysql_error()); mysql_select_db(DB_NAME, $connection) or die(mysql_error()); $q = " …

I need to do a 'top 10 songs'. I have the following fields: -song -artist -album -votes -code_song I want to do a top. I tried with this query, but it didn't work... SELECT votes …

I use MySQL. I have been trying to find a way to use an SQL statement to bring up a list of those whose "yellow fever" vaccinations are up for expiration within two months, using …

I store URLs in one of database fields i.e. 'test_this' and 'test-this' Query select * from tableName where url like 'test_this%' returns both records. Why it works this way? Is …

What is easiest way to avoid SQL injections?