[PHP-DB] MySQL - Query within a query
I am looking to do the following w/ MySQL and PHP. Have 1 query that gets results, then use those results in another query: $l = 2; $result1 = ("SELECT * FROM Drivers WHERE League = $l"); $result2 = mysql_query("SELECT DriverID, Driver, CarNbr FROM Drivers LEFT JOIN $LeagueList ON Drivers.DriverID = $Result1.DriverID WHERE $Result1.DriverID) Is Null ORDER BY Drivers.DriverID"); I can do it w/ Access and MSSQL, but if I try in MySQL, i get an error, both in DBManager (MySQL interface), and in PHP. Any help is appreciated. Thanx! Pete -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] undefined function error
It could be possible that mySQL is not enabled in your installation of PHP. Let the server parse a page with phpinfo() in it and read the results. Look for mySQL enabled. Perhaps the reason it runs fine on another server is that the php on that server has mysql enabled. HTH, Mark Cain - Original Message - From: "Chip Wiegand" <[EMAIL PROTECTED]> To: "PHP DB" Sent: Friday, March 18, 2005 4:53 PM Subject: [PHP-DB] undefined function error > I have a web site that connects to a mysql database using this connect > script - > >mysql_select_db("simradusa",$db); > ?> > > When I access the page it gives me this error - > > Fatal error: Call to undefined function: mysql_connect() in > /usr/local/www/data-dist/connect on line 1 > > Using mysql-4.1.10a for FreeBSD-5.3 with php-4.3.9 > > Any idea why I'm getting this error? (the same connect string works fine > on a differant web server running FreeBSD-5.2.1/php-4.3.6/mysql-3.23.49) > > Thanks, > Chip > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] dynamic data manipulation in form
You can try tinyMCE http://moxiecode.com/downloads_tiny_mce.php Mark Cain - Original Message - From: "Doug Finch" <[EMAIL PROTECTED]> To: "phpdb-list" Sent: Friday, March 18, 2005 4:42 PM Subject: [PHP-DB] dynamic data manipulation in form > I have a script that I have written in PHP that is a basic form that > inputs simple text into a mysql db. One section is just a textarea > value that I would like to be able to add some dynamic formatting to the > text being entered if the user wants. For example, I want to give the > user the ability to be able to highlight the text and click on a > paragraph tag and it automatically insert that tag - or a bold, itallic, > underline, etc. I have searched the web but came up empty-handed. Any > ideas? I don't even know where to begin. > thanks, > Doug > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] undefined function error
from the php manual [quote] This MySQL extension doesn't support full functionality of MySQL versions greater than 4.1.0. For that, use MySQLi. [/quote] http://ca3.php.net/manual/en/ref.mysqli.php bastien From: Chip Wiegand <[EMAIL PROTECTED]> To: "PHP DB" Subject: [PHP-DB] undefined function error Date: Fri, 18 Mar 2005 13:53:08 -0800 I have a web site that connects to a mysql database using this connect script - When I access the page it gives me this error - Fatal error: Call to undefined function: mysql_connect() in /usr/local/www/data-dist/connect on line 1 Using mysql-4.1.10a for FreeBSD-5.3 with php-4.3.9 Any idea why I'm getting this error? (the same connect string works fine on a differant web server running FreeBSD-5.2.1/php-4.3.6/mysql-3.23.49) Thanks, Chip -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] undefined function error
I have a web site that connects to a mysql database using this connect script - When I access the page it gives me this error - Fatal error: Call to undefined function: mysql_connect() in /usr/local/www/data-dist/connect on line 1 Using mysql-4.1.10a for FreeBSD-5.3 with php-4.3.9 Any idea why I'm getting this error? (the same connect string works fine on a differant web server running FreeBSD-5.2.1/php-4.3.6/mysql-3.23.49) Thanks, Chip -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] dynamic data manipulation in form
You can add bbcode or for true 'wow 'em' factors, use htmlarea (www.htmlarea.com) bastien From: Doug Finch <[EMAIL PROTECTED]> To: phpdb-list Subject: [PHP-DB] dynamic data manipulation in form Date: Fri, 18 Mar 2005 15:42:18 -0600 I have a script that I have written in PHP that is a basic form that inputs simple text into a mysql db. One section is just a textarea value that I would like to be able to add some dynamic formatting to the text being entered if the user wants. For example, I want to give the user the ability to be able to highlight the text and click on a paragraph tag and it automatically insert that tag - or a bold, itallic, underline, etc. I have searched the web but came up empty-handed. Any ideas? I don't even know where to begin. thanks, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] dynamic data manipulation in form
I have a script that I have written in PHP that is a basic form that inputs simple text into a mysql db. One section is just a textarea value that I would like to be able to add some dynamic formatting to the text being entered if the user wants. For example, I want to give the user the ability to be able to highlight the text and click on a paragraph tag and it automatically insert that tag - or a bold, itallic, underline, etc. I have searched the web but came up empty-handed. Any ideas? I don't even know where to begin. thanks, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Problems with 4.3.10 and SQL Server
Hi There are serious bugs in mssql support in 4.3.10. Get the latest snapshot from CVS and update php_mssql.dll http://snaps.php.net/ "Aifoundations.Org" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >I don't see many SQL Server posts here but I will give it a shot. I am > using PHP 4.3.10, SQL Server 2000, and W2000. > > I have had no problems with scripting against PHP 5.x but I have had > real problems when running these same scripts against 4.3.10. > > For example, all my select and insert statements do nothing. > Submitting truncate commands against the database work, but a simple > query like "insert into input values('$lines')" do nothing. Again, I > have had no problems with 5.x. Any general suggestions or tricks to > try. I have tried things such as fully quoting table names, bracketing > the name, using 2 single quotes instead of 1. None of these > suggestions work however. > > Jim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] String pictures in MySQL
examples of how to get them into the db (use a blob field) http://www.weberdev.com/get_example-4063.html and get the out http://www.weberdev.com/get_example-4062.html bastien From: Bunmi AKinmboni <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] String pictures in MySQL Date: Fri, 18 Mar 2005 05:32:05 +0100 I want to store picture in a MySQL field. What type do I call the field and any guide or link on the net to tell me how to store the picture? Bunmi from Lagos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] ocilogon timeout
Hi, Some of our scripts that generate customer-facing pages, need a connection to a database. The problems is that the database is in Norway and - allthough we have a VPN setup - the connection isn't always available. In case the connection cannot be made, we can redirect the customer to a nice error page and ask them to try again later. That's not too hard. The issue is that it takes really really long before ocilogon returns if the connection cannot be established. Is it possible to set a timeout on ocilogon (like you can with eg fsockopen)? Rgds, Jos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php