Re: [PHP-DB] no temp var for mysql_fetch_array results

2004-05-11 Thread David T-G
Jeff (and John) -- ...and then [EMAIL PROTECTED] said... % ... % $r = mysql_query($q,$dbro) ; % $row = mysql_fetch_array($r) ; % $i = $row[0] ; ... % this one row (not looping), could I just % % $i = mysql_fetch_array($r)[0] ; % % Hi David Hi! % How about: % $i

Re: [PHP-DB] no temp var for mysql_fetch_array results

2004-05-11 Thread Justin Patrin
David T-G wrote: Jeff (and John) -- ...and then [EMAIL PROTECTED] said... % ... % $r = mysql_query($q,$dbro) ; % $row = mysql_fetch_array($r) ; % $i = $row[0] ; ... % this one row (not looping), could I just % % $i = mysql_fetch_array($r)[0] ; % % Hi David Hi! % How

Re: [PHP-DB] no temp var for mysql_fetch_array results

2004-05-11 Thread David T-G
Justin, et al -- ...and then Justin Patrin said... % % David T-G wrote: % % ...and then [EMAIL PROTECTED] said... % % ... % % How about: % % $i = mysql_result(mysql_query($q,$dbro),0); % % Oooh! Cool! Just right. ... % % Of course, this leaves the result handle open. It's best

Re: [PHP-DB] no temp var for mysql_fetch_array results

2004-05-11 Thread Justin Patrin
David T-G wrote: Justin, et al -- ...and then Justin Patrin said... % % David T-G wrote: % % ...and then [EMAIL PROTECTED] said... % % ... % % How about: % % $i = mysql_result(mysql_query($q,$dbro),0); % % Oooh! Cool! Just right. ... % % Of course, this leaves the result

[PHP-DB] Printing + without encoding as %2B

2004-05-11 Thread J. Alejandro Ceballos Z.
While calling a php with a parameter, the plus sign is interpreted as a white space. Is any solution to prevent this in the php page, not before calling it or previously urlencoding? --- While calling http://mysite.com/mypage.php?id=29d9f+Kr2/4=otherdata=xx ?php echo id = $id; ?

[PHP-DB] upload files into MySQL database

2004-05-11 Thread PHPDiscuss - PHP Newsgroups and mailing lists
Hello, I have problem for downloading files from MySQL database. Although I store and I see the filename and the extension in the database, when I try to download it, if there are blank spaces inside the filename, like my book store.doc I cannot open it and see it. Best regards Stelios Karapas

Re: [PHP-DB] Edit with notepad

2004-05-11 Thread Michael Forbes
Why not just provide them with two different links to the document-- one version includes the tag, the other doesn't. -Mike Forbes Ng Hwee Hwee wrote: hi, header(Content-type: application/vnd-ms.word); is not what my customers want. They may or may not want to save it in their harddisk.. but

[PHP-DB] Re: upload files into MySQL database

2004-05-11 Thread Michael Forbes
I've not run into this problem before, but the solution seems obvious: replace your filename spaces with underscores, or get rid of them completely. -Mike Forbes Phpdiscuss - Php Newsgroups And Mailing Lists wrote: Hello, I have problem for downloading files from MySQL database. Although I

[PHP-DB] Virtually Unbreakable

2004-05-11 Thread ICS Atlanta
The BEST encryption software in the world is now available! Virtually Unbreakable! Try To Break It Yourself! ICSAtlanta.NetFirms.Com (This is a one time mailing, you will not be contacted again)

Re: [PHP-DB] upload files into MySQL database

2004-05-11 Thread John W. Holmes
From: PHPDiscuss - PHP Newsgroups and mailing lists [EMAIL PROTECTED] I have problem for downloading files from MySQL database. Although I store and I see the filename and the extension in the database, when I try to download it, if there are blank spaces inside the filename, like my book

[PHP-DB] no temp var for mysql_fetch_array results

2004-05-11 Thread David T-G
Hi, all -- I have some code which looks about like if ( $_POST['signup']['referrer'] ) # a friend? { $q = select InvitedBy from customer where EMail = '{$_POST['signup']['referrer']}' ; $r = mysql_query($q,$dbro) ; $row = mysql_fetch_array($r) ; $i = $row[0] ; }

Re: [PHP-DB] no temp var for mysql_fetch_array results

2004-05-11 Thread jeffrey_n_Dyke
Hi, all -- I have some code which looks about like if ( $_POST['signup']['referrer'] ) # a friend? { $q = select InvitedBy from customer where EMail = '{$_POST['signup']['referrer']}' ; $r = mysql_query($q,$dbro) ; $row = mysql_fetch_array($r) ; $i =

Re: [PHP-DB] no temp var for mysql_fetch_array results

2004-05-11 Thread John W. Holmes
From: David T-G [EMAIL PROTECTED] $r = mysql_query($q,$dbro) ; $row = mysql_fetch_array($r) ; $i = $row[0] ; $r = mysql_query($q,$dbro) ; $i = mysql_result($r,0); ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Edit with notepad

2004-05-11 Thread Neil Smith [MVP, Digital media]
Just offer them a link to the next page. Put amp;format=word in as the query string if they choose the 'view word document' link or no query string if they choose the plain text view as html page. Then go for if ($_GET[format]=='word') { header(Content-type: application/vnd-ms.word); }

[PHP-DB] I'm new at PHP and MySQL and have a problem

2004-05-11 Thread news.php.net
To help me learn using these awesome tools together, I'm creating a sample application for myself - a movie database. In this database (which is named movies), I have five tables. One named moviemain, one named actors, one named genre, and then two tables that are designed to link these tables

[PHP-DB] Re: I'm new at PHP and MySQL and have a problem

2004-05-11 Thread Torsten Roehr
News.Php.Net [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] To help me learn using these awesome tools together, I'm creating a sample application for myself - a movie database. In this database (which is named movies), I have five tables. One named moviemain, one named actors,

[PHP-DB] Slow php-mysql

2004-05-11 Thread drez
Hi all, I recently change my apche, php mysql server for a better one. I installed all the same versions of software on the new server (except for php which was 4.36 RC2). I have apache 1.3 + mysql 3.23.58 + php 4.36. Im on a WinXp Pro os. I copy the exact config for the my.ini, httpd.conf and