[PHP-DB] Interbase queries

Hi I am new to using PHP with Interbase. If I want to issue a query, I use: $sth = ibase_query ($dbh, $sqlstmt); I am assuming this issues the query to the database, and commits at the same time? Do I need to release anything after having done this, or does it take care of that by itself? Than

[PHP-DB] mySQL help on win xp

i installed php and apache fine on my pc, but mysql is giving problems. in winmysqladmin, you cant create a adb on the databases tab. all that lets you do is flush threads, flush processes, etc. so i had to create my database through the mysql command line. also, phpMyAdmin doesnt work, it returns

[PHP-DB] updating a column based on info from another coluimn? Desperate!

Hi All, This is OT but I am in need of serious help. I am rewriting URL's for a site and came across an issue with spaces in URLS having %20 applied to them. I can't seem to find a solution with mod_rewrite to get rid of the %20 and replace with - (hyphen) so I am hoping someone can help me her

RE: [PHP-DB] updating a column based on info from another coluimn? Desperate!

Will urldecode() work for you on the PHP side or do you have to convert everything in the database? http://us4.php.net/manual/en/function.urldecode.php > -Original Message- > From: Aaron Wolski [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 31, 2003 3:14 PM > To: [EMAIL PROTECTED] > Sub

RE: [PHP-DB] updating a column based on info from another coluimn ? Desperate!

Or rawurldecode()? http://us4.php.net/manual/en/function.rawurldecode.php > -Original Message- > From: Hutchins, Richard [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 31, 2003 3:21 PM > To: [EMAIL PROTECTED] > Subject: RE: [PHP-DB] updating a column based on info from another > coluimn

RE: [PHP-DB] updating a column based on info from another coluimn? Desperate!

Hey hey, Works like a charm. I have have my urls looking like The+Man+on+The+Moon Seems weird, however, PHP automatically strips out the +'s? cause when I echo the variable I get The Man On The Moon. Idea's? Also.. ANYWAY to make the +'s into -'s (hyphens)??? Thanks!! Aaron -Original Me

RE: [PHP-DB] updating a column based on info from another coluimn? Desperate!

This note from http://us4.php.net/manual/en/function.rawurldecode.php might explain what you're seeing if you're using urldecode() "Note: rawurldecode() does not decode plus symbols ('+') into spaces. urldecode() does. " If you start out with $url = "The+Man+On+The+Moon" and you urldecode($url) t

RE: [PHP-DB] updating a column based on info from another coluimn ? Desperate!

Sorry, I'm only reading half posts today. :) If you want to turn your + into - you'll probably have to go through one more step and do a preg_replace(). Like $new_url = preg_replace("+","-",$url); I think that'll work. Again, shooting from the hip and not testing. Yeah, baby, livin' on the wild

[PHP-DB] Seach for data calling function in field

Hello, how can i search for a data in Mysql database calling a PHP function in field propeties ?? example: is this valid ?? thanks roberto --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.504 / Virus Database: 302 - Release

Re: [PHP-DB] mySQL help on win xp

At 07:44 PM 7/31/2003 +0100, John Ryan wrote: i installed php and apache fine on my pc, but mysql is giving problems. in winmysqladmin, you cant create a adb on the databases tab. all that lets you do is flush threads, flush processes, etc. so i had to create my database through the mysql command l