desc
would likely do the trick (sorting your results by the value of the ID
field, in descending order).
---
Mark Roedel| "A wise man once told me that everything in
Systems Programmer | life is either a lesson or a joke. Our task
LeTourneau University | is to figure ou
ocate
the product in her database and process my request.)
For reference, my e-mail confirmation referred to the package as
"Orderable Part Number 100-15871-204057-1"...no idea whether that refers
specifically to the electronic-delivery option or not, though.
---
Mark Roedel|
eak a couple of things
before I got PHP to work with a MS SQL server, and most of them came in
the stages of getting FreeTDS working correctly before I even tried to
build it into PHP.
Is your SYBASE environment variable set correctly? Have you
double-checked the sybase-related settings in your
Perl-style "HERE docs". I have tried
> to make this work with PHP4.04 with no success. I also haven't
> found any reference to HERE docs in the PHP documentation. Is
> this really supported in PHP?
http://www.php.net/manual/en/language.types.string.php
---
M
ables.predefined.php
---
Mark Roedel | "Blessed is he who has learned to laugh
Systems Programmer| at himself, for he shall never cease
LeTourneau University | to be entertained."
Longview, Texas, USA | -- John Powell
> -Original Message-
e "5".
This, on the other hand, makes me suspect that the arrays themselves
don't actually contain what you think they do. How are you assigning
the values you described at the top of your message?
---
Mark Roedel ([EMAIL PROTECTED]) || "There
> -Original Message-
> From: Martin [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 02, 2001 10:48 AM
> To: Mark Roedel; [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] array_diff usage
>
>
>
>> This, on the other hand, makes me suspect that the arrays themse
s there was a problem with your query. For more info,
including some useable sample code that should help you troubleshoot
exactly what went wrong, see
http://www.php.net/FAQ.php#7.12
---
Mark Roedel ([EMAIL PROTECTED]) || "There cannot be a crisis next week.
Systems Progr
address1');
> $address2 = @mysql_result($result, 0, 'address2');
> $town_city = @mysql_result($result, 0, 'town_city');
> $postcode = @mysql_result($result, 0, 'postcode');
Looks reasonable to me...what happens when you try it?
---
Mark Roedel ([EMA
nderstanding, thats not supposed to work.
Here, I think, is where we can clear things up for you a bit by
explaining that the important quotes, the ones that determine which of
the two behaviors you listed will apply, are the *outermost* ones.
So...
Get the idea?
---
Mark Roedel
> -Original Message-
> From: SOHH.com Webmaster [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 19, 2001 4:45 PM
> To: Mark Roedel
> Cc: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] Help Me Fix My User Defined Funtion
>
>
> However, since posting my question
king something like
SELECT cia.name
FROM cia, table
WHERE cia.region = table.region
AND table.name='Brazil'
For the second, I'd do something like
SELECT name
FROM table
ORDER BY count DESC
LIMIT 1
---
Mark Ro
this error-message,
> but I cannot find a problem in the Query:
> ie.:
> $db_handle = mysql_connect("localhost", "mysql", "mysql");
> if($db_handle)
> {
> $result = mysql_db_query("mysql", "select * from user", $db_ha
Erm...can you give us a bit more information?
Does the script bring up an error message? If so, what does it say? If
not, what specifically makes you think there's something wrong with it?
(What results do you get? How are they different from what you
expected?)
---
Mark Roedel ([
s.org/) on your Linux machine and then build
PHP with the --with-sybase configuration parameter. This will enable
the mssql_* functions.
---
Mark Roedel ([EMAIL PROTECTED]) || "There cannot be a crisis next week.
Systems Programmer / WebMaster || My schedule is alr
hat
there's a setting to enable this *if* you're using Informix 11.x (we're
still on 9.x here).
The speaker didn't know the setting off the top of his head, but
indicated it was in Informix's online documentation, searchable at
http://www.informix.com/answers/
ur copy of PHP *does* include the MySQL client functionality, and
(2) it isn't successfully connecting to a MySQL server.
> From what i've heard, MySQL is included in PHPbut why
> doesn't the connect work if it is included?
Do you actually have a MySQL server running?
tions if you could give a little more information about
your database structure and the source for the part of the program
that's causing problems...
---
Mark Roedel ([EMAIL PROTECTED]) | "There cannot be a crisis next week.
Systems Programmer / WebMaster | My schedule is alre
or
in the query or a problem with your database access or connection.)
---
Mark Roedel ([EMAIL PROTECTED]) || "There cannot be a crisis next week.
Systems Programmer / WebMaster || My schedule is already full."
LeTourneau University ||-- Henry Kis
ield, mssql_field_seek, mssql_result, mssql_affected_rows,
mssql_min_error_severity, and mssql_min_message_severity.)
---
Mark Roedel | "The most overlooked advantage to owning a
Systems Programmer| computer is that if they foul up there's no
LeTourneau University | la
eme,
but then it's hard to make much of a judgment on that without knowing
more about the machine in question, what else it's being used for
besides sql services, how heavily it's being utilized, etc.
---
Mark Roedel | "Nothing in life is so bad that it cannot be
S
;0;
But the following will also work:
mysql> SELECT * FROM tbl_name WHERE set_col = 'val1,val2';
mysql> SELECT * FROM tbl_name WHERE set_col & 1;
The first of these statements looks for an exact match. The
second looks for values containing the first set m
h=3; break;
case 8: $row_width=4; break;
case 9: $row_width=3; break;
default: $row_width=6;
}
should do the trick.
---
Mark Roedel | "The most overlooked advantage to owning a
Systems Programmer| computer is that if they foul up there's no
LeTourneau U
which seems like sort
of a futile exercise. Try changing it to the IP of the NT machine.)
---
Mark Roedel | "The most overlooked advantage to owning a
Systems Programmer| computer is that if they foul up there's no
LeTourneau University | law against whacking them aroun
n, $myuser, $mypass) or die ("Unable
> to connect MS SQL");
Does mssql_get_last_message() say anything interesting when this line
fails?
---
Mark Roedel ([EMAIL PROTECTED]) | "There cannot be a crisis next week.
Systems Programmer / WebMaster | My schedule is already full."
SSQL and am able to successfully use all three -- even within
the same script when it's called for.
What's the error message you get when you try to build with multiple
DB's supported?
---
Mark Roedel | "Blessed is he who has learned to laugh
Systems Programmer| a
oday that the Sybase database engine
likes to have a single quote escaped by another single quote, not by a
slash.
Perhaps this is a case where MSSQL is showing its Sybase roots...do you
get the same errors if you change \' to ''?
---
Mark Roedel | "Blessed is he w
printing of those messages). I didn't
see anything in either of the messages you posted that appeared to
indicate a change in functionality...do you have some reason to believe
that things aren't working the same behind the scenes as they did
before?
---
Mark Roedel |
do the same thing as mysql_num_rows(). It counts
the number of rows that you've viewed from the result set, not the total
number of rows returned.
If you use mysql_fetch_array(), the equivalent Informix function is
ifx_fetch_row().
---
Mark Roedel | "Blessed is he who ha
Is it possible that there's a string farther up with an unclosed
single-quote?
---
Mark Roedel | "Blessed is he who has learned to laugh
Systems Programmer| at himself, for he shall never cease
LeTourneau University | to be entertained."
Longv
30 matches
Mail list logo
