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 mssq
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', bin_data=
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
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.
However I get the following error.
Warning: MS SQL: Unable to connect to server: 192.168.1.1:1433 in c:\program
files\apache group\apache\htdocs\meyedev\connect.
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 D
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 ...
--
Thanks everyone that was just the ticket :)
Off to read up on JOINs now...
Thanks again
Dave
-Original Message-
From: Dobromir Velev [mailto:[EMAIL PROTECTED]]
Sent: 30 July 2001 08:42
To: Dave Watkinson; PHP-MySQL List
Subject: Re: [PHP-DB] Finding NoMatches in MySQL
Hi,
I think th
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 no
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
('[$FirstName]','[$LastName]','[$WorkPhone]','[$H
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
> [
mysql_fetch_array places 2 records for each one returned (example)
Array
(
[0] => 56
[location_id] => 56
)
Is there any way to delimate that and have the key present only once?
here is my code :
/*
*
*
* Start code
*
*
*/
while ($aRow = mysql_fetch_array($sResult) ) {
Check the /etc/services if Unix/Linux or c:\windows\services if windows. In
the ODBC definition you supply a service name wich must to exist in this
file. I hope this helps.
-Original Message-
From: sdk [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 12:29 PM
To: [EMAIL PROTECTED]
tried to connect to an oracle db via odbc, but with no success
get errormsg that php (php odbc driver) cannot resolve service name
can anyone help?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED
"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
Adam,
Configure PHP --with-iodbc as per the HOWTO on www.iodbc.org.
Get yourself an ODBC driver, and install it on the Linux box.
If you want to use ours, OpenLink's Multi-Tier driver is a free download
with a 2-user license that does not expire.
Get the MT driver components from our site, select
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?
>
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, e
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 help.
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
To take it a step further, I would suggest creating a php script
downloadimage.php as follows:
Then link to that with
Download
Image
Make sure the images are outside of your webservers document root. Then
you can programatically decide whether to serve the image to the user.
Removes the po
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
"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 Comp
"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 th
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
-
"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
"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 descrip
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 (
Afternoon, olinux!
.·Cite 30 èþëÿ 2001 ã., 15:38:53·.
oo> What is the best way to do this? By adding an
oo> additional column to the Messages Table OR creating a
oo> new table with the field "Table_Name" and
oo> "Last_Checked"
By adding additional column. With one table you may do only one
que
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
additional column to the Messages Table OR creating a
new table with the field "Table_Name" an
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
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 1
31 matches
Mail list logo