forbidden syntax search

2003-11-16 Thread M. Bader
Hi, I need a little help on my SQL syntax. I want to store forbidden inputs from the GUI in a table and query it on input from the user; simple layout: CREATE TABLE `forbidden_input` (`lfdnr` TINYINT (3) UNSIGNED DEFAULT '0' AUTO_INCREMENT, `input` VARCHAR (255) NOT NULL, PRIMARY KEY(`lfdnr`),

SQL: forbidden syntax search

2003-11-15 Thread M. Bader
Hi, I need a little help on my SQL syntax. I want to store forbidden inputs from the GUI in a table and query it on input from the user; simple layout: CREATE TABLE `forbidden_input` (`lfdnr` TINYINT (3) UNSIGNED DEFAULT '0' AUTO_INCREMENT, `input` VARCHAR (255) NOT NULL, PRIMARY KEY(`lfdnr`),

Adding up DATETIME field

2003-08-21 Thread M. Bader
Hi, i'm struggling with updating session expire times in my login table. Can you tell me, how to correctly add an amount of seconds (after that the session expires) to a datetime field? when i do the insert for a new login, or an update, the expire field will alway end up containing zeros

RE: Adding up DATETIME field

2003-08-21 Thread M. Bader
Hi again, From: Diana Soares [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 4:05 PM | NOW() + sec_to_time(6000) | That i allready tried, and it's leading to wrong results, as same as From: Cybot [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 3:42 PM UPDATE

RE: How can I display images from a mySQL Database in a web page?

2003-07-16 Thread M. Bader
image start: jpeg /image use this: echo 'img src='.mysql_result($conn, 0, 0).' alt='; where 0,0 is the result-set index for your mysql field. you might use other mysql functions of course, but the place to put the output in is the same the html-source code will look like it is

RE: Aborted Result in simple Query

2003-06-17 Thread M. Bader
Hello Shane, I found nothing better than the standard MySQL C API standard with MySQL. That's true. I read it now i find it very easy in comparison to the C++ documents. This one reminds me of PHP functions a lot. I have made 2 such classes, which are quite simple, not a significant ammount

Aborted Result in simple Query

2003-06-16 Thread M. Bader
symbols (like a misplaced pointer) So here are my questions: 1. Is there any way to get out correctly what's wrong? 2. Is there any good(!) description of the mySQL C++ API? (http://www.mysql.com/documentation/mysql++/index.html is horrific!) Best regards M. Bader -- MySQL General Mailing List