Any idea how to extract table names for a database in informix - like the
sql for mysql SHOW TABLES;
??
J
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail
Anyone know where I can find documentation or sample-usage for metabase?
It's not on sourceforge or the metabase homepage.
Dean.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list
Hehe, sounds tricky.
There's prossibly a more elegant solution, but this one may work, aliasing
the master table a few times with different names:
SELECT s.*, r1.name, r2.name, r3.name
FROM schedule s, ref_master r1, ref_master r2, ref_master r3
WHERE s.ref1_id=r1.id
AND s.ref2_id=r2.id
AND
""Stuart J. Browne"" <[EMAIL PROTECTED]> wrote in message
98ujpk$i2j$[EMAIL PROTECTED]">news:98ujpk$i2j$[EMAIL PROTECTED]...
> > My first line of PHP code (embedded in HTML) has:
> >
> > $db = mysql_connect("x","y","z") or
> > die("saysomethinghere");
> >
> > If I have a connection problem, it do
> My first line of PHP code (embedded in HTML) has:
>
> $db = mysql_connect("x","y","z") or
> die("saysomethinghere");
>
> If I have a connection problem, it does print the
> "die" message and the connection error, but it also
> stops the page right there: no more HTML is displayed.
Well, you've
This has to be a basic question but I can't find it
answered anywhere; I'm probably not searching for the
right words or something.
I have a page that inserts some MySQL search results
in the middle of the page. My web hosting provider's
MySQL uptime is spotty. I'd like the rest of the page
to lo
I am retrieving values to form a shedule for referees. The master shedule
contains all info for a given date with three referees for that game. The
three referees are refrenced by their id number from the referee information
table. I am now stuck trying to figure out how to take the three refer
Are the fields always the same?
Ive used something similar, I usually fill an array with selection ids when
while loop them into querys-> To get the table I ussualy create a container
table(one cell) and generate tables inside the container one for each item.
-Original Message-
From: o
Greetings,
I would like to put together a script that results similar to www.bestbuy.com 's
compare feature. Basically if you are looking in an item category you can select
check boxes for each item you would like to compare. The results display like this;
ITEM 1 ITEM 2
Do you mean JOIN the tables and then SELECT?
>
> The best way to do this is to structure your SQL statement to grab both
> apartment and
> feature information into one recordset... this simplifies the code alot
and
> makes it easier to use.
>
> Ryan Flynn
> Practical web development/design
> www
Just a note...you can hash the password in the database.
Rick Emery wrote:
> First, I would NOT store passwords in a database. Rather, I'd store a hash
> based upon the password and username. Storing a password is dangerous as
> regards security.
>
> Second, if you're asking for syntax on
At 02:00 PM 3/16/2001 -0600, you wrote:
>First, I would NOT store passwords in a database. Rather, I'd store a hash
>based upon the password and username. Storing a password is dangerous as
>regards security.
Just to be a little picky and *not* to start an argument (discussion yes),
this reall
Okay, maybe this is simple, but I'm at wit's end. I have a drop down menu
(code follows) and I want it to show full name (i.e. John Doe) ordered by
last name. Works fine under normal circumstances, but then I need it to
write the email id associated with the full name to the database. It won
First, I would NOT store passwords in a database. Rather, I'd store a hash
based upon the password and username. Storing a password is dangerous as
regards security.
Second, if you're asking for syntax on how to add the security level column:
ALTER TABLE mytable ADD access tinyint unsigned no
Hi,
I've got a db with a username and password in it. I can let people log in,
like SELECT * FROM table WHERE username = username AND password = password.
But how can I add an access level column so that I can have different levels
of security. So admin's can read everything, but users can only
It is a little hard to advise on this without knowing the table schema, but
it is generally best to make the database do as much of the work as possible
rather than use logic in your script because databases are specifically
optimized for what they do. If I were trying to do what you are talking
I have setup php/linux/mssql and everything works execpt the MS SQL
connection. I don't get any errors returned to me, but it doesn't
connect. As far as I can tell it doesn't even try, but I can't tell at
what point it is breaking. I have used the freetds 0.51 libs to make
this connection since
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] ("Trond Erling Hundal") wrote:
> I want to query two tables in my db. One containing a list of numbers
> ranging from 1 - 10200, the other table is storing information that is
> relative to some of the numbers:
>
> Eks:
> Table1.record1: nu
On 16 Mar 2001, at 10:53, Vanstaen Laurent wrote:
> Hi all,
>Do you know if the php "crypt" function really works like the unix one ??
> I mean, when I compare my password on my system (crypted with unix crypt) and my
> password crypted with php crypt, it's not the same. And the php crypt do
Hi there...
I want to query two tables in my db. One containing a list of numbers
ranging from 1 - 10200, the other table is storing information that is
relative to some of the numbers:
Eks:
Table1.record1: number=1
Table2.record1: number=1 name=John
Now I want to query these to t
Hi,
I have some code which I decided to make into a function. Some of the code
updates a session var which holds the current time. It now does not work.
// update session variable with new time
session_register("LOGGED_IN['time']");
$LOGGED_IN['time'] = mktime();
Salt is the first two characters in a DES-encrypted
password. It is used as a modifier to
regularly-encrypted passwords to avoid the same
encryptions for similar passwords. You must extract
the salt first for your reference password, then use
it as a salt to encrypt the password you want
compared
BDY.RTF
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Hi evryone !
I have folowing error during execute my php3 script.
Warning: MySQL Connection Failed: Lost connection to MySQL server during query in
/home/sw81/public_html/miss_wiosna_01/info.php3 on line 59
This happened somtimes.
Can i do something with it ??
Ireneusz Piasecki
webmaster w
Hi all,
Do you know if the php "crypt" function really works like the unix one ??
I mean, when I compare my password on my system (crypted with unix crypt) and my
password crypted with php crypt, it's not the same. And the php crypt doesn't
send twice the same answer.
Laurent Vanstaen
--
P
As far as I can see:
>What does this mean?
>Parse error: parse error, expecting `','' or `';'' in
>/http/www/b/bidattorney.com/public_html/user/stest.phtml on line 13
This means probably on line 12 you forgot a semi-colon...
and so php goes on to parse the lines past where it expected a
semi-co
Publish first part of the php code so that we can see what's wrong in line
13 (or 12 sometimes).
Rudolf Visagie
[EMAIL PROTECTED]
-Original Message-
From: Marc S. Bragg [mailto:[EMAIL PROTECTED]]
Sent: 15 March 2001 10:39
To: [EMAIL PROTECTED]
Subject: syntax trouble
What does this mea
$year2 = substr($year,2,2)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 16 March 2001 09:06
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Using strings
Hi all
do you know how to delete the 2 first characters of a string. I have to
put a
string year in a datab
Members of the list, I'd like to apologize for this and assure you
that the email did NOT come from our domain nsmb.com. My headers
are useless in tracking this person down, but if someone could please
offer assistance off the list, please email me.
Regards.
[EMAIL PROTECTED] wrote:
>
> Websi
Hi all
do you know how to delete the 2 first characters of a string. I have to put a
string year in a database (4 digits year) and somewhere else I need only the
last two digits. How do I get them from my string "year" ?
Laurent Vanstaen
--
PHP Database Mailing List (http://www.php.net/
Hi Marc,
Try this - untested and I'm very sleepy, but should get you closer ;o)
Refresh Test
http://www.chescolawyers.com/BB/index2.shtml\">";
?>
Regards,
- Paul -
- Original Message -
From: "Marc Bragg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, M
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Marc,
On 16 March 2001 at 23:09:48 -0500 (which was 04:09 where I live)
Marc Bragg wrote to [EMAIL PROTECTED] and made these points:
MB> Crazy after hours of syntax. How do you insert php code so that on
MB> different results, 1 or 0, a differe
32 matches
Mail list logo