Search:

As long as these things remain at the "i believe" and "i don't believe" level there is no end to these discussions. Get hold of the questioner and questions will cease.

What is the difference between 70 years and 80 years? Theory of relativity.....

Religion wasn't part of curricula in my school.
Blind believers aren't limited to religion alone, even science has them. If I say , "Jesus said so and so..", there are people who will believe it....

http://www.search-this.com/2008/06/24/10-things-any-web-developer-worth-their-spit-should-know/

HTML, CSS, Javascript, one server side scripting language (php, asp.net, python, ruby on rails,...

If it is a single user app without need for transaction support etc, you can consider sqlite too.

You can get a proper result set only if one TSCN has only unique combination of TCO and TSB.

select tsb, tscn, tco
from DTracking
where tscn in
(select tscn from DTracking
group by...

I was not aware of the world in deep sleep. Does that mean world came to an end in sleep?

May I ask why and how?

One thing you can do for sure is having a JOIN statement to get the brand name along with the foodid etc.

$query = "SELECT f.foodid, f.foodname, f.foodbrand, f.foodsite, b.brandname
FROM...

Once you are comfortable with simple programming, may be you should consider SAP HR module. That way you can do programming and your experience in HR can be put to use.

How do you give an estimate on something which you never worked with? Very very early in my career I was asked to give an estimate on a project which involved interfacing with the google documents....

One thing with regard to the escape_string function. Before using mysql_real_escape_string on the variable, it is necessary to check if magic_quotes_gpc is enabled. Otherwise we will be escaping the...

while($row = mysql_fetch_row($export)) {
$line = '';
$count = count($row);
for($i=0;$i<$count;$i++){
if ((!isset($row[$i])) OR ($row[$i] == "")) {
$value = "\t";
} else {
if ($i...

$results->data_seek(0); before the next loop.

It is a csv file right? Commas in the column should automatically put them in separate cells. But since you are using " to enclose the values that might not be happening. What you can do is split the...

After fetching the data of the last column, replace the commas in that with a | . str_replace(',' '|', $value);

My guess is * will be slower. In that case engine has to do some kind of querying on its own to determine the columns of the table. If I am not wrong this is a generic sql question not specific to...

I believe it has something to do with the charset thing, but I am not sure which charset to use. Try charset=iso-8859-1.

http://dev.mysql.com/downloads/
You have several tools listed there.

What is the charset used for the page containing the select box. I mean the meta tag <meta http-equiv="content-type" content="text/html; charset=utf-8"/>
I guess it has something to do with the...

I don't know much about stored procedures. May be you could try

SELECT IFNULL(gas, 0) INTO vgas FROM someTable WHERE car=rec2 AND driver=rec1;

Also check that the mysql server is running.

Check if the query has executed successfully before using the result set.

And this is what EXPLAIN says for 'not exists'.

Thanks folks. This was a good learning experience.

With the "not in" we assume that the optimizer will retrieve all the r_id's from ra table and do something like

select name, r_id from r where r_id not in (1,2,3,4);
But that doesn't seem to be...

I have attached screen shot of the result as given by phpmyadmin.
First result is for the join, second one is for the not in.

There is a statement called 'EXPLAIN' which gives out info about the performance of a query in MySQL. And here is the link which gives detailed info about the 'EXPLAIN'.explain

I am using MySQL. Will 'EXPLAIN' review the execution plan.
I am not sure if JOIN will do what I want. I want to know r_id's in table r which are NOT in table r_id. I can't claim to be knowledgeable...

I have this query to retrieve rows from table r which do not have a corresponding entry in the table ra.

SELECT name, r_id FROM r WHERE r_id NOT IN (SELECT r_id FROM ra GROUP BY r_id);
This one...

I would rewrite the echoing part to something like this.

if (mysql_num_rows($res) > 0){
while ($row=mysql_fetch_assoc($res){
echo $row['city'].'<br/>';
echo $row['name'].'<br/>';
...

Thanks brucevde. Your query was spot on. Thanks again.

Thank you. But that is returning only one value, while there are several rid's whose count is greater than 1.

May be you have already done it, but did you try to check through php if the cookie is actually being set, rather than look at the IE files?

Hello,
I have a table which apart from other columns, has id and rid columns. id is the primary key and rid is a reference to another table.
What I want to do is retrieve the rid's which have more...

Thanks everyone. It seems to be rather round about way of doing it. But then, if that is the only way, there is nothing much one can do but follow it.
btw, this is my first visit to the forums in...

Thanks for the reply. I think I couldn't explain myself properly. Do we have anything in ms-access through which we can execute the sql statements directly instead of taking recourse to query wizards...

The goal is to learn SQL. Can I do it from within ms-access? I am not familiar with it. A quick look at it shows query designers , wizards etc.
Thank you.

Thank you.

Hello,
I have thought of using the schema explained below to store the poll questions, answers and votes received.
1- Table 'poll_questions' - columns: id(primary key), question
2- Table...