[PHP-DB] MySQL connection: Change on syntaxis?

Hello, I updated php to version 4.0.5 and MySQL to version 2.32.39, had errors on lines like this: $rows = mysql_num_rows($result); and noticed that this is a solution: $rows = @mysql_num_rows($result); Is this a new use of the function mysql_num_rows? +--

Re: [PHP-DB] Informix Question (Still need help,please)

Chris, Thanks for the advice, of course I already did "rtfm" and the ifx_fetch_rows entry did not really help me. It, in fact does NOT return an enumerated array, as the top line of the page states. It ONLY returns an associative array. If there was an ifx_fetch_array like the one for MySQL, I w

[PHP-DB] Does PHP work with MSSQL 2000?

Does PHP work with MSSQL 2000? Chris Cowan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] ORACLE JOB

I need to do a select or a insert based in a variable Something like this $select = "SELECT * FROM TABLE1" and after i do the select above with is in the variable... All help is important... Thanks Fernando -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

Re: [PHP-DB] raw file header in http

Try the following: create a link to a script download.php which will read the file (from anywhere on the disk) and send it to the user like this: header("Content-Type: application/force-download"); header("Content-Length: ".filesize($filename)); header("Content-Disposition: attachment; filenam

RE: [PHP-DB] Connecting to MySQL

Sounds like either: 1) You don't have your correct username/password info in the mySQL/user table or 2) Your server is bound to an IP address or something (a frequent problem on Win machines, but it looks like you're using Linux or something) The localhost part isn't really the username that is

[PHP-DB] 1 is not a valid PostgreSQL link resource

! Hi ¡ i have redhat 7.1 and php 4.0.4 but i have a problem with conections becose send me this messages "1 is not a valid PostgreSQL link resource", how i cant fix this problem someone friend say me that rebuild source code php 4.0.4 , is true o someone have a solution Thanks ::: -- PHP Da

[PHP-DB] changing field size

hello *: I have initially set a field named title to be varchar(50)...I am finding that it is not long enough...can I change the size without adversely affecting existing data? Thanks Luis __ Do You Yahoo!? Get personalized email addresses from Y

[PHP-DB] Fatal error: Call to undefined function: mssql_connect()

Hello All. I'm trying to connect to MS SQL Database but I receive Fatal error: Call to undefined function: mssql_connect() error. Anyone know what could be causing this? I have configured the PHP.INI file in the System32 folder and placed all necessary .DLL's. I still get this error. Thanks

Re: [PHP-DB] raw file header in http

Hi, I think you could use something like this $file_name="/tmp/your_file_name"; Header ( "Content-Type: application/octet-stream"); Header ( "Content-Length: ".filesize($file_name)); Header( "Content-Disposition: inline; filename=$file_name"); readfile($file_name); If you want instead of using "

Re: [PHP-DB] How do I backup my MySQL database? asks a Newbie.

Install phpMyAdmin and this will give you a web interface to manage your DB. You can do a dump of your database using it. Andre Dan Eskildsen wrote: >*** >NEWBIE ALERT! >*** > >I am only new at this, but I have discovered one thing: I love php and >mysql! > >I now have

[PHP-DB] Connecting to MySQL

Can anyone help with this problem ! user name should just be keith but the @localhost gets added and then I can't connect ??? Warning: MySQL Connection Failed: Access denied for user: 'keith@localhost' (Using password: YES) in /usr/var/www/www.happy.de/html/cms/test.php on line 23 Problem connect

Re: [PHP-DB] mysql client compression with php?

Is there anyone who can help with this? Or is there a paid support option I could use to help resolve this issue? Regards, Shriram ""Shriram Chaubal (Personal)"" <[EMAIL PROTECTED]> wrote in message 9gntu2$ng8$[EMAIL PROTECTED]">news:9gntu2$ng8$[EMAIL PROTECTED]... > Hi, > > I have to connect my

RE: [PHP-DB] How do I backup my MySQL database? asks a Newbie.

get mysql front, install it and then choose export tables to file. i've found mysql-front to be a really good tool for adminisrating mysql dbs Steve > -Original Message- > From: Dan Eskildsen [mailto:[EMAIL PROTECTED]] > Sent: 21 June 2001 10:15 > To: [EMAIL PROTECTED] > Subject: [PHP-D

[PHP-DB] raw file header in http

I' ve a file in a directory(/tmp) out from http root of web server. I need to open a page that send this file when it is opened (es.: opening page.php under netscape it opens a request to save file to disk, but the "file is out of www root"), i think i t is possible using command header and a raw

RE: [PHP-DB] imap problem

Did you compile php with the --with-imap option ? Because generally, this type of message happens when the function is not installed. - Mensaje original - De: "vipin chandran" <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED]> Enviado: mercredi 20 juin 2001 14:54 Asunto: [PHP-DB] imap problem

[PHP-DB] passing db persistent connections through different pages

hello, I've this silly question: how can I pass a db persistent connection from a script to another? (it seems there's no way: but what's the use then of them?) eg, I tryed this 2 scripts (with Oracle 8.1.6) $conn"; ?> $conn"; OCILogOff($conn); ?> this works if both are on the same page,

Re: [PHP-DB] Informix Question how to put data from query into variables

"wflow" <[EMAIL PROTECTED]> wrote: > Hi All, > What I want to do is create another query from some of the data from another > one. The question is how do I take the data I get back from my first query > and put that into variables so I can build my second query. The example I > have in mind is:

Re: [PHP-DB] Informix question

Bård Farstad <[EMAIL PROTECTED]> wrote: > Hi all, > I'm writing an application which uses the PHP interface to informix. I'm > having trouble with newlines in char/varchar or lvarchar fields. > How can I store newlines (\n) to an informix database without using blobs? You need to escape newlin

[PHP-DB] Interbase & blob

I have many problem to view image stored like blob in interbase6. Is impossible. I Use ibase_blob_echo(). my php is 4.0.5

[PHP-DB] How do I backup my MySQL database? asks a Newbie.

*** NEWBIE ALERT! *** I am only new at this, but I have discovered one thing: I love php and mysql! I now have a couple of tables of information in a MySQL database. The site is run by my ISP so I don't have control of the server. My question is: how do I via php/mysql

Re: [PHP-DB] concatenation

U I might be missing something but isn't it something like: $emailVal = "mailto:"; . $email . "\">" . $email . ""; HTH :-) Russ On Thu, 21 Jun 2001 00:05:46 -0500 DanielW <[EMAIL PROTECTED]> wrote: > Greetings. > > Can anyone tell me how to concatenate text to the value of a cell > pul

RE: [PHP-DB] concatenation

$mailto_link = "mailto:"; . $result["email_address"]; // -Original Message- // From: DanielW [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 21 June 2001 1:06 PM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] concatenation // // // Greetings. // // Can anyone tell me how to concatenat

Re: [PHP-DB] Date field

> Hi, > Can someone tell me how do stote date field in MySQL DB ? This is the dump from my phpMyAdmin: use this SQL from the command line and adapt it for your own needs: # Table structure for table 'item' # CREATE TABLE item ( id smallint(4) DEFAULT '0' NOT NULL auto_increment, name varc

Re: [PHP-DB] flush privileges

> what kind of privileges i should have if i want to run > 'flush privileges' ? You need to be the MySQL superuser, this is the user who has permission to grant privileges to other users and set them up as such. You use 'flush privileges' when you want to instruct MySQL to 'refresh' it's '

Re: [PHP-DB] Date field

Hi, it depends on the the MySQL date type you are using. Here are the formats for the different types. DATE - '-MM-DD' DATETIME - '-MM-DD HH:MM:SS' TIMESTAMP(14) - MMDDHHMMSS TIMESTAMP(12) - YYMMDDHHMMSS TIMESTAMP(8) -MMDD TIMESTAMP(6) -YYMMDD TI

[PHP-DB] concatenation

Greetings. Can anyone tell me how to concatenate text to the value of a cell pulled out of a table in a while loop? I'm trying to add "mailto:"; to an email address value. Thanks, Dan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional