Hi Robin
Instead of using sql to change the case of the search criteria try using php
as in the statement below
$query=
SELECT *
FROM [Organisation Membership]
WHERE lower(organisation) LIKE '%. strtolower($SearchBox) .%');
Hope this is of some help to you
Tony James
Hi Dave
Assuming you are using mysql try the following query
select count(Admin_id) as admin1, Admin_id as admin2 from TABLE_NAME group
by admin2
substituting TABLE_NAME for whatever you have called your table.
Hope this helps
Cheers
Tony James
- Original Message -
From: Dave
hi Rehab
Because your submitted text on the url contains an '' anthing after this
character will be parsed as a new variable.
Instead of
location.href=additems.php?category=+c
try
location.href=additems.php?category=+escape(c)
this will encode the '' aswell as spaces to preserve
Hi Jennifer
The table defines the uid field as not null.
CREATE TABLE users (
uid int(10) unsigned NOT NULL auto_increment,
name varchar(20) NOT NULL default '',
password varchar(20) NOT NULL default '',
..
However you are trying to insert null
Hi again
The insert statement is incorrectly positioned within the if statement.
?
if(!IsSet($stage))
{
?
Please fill out the form below to get an account.
FORM METHOD=POST ACTION=te.php
Username:BRINPUT TYPE=TEXT NAME=name SIZE=15BR
input type=hidden
