Transactions are not for critical data such as credit card numbers. There
are at least a couple of reasons for transactions and neither of the
reasons I can think of are for storing critical data such as credit card
numbers.
Transactions are for updates to the database that must happen all toget
Hi,
I'm trying to select records based on dates.
I have a table with dates in the format 2001-04-08 and I'm using the query:
SELECT name, description, date_time FROM events WHERE YEAR(date_time) = 2001
AND MONTH(date_time) = 04 AND DAYOFMONTH(date_time) = 08
But it doesn't yield any records? I
>I'm trying to select records based on dates.
>I have a table with dates in the format 2001-04-08 and I'm using the query:
>
>SELECT name, description, date_time FROM events WHERE YEAR(date_time) = 2001
>AND MONTH(date_time) = 04 AND DAYOFMONTH(date_time) = 08
WHERE field_holding_date="2001-04-0
Doug,
You've posted your usual good sense, combined with one statement I
strongly disagree with.
>One of
>these products is a relational database management system. The other is a
>quasi-SQL-like-front-end-to-systems-of-indexed-files that has never
>concerned itself with things like standards
On Sun, Apr 08, 2001 at 02:09:04AM -0300, Manuel Lemos wrote:
> Hello Sharmad,
>
> On 06-Apr-01 08:33:54, you wrote:
>
> >Hi,
> > Thanks for firstly helping me out with the prevoius query.
> > I have a database with mem_id(int) and name(text) as its fields.
> > In the first form (HTM
Although i have compiled php with gd i don't get image do i have to make
any changes in php.ini
-Regards
--
The secret of the universe is @*&í!'ñ^#+ NO CARRIER
___ _ _ _
|_|_||_||_||\/||_|| \
_|| || || \| || ||_/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
On Sun, 8 Apr 2001, Bob Hall wrote:
> Doug,
>
> You've posted your usual good sense, combined with one statement I
> strongly disagree with.
>
> >One of
> >these products is a relational database management system. The other is a
> >quasi-SQL-like-front-end-to-systems-of-indexed-files that has n
Hello,
I have a fresh instalation of mysql from the ditribution of RH7.
What do I have to put into the user and host tables so that
I can use MySQL through PHP (I doesn't have to be super-secure,
just so that not everybody could get to my databases)
Btw.
Now I get this error when trying to use my
I'm getting an Invalid Query error after inputting the following
$sql_query = "UPDATE commentary SET com_num=$com_num, com_by=$com_by,
com_band=$com_band, com_title=$com_title, com_release=$com_release,
com_rating=$com_rating, com_body=$com_body, com_type=$com_type, WHERE
com_num=$com_num";
$r
Use mysql_error() to see the real error message from MySQL. It's probably
related to the lack of single quotes around your string values in your
query.
-Rasmus
On Sun, 8 Apr 2001, Jonathan Underfoot wrote:
> I'm getting an Invalid Query error after inputting the following
>
>
>
>
> $sql_quer
At 21:20 8-4-01 +0200, Adam wrote:
>Hello,
>I have a fresh instalation of mysql from the ditribution of RH7.
>What do I have to put into the user and host tables so that
>I can use MySQL through PHP (I doesn't have to be super-secure,
>just so that not everybody could get to my databases)
I don't
Well, I just started working on implementing SQL Server support in my
database abstraction class. I downloaded and installed the SQL2k evaluation
from MS and I can connect through DBArtisan and through the SQL Server Query
tool. However when I try to do it through PHP, it just sits there, and
caus
Hi,
if you're using MySQL, the simpliest method is using RLIKE
SELECT stuff FROM table WHERE stuff RLIKE '^[0-9]+';
see
http://www.mysql.com/doc/S/t/String_comparison_functions.html
http://www.mysql.com/doc/R/e/Regexp.html
for more info
HTH
Victor
> Okay it's working now..
> How if I want to
I've been surprised that I couldn't find a quick answer to this in the books
and resources I've looked at. It must be really straightforward but how are
single quotes (apostrophes) in record data (such as a name like O'Reilly)
handled on data entry? Presumably they are escaped in the database and
I am using sessions to store variables until all forms have been filled out. at this
point they are put into the db.
I would like to know how i can eliminate the problem that occurs when the user presses
the back button. I receive a "warning, page has expired... press refresh" I know that
pres
Try removing the last comma in your update statement
change:
com_type=$com_type, WHERE
to:
com_type=$com_type WHERE
olinux
- Original Message -
From: "Jonathan Underfoot" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, April 08, 2001 4:16 PM
Subject: [PHP-DB] PHP & MySql
>
Hi Bob!
That would make a very interesting study. Attempting to come up with a
modern definition of RDBMS. Of course, it would be only an academic
exercise...but it would be a fascinating paper if any youngsters reading
this from a university dorm room or computer lab would like to tackle it.
If you are using windows,
Uncomment (un ;) the following line in php.ini
extension=php_gd.dll
Regards,
Corin Rathbone
[EMAIL PROTECTED]
-Original Message-
From: Sharmad Naik [mailto:[EMAIL PROTECTED]]
Sent: 08 April 2001 18:44
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Images donot appear
18 matches
Mail list logo
