[PHP-DB] build drop-down pick from MYSQL table

2001-04-12 Thread Quentin Krengel
I’m very new to PHP (coming from shell programming) and have a very easy question… :-) I have found examples of building a dropdown list, and have found examples of reading a mysql table, but am looking for examples of creating a drop-down list with the results of a mysql query. Ie, I have an

[PHP-DB] substring_index Part 2

2001-04-12 Thread Mike Baerwolf
Thanks for the help on the earlier ?. Now that I have the select statement working I can't get any results displayed. $result = mysql_query("SELECT substring_index(body, \".\" ,2) FROM news",$db) or die ("Invalid Query"); if ($myrow = mysql_fetch_array($result)) { do {

Re: [PHP-DB] build drop-down pick from MYSQL table

2001-04-12 Thread Paul Burney
on 4/12/01 8:40 AM, Quentin Krengel ([EMAIL PROTECTED]) wrote: I have found examples of building a dropdown list, and have found examples of reading a mysql table, but am looking for examples of creating a drop-down list with the results of a mysql query. Ie, I have an admin screen where

Re: [PHP-DB] substring_index Part 2

2001-04-12 Thread Paul Burney
on 4/12/01 9:53 AM, Mike Baerwolf ([EMAIL PROTECTED]) wrote: $result = mysql_query("SELECT substring_index(body, \".\" ,2) FROM news",$db) or die ("Invalid Query"); if ($myrow = mysql_fetch_array($result)) { do { printf("%s\nbr", $myrow["headline"]); printf("%s\n", $myrow["body"]);

[PHP-DB] Fatal error: Call to unsupported or undefined function mysql_connect()

2001-04-12 Thread franky
I'm trying to connect to mySQL DB by Web page and when I use mysql_connect() this append: Fatal error: Call to unsupported or undefined function mysql_connect() thanks! Franky [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] Fatal error: Call to unsupported or undefined function mysql_connect()

2001-04-12 Thread Brian S. Dunworth
Such patience! You waited nearly 7 whole minutes before reposting your message! I don't run MySQL, so I'm not sure... but it looks like you probably don't have MySQL support in your version of PHP. Try: ?php phpinfo(); ? ...and see if it says you do. At 12:44 PM 4/13/01 -0400, franky

Re: [PHP-DB] Fatal error: Call to unsupported or undefined function mysql_connect()

2001-04-12 Thread B. van Ouwerkerk
Such patience! You waited nearly 7 whole minutes before reposting your message! I don't run MySQL, so I'm not sure... but it looks like you probably don't have MySQL support in your version of PHP. Try: ?php phpinfo(); ? Also, include some more code.. Or even better, check out some of the

[PHP-DB] add php to apache

2001-04-12 Thread franky
Can I add to the actual serveur apache? With somthing like this: ./configure --with-php=../php or more complicate... Franky [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

Re: [PHP-DB] add php to apache

2001-04-12 Thread B. van Ouwerkerk
./configure --with-php=../php or more complicate... More complicated. You really should check www.devshed.com you can find more on how to install MySQL, PHP and Apache. Bye, B. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [PHP-DB] sessions and page has expired warning

2001-04-12 Thread Phil Jackson
Here, I think you may be over - using session variables a bit...have not used them in php, as I have version 3, which doesn't support them. However, by day I am an ASP developer, and article after article I read warns about session variables! They are great, but can hog memory, especially if

[PHP-DB] oracle 8i client/ PHP 4.0.4pl1 breaks

2001-04-12 Thread Dave Thomas
Here's the scoop: Goal: to connect apache 1.3.19/PHP to remote Oracle server. Background: I downloaded Oracle 8.1.7 and installed the default Client configuration. Machine is an SMP Mandrake 7.0 Linux 2.2.14. PHP is 4.0.4pl1. Synopsis: I configure and make php even with the cleanest

Re: [PHP-DB] Uploading file into database

2001-04-12 Thread Phil Jackson
Hi, ok, first of all make sure your form tag is like : form method="POST" name="ImageForm" action="UploadImage.php3" ENCTYPE="multipart/form-data" The ENCTYPE is important! Next, make sure you have a field like: input type="file" size="50" name="txtImage" type="file" is important! This will