Hello All,
Ok, I have a database that has a table called critiera in this table
is to fields on is ID and the other is critiera.
Now I want to filter out all the one that don't apple to the list and
move the one that match to a different database.
I know how to open a connection, close, select
but I don't know how I would inside of a database use another one as
the way to create the list of critieras.
if I am right, I would create say a var
$query = "SELECT critiera_check_table FROM critera
$critiera = mysql_query($query) or die('Error, Query failed');
Now I think I would do some thing like this:
$query = "SELECT nfnp_table FROM (NPO, NTEE) WHERE $critiera
$critiera = mysql_query($query) or die('Error, Query failed');
now this is what I don't get, how can I tell it how to look for what
the critiera is.
some I want to look for using %critera% others are exactly like G41.
Should I in the table wrap the critera information with the thing I
want so in the case of %% I would in the database write iin like this
" %dog% " or " 'G41' or 031 (these are the three types of things I
would be search but there is as of now 25 different criteras and if it
mets only one or more of them then I want it. Now if there is two
words that I want together in the database I would write like this "
%dog AND cat% " I put in the % still because it could be at the
begging or end or even in the middle still but I want the to words in
the match?
Thanks for helping and if I miss some thing or have question to ask
please do so!
Sincerly,
Christopher & Missy
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
