Hi all
I sent a similar message yesterday, but I don't think it was clear enough,
so I'm trying again:
Basically, I want to know if it is possible to make PHP aware of
Interbase/Firebird *without* recompiling PHP.
If it is not possible, I'd like to know what option to pass PHP at configure
time
I don't know the reason (perhaps OS-based, since tables are implemented as
eponymous files), but it was a pretty awful idea to allow special chars in
names in the first place.
you probably have only two options, equally unpleasant:
- rename your tables and columns
- back-tick all your non-standard
Awesome, that you ALL for your help - the error is gone and I can post to
the DB now, and it works!
But... *grin*
Every time I access or refresh the page, it adds one blank entry to the DB.
Maybe I have the insert query in the wrong place?
"Matt Schroebel" <[EMAIL PROTECTED]> wrote in message
Yep, I wish I could name the fields, but alas it is not my database
application. For some reason it works... :)
When I use isql it works as expected, thus the problem.
At 10:41 PM 8/5/2003 -0400, John W. Holmes wrote:
Jeremy Peterson wrote:
I am having a problem with a query that has a pound
Anyone know how you set a lock in a MySQL table using PHP?
I tried:
$select = ³LOCK TABLES t1 WRITE;²;
$select .= ³select * from t1;²;
$select .= ³UNLOCK tables;¹;
When I run mysql_db_query(³db²,$select,$conn); it always returns nothing.
Any insights would be appreciated!
Thanks,
/T
Well I did what you said, and now I get "Parse error: parse error,
unexpected T_ECHO in C:\FoxServ\www\encana_db.php on line 44"
And magic_quotes_gpc was already ON.
"Matt Schroebel" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> -Original Message-
> From: Jeff [mail
Michael,
You can select the Database to run the queries on by using
mysql_select_db($dbname) after you have connected. for example:
$link = mysql_connect($host, $username, $password);
mysql_select_db($dbname, $link);
$query = "INSERT INTO $table ('joe', 15)";
if(mysql_query($query, $link)) {
>From what I can see is that you're not actually looping anything?
while( !$done ) {
$row = mysql_fetch_row( $result );
if( !$row ) {
$done = 1;
}
This doesn't loop through your query, least not in my eyes it doesn't.
Why not:
while ($rows = mysql_fetch_array
