Using WHERE in MySQL query

[samlutley]

If I have two variables:

$start
$end

How would I query entries from a data base with dates between $start and $end

Would it be something like:

SELECT id, date FROM my_db_table WHERE date>=$start && date<=end ORDER BY date ASC

thanks,
sam

[Pig]

Correct, except that it would be $end, not end.

[det1smc]

almost...

the and operator in SQL is "AND", not "&&".
It's also a good idea to use identifiers "`" if you have a filed name like date.

SELECT `id`, `date` FROM my_db_table
WHERE `date`>='$start' AND `date`<='$end' ORDER BY 'date' ASC


You can also use the BETWEEN (http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html) operator. It does the same thing, but it's a little easier to read.

SELECT `id`, `date` FROM my_db_table
WHERE `date` BETWEEN '$start' AND '$end'
ORDER BY 'date' ASC

[samlutley]

thanks

[Pig]

I thought mysql allows &&
http://dev.mysql.com/doc/mysql/en/Logical_Operators.html

[det1smc]

I thought mysql allows &&
http://dev.mysql.com/doc/mysql/en/Logical_Operators.html
Indeed, you are correct, and I am not :confused: .
I've been using SQL (not mySQL) for many years and I've never seen && used in a WHERE.

Thanks

[samlutley]

If I have a string:


$output = " rowspan = \$number "


And then calculate the value of $number (let's say $number = 3)

How do I successfully echo/print out:

rowspan=3

using something to the effect of


echo $output


right now it just prints

rowspan = $number

[det1smc]

$output = " rowspan = \$number "


If you can assign a value to $number before you create the $output variable.

$number=3;
$output = " rowspan =\"$number\"";
echo $output;
//rowspan ="3"


If the value of $number is unkown, you can use this approach.

$output = " rowspan =\"%d\"";

$number=3;
echo sprintf($output,$number);
//rowspan ="3"

[Pig]

mysql is not very strict about complying to standards. That's why you can insert strings into int columns :(

This is perfectly valid to mysql:
INSERT INTO table (some_int_col) VALUES ('3');