[PHP-DB] Re: Who is the interbase maintainer?

Jeremy Bettis wrote: > I have pruned down my changes to the interbase module to just 2 bug fixes > and then my blob insert patch. > > Where do I send these? > > Please give me the name of someone that will add these to CVS and not just > blow me off. Send them to php-dev list ([EMAIL PROTECTE

[PHP-DB] Dropping tables in MySQL

Hi guys I had a question. How do you drop a table in a database in MySQL that has spaces in it's name. I created some tables in M$ Access and then exported them using MyODBC to MySQL. One of the tables had whitespaces in the name. Now MySQL is all screwed up. I want to drop the table but nothing

[PHP-DB] Email Processors Wanted!

Dear [EMAIL PROTECTED], EMAIL PROCESSING COMPANY LOOKING FOR EMAIL PROCESSORS IMMEDIATELY, TO SUSTAIN EXPLOSIVE GROWTH. EARN $2,000-$6,000 (PART-TIME) AND $5,000-$10,000 (FULL TIME) MONTHLY. FREE START-UP, NOT MLM, NO EXPERIENCE NECESSARY. SEND AN EMAIL TO: [EMAIL PROTECTED] WITH SUBJECT

[PHP-DB] MySQL / PHP Timeout issue

Hi, I'm having a problem with MySQL timing out after somewhat extensive usage (nothing compared to what it should be able to handle though). I'm running NetBSD with PHP 4.0.5 and 11.15 Distrib 3.23.39, for -netbsd. This is running on an m68k, which I doubt (but could) is an issue, using Apache

RE: [PHP-DB] resizing image with php - what is the quality?

imagecopyresized: crap imagecopyresampled: good but requires gd > 2.0 - seb -Original Message- From: Andrius Jakutis [mailto:[EMAIL PROTECTED]] Sent: 01 September 2001 09:07 To: [EMAIL PROTECTED] Subject: [PHP-DB] resizing image with php - what is the quality? Hello, Again question a

[PHP-DB] resizing image with php - what is the quality?

Hello, Again question about resizing image with PHP. What is the quality of the image after this process? I am about standart GIF or JPG image. Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECT

Re: [PHP-DB] Weird Problem In mysql_connect();

JH has it right - your function has no idea what $host, $user, and $pass are, because they're out of scope. Add the global statements that Jonathan suggested inside your dbConnect function, and all will be well. Dave Watkinson wrote: > function dbConnect (){ > $link = mysql

RE: [PHP-DB] Weird Problem In mysql_connect();

err... neither! Originally I had function dbConnect (){ $link = mysql_connect("ipaddress","username","password"); } And what I tried to do was require('somefile'); who's contents were: and then edit the function on the first fi

RE: [PHP-DB] Weird Problem In mysql_connect();

Hello!! Well what is the hostname of that box It does a DNS lookup. I tried (lets say) 192.168.100.104 and the error was something like this... Access denied for user: '[EMAIL PROTECTED] (Using password: YES) in. See it's looking for that USER on the Hostname... So I added another

Re: [PHP-DB] Last Modified question..

Remember that the timestamp/default feature is only available to the 1st timestamp column in the table. This caught me a bit .. makes sense but if you don't know .. DSig On Fri, 31 Aug 2001 09:20:50 -0500, [EMAIL PROTECTED] (Rick Emery) wrote: > >You can use a TIMESTAMP field in the the recor

Re: [PHP-DB] Weird Problem In mysql_connect();

You mean you had all this inside a function? Like: function dbConnect () { $link = mysql_connect($host,$user,$pass); } ? If so, did you pass $host, $user, and $pass to the function by global-ing them like: function dbConnect () { global $host; global $user; global $pass; $link = mysql_connect($

RE: [PHP-DB] Weird Problem In mysql_connect();

Yeah I just tried myself and it didn't work... localhost works as hostnameBut no IP number...hm.. Maybe it's the . in the variable...hm. Dan Anybody else have a idea?!!??! > -- > From: Dave Watkinson > Sent: Friday, August 31, 2001 3:25 PM > To

RE: [PHP-DB] Weird Problem In mysql_connect();

yeah - everything's fine! All the variables are being stored, but they're not getting passed to mysql_connect() for some really strange reason! :-( I've done a temporary fix - moved the entire database connection function to a separate file, and required that from the first required file (!), an

[PHP-DB] Weird Problem In mysql_connect();

Hey all I can connect with $conn = mysql_connect("IP_Address","username","password"); but I can't connect with $host = "IP_Address"; $user = "username"; $pass = "password"; $conn = mysql_connect($host,$user,$pass); Any ideas? All I get is "Can't connect to MySQL Server on 'loca

RE: [PHP-DB] Previous | Next (Again)

OK, I see what you're saying and the O'Reilly link from someone else was very helpful, however I think there still must be a simpler way to do it. I don't need to have the reorder picture function. Each picture record has an id field which is linked to their username (in another table) and a photo

[PHP-DB] Previous | Next (Again)

I don't know of a way to do the insert in a single query (anyone?!?) with this... but assuming the fields in pic are id int PRI location varchar(30) picnumber int user varchar(20) $query = "Select max(picnumber) from pics where user=\"$user\""; $dbq = mysql_query($query,$dblink) or die(

RE: [PHP-DB] Random

I know it's documented as rand() but you might want to try random() just in case... I'm sure I read that somewhere - seb -Original Message- From: John Hurleston [mailto:[EMAIL PROTECTED]] Sent: 31 August 2001 19:18 To: [EMAIL PROTECTED] Subject: [PHP-DB] Random I would like to get

Re: [PHP-DB] Random

> according tho the description at > , that looks >> $result = mysql_db_query ("$DBName","select * from Contacts order by rand() >> LIMIT 5 "); >> Doesn't work at all. :( What version of MySQL are you using? I remember something about or

RE: [PHP-DB] PHP / MySql / catalogs / carts

php.net has loads of such links - don't be so lazy! ;-) -Original Message- From: Larry "RedCobra" Linthicum [mailto:[EMAIL PROTECTED]] Sent: 31 August 2001 20:57 To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP / MySql / catalogs / carts I bet there are some shopping carts and or "catalogs"

[PHP-DB] PHP / MySql / catalogs / carts

I bet there are some shopping carts and or "catalogs" using PHP and MySql out there that I can use for my project rather than start from scratch links please thanks in advance -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional command

Re: [PHP-DB] Random

I was sure there was a syntax error in that SELECT statement, but according tho the description at , that looks right on to me. I know this doesn't help a lot, but at least you've had a second set of eyes confirm that your code looks ri

Re: [PHP-DB] resizing image in php

PHP apparently has some functions for such tasks, as mentioned by another poster. I can't comment on their usefulness, as I've never used them myself. There is a package (cross-platform) called ImageMagik which does a pretty nice job of manipulating images from a command-line environment. This

RE: [PHP-DB] Previous | Next (Again)

Hello!!! Now that I have found a better link to understand and use the code for next/previous...here it is... http://www.onlamp.com/pub/a/php/2000/11/02/next_previous.html I use this idea with every database. This also teaches you...mysql_fetch_object PhPBuilder is "OK" but this one bette

[PHP-DB] order by group by...

hi, i am trying to build a message board in php with mysql as back end; what i want to do is to query the database in a certain way that the result is returned in the correct order for php to display the discussion thread properly here is my table structure: mysql> show fields from posts -> ; +-

RE: [PHP-DB] Previous | Next (Again)

Sorry but I'm just not getting this. I'm not sure how to get the order of the pics in the first place or what do with the picnumber column. If someone deletes a pic wouldn't the picnumbers higher than it also need to be changed? I'm understanding everything else, even the password stuff but this I

[PHP-DB] Random

I would like to get the first 5 random entries out of my "mysql" database, what would be the correct SELECT option? I adjusted this line $result = mysql_db_query ("$DBName","select * from Contacts LIMIT 0,5 "); which works correctly. :) $result = mysql_db_query ("$DBName","select * from Contact

[PHP-DB] Who is the interbase maintainer?

I have pruned down my changes to the interbase module to just 2 bug fixes and then my blob insert patch. Where do I send these? Please give me the name of someone that will add these to CVS and not just blow me off. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [

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

hello phpNuke uses this process and i have used the code in my own applications and works fine - Original Message - From: Alexandre Santos To: Andrius Jakutis Cc: [EMAIL PROTECTED] Sent: Thursday, August 30, 2001 1:52 AM Subject: [PHP-DB] Re: example of making "Next 10 ent

[PHP-DB] ODBC Drivers that doesn't support odbc_fetch_row

Hello, I'm building an application that uses odbc_fetch_row with a row number (odbc_fetch_row($cx, 0)). This works fine in MS-SQL7.0, but the PHP manual explains that using odbc_fetch_row with a row number (second argument) might not work with some drivers. Does anyone of you have an experi

Re: [PHP-DB] Password Question

I think you both (Jeff and Jon) misunderstood what I meant... Of course, I probably didn't explain very well either :-) I will describe the process again and then address each of your concerns... - Create a form named lostpass.php or something similar. This form should take the user's email ad

Re: [PHP-DB] Password Question

Don't let them change it to whatever they want - have your program/system create a new, random password and e-mail it to the user's account. Unless the malicious person has a way to intercept the e-mail - which is possible - it's kind of useless. But how else are you going to get that information

RE: [PHP-DB] Password Question

I like the new password idea. How do I make sure it's them who's creating a new password so that someone else doesn't maliciously change their password? If someone knew someone's username and e-mail address I would think they could change it. Thanks. Jeff > This doesn't seem to solve his problem

Re: [PHP-DB] Password Question

Ugh, need to proof-read... Let me repost: Jeff, In order to maintain a strong encryption of passwords, you should probably use an MD5 hash. Unfortunately, this is a one-way street. What I would suggest doing however, is not actually attempt to give the user their password, but allow them to c

Re: [PHP-DB] Password Question

Jeff, In order to maintain a strong encryption of passwords, you should probably use an MD5 hash. Unfortunately, this is a one-way street. What I would suggest doing however, is not actually attempt to give the user their password, but allow them to change it. To do this, you would need to hav

Re: [PHP-DB] Password Question

This doesn't seem to solve his problem of encryption, however. If you really want secure encryption, you'll be using one-way encryption, which means it cannot be decoded/decrypted/unencrypted/whatever. If you want to use this method, then instead of sending them their password, it would be best to

Re: [PHP-DB] Password Question

Sorry it should have read: if ($check != 0) echo "this username already exists, select another."; } else { echo "continue!"; } Cheers. Russ On Fri, 31 Aug 2001 17:43:59 +0100 (GMT Daylight Time) Russ Michell <[EMAIL PROTECTED]> wrote: > Have a registration scre

Re: [PHP-DB] Password Question

Have a registration screen that inserts their names, email etc *and* their choice of username + password: $sql = "INSERT INTO (username,realname,password,email) VALUES ('$username',$realname',password('$password'),'$email')"; $result = mysql_query($sql,$connect); //and do a check if the user

[PHP-DB] Password Question

I would like users to be able to request to have their password sent to their email address if they forget it. I would also like it encrypted in the database though. How is this best handled? The security isn't real important. But I let users choose their own password and if they use a password t

[PHP-DB] Php and ODBC

How easy is to connect MSSQL server from PHP , running in Linux? I already have Php installed but I dont think I complied it --with-odbc(?). Do i have to recompile? Is there any way to test it? Any help will be great. thanks -Sharif ) (( |""|-. | :|/' -`--'- -- PHP Database Ma

Re: [PHP-DB] PHP and ms Access

Hi, You need to retreive data using a query script and just put them in a page :) It's as easy as that... Anyway if you precise your question we'll be able to give a more precise answer -Message d'origine- De : user <[EMAIL PROTECTED]> À : [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date :

[PHP-DB] Re: resizing image in php

Any specific type of image? Look at the function and user comments on this PHP manual page. They have some good examples of resizing. http://www.php.net/manual/en/function.imagecopyresized.php - Jonathan "Andrius Jakutis" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTE

[PHP-DB] Re: store an array in a mysqldb

Yikes - not sure what everyone else is smoking. That's the hard way. I thought he was just asking if he could a variable that is an array inside a database and retrieve it later as an array. If this is the case, you can use the serialize() function to convert the array to data that can be stored i

Re: [PHP-DB] Opt-In Request Re: Php-db@lists.php.net

Boy, as a list, I _sure_ think it'd be fun to subscribe to this "Abundant Living Online", don't you? I mean, I only thought you lived in the biological world, and had to log in to get online - if we can live online, that would really save a lot of time! And cut down on travel expenses. Sorry,

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

On Fri, 31 Aug 2001 15:28:13 +0800, [EMAIL PROTECTED] (John Lim) wrote: >This technique is sometimes called an optimistic locking strategy. ahh, thanks. that's cool. by the way, i like ADODB *from*looking*at*it*. haven't used it yet because, for now i prefer not to work with PHP objects.

RE: [PHP-DB] Last Modified question..

You can use a TIMESTAMP field in the the record. When you INSERT a record, set the field to NULL; the time will automatically be entered. The same is true for files/records that are UPDATED. CREATE TABLE mytable ( first_name varchar(25) default "", last_name varchar(25) default "", bday date,

[PHP-DB] Setting nls_date_format in initSID.ora

Hello, I've tried changing the nls_date_format variable from: nls_date_format = DD-MON- to nls_date_format = -MM-DD Then I restart the database but it will only use the old format, the new format has not been recognised. I'm editing the initSID.ora file where SID is the sid of the databas

Re: [PHP-DB] PHP and ms Access

I think that by using ODBC you can connect to the MS Access server. Andrey Hristov IcyGEN Corporation http://www.icygen.com BALANCED SOLUTIONS - Original Message - From: "user" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 31, 2001 4:33 PM Subject: [PHP-DB] PHP and

[PHP-DB] PHP and ms Access

Hello, I am builing a microsoft access database. Now wants the compagny I created it for me to use it to make dynamic webpages. The problem is that I am new at this. Can somebody please explain the basics of integrating a MS Access databse with php into a webpage? I thank you in advance, TheB

[PHP-DB] Opt-In Request Re: Php-db@lists.php.net

This is a one-time mailing only. You are receiving this message because you recently submitted to one of our websites -- this is simply an attempt to update our files by verifying your email address [EMAIL PROTECTED] at 206.43.192.76

[PHP-DB] resizing image in php

Hello all, I need to make some program with php, that I would resize image. Any examples? Thanks! -- 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: [EMAI

[PHP-DB] insert date problem

I get the following error when I try the statement below. Through elimination I know it is the dates that are causing the problem. I have set the date format to this: alter session set NLS_DATE_FORMAT = '-MM-DD'; $sql_season: insert into season (id, code, start_date, end_date) values (16, 'a

RE: [PHP-DB] store an array in a mysqldb

If you are setting up a true relational database, arrays would be stored in a seperate table with a unique key. Each part of the array would be a seperate row. This is called normalization. If you are doing it for fun, then you could place some type of seperator (like a comma, semicolon, etc) b

[PHP-DB] Re: Space in database coloumn

"Nagasea" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I had a database like this > > Name : John Doe > Sex : Male > > when i want to call this data with url link > > http://www.test.com/template.php?nick=John > > why the (space)Doe is not in there. > > what

Re: [PHP-DB] SQL problem

Hi, Are there any error messages? Just a guess - may be this will work Select $tbl_virtual.thumb1,$tbl_descriptions.short_desc FROM $tbl_virtual left join $tbl_descriptions on $tbl_virtual.id_property=$tbl_descriptions.id_property WHERE $tbl_virtual.id_property=$link Dobromir Velev -Origina