Hello,
If someone could give me a pointer on this issue:
I have a table called codes with only one field left.
When trying this in PHP:
$result=mysql_query(DELETE FROM codes WHERE
left='$temp');
I get a syntax error...
This must be some stupid mistake... But I am stuck...
Thanks,
On 26 Nov 2001 at 0:39, [EMAIL PROTECTED] wrote:
Isn't left a reserved word? As in left join? But then, create
shouldn't have
worked either...
Hello,
Thanks a lot, that worked! I changed the name of the field, bingo!
Sincerely,
Gil.
PS: for spam filter: database
--
Hello,
I would really appreciate some help on this, thanks!
I have a colomn with days_left, an integer. I have to write a Perl
script to run on a cron job once a day and decrement all the fields
in that column by 1. Is there a query to do this?
Sincerely,
Gil.
--
http://planenews.com
PGP
Hello,
Does the data stored in a VARCHAR field get truncated on spaces?
All my fields contain the data up to the first space...
What should I use ?
Thanks a lot, sincerely,
Gil.
[ PHP 4.01, MySQL 3.23, FreeBSD 4.2 ]
--
PGP public key at:
keskydee.com/gil.asc
ICQ: 3310801
Hello,
I have in mind a site that would require a Java applet to load
information from a MySQL database...
The applet would pull fields from a row randomly selected each
time is is loaded onto a web page on a client computer.
Fields would include some text and one picture.
Of course, login
Hello,
I recently started using MySQL on FreeBSD.
Everything works great, except that I can't access a database created by root
as another user. When I grant privileges, from the command line or phpmyadmin,
things seem to work fine (no error message), but access is still denied.
I did restart