WHERE LENGTH('something') >...

[Anon]

I got this problem...
I can't SELECT from my db, because of this...
I need to be able to select where length of column is <= $var...

Here's the query-part:
$where[] = "LENGTH('tolt') >= '".strlen($tolt)."'";

And here's the query:
SELECT id, name, regno, breedingno, bcolor, colorv, gender, type, gaits, price, f, f_breedingno, m, m_breedingno FROM horse_test1 WHERE LENGTH('tolt') >= '3' && date > date_sub(NOW(), INTERVAL 30 DAY) ORDER BY name ASC LIMIT 0, 15

But it selects ALL, not just the ones where tolt is >= 3...

Do I need to set the column to something?
The others are just empty, and NOT NULL 🙂

With thanks in advance, Arni

[baruch]

Your query has in its where clause the condition:
LENGTH('toit')>='3'
Since it is a fixed condition and it is always true it is optimized out, it doesn't matter to the rest of the query.

Please describe your database schema and what you try to achieve and I'll try to help resolve this.

If you have a column in the table named toit then you need to query without the ' as in:
LENGTH(toit)>=3

[Anon]

That worked, without quotes...

Thanks alot 🙂

[Anon]

I'm also making PREV / NEXT buttons, out of image-submit button...

Here's the code for the PREV button:
if ($record_start > 0) {
echo '<form method="post" action="search.php">
<input type="hidden" name="action" value="1">
<input type="hidden" name="name" value="'.$name.'">
<input type="hidden" name="regno" value="'.$regno.'">
<input type="hidden" name="breedingno" value="'.$breedingno.'">
<input type="hidden" name="bcolor" value="'.$bcolor.'">
<input type="hidden" name="colorv" value="'.$colorv.'">
<input type="hidden" name="gender" value="'.$gender.'">
<input type="hidden" name="type" value="'.$type.'">
<input type="hidden" name="gaits" value="'.$gaits.'">
<input type="hidden" name="max_price" value="'.$max_price.'">
<input type="hidden" name="min_price" value="'.$min_price.'">
<input type="hidden" name="f" value="'.$f.'">
<input type="hidden" name="f_breedingno" value="'.$f_breedingno.'">
<input type="hidden" name="m" value="'.$m.'">
<input type="hidden" name="m_breedingno" value="'.$m_breedingno.'">
<input type="hidden" name="tolt" value="'.$tolt.'">
<input type="hidden" name="trot" value="'.$trot.'">
<input type="hidden" name="pass" value="'.$pass.'">
<input type="hidden" name="appearance" value="'.$appearance.'">
<input type="hidden" name="movements" value="'.$movements.'">
<input type="hidden" name="mane_tail" value="'.$mane_tail.'">
<input type="hidden" name="willingness" value="'.$willingness.'">
<input type="hidden" name="record_start" value="'.$rows_prev_from.'">
<input type="hidden" name="record_limit" value="'.$record_limit.'">
<input type="image" border="0" name="prev" src="prev.gif" width="25" height="13">
</form>';
} else {
echo '&nbsp;';
}

But how should the Next button have his if code?

if ($record_start >= $rows) { doesn't work, simple 'cause I punched some crap in...
I can't see the logic in this next prev thing :?

$rows = mysqlnumrows
and $record_start is in the query like this:
LIMIT $record_start, $record_limit

Any thoughts on this?
Thanks, Arni