Re: [PHP-DB] Call to undefined function mysql_connect()

2004-06-27 Thread Cole S. Ashcraft
Create a page called phpinfo.php. In it put . Search for MySQL. You probably don't have MySQL support in your installation. Cole Leandro de Oliveira wrote: Hi! I want test MySQL with PHP, for that I wrote this: Test MySQL 0) echo "Success!!"; else { echo "Failure!!"; echo mysql_error(); } ?>

Re: [PHP-DB] Auto increament

2004-06-27 Thread Daniel Clark
Yes there is an auto increment field in mySQL and most other databases. >>Can any of you guide me how to do auto increament in a field? >>I think there is one datatype for auto increament. >>But I dont know how to do it ? >> >>Rinku -- PHP Database Mailing List (http://www.php.net/) To unsubscr

Re: [PHP-DB] Call to undefined function mysql_connect()

2004-06-27 Thread Larry E . Ullman
But i received "Call to undefined function mysql_connect() on line 5" Can anyone help me? Your PHP installation apparently does not support MySQL. You can confirm this by running a phpinfo() script. You may need to reinstall/recompile PHP. Larry -- PHP Database Mailing List (http://www.php.net/)

[PHP-DB] Call to undefined function mysql_connect()

2004-06-27 Thread Leandro de Oliveira
Hi! I want test MySQL with PHP, for that I wrote this: Test MySQL 0) echo "Success!!"; else { echo "Failure!!"; echo mysql_error(); } ?> But i received "Call to undefined function mysql_connect() on line 5" Can anyone help me? Thanks! - Crie seu

[PHP-DB] Dates and Count

2004-06-27 Thread Shannon Doyle
Hi People, I have two queries for the list:- First, I have two dates stored in a MySQL DB that I want to do a compare on and then only display via a web page those records that have a 5 or greater day difference in them. What would be the best way to achieve this. Second, I want to be able to r

Re: [PHP-DB] Auto increament

2004-06-27 Thread Larry E . Ullman
Can any of you guide me how to do auto increament in a field? I think there is one datatype for auto increament. But I dont know how to do it ? I'd start by reading the manual and documentation for the database application being used. But, generally, auto incremented fields are primary keys, unsi

[PHP-DB] Re: Auto increament

2004-06-27 Thread Torsten Roehr
"Rinku" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Can any of you guide me how to do auto increament in a field? > I think there is one datatype for auto increament. > But I dont know how to do it ? Here is everything you need to know: http://dev.mysql.com/doc/mysql/en/CREATE_TA

[PHP-DB] Auto increament

2004-06-27 Thread Rinku
Can any of you guide me how to do auto increament in a field? I think there is one datatype for auto increament. But I dont know how to do it ? Rinku - Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers!

[PHP-DB] Php-Mysql, select and update trouble

2004-06-27 Thread Alessandro Folghera
Dear Phpers, I have the following part of a script that retrieve an URL site. I'd like to count the clicks for every URL. I have added to mysql table a column "hit". May anybody tell me how to insert into an sql selection also an update, referring to the HIT variable (i.e. to realize a select and