Re: [PHP-DB] Selection an id from a table where it doesn't exisit in another

Hi, I think this should do the job SELECT words.id FROM words left join searchwords on words.id = searchwords.word_id where searchwords.word_id is Null; Let me know if it is OK. Dobromir Velev -Original Message- From: Scott Mebberson <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PR

[PHP-DB] Re: General PHP problem

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Ali Nayeri) wrote: > >> File php1.php > print("Hi $name"); > > >>File test.htm > > > Name: Check phpinfo(): is the option "register_globals" turned on? See for more info... You may always want t

[PHP-DB] RE: General PHP problem

>> File php1.php PHP test Hi $name"); ?> >>File test.htm Test Name: Thanks Ali _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To uns

[PHP-DB] Re: General PHP problem

Hi again, I thought maybe the example files would be useful. They're attached. Ali -- 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]

[PHP-DB] Re: Oracle takes 5 seconds to logon in PHP, ASP is instant??? Wussup?

I did, an unfortunitly no difference. I am running PHP4.0.6 on win2k using iis5. Anyone else experiance anything like this? "Manuel Lemos" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hello, > > Bawy wrote: > > > > > $db = "newora"; > > $c2 = ocilogon("cs

RE: [PHP-DB] SELECT giving too much :)

Hi Beau-- Alternatively you could probably include an AND for the location ID to link up with whatever it is supposed to link up to in the WHERE clause. But I have no idea how you responded to my message in 2 minutes flat! Are you a remarkably complex AI autoresponder that knocks the socks off

RE: [PHP-DB] SELECT giving too much :)

Actually yes I do :) thanks for that - it fixes it when i remove the "FROM locations" although I didn't want to have to pull it, because it is going to mean some ugly testing and stuff that I wanted to avoid - oh well, looks like I have no choice now :) Cheers beau // -Original Message-

Re: [PHP-DB] SELECT giving too much :)

Hi Beau-- This is just a wild guess (I've only glanced at your SQL), but do you have two locations in your locations table? You might want to try yanking locations out of the join since you're not using it in your WHERE clause or showing any info from it. Doug At 12:06 PM 8/30/01 +0800, Beau L

[PHP-DB] General PHP problem

Hi guys I know that this actually doesn't belong here but I had a question that I think has to do with installation and configuration. I volunteer at this FreeNet group and the SysAdmin there recently installed PHP 4 on an Apache server on a Solaris Box. But when I tried to test it, I found some

Re: [PHP-DB] Date_Format Question

- Original Message - From: boclair <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; PHP-DB <[EMAIL PROTECTED]> Sent: Thursday, August 30, 2001 1:09 PM Subject: Re: [PHP-DB] Date_Format Question > > - Original Message - > From: Jeff Oien <[EMAIL PROTECTED]> > To: PHP-DB <[EMAIL PROTE

[PHP-DB] SELECT giving too much :)

Hi guys, I have a set-up to query a database by allowing the user to build a query from selecting fields, restrictions etc etc. It produces the following; SELECT students.fname, courses.title AS course FROM students, courses, course_enrolments, groups, locations, staff WHERE (students.studentID=

RE: [PHP-DB] Date_Format Question

Isn't that what I tried? Jeff Oien > Although it might be better to format the date in php, don't forget you can > also do date formating in the select string. The date format functions for > mySQL can me found here: > > http://www.mysql.com/doc/D/a/Date_and_time_functions.html > > Hope this h

Re: [PHP-DB] Date_Format Question

- Original Message - From: Jeff Oien <[EMAIL PROTECTED]> To: PHP-DB <[EMAIL PROTECTED]> Sent: Thursday, August 30, 2001 11:07 AM Subject: [PHP-DB] Date_Format Question > I have a date like this in date format in MySQL > 2001-08-29 > > and I want it to say > August 29, 2001 > > I tried t

[PHP-DB] Selection an id from a table where it doesn't exisit in another

Hi Guys, I have two tables, words and searchwords. words contains a list of words with an id number next to them and searchwords contains a page id with a word id (from the words table). I want to select all of the id's from the words table which does not exist in the word_id feild in the searchw

[PHP-DB] Date_Format Question

I have a date like this in date format in MySQL 2001-08-29 and I want it to say August 29, 2001 I tried this and it didn't work. select date_format('creation_date', '%b %D, %Y') from Chart_Users; Could you tell me what I'm doing wrong or how I should do this? Thanks. Jeff Oien -- PHP Databas

[PHP-DB] Re: example of making "Next 10 entries" - "previous .."

Andrius Jakutis wrote: > > Hello, > > I need example of making simple thing: to list only 10 entries per page, and > next 10 is shown after "next page" button is clicked. > > Thanks Look in www.phpbuider.com for a article about previous/next buttons. Alex -- PHP Database Mailing List (http:/

[PHP-DB] Re: Oracle takes 5 seconds to logon in PHP, ASP is instant??? Wussup?

Hello, Bawy wrote: > > $db = "newora"; > $c2 = ocilogon("cst","cst",$db); > echo "done"; > ?> > This takes 5 seconds to appear, what is wrong? An ASP script I wrote > connects instantly. TNSPING shows newora to be OK and responds instantly. Try OCIPlogon. Regards, Manuel Lemos -- PHP Databa

[PHP-DB] Oracle takes 5 seconds to logon in PHP, ASP is instant??? Wussup?

This takes 5 seconds to appear, what is wrong? An ASP script I wrote connects instantly. TNSPING shows newora to be OK and responds instantly. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To c

Re: [PHP-DB] example of making "Next 10 entries" - "previous .."

Here is an excellent example at PHPBuilder (a great site for finding tutorials) http://www.phpbuilder.com/columns/rod2221.php3 HTH Maureen Andrius Jakutis <[EMAIL PROTECTED]> said: > Hello, > > > I need example of making simple thing: to list only 10 entries per page, and > next 10 is

[PHP-DB] example of making "Next 10 entries" - "previous .."

Hello, I need example of making simple thing: to list only 10 entries per page, and next 10 is shown after "next page" button is clicked. Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

Re: [PHP-DB] Tablename issue..

Tried this - same errors -- Also tried the following permutations (courtesy of Trevor Lanyon) -- You can try to encapsulate the table name with hard bracket [Table - Name] You can escape the character with a slash (I don't think this will work): Table\ \- Name You can escape the characters

Re: [PHP-DB] MD5 (' ')

> - Original Message - > From: "Ignat Ikryanov" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, August 29, 2001 4:45 PM > Subject: [PHP-DB] MD5 (' ') > > > Hi! > I use md5 function to encrypt users password stored in MySql database. > When I try encrypt string 'asdf' using

RE: [PHP-DB] Tablename issue..

Try putting Brackets [] around the spaces. This will typically fix the problem, ie: $sql2 = odbc_exec($conn,"SELECT [Character Field] FROM [ABC - Table]"); Let me know if it works! Ryan -Original Message- From: Tom Wallace [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 3

[PHP-DB] Tablename issue..

Hola, I'm having a difficult time figuring out the syntax here -- my table name has spaces & dashes in it..Unfortunately I can't permanently change the tablename.. I've tried a half dozen different ways to access the table, each return an error similar to this: Warning: SQL error: [ISAM]No dat

Re: [PHP-DB] Pleazzzzzz Help.

Start with tutorials at http://www.thickbook.com (The one on customized error messages is v. good.) and also at WebMonkey, DevShed, PHPBuilder and Zend When you say "email a template", do you mean a standard response with the blanks filled in? The tutorials will get you started, but might also

[PHP-DB] Pleazzzzzz Help.

How do I creat a form that submits the collected information to a databas (MySQL) And email a template to the submitter with the collected information and to a few other parties based on seprate templates for the E-Mail? Please help... -Jason [EMAIL PROTECTED] -- PHP Database Mailing List (ht

[PHP-DB] RE: Could get all data from MYSQL using Mysql_fetch_array!!

You did fetch all the data by using '*' in your query, but you can't use '*' as a wildcard when referring to an associative array (which is what $row is) - you need to step through each key in the array: while ($row= mysql_fetch_array($result,MYSQL_ASSOC)) { $fields = array_keys($row);

Re: [PHP-DB] Database "Transactions" and HTTP statelessness

Hi BP-- There's also named cursors, but then you're going to have the problem of time. That is if you create a cursor FOR UPDATE and the user never saves the record or never cancels the edit (just closes her browser, for instance), then you're messed up and have locks floundering around in the d

Re: [PHP-DB] MD5 (' ')

MD5 doesn't use a salt. http://www.faqs.org/rfcs/rfc1321.html Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: "Andrey Hristov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 10:10 AM Subject: Re:

Re: [PHP-DB] MD5 (' ')

I had a similar problem. I think it has to do with the character encoding of the output hash. My only resort (very ugly!!) was to have a perl script wich calculated the hash. The perl script looks like: #!/usr/bin/perl use Digest::MD5 qw(md5_base64); print md5_base64($ARGV[0]); Maybe your pro

Re: [PHP-DB] Couldn't get all data using the "mysql_fetch_array" function, Pls Help!!!!

while ($row= mysql_fetch_array($result,MYSQL_ASSOC)) { foreach ($row as $value){ print ("$value |"); } } - Original Message - From: "Jack" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 6:16 PM Subject: [PHP-DB] Couldn't get all data using

[PHP-DB] trip-database and PHP

Is someone heard something about trip-database? And if anyone knows how I can get connection with PHP to trip-database I would be grateful. Seppo Puikko

[PHP-DB] Couldn't get all data using the "mysql_fetch_array" function, Pls Help!!!!

Dear all I was trying to fetch all the data from one of my table "leaverequest", but i couldn't fetch all the data if i use the * . here is my program, this one is only fetch the Reason field, but what i want is all the data. But can i do it like that way to get all the data? (Showing below) :

[PHP-DB] Could get all data from MYSQL using Mysql_fetch_array!!

Dear all I was trying to fetch all the data from one of my table "leaverequest", but i couldn't fetch all the data if i use the * . here is my program, this one is only fetch the Reason field, but what i want is all the data. But can i do it like that way to get all the data? (Showing below) :

Re: [PHP-DB] MD5 (' ')

I'm not so sure, but there is another parameter to md5() - the salt. Andrey Hristov IcyGEN Corporation http://www.icygen.com 99% - Original Message - From: "Ignat Ikryanov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 4:45 PM Subject: [PHP-DB] MD5 (' ')

[PHP-DB] MD5 (' ')

Hi! I use md5 function to encrypt users password stored in MySql database. When I try encrypt string 'asdf' using md5 function I retrieve: 912ec803b2ce49e4a541068d495ab570 But in 'shodow' file of my linux (Debian 2.2 used MD5 to encrypt users password) 'asdf' string looks like: $1$arjq575D$rnHVF

RE: [PHP-DB] Can I UPDATE 2 tables with 1 SQL statement?

This is not standard SQL so most databases won't support it. Access is supposed to support this kind of updates, but then it won't work on other db's A "better" way to do this is to issue two separate inserts right after each other within a transaction. But this will also crash some databases as

RE: [PHP-DB] Re: Database "Transactions" and HTTP statelessness

maybe you could add a column called lasteditdate to the table? Set it as a DATETIME type and then check that the last edited date/time is not within that last, say, 10 minutes? If it is compare the data? Or add a TINYINT column to the table with a default value of 0, and when a user chooses to ed

Re: [PHP-DB] Database "Transactions" and HTTP statelessness

On Wed, 29 Aug 2001 03:18:01 -0400, [EMAIL PROTECTED] (Doug Semig) wrote: >0. User A loads Record R. >1. User B loads Record R. >2. User B edits and saves Record R. > (Saving involves starting a transaction, retrieving R from the DB, >comparing the values with the original values to make su

[PHP-DB] Re: Database "Transactions" and HTTP statelessness

On Tue, 28 Aug 2001 23:55:32 -0300, [EMAIL PROTECTED] (Manuel Lemos) wrote: >The solution is to pass data between pages and only commit it when you >are done with all the data that you need to grab from the user. >Transactions can't be kept between HTTP requests, but you can pass data >between pag

Fw: [PHP-DB] Special character on an INSERT statement

Hi again. I'm still trying but I can't do it. I have tried this : $values=$values.addslashes("'".$value).addslashes("'"); The result of this would be something like this INSERT INTO Carrocerias VALUES (\'Ber\',\' Berlina\') The mysql_errno is 1064. I've tried mysql_escape_tring with the same r

Re: [PHP-DB] Error "making" php with informix

Hello again, What version of Informix are you now running? Last time we spoke you were only on 5. AFAIK you need at least ver 7 In the current version(4.0.6) of PHP the Informix libraries must be specified in LIBS when compiling Apache. Jani has hopefully fixed this problem for 4.0.7. Have a lo