Re: [PHP-DB] PHP4 LDAP

2002-03-21 Thread Matt Williams
On Wednesday 20 March 2002 17:15, David Christensen wrote: The problem arises when I try to read back all of the attributes within the PHP script.  I can see only certain attributes: uid, mail, cn (the normal stuff) but if I try to read these fields that I want to use for the session, they

Re: [PHP-DB] order by problem

2002-03-21 Thread guslist
Thank you all for the Tip ! It works fine now !! :) Gus - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, March 20, 2002 10:32 AM Subject: Re: [PHP-DB] order by problem On Wed, 20 Mar 2002 [EMAIL PROTECTED] wrote: You have

[PHP-DB] Selecting Alphabetically

2002-03-21 Thread Jordan Elver
Hi, Could anyone point me in the right direction with this one please. I have a table of records wit a field of artists. I want to select all the records which begin with the letter a-h then i-p etc What is the best way to do this? Cheers, Jord -- PHP Database Mailing List

Re: [PHP-DB] Selecting Alphabetically

2002-03-21 Thread Andrey Hristov
select * from sometable where (SUBSTRING(somefield,1,1) in ('a','b','c','d','f','g','h')) AND (SUBSTRING(somefield,2,1) in ('i','j','k','l','m','n','o','p')); Best regards, Andrey Hristov - Original Message - From: Jordan Elver [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday,

[PHP-DB] Re: Output of curl to an array.

2002-03-21 Thread Adam Royle
Hi Keith, I read your post and decided to write a function for you. Basically what it does is does, is take in a string, and optional newline and value separators, and outputs an associative array. It actually works, and has a few comments... so yeah, enjoy.. and thanks for the challenge : )

[PHP-DB] Relational database

2002-03-21 Thread Ron
I am trying to get fields from 2 different tables that have the same field name to pull the records from one table For example mysql_connect($DBhost,$DBuser,$DBpass) or die(Unable toconnect to database); mysql_select_db($DBName) or die(Unable to select database $DBName); $sqlquery1 =

RE: [PHP-DB] Relational database

2002-03-21 Thread Hunter, Ray
Try this: SELECT ccsd.Description, ccsd.Impact, ccsd.Isolation FROM ccsd, log WHERE ccsd.logccsd=log.logccsd; You cannot specify a database is = to a row... Thank you, Ray Hunter Firmware Engineer ENTERASYS NETWORKS -Original Message- From: Ron [mailto:[EMAIL PROTECTED]] Sent:

Re: [PHP-DB] Relational database

2002-03-21 Thread Andrey Hristov
The info is not full but I'll try to help. Lets say the name of the field in the two tables is common_field. Then we do SELECT all_that_is_needed FROM table1,table2 WHERE table1.common_field=table2.common_field; And an optimized variant: SELECT all_that_is_needed FROM table1 LEFT JOIN table2

[PHP-DB] Re: major performance disparities with mysql/php - SOLVED

2002-03-21 Thread Henry Hank
Nevermind.. I found the problem. My production server is running mysql 3.22.29, and I needed to use a SET SQL_BIG_TABLES=1 in many places to prevent a full table condition. The new server is running 3.23, and once I removed the SQL_BIG_TABLES=1 from the script (and allowed mysql to use memory

[PHP-DB] Re: Relational database

2002-03-21 Thread Ron
SELECT ccsd.Description, ccsd.Impact, ccsd.Isolation FROM ccsd, log WHERE ccsd.CCSD=log.logccsd I have tried this and the code and now I get to where it include variable from the table, but it is the wrong record??? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: Relational database

2002-03-21 Thread Ron
Is there a way under mysql to identify the last record in a table so that I can pull information that I need from that entry. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Relational database

2002-03-21 Thread Hugh Bothwell
Ron [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Is there a way under mysql to identify the last record in a table so that I can pull information that I need from that entry. Um... sort backwards then use the first record (ie LIMIT 1)? -- PHP Database

[PHP-DB] phpMyAdmin

2002-03-21 Thread James Kupernik
I'm trying to load phpMyAdmin on, and it seems to work fine, but when I browse a table and run my mouse over the contents of that table I get a jazascript error. Does anyone know a solution for this problem? I doesn't happen in the earlier version of phpMyAdmin .. just this later version. Any

[PHP-DB] Re: Relational database

2002-03-21 Thread Ron
But can you do that in PHP before you pull info from it -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: phpMyAdmin

2002-03-21 Thread James Kupernik
Nevermind ... I found the problem! (slamming head against desk) James Kupernik [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'm trying to load phpMyAdmin on, and it seems to work fine, but when I browse a table and run my mouse over the contents of that

RE: [PHP-DB] Re: Relational database

2002-03-21 Thread Rick Emery
What do you mean last record in a table? What are you REALLY trying to do here? Do you want the last entry made according to a specific criteria? -Original Message- From: Ron [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 9:20 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re:

RE: [PHP-DB] Re: Relational database

2002-03-21 Thread Rick Emery
Huh -Original Message- From: Ron [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 9:30 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Relational database But can you do that in PHP before you pull info from it -- PHP Database Mailing List (http://www.php.net/) To

RE: [PHP-DB] Selecting Alphabetically

2002-03-21 Thread Rick Emery
SELECT * FROM mytable WHERE record_name REGEXP ^[a-h] -Original Message- From: Jordan Elver [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 6:05 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Selecting Alphabetically Hi, Could anyone point me in the right direction with this one

[PHP-DB] Re: Relational database

2002-03-21 Thread Ron
I have a database and under that database I have 2 tables. Log (which is an event reporting log) under Log there is field called 'logccsd' CCSD (which is what identifies our circuits) under CCSD there is a field called 'CCSD' When I use my mysql statement I pull all records that match my

[PHP-DB] ODBC -- Setting ApplicationID

2002-03-21 Thread Bruce S. Garlock
I am trying to set the ApplicationID, when connecting to an ODBC datasource. I have tried: odbc_setoption ($conn, 1, 1053, PHPAPP); And get a: SQL error: [iODBC][Driver Manager]Option type out of range, SQL state S1092 in SetConnectOption Basically, I want my PHP script to pass the

[PHP-DB] PHP and HTML problems

2002-03-21 Thread Bzdpltd
HI People, I do not use dreamweaver normally, but have to do a few changes and add some php code to this site. I wonder if someone could quickly look at the attached php page, and look at the navigation i use and see why it is looping within the html. Basicall I need the records to look but

[PHP-DB] Re: major performance disparities with mysql/php

2002-03-21 Thread John Lim
Hi Henry. I have a suggestion. Run in a seperate window top d 1 with php running or mysql client and compare what happens. I presume that X-windows and similar mem/cpu hogs are disabled. Do post your results please. This should be interesting. Regards, John Henry Hank [EMAIL PROTECTED] wrote

[PHP-DB] LAST_INSERT_ID()

2002-03-21 Thread Morten Nielsen
Hi, In the PHP manual under the function mysql_insert_id() function they have the following line: The value of the MySQL SQL function LAST_INSERT_ID() always contains the most recently generated AUTO_INCREMENT value, and is not reset between queries. How do I get to use the function

RE: [PHP-DB] LAST_INSERT_ID()

2002-03-21 Thread Rick Emery
use mysql_last_id() -Original Message- From: Morten Nielsen [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 2:30 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] LAST_INSERT_ID() Hi, In the PHP manual under the function mysql_insert_id() function they have the following line: The

Re: [PHP-DB] Relational database

2002-03-21 Thread Mike Maltese
Try this: SELECT Description, Impact, Isolation FROM ccsd NATURAL JOIN log or SELECT Description, Impact, Isolation FROM ccsd LEFT JOIN log USING(logccsd) Just add on a WHERE conditional to get the required results if necessary. - Original Message - From: Ron [EMAIL PROTECTED] To:

RE: [PHP-DB] LAST_INSERT_ID()

2002-03-21 Thread Rick Emery
I mean: mysql_insert_id() -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 2:28 PM To: 'Morten Nielsen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] LAST_INSERT_ID() use mysql_last_id() -Original Message- From: Morten Nielsen

[PHP-DB] Resizing images stored in a mysql db

2002-03-21 Thread Jose Miguel Selman
I made a script for retrieving the data of some jpeg images stored in a mysql database.I can get the image and print it on the screen... I have to resize some of them according to their size in order to create thumbnails on the fly. The GetImageSize function receives the image's path or url. As I

[PHP-DB] Re: [PHP] Temporary MySQL Tables

2002-03-21 Thread John S. Huggins
On Thu, 21 Mar 2002, Georgie Casey wrote: -Hi, - -membership with the username and timestamp in the URL. The users clicks it, -and I run a SQL command that copies the row from tempmembers into the -members table. I assume you are building up all your fields as you move through the site. I would

[PHP-DB] Temporary MySQL Tables

2002-03-21 Thread Georgie Casey
Hi, On my site now, there's a lengthy register process where the user has to fill in 5 forms, one after the another. I get the PHP script to echo the values from the previous into the next form by using ?php echo input type=\hidden\ name=\name\ value=\ . $name . \; ? for example. Then I keep