There is a problem with this SQL statement. The problem is with the set command, with only one value to change it will work fine, but with more than one it returns an error.
UPDATE blank_date
SET name='Matthew' and telephone='678' and e-mail='matthew@sexycooking.co.uk'
WHERE (date =...
I'm trying to search two fields in a database. The SQL statement below returns all the records in the database:
select * from table where (desc OR title LIKE "%this%") AND (desc OR title LIKE "%that%")
Does anybody know of a goog way of removing duplicate values from an array?
I presume that the values will have to be put into a new array as they are filtered for duplicates, but have yet to find a way of filtering them.
In advance thank you to anyone who can shed some light on this problem for me.
I'm trying to use recordsets to display a list of items, this is simple, but I don't seem to be able to display them in reverse chronological order (most recent first), as they are added into the database in chronological order. I have tried several things, but they all cause errors of some...
I am trying to create a two page system which has one page displaying a list of articles and a second which displays the the individual articles, selecting them from information in the querystring. I tried to use a server side include, although it's writen to the page it does not get executed.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.