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 th
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: "
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 pre
Hi again
The insert statement is incorrectly positioned within the if statement.
Please fill out the form below to get an account.
Username:
should be
Please fill out the form below to get an account.
Username:
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