USE AT YOUR OWN RISK, THERE IS NO WARRANTY EXPRESS OR IMPLIED WITH THIS
SOFTWARE
Cheers
Dean
--- Script Starts ---
#!/usr/bin/php -q
?php
# Remove the first line if you are running this through a browser
# Author Dean Urmson durmson (_A_T_) mistral-networks (_D_O_T_) co
(_D_O_T_
For example:
gallery_id | gallery_name | keywords
1 | test | 1,2,3,4
2 | test2| 3,4,5,6
And I won't to get all the galleries with where the have the
keywords 2, which in this case would be record 1 or keyword 4
which would be both record.
SELECT
Already tried that, but is 2 appears at the end of the list
is doesn't get picked up because there is no comma at the end
of the list
Are there spaces between the commas???
If not then
SELECT gallery_id, gallery_name
FROMgalleries
WHERE
keywords = '2'--
I have a TBL of users and I have created a search screen where you can
type in
first or last name and it will retrieve the appropriate records. Here is
the statement:
Select * from STUDENTS WHERE FName LIKE '% .$_REQUEST['searchit']. %'
OR LName LIKE '% . $_REQUEST['searchit']. %' OR
Thanks - but did not work...here is the information you
requested. In looking at this please remember that, for
example, there are lots of smith records in the data, but
only one with the first name allenand there are lots of
sarah records in the data but only one with the last name
OK getting somewhere now...I have modified the code to the
more advanced option that you suggested...I am now getting a
return when I search by the ID but still not when I search by
the FName or LName:
Here is the html:
snip
* No, no error reported
* What command do I type to find
For the benefit of the list...
Marty and I corresponded off list to make sure his PHP wasn't at fault, it
wasn't!
Turns out the problem was a corrupt table or index that 'optimize table
tablename' fixed up.
Cheers
Dean
--
MySQL General Mailing List
For list archives:
The problem is that in my java.sql.ResultSet.getDouble(strength)
a zero amount throws a number format exception.
Hi Paul,
Not a Java user so I haven't tested this.
You could try...
SELECT abs( strength ) FROM data ;
It 'might' stop the exception!
Cheers
Dean
--
MySQL General Mailing