wow. another postgresql user !
i use pg_connect to connect as well, including the connect script as an 'if
not connected then connect' type of thing. the connection is killed and
memory from queries freed up when the script finnishes.
incidently, i used pconnect for a while but found that connec
pg_numrows will only bring back the number of results in the resultset.
you could try:
a. a query using distinct to bring only the vlaues you want.
b. (better) a query using an aggregate function like count and then access
the count var from your resultset.
like:
select count(id) as idcount f
I want to be able to access the rows of a resultset,but I want to specify
which ones.(Lets say $row[5]).Do I have to copy the RS into a seperate array
first?Most examples enumerate with "while" statements.I dont want to do
that.
Thanks
Mike P
[EMAIL PROTECTED]
--
PHP Database Mailing List (ht
Im very new to PHP (coming from shell programming) and have a very easy
question
:-)
I have found examples of building a dropdown list, and have found examples
of reading a mysql table, but am looking for examples of creating a
drop-down list with the results of a mysql query. Ie, I have an ad
Thanks for the help on the earlier ?. Now that I have the select statement working I
can't get any results displayed.
$result = mysql_query("SELECT substring_index(body, \".\" ,2) FROM news",$db) or die
("Invalid Query");
if ($myrow = mysql_fetch_array($result)) {
do {
on 4/12/01 8:40 AM, Quentin Krengel ([EMAIL PROTECTED]) wrote:
> I have found examples of building a dropdown list, and have found examples of
> reading a mysql table, but am looking for examples of creating a drop-down
> list with the results of a mysql query. Ie, I have an admin screen where
>
At 10:12 PM 4/11/01 +, Richard Crawford wrote:
>This isn't strictly a PHP question, I suppose... but is anyone aware of a
>date_format function for Oracle comparable to MySQL's date_format() function?
I'm not familiar at all with MySQL nor its date_format() function, but
Oracle has two f
on 4/12/01 9:53 AM, Mike Baerwolf ([EMAIL PROTECTED]) wrote:
> $result = mysql_query("SELECT substring_index(body, \".\" ,2) FROM
> news",$db) or die ("Invalid Query");
> if ($myrow = mysql_fetch_array($result)) {
>
> do {
>
> printf("%s\n", $myrow["headline"]);
> printf("%s\n", $myrow["body"])
I'm trying to connect to mySQL DB by Web page
and
when I use mysql_connect()
this append:
Fatal error: Call to unsupported or undefined function mysql_connect()
thanks!
Franky
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
I'm trying to connect to mySQL DB by Web page
and
when I use mysql_connect()
this append:
Fatal error: Call to unsupported or undefined function mysql_connect()
thanks!
Franky
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
Fo
Such patience! You waited nearly 7 whole minutes before reposting your
message!
I don't run MySQL, so I'm not sure... but it looks like you probably don't
have MySQL support in your version of PHP. Try:
...and see if it says you do.
At 12:44 PM 4/13/01 -0400, franky wrote:
>I'm trying to
>Such patience! You waited nearly 7 whole minutes before reposting your
>message!
>
>I don't run MySQL, so I'm not sure... but it looks like you probably don't
>have MySQL support in your version of PHP. Try:
>
>phpinfo();
>?>
Also, include some more code.. Or even better, check out some of t
At 11:53 AM 4/12/2001 -0500, you wrote:
>Thanks for the help on the earlier ?. Now that I have the select statement
>working I can't get any results displayed.
You can't print what you haven't asked for.
> $result = mysql_query("SELECT substring_index(body, \".\" ,2) FROM
> news",$db) or die
Can I add to the actual serveur apache?
With somthing like this:
./configure --with-php=../php
or more complicate...
Franky
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To c
>./configure --with-php=../php
> or more complicate...
More complicated.
You really should check www.devshed.com you can find more on how to install
MySQL, PHP and Apache.
Bye,
B.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
Many of the DBMS's allow you to choose which row to fetch.
Eg with MySQL, you can use mysql_data_seek() (see
http://www.php.net/manual/en/function.mysql-data-seek.php)
Similar equivilents exist for ODBC, MS SQL etc.
Eg: odbc_fetch_row($result, $rownumber);
What is it about row 5 for example tha
How can i use MSSQL + IIS?
i´m having some problems...
tks
--
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]
If you connect with pg_PConnect(), connection will be there until web server
dies unless user is using CGI. (PostgreSQL backend will be there until then)
That's the idea of persistent link, so that user can avoid connection setup for
every db connection.
However, PostreSQL connects db relatively f
If you are speaking of Microsoft SQLServer, there are some lists that
specialize in this product at http://www.sqlteam.com
Also - try www.4guysfromrolla.com and asp101.com
hope this helps a little,
Phil J.
"André M.S.\"
> How can i use MSSQL + IIS?
> i´m having some problems...
>
> tks
>
> --
Here, I think you may be over - using session variables a bit...have not used them in
php, as I have version 3, which doesn't support them. However, by day I am an ASP
developer, and article after article I read warns about session variables! They are
great, but can hog
memory, especially if
Here's the scoop:
Goal: to connect apache 1.3.19/PHP to remote Oracle server.
Background: I downloaded Oracle 8.1.7 and installed the default Client configuration.
Machine is an SMP Mandrake 7.0 Linux 2.2.14. PHP is 4.0.4pl1.
Synopsis: I configure and make php even with the cleanest co
Hi,
ok, first of all make sure your form tag is like :
The ENCTYPE is important!
Next, make sure you have a field like:
type="file" is important! This will present a browse button for the user to browse
their drives
something like this seems to work - drop the addslashes if it is not a bin
Hello,
I need a way to tell if a specified column is an identity column or not.
All PHP seems to be able to tell me is the name, type and size of the field.
any help would be appreciated
thanks,
>-<
Sean Finkel
Webmaster - R
Hi,
If you exactly know which row you want you could use LIMIT yourRow, 1.
If you copy the RS into an array first you would have to use a while
statement
aswell, or not?
Cheers
Johannes
""Mike"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
9b4e4n$gmh$[EMAIL PROTECTED]">news:9b4e4n$gmh$[EMAIL PROT
24 matches
Mail list logo