[PHP-DB] Problem with InterBase

2001-12-14 Thread Vins
My DL will not load. I add my extension=php_interbase.dll in the php.ini file and the php console tells me it can't locate the file. What does that mean Please Help Me Thanks Vins [EMAIL PROTECTED] +27721807050 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

RE: [PHP-DB] parse error

2001-12-14 Thread matt stewart
the way to start this is to just add a couple of letters to the message and see if you're still getting an error - try (on line 357)... $message .=nobr\nHello world; keep it all on one line, and then see if you're still getting an error - if you are then i don't think this line is the one you

RE: [PHP-DB] Re: Dynamically populating a dropdown box

2001-12-14 Thread matt stewart
yep, that's basically what i use for this sort of thing - it's a nice short simple function, and works a treat. Obviously if you'd rather be passing the actual colour name to the next step, you use printf(option value=%s%s/option, $myrow[colorname], $myrow[colorname]); I also prefer to use

Re: [PHP-DB] parse error

2001-12-14 Thread +markus lervik
On Thu, 2001-12-13 at 23:49, Rob Day wrote: As far as I can see, you're missing '; in line 360, unless it continues further down and terminates the $message string there. Here is the offending code: 353 if ($moderation == no){ 354 $message .= checked; 355 } 356 357$message

[PHP-DB] Is MySQL enough for a huge amount of data?

2001-12-14 Thread Andy
Hi there, I am wondering if I could have MySQL as a DB for an Application which needs to have access a table of 1 Mio entries. And how long would it take to get an entry out of it. Asuming it contains only a name field and an id. e.g. select name from cities where provincial id = 2 If it

Re: [PHP-DB] Is MySQL enough for a huge amount of data?

2001-12-14 Thread Russ Michell
Did you go look at: www.mysql.com?? Russ On Fri, 14 Dec 2001 13:27:03 +0100 Andy [EMAIL PROTECTED] wrote: Hi there, I am wondering if I could have MySQL as a DB for an Application which needs to have access a table of 1 Mio entries. And how long would it take to get an entry out of it.

[PHP-DB] :: Problems With Interbase :: Please Help ::

2001-12-14 Thread Vins
Hi. I need help with Interbase. Here is my script... *~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~* ?php $database = ../../interbase_data/NAMES.GDB; $username = ADMIN; $password = ; $dbh = ibase_connect ($database, $username, $password); $stmt = 'SELECT * FROM name';

[PHP-DB] Re: Is MySQL enough for a huge amount of data?

2001-12-14 Thread Michel Laine
Andy wrote: Hi there, I am wondering if I could have MySQL as a DB for an Application which needs to have access a table of 1 Mio entries. And how long would it take to get an entry out of it. Asuming it contains only a name field and an id. e.g. select name from cities where

Re: [PHP-DB] Re: Is MySQL enough for a huge amount of data?

2001-12-14 Thread Miles Thompson
I'm Canadian, so when I see provincial_id I assume Canadian provinces. If so, we have only 12 provinces and territories (or is it 13 now with Nunavit?). On top of that, most of the population is in Ontario and Quebec, so you will likely get huge result sets on certain id's. MySQL, or almost

Re: [PHP-DB] :: Problems With Interbase :: Please Help ::

2001-12-14 Thread Daniel Ems
Hi Vins, Have you tried the database path without .. (i.e. /path/to/database/NAMES.GDB)? Have you tried defining the database like this? localhost:/path/to/database/NAMES.GDB I'm not sure these will work, but they are worth trying. Daniel Ems On Fri, 14 Dec 2001, Vins wrote: Hi. I need

[PHP-DB] mysql EXPLAIN

2001-12-14 Thread Sharmad Naik
How do i get all the info for mysql just the EXPLAIN statement in postgres -- Feel free to contact me (flames about my english and the useless of this driver will be redirected to /dev/null, oh no, it's full...). (Michael Beck, describing the PC-speaker sound device)

RE: [PHP-DB] Re: Dynamically populating a dropdown box

2001-12-14 Thread Andrew Chase
I also prefer to use printf(option value=\%s\ so it has the value in quotes - just a fussy html thing i do though. If you like your code to be legible in a browser's 'View Source' function (which can sometimes be helpful for debugging), you can also add a newline \n character to the end of

Re: [PHP-DB] Re: Dynamically populating a dropdown box

2001-12-14 Thread Ian Ferger
also, to get existing vals to show in the select as default, select name=colorz while($row=mysql_fetch_array($result)){ $selected=($row[ID]==$ID)?selected:; echo option value=' . $row[ID] . ' $selected . $row[name] . /option\n; } /select the value can be in single quotes also, altho i dont think

[PHP-DB] Re: Is MySQL enough for a huge amount of data?

2001-12-14 Thread Ian Ferger
mysql is better for quick and lightless overhead than postgress, less functionality too. overall, if you sit and tune it, you can get postgress to run better, but who has the time. Andy [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi there, I am

Re: [PHP-DB] Re: Dynamically populating a dropdown box

2001-12-14 Thread Richard S. Crawford
At the risk of sounding like a browser-snob... The quotes probably don't matter in IE, but that's primarily IE allows (and, in my opinion, encourages) bad coding practices. Your echo command really ought to look like this: echo option value=\ . $row[ID] . \ $selected . $row[name] . /option\n;

[PHP-DB] Page loading

2001-12-14 Thread Christopher Joseph
Apologies for xposting. Also for irrelevence I have three different php applications running on my web site in thre different directories. All display the pages correctly when I point my browser at them. I have just installed a fourth in a directory at the same subdirectory level as the others

[PHP-DB] How to get Session ID

2001-12-14 Thread Chris Payne
Hi there everyone, I know how to get the session ID in the url using ?=$SID?, but how do I copy the current SessionID into a Var? I need to store the sessionID so that I can reference items added to a database during a particular session, so people can continue shopping after they have added

[PHP-DB] Re: How to get Session ID

2001-12-14 Thread Ian Ferger
there is a very cryptic function for getting the session id: session_id() if you pass it a value, it will also set the id Chris Payne [EMAIL PROTECTED] wrote in message 000c01c184ef$53abc220$0200a8c0@chris">news:000c01c184ef$53abc220$0200a8c0@chris... Hi there everyone, I know how to get the

Re: [PHP-DB] Dynamically populating a dropdown box

2001-12-14 Thread Daniel Barton
Chris - You're getting already getting plenty of answers to this question - I only have one suggestion, which is that if you're not doing it already, just write a function or create an object that makes a dropdown box. I have a function and a class that I use for creating dropdowns. Well,

[PHP-DB] Strange PgExec() Error

2001-12-14 Thread Joe Koenig
I got a PgExec() error that said: Warning: PostgreSQL query failed: PQexec: you gotta get out of a COPY state yourself. What in the world does that mean? Thanks, Joe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

Re: [PHP-DB] Dumb Question??

2001-12-14 Thread Daniel Barton
Russ - Why not (MySQL) extract the field always, and code into your (php) generic mechanism whether or not a particular field under that name appears? Using mysql_fetch_assoc() you could exclude 'modified' from your generic mechanism under particular circumstances. This avoids coding it

RE: [PHP-DB] quetion about Win PHP mssql

2001-12-14 Thread Shane Peery
This is as far as we got on the question of W2k based PHP with mssql. Just wondered if anyone out there had any further questions. Thanks, Shane -Original Message- From: Shane Peery Sent: Thursday, December 13, 2001 1:35 PM To: 'Joshua Hoover' Subject: RE: [PHP-DB] quetion about Win

[PHP-DB] Re: Dumb Question??

2001-12-14 Thread Ian Ferger
$table = some_junk; $resultset=mysql_query(select blah ,blah from $table); Russ Michell [EMAIL PROTECTED] wrote in message news:SIMEON.10112131209.A@k1c. anglia.ac.uk... Hi there everyone: I have a genericphp/MySQL search+retrival mechanism. Generic in that it takes table names, fieldnames

[PHP-DB] List

2001-12-14 Thread Victor Bogdan C.
list

Re: [PHP-DB] Re: Dumb Question??

2001-12-14 Thread Daniel Barton
Don't think that was the question...? Ian Ferger wrote: $table = some_junk; $resultset=mysql_query(select blah ,blah from $table); Russ Michell [EMAIL PROTECTED] wrote in message news:SIMEON.10112131209.A@k1c. anglia.ac.uk... Hi there everyone: I have a genericphp/MySQL

[PHP-DB] Re: SQL problem is killing this newbie

2001-12-14 Thread Samios
Thanks Matthew, I can see the advantages of the table structure you recommend, but what would be the select statement to find people who have seen both Fear and loathing AND Monkey Town? Matthew Crouch [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... You need an

[PHP-DB] cURL not returning anything

2001-12-14 Thread Jonathan Hilgeman
I copied one of my PHP applications to a new server that is within a firewall. The new server is running PHP 4.0.6 and cURL 7.8.1. I use cURL to connect to a gateway and process credit card transactions. In any case, if I run curl from the command line with all the required POST fields, I get an

Re: [PHP-DB] :: Problems With Interbase :: Please Help ::

2001-12-14 Thread Daniel Barton
Vins, Have you tried sticking the path of the database relative to the server root in there? like: /home/vins/interbase_data/NAMES.GDB or: /var/interbase_date/NAMES.GDB etc. ? -db Vins wrote: Hi. I need help with Interbase. Here is my script...

[PHP-DB] Re: MYSQL query help

2001-12-14 Thread Fred
There are several ways to get around the lack of subselect support in mysql. For your situation you can simply use: SELECT * FROM lib_asset_tbl, lib_copy_tbl WHERE lib_asset_tbl.material_id '' AND lib_asset_tbl.asset_id = lib_copy_tbl.asset_id of course, this will return a row for every

Re: [PHP-DB] MYSQL query help

2001-12-14 Thread Miles Thompson
It's not the IN, it's the sub-query you cannot use. MySQL doesn't support them and it's just about the main reason I don't like it. Alternatives? You could execute your subquery and return the results to an array. Loop through the array, using the index and the indexed element to drive a

[PHP-DB] MYSQL query help

2001-12-14 Thread Harpreet
I dont think we can use 'IN' and 'NOT IN' in mysql. Is there an alternative that would work? select * from lib_asset_tbl where material_id '' and asset_id in (select asset_id from lib_copy_tbl) Help is appreciated. Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP

Re: [PHP-DB] Re: Dynamically populating a dropdown box

2001-12-14 Thread Paul DuBois
At 10:46 -0800 12/14/01, Richard S. Crawford wrote: At the risk of sounding like a browser-snob... The quotes probably don't matter in IE, but that's primarily IE allows (and, in my opinion, encourages) bad coding practices. Your echo command really ought to look like this: echo option

[PHP-DB] Re: :: Problems With Interbase :: Please Help ::

2001-12-14 Thread John Lim
Vins [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... $database = ../../interbase_data/NAMES.GDB; Sorry, this is a relative path, not a full path. The php manual says that the $database variable must be the full path the database file if it's location