[PHP-DB] Interbase queries

2003-07-31 Thread Evan Morris
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?

[PHP-DB] mySQL help on win xp

2003-07-31 Thread John Ryan
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

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

2003-07-31 Thread Aaron Wolski
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

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

2003-07-31 Thread Hutchins, Richard
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) then

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

2003-07-31 Thread Hutchins, Richard
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

2003-07-31 Thread Roberto Dragva Filho
Hello, how can i search for a data in Mysql database calling a PHP function in field propeties ?? example: ?php echoinput type='text' name='ID' size='20' onBlur=SEARCH_ID(); ;? is this valid ?? thanks roberto --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system

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

2003-07-31 Thread Larry R. Sieting
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