Re: [PHP-DB] Forms : Validating user input is integer

2001-04-08 Thread Boclair
Manuel, Manuel Lemos [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... | Hello boclair, | | On 05-Apr-01 01:58:24, you wrote: | | I have a problem with a user input in a form required to be an | integer, creating a variable for a mysql query. | | I have instances

[PHP-DB] Images donot appear

2001-04-08 Thread Sharmad Naik
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,

Re: [PHP-DB] Re: PostgreSQL versus MySQL

2001-04-08 Thread The Hermit Hacker
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 never

[PHP-DB] mysql -- php

2001-04-08 Thread Adam
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

[PHP-DB] PHP MySql

2001-04-08 Thread Jonathan Underfoot
I'm getting an Invalid Query error after inputting the following connect to Server select DB $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,

Re: [PHP-DB] mysql -- php

2001-04-08 Thread B. van Ouwerkerk
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

[PHP-DB] MS SQL server 2k and php4 on win32

2001-04-08 Thread alarion
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

Re[2]: [PHP-DB] Display data begin with A

2001-04-08 Thread Victor Foitzik
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

[PHP-DB] PHP-MySQL - Escaping single quotes

2001-04-08 Thread duncan
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