Hi Alvaro,
I have no experience using these in PHP scripts. Couldn't hurt to try
putting it in mysql_query statements and see if it works. If you can
turn on the general query log for a bit then you can see exactly if
it's working; if you can't turn it on, then you'll have to guess from
output.
Thanks Sheeri:
Yes, you where right. It was because I was not opening the table first.
Actually, I was using this statements from a MySQL GUI (MySQL Query
Browser) so it doesn't work in this program (it doesn't keeps the table
opened).
But when I use your example in the shell mode it works perfec
Hi there,
What did your MySQL error say?
It looks like you didn't open the table. my example, which worked:
CREATE TABLE `foo` (
`id` int(11) NOT NULL auto_increment,
`bar` char(3) default NULL,
PRIMARY KEY (`id`),
KEY `idx_bar` (`bar`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
insert
Dear all:
I have been exploring about this issue quite a lot, and find no solution:
Platform: Debian, MySql 4.1.11, PHP 4.3.10-2, Apache.
Is there any way I can retrieve a set of values depending in a where clause:
For example:
from a set of values in one field: 1,2,5,8,9,11,13
I'd like to re