http://www.mysql.com/doc/E/X/EXPLAIN.html
Sharmad Naik wrote:
> How do i get all the info for mysql just the EXPLAIN statement in postgres
--
___ ____ _
Chris Hobbs / \ \/ / | | |/ ___\| __ \
Head Geek| (___ \ \ / /| | | | (___ | | |
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 loc
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 "" .
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 insta
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...
>
> *~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
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
i
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 n
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/M
list
$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,
> f
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 P
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 into
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: [
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, seve
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
Christopher:
I can guess two reasons:
a) You new directory has the same name as the directory in which php is
installed - regardless of where it sits on the system (true for windows). Sounds
odd, but I ran into this problem when I was goofing around on my development box
and called a http docs d
Hi there everyone,
I know how to get the session ID in the url using , 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 their i
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 a
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 "" . $row["name"] .
"\n";
Many coders even forget to put in the
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 wo
also, to get existing vals to show in the select as default,
while($row=mysql_fetch_array($result)){
$selected=($row["ID"]==$ID)?"selected":"";
echo "" . $row["name"] .
"\n";
}
the value can be in single quotes also, altho i dont think quotes matter
unless you use opera or some other wierdass b
> I also prefer to use printf(" 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 each option line
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 serie
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)
---
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
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
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
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
> wher
Hi.
I need help with Interbase.
Here is my script...
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
\n";
}
ibase_close ($dbh);
?>
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
The php manual says that the $database variable must be the full path the
database
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 o
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 works,
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
> 35
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("%s", $myrow["colorname"], $myrow["colorname"]);
I also prefer to use printf(" so it has the
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 .=">no\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 h
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: [
35 matches
Mail list logo
