[PHP-DB] Image Bank with php mysql!! ??!!

Hello everyone... I wan't your opinion regarding a program i am constructing. It is about an image bank for graphic studios or anyone else who needs a program that can insert his pictures or descriptions of it and be able to make a fast and reliable search. The Question is: What would be

Re: [PHP-DB] Finding NoMatches in MySQL

Hi, I think this query should do the job SELECT jobs.uid FROM jobs LEFT JOIN employers ON jobs.id1 = employers.uid WHERE employers.uid is Null Dobromir Velev -Original Message- From: Dave Watkinson [EMAIL PROTECTED] To: PHP-MySQL List [EMAIL PROTECTED] Date: Monday, July 30, 2001

RE: [PHP-DB] MySQL newbie: inserting new entry to table?

I'm a learner too. But as I understand it, You make a connection to the database (or open it?). Once it's open or connected to, you can access the different tables within it. I think the difference between mysql_db_query mysql_query is that later assumes that you all ready connected to the

[PHP-DB] double mysql calls?

Hello all... Im having a bit of trouble with a mysql update feature. What I am doing is having a script email a list of people in a database (one email address per db record) and have the script update the database that it has sent an email to that particular person. Currently I have: while

[PHP-DB] Re: Image Bank with php mysql!! ??!!

Koutsogiannopoulos Karolos [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I wan't your opinion regarding a program i am constructing. It is about an image bank for graphic studios or anyone else who needs a program that can insert his pictures or descriptions

[PHP-DB] Re: Storing last access

Olinux O [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi all, I would like to display messages that are entered into a database since the last time i checked it. [Much like web based email marks NEW messages.] What is the best way to do this? By adding an

[PHP-DB] A Join Question

I'm trying to create a join statement that pulls out a CompanyName based on a given CompanyID that is tied to a specified ContactID. For example, if ContactID=1 then the corresponding CompanyName might be Smith, Inc. depending on what was entered. Here are the tables. table = Contacts

[PHP-DB] Re: Query displays one

Mike Gifford [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... The problem is that I am only getting one response from this query rather than 5. I can't figure this out. What did I do to only get one response? Try removing the ORDER BY and LIMIT and run the

[PHP-DB] Re: A Join Question

Steve Fitzgerald [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'm trying to create a join statement that pulls out a CompanyName based on a given CompanyID that is tied to a specified ContactID. For example, if ContactID=1 then the corresponding CompanyName

RE: [PHP-DB] ODBC and PHP

Ariadne, What is the exact error you get? Among other debugging tricks, you can get an ODBC trace from the ODBC Administrator control panel (if using Win32 on client side) and look at where the API calls are failing. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software

Re: [PHP-DB] Re: Image Bank with php mysql!! ??!!

To take it a step further, I would suggest creating a php script downloadimage.php as follows: ?php //downloadimage.php //some code to verify requested download against customers details, remembering not to send any output to the browser (would upset the header() function) //

[PHP-DB] RE: Tree Display

Have your table set up with the following two fields (among others!): -Category -Parent Result1 parent = 0 (it has no parent). Item1 parent is Result1 (ie the parent field of item1 is result1's unique identifier). Item2 parent is Result1. Result2 parent = 0. Result2's children have Result2 as

[PHP-DB] new lines in text field

Greetings. I'm trying to concatenate several values entered in my form, then write them to a TEXT field in my mySQL database. All is well, except that I want to each value to appear on a different line. I've tried \n and that didn't work. What am I doing wrong? Thanks in advance for the

[PHP-DB] PHP on Linux and MS SQL

Anybody know of a good installation description for connection PHP on linux to MS SQL on a 2000 machine? I've been through about 3 so far and none of them have worked. Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

[PHP-DB] Re: Query displays one

Hi Hugh, Hugh Bothwell wrote: Mike Gifford [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... The problem is that I am only getting one response from this query rather than 5. I can't figure this out. What did I do to only get one response? Try removing

[PHP-DB] Re: new lines in text field

Kenn Murrah [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I'm trying to concatenate several values entered in my form, then write them to a TEXT field in my mySQL database. All is well, except that I want to each value to appear on a different line. I've

[PHP-DB] Re: mysql_fetch_array

try just changing mysql_fetch_array to mysql_fetch_assoc Bryan [EMAIL PROTECTED] wrote in message 006801c1192c$649f6e30$272478cc@bryanspc">news:006801c1192c$649f6e30$272478cc@bryanspc... mysql_fetch_array places 2 records for each one returned (example) Array ( [0] = 56

[PHP-DB] INSERT with a JOIN

I'm trying to create an INSERT statement that will change a field in one table based upon the id defined in another table. Here is what I tried: $sql1 = INSERT INTO $table_name1 (FirstName,LastName,WorkPhone, HomePhone,EmailName,Birthday) VALUES

[PHP-DB] Application dev w/ PHP MySql

Hello I am having to learn php and mysql, at the sametime and with a time constraint. So I am hoping I can have a lending hand from all the coding gurus out there. Let my give you a little back ground. I the owner of an ISP tech support outsourcing company and am trying to develop a call

[PHP-DB] INSERTING DATA into a MySQL DB

Hi All, I am having a problem with Inserting Data from a generated form. To explain this clearly the code is listed below. There are three pages and a table in the db. When the sql statement is run, it ends at the INSERT clause. Any help would be appreciated ...

Re: [PHP-DB] INSERTING DATA into a MySQL DB

My last post may have been a little unclear, I have attached the pages. Thanks ... From: Christopher Trewin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] INSERTING DATA into a MySQL DB Date: Tue, 31 Jul 2001 09:48:23 +1000 Hi All, I am having a problem with Inserting Data from a

[PHP-DB] Can't connect to MS SQL

I have PHP running on Apache for win32. The mssql module is enabled. I am trying to connect to a database with the following code. ?php $hostname = 192.168.1.1:1433; $username = test; $password = smiley; $dbName = meyedev; $dbc = mssql_connect($hostname,$username,$password) or DIE(DATABASE

[PHP-DB] Linux, Oracle 8.1.5, configure: libclntsh.so: Don't use llseek; slpmprodstab undefined

I'm at wit's end. .../php-4.0.6/configure gives an error, and debug.log says libclntsh.so: don't use llseek, use lseek64, and slpmprodstab is undefined. I've looked everywhere. All of php.org. All of this newsgroup. The linux forum at Oracle TechNet. The one lead I found was a reference to

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

Heres what I'm trying to do: $data=addslashes(fread(fopen($form_data, rb), filesize($form_data))); //some lines of code edited out $result = mysql_query ( UPDATE bands, binary_data SET genreid='$genre', bandname='$name', bandesc='$description', bandurl='$url', bandemail='$email',

Re: [PHP-DB] Can't connect to MS SQL

Hi Adam, Host name should not include the port number. If you need to use a non standard port number you should create a client configuration (using client network utility) and then use the name of the configuration as the host name. - Frank I have PHP running on Apache for win32. The