I thought I had it but I didn't! I can only get LIKE to perform queries that
allow me use the result for a subsequent query but for accuracy, I need to
use actual values. The first statement below works OK (at least I get a
Resource id #) - courtesy of help received here - but will not return
Hi all,
I just installed apache, php mysql on a win98 laptop. I normally use
linux
Things work fine, but when I execute more queries in one script, I get
error messages like:
Warning: MySQL: Unable to save result set in c:/program files/apache
Hi there,
This is a NewBie Question:
While out surfing I have often seen a message like: "There are 17 users on
this site at the moment."
Can I do this with php? Just to show how many people are on (browsing) the
site at that moment? I run a community website.
Thanks
Hello,
I'd like the user of my site to log in/out, but, how can I disallow the user to press
the 'back button' of the browse after logout, and back to the page ???
What I need:
- The user press 'logout';
if (user press the 'back button' of the browser) then
show a page telling that
this should work ... in the top of the page, before any other headers are
sent
?php
header ("Ex-pires:Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
// al-ways modified
header ("Cache-Control: no-cache, must-revalidate"); //
get the postgrtesql source code and untar then run ./configure etc etc on
postgresql
then run ./configure in php as
./configure --with-pgsql=/path/to/untarred/source/files
e.g.
postgresql source untarred to /usr/src/postgresql
php configure options are:
./configure
Hallo!
I'm trying to read lo objects (images) from postgreSQL using php's
pg_loreadall() function with the intention of put them dirctly on a html
document, but I can't. I also have problems about how to embed the result of
the pg_loread() on a html document.
Somebody can help me?
Thak you very
I'm trying to use mysql_result to extract data from one particular field
in a record. So I suppose the most viable solution is to use
mysql_result. But when I do this:
$sqlstmt="SELECT * FROM dept WHERE shortname=$shortname";
$result=mysql_query($sqlstmt);
$resultp = mysql_query("select Primaryid from primarycodes where Code =
'".$row['Primaryexpertise']."'") or die (mysql_error());
$resultp = mysql_query("select Primaryid from primarycodes where Code
like
'%$row[Primaryexpertise]%'") or die (mysql_error());
$pcodeid =
On Wed, 21 Mar 2001, boclair wrote:
This is simple but I cannot see where I am going wrong
I have a table members with one of the fields
status, varchar(10)
The values may be active or retired or deceased or null
If I run the select
SELECT * FROM members WHERE status = 'deceased';
On Mon, Mar 19, 2001 at 10:06:52PM -0800, Toke Herkild wrote:
I've written this login rutine
But that doesn't work... I've tried to use mysql_num_rows too but I still
get :
bWarning/b: Supplied argument is not a valid MySQL result resource in
bg://web/herkild/html/loginout.php/b on line
- Original Message -
From: boclair [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 21, 2001 12:02 AM
Subject: [PHP-DB] Select where
This is simple but I cannot see where I am going wrong
I have a table members with one of the fields
status, varchar(10)
The values
I've tried what you suggested and it works, thanks.
Russ Michell wrote:
Try:
$sqlstmt="SELECT * FROM dept WHERE shortname='$shortname'";
//Include single quotes..
Russ
#---#
"Believe nothing - consider everything"
Russ
That didn't quite work, I tried using single quote enclose within double
quotes and it works.
$sqlstmt="SELECT * FROM dept WHERE shortname='$shortname'";
Thanks anyway
ben wrote:
On Tue, 20 Mar 2001, Shahmat Dahlan wrote:
I'm trying to use mysql_result to extract data from one particular
Thanks, I only gave the mySQL but the php scripting is
$deceased = mysql_query(SELECT * FROM members where
status=\'deceased\'");
and later
while ($myrow = mysql_fetch_row($deceased))
MySQL now says in relation to the *while* line
Warning: Supplied argument is not a
Hi,
I've been trying to figure this out by looking through the code in
phpMyAdmin but I'm not getting very far.
What I want to do is dynamically generate a form where I get a table row
containing the field name in one cell and the input field in the next cell,
for example:
$DatabaseName =
--with-pgsql[=DIR] Include PostgreSQL support. DIR is the PostgreSQL
base install directory, defaults to
/usr/local/pgsql.
Set DIR to shared to build as a dl, or shared,DIR
to build as a dl and still specify
Hi all
Such problem - I cant get MX records from my php script
When I use getmxrr() function it times out. But such functions as gethostbyname() work.
Anybody knows the problem?
Thanks, Vlad
But did you have /usr/local/pgsql/include and /usr/local/pgsql/lib
directories with the correct files in them?
On Tue, 20 Mar 2001, Steve Brett wrote:
--with-pgsql[=DIR] Include PostgreSQL support. DIR is the PostgreSQL
base install directory, defaults to
from phpinfo()
'./configure' '--with-mysql=no' '--with-apache=/usr/src/apache_1.3.14/'
'--with-pgsql=/usr/src/postgresql-7.0.3/' '--with-xml' '--enable-track-vars'
'--enable-trans-sid' '--with-gd'
Steve
-Original Message-
From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]]
Sent: 20
Now that is cool. I wish I had noticed that one before. Would have saved a
lot of odd keystrokes.
--
phill
""Joe Brown"" [EMAIL PROTECTED] wrote in message
996a64$k3a$[EMAIL PROTECTED]">news:996a64$k3a$[EMAIL PROTECTED]...
try:
?php
echo htmlentities("A HREF=home.phpHome/A");
?
""Osman
I am really new working with classes. Some of the ideas I am getting, some I am not.
I wrote this simple little class, with a connection method, and a method to loop
through the
data. I am not even sure if my code is write (for the loop), but I am having trouble
displaying the data. My
My thanks to everyone who provided me info and other hints/tips.
The vast majority of the problem was human error of course, sprinkling in a
few bad assumptions and some configuration problems...its amazing I got it
working at allbut it is :)
Thanks again to everyone.
Gary
"Rasmus Lerdorf"
I have a form which dynamically builds a table by taking data out of a mysql
database
http://www.fyrespray.net/screenshots/admin/modifyscreenshot.php4?pageid=1
but i'm having problems whn i try to modify the data i'm trying to put all
the data into arrays serialize it, urlencode it then send it
I need a little more information to help you.
Is the $query variable a global one ? Or is it a property of the class ( var
$query; ) ?
Why are you assigning the "mysql_fetch_array" function to a variable if call
it is easier ?
You have misplaced the "if $result" statement, the right position, I
If you are using MySQL you can use the "mysql_list_fields" to get the fields
names from a table.
HTH
Jayme.
-Mensagem Original-
De: Martin E. Koss [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: tera-feira, 20 de maro de 2001 12:02
Assunto: [PHP-DB] Dynamically build a form from
Have a look on Sessions. You can also write to a database every time a new
visitor runs into your site and check if the other are still connected.
You have to create a script that tracks every movement of the visitor. It is
not a simple script. As far as I know the web server doesn't give you
Yeah, the var $query is defined to the class.
I did mistype the result, thanks.
I was able to make this bad boy work with placing
$field = $row['row_name']; // whatever the row is called.
But, if that is the case, why would I need a class?
I am just trying to make it so that I can use the
I am trying to implement session support with mysql. I am using
session.set_save_handler but don't really have a great set of functions does
anyone have some good ones?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands,
I have IIS 4 with PHP 4pl1 running on Win NT 4. I can't seem to load the
(*.dll) extensions. There seem to be something wrong with the extension
path. The browsercap.ini path is pointing to the right path. Can anyone
help?
Thanks in advance.
Shahmat
--
PHP Database Mailing List
ATTENTION: ANY SERIOUS NETWORK MARKETER
TAKE A LOOK AT THE FOLLOWING OPPORTUNITY I CAME ACROSS!!
IF YOU PLUG INTO THEIR PROVEN SYSTEM, THEY GUARANTEE YOU SUCCESS,
AND PROVIDE YOU WITH FREE LEADS TO BUILD YOUR GROUP!!
DO NOT LET THIS SLIP AWAY!! CLICK BELOW AND FIND OUT AS I DID,
WHY THESE
I've posted notes on PHP Manual
http://www.php.net/manual/en/install-windows.php
It might help.
--
Yasuo Ohgaki
""Shahmat Dahlan"" [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I have IIS 4 with PHP 4pl1 running on Win NT 4. I can't seem to load the
32 matches
Mail list logo