I followed an online tutorial (url below) to create a simple indexed keyword
search. The sample as outlined in the tutorial was designed to work with
one keyword only. I am an experienced PHP programmer with some SQL
experience but only simple queries. This Aliasing and Grouping is brand new
to
Very simply I protect whole pages on my member's website by include()'ing a
script called auth.php into the top of each page. Rather than using a
binary string to turn functions 'on' and 'off', I do things a bit more
general than that. I have defined levels of access (ie, L1, L2, L3, etc..)
stor
There is no way to know if the user has left the website. About all you can
do is save a timestamp in the database for every recordable action the user
performs then if no actions take place for say 10 minutes that user is said
to be 'logged out' and you delete the database row and deallocate any
To be honest I have no idea (just learning SQL myself) but the MySQL manual
does offer at least a few tips to help opitmize your insert statements in
looped scenarios... http://www.mysql.com/doc/I/n/Insert_speed.html
-Kevin
- Original Message -
From: "Leif K-Brooks" <[EMAIL PROTECTED]>
T
All I need to do is return anything matching the following pattern from a
specific column in a table. This is how I'd write it in PHP if I were
pulling the data from string. The string in this example is a direct copy
of one of the column fields..
What would be the SQL equivilant? I hate to
(in response to my own response)
By the way it just occured to me that the default SELECT statement is
already case insensitive. So is any of this is even necessary? If you want
to display the selected items in lower case, then do that in your script
with strtolower();
-Kevin
"Robin S McKenzie
Your problem may be the use of single quotes around your wildcard search
string. I haven't tested it but SQL probably works like PHP in that single
quotes denote exact values while double quotes allows evaluation of the
quoted string.
-Kevin
"Robin S McKenzie" <[EMAIL PROTECTED]> wrote in messag