RE: [PHP-DB] imap problem
Hi, It's likely that you need to enable imap support, if you are using win32 this is relatively simple, all you have to do is get the dll from the php website and uncomment the lines from the extensions section of the php.ini file. If you are using unix, then you have to recompile php with the --imap flag (I think, something like that) although I had no end of trouble getting this to work, Regards Tom Hodder -Original Message- From: vipin chandran [mailto:[EMAIL PROTECTED]] Sent: 20 June 2001 18:54 To: [EMAIL PROTECTED] Subject: [PHP-DB] imap problem Hi, I am developing an email reader for IMAP/POP3. But I am getting the following error when trying to excute the file. I have removed the comment from the IMAP extensions in the php.ini. Fatal error: Call to undefined function: imap_open() in conn.inc on line 6 Contents of conn.inc is as below : ? $username = whoosh_vc; $password = crossroads; $mailserver = {pop.postmark.net/pop3:110}INBOX; $link = imap_open($mailserver,$username,$password); ? Please help. Thanx in advance. vipin chandran [EMAIL PROTECTED] -- 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 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] 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 commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 TIME - 'HH:MM:SS' YEAR(4) - YEAR(2) - you can use 'YY' here if you use years between 1970 and 2069 Dobromir Velev -Original Message- From: Rosen [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Wednesday, June 20, 2001 10:57 PM Subject: [PHP-DB] Date field Hi, Can someone tell me how do stote date field in MySQL DB ? Thanks, Rosen M. -- 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 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]
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 'mysql' table data AFTER you have set up a user. If you have been able to connect to MySQL from the command line or phpMyAdmin and successfully enabled a new user (Without SQL errors) then you should be able to issue 'flush privileges'. I honestly cant remember how I set it all up originally, but you could go try: www.mysql.com/doc/P/r/Privileges.html and see if that helps. Cheers Russ On Wed, 20 Jun 2001 22:38:20 +0700 andRie Is [EMAIL PROTECTED] wrote: Hello php-db, what kind of privileges i should have if i want to run 'flush privileges' ? ,,, (@-@) +==---o00(_)00o-==+ It is better to be defeated on principle than to win on lies. --Arthur Calwell -- Best regards, andRie -- 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] #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam t: +44 (0)1223 363271 x 2331 www.theruss.com #---# -- 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]
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 varchar(25) NOT NULL, dept varchar(25) NOT NULL, abstract mediumblob NOT NULL, submitDate datetime DEFAULT '-00-00 00:00:00' NOT NULL, // The //bit you need scale varchar(7) NOT NULL, PRIMARY KEY (id), UNIQUE id (id) ); HTH !! Russ On Wed, 20 Jun 2001 18:27:42 +0300 Rosen [EMAIL PROTECTED] wrote: Hi, Can someone tell me how do stote date field in MySQL DB ? Thanks, Rosen M. -- 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] #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam t: +44 (0)1223 363271 x 2331 www.theruss.com #---# -- 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]
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 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 commands, e-mail: [EMAIL PROTECTED] // To contact the list administrators, e-mail: // [EMAIL PROTECTED] // -- 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]
Re: [PHP-DB] concatenation
U I might be missing something but isn't it something like: $emailVal = a href=\mailto:; . $email . \ . $email . /a; 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 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 commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] #---# Believe nothing - consider everything Russ Michell Anglia Polytechnic University Webteam e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam t: +44 (0)1223 363271 x 2331 www.theruss.com #---# -- 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] 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 make a backup of the entire database so that I can restore it again should the worst happen and the server goes down? I would really appreciate your comments on this! Dan == Regards from Denmark, Europe Please cc your reply to [EMAIL PROTECTED] == I haven't lost my mind, I've got it backed up on TAPE somewhere... -- 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] 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
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 newlines or replace them eg. with br. Chris. -- 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]
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: I a do a select tracknum,orderdate,ordertotal,status,shipdate from orders where tracknum = '$trknum' and I want the data returned into vars: like orderdate = $orderdate so I can create a new query like: select * from shipping where orderdate = '$orderdate'. @ifx_htmltbl_result($sql_result,border=1); You might want to consider reading the php manual, especially the part on functions and even more the one on informix functions. There you'll find a function called ifx_fetch_row. Chris. -- 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] 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) ?php set_time_limit(0); $conn = ociplogon('user','pass','testdb'); echo Server Version: . OCIServerVersion($conn); echo brbr $conn; ? ?php echo brbr $conn; OCILogOff($conn); ? this works if both are on the same page, but I see no way to pass $conn (with the associated info) to another one; I've read on http://marc.theaimsgroup.com/?l=php-dbm=97024385511984w=2 __ I'd like to know if it is possible to create a session variable for a database to get a persistent database connection. I've got lots of updates If you think passing persistent connection between pages as other vars, answer is no. __ there's really no way to do this? thank you, bye, --Giuse Find the best deals on the web at AltaVista Shopping! http://www.shopping.altavista.com -- 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]
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 Hi, I am developing an email reader for IMAP/POP3. But I am getting the following error when trying to excute the file. I have removed the comment from the IMAP extensions in the php.ini. Fatal error: Call to undefined function: imap_open() in conn.inc on line 6 Contents of conn.inc is as below : ? $username = whoosh_vc; $password = crossroads; $mailserver = {pop.postmark.net/pop3:110}INBOX; $link = imap_open($mailserver,$username,$password); ? Please help. Thanx in advance. vipin chandran [EMAIL PROTECTED] -- 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 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] 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 http command, but i aven't any idea if it is possible and if yes in what mode. The system i use is apache 1.3.9 under redhat linux 7.1, tank's Omar -- 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]
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-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 make a backup of the entire database so that I can restore it again should the worst happen and the server goes down? I would really appreciate your comments on this! Dan == Regards from Denmark, Europe Please cc your reply to [EMAIL PROTECTED] == I haven't lost my mind, I've got it backed up on TAPE somewhere... -- 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 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]
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 php server to a remote mysql database and would like to minimize the bandwidth usage. Adding a setting in my.cnf as follows only seems to affect the mysql client applications and not php. [client] compress I have noticed a define in the php sources called HAVE_COMPRESS but have no clue where it gets defined. Any tips? Cheers, Shri -- 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 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] 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 connecting to DataBase -- 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]
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 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 make a backup of the entire database so that I can restore it again should the worst happen and the server goes down? I would really appreciate your comments on this! Dan == Regards from Denmark, Europe Please cc your reply to [EMAIL PROTECTED] == I haven't lost my mind, I've got it backed up on TAPE somewhere... -- 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]
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 application/octet-stream you can can use the MIME type of the file you are sending for example application/x-compressed. The second and the third headers are optional. Dobromir VElev -Original Message- From: schiarat@libero. [EMAIL PROTECTED] To: [EMAIL PROTECTED] [EMAIL PROTECTED] Date: Thursday, June 21, 2001 6:03 PM Subject: [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 http command, but i aven't any idea if it is possible and if yes in what mode. The system i use is apache 1.3.9 under redhat linux 7.1, tank's Omar -- 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 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] 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 in advance!!! -- 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] 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 Yahoo! Mail http://personal.mail.yahoo.com/ -- 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] 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 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]
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 being sent. It simply appends the @localhost so you can see where you're connecting to. I would check the users table in the mysql database. - Jonathan -Original Message- From: Keith Whyman [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 7:52 AM To: [EMAIL PROTECTED] Subject: [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 connecting to DataBase -- 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 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]
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; filename=.$orig_filename); readfile($filename); exit; This should give him a download dialog box and set the filename in the dialog box to $orig_filename. hope this helps ciao andre. schiarat@libero. wrote: 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 http command, but i aven't any idea if it is possible and if yes in what mode. The system i use is apache 1.3.9 under redhat linux 7.1, tank's Omar -- 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 PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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]
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 would not have to even post this question. I only did post the question, because I needed help and figured I would ask the experts, but all I got was somebody who says rtfm and most likely did not read or understand my question, so, thanks a lot. B Christian Haul [EMAIL PROTECTED] wrote in message 9gsg0u$6nf$[EMAIL PROTECTED]">news:9gsg0u$6nf$[EMAIL PROTECTED]... 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: I a do a select tracknum,orderdate,ordertotal,status,shipdate from orders where tracknum = '$trknum' and I want the data returned into vars: like orderdate = $orderdate so I can create a new query like: select * from shipping where orderdate = '$orderdate'. @ifx_htmltbl_result($sql_result,border=1); You might want to consider reading the php manual, especially the part on functions and even more the one on informix functions. There you'll find a function called ifx_fetch_row. Chris. -- 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 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] 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? +-- --+ Tomás García Ferrari Bigital http://bigital.com/ +-- --+ -- 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]