[PHP-DB] More on strings

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

[PHP-DB] MySQL errors on win32

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

[PHP-DB] No. of Users online right now?

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

[PHP-DB] Expires Pages

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

RE: [PHP-DB] Expires Pages

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"); //

RE: [PHP-DB] problems configuring php and postgres - call to undefined function

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

[PHP-DB] LO on postgreSQL HELP!

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

[PHP-DB] mysql_result

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);

Re: [PHP-DB] More on strings

$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 =

Re: [PHP-DB] Select where

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';

Re: [PHP-DB] How do I test on number of fields ?

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

Re: [PHP-DB] Select where

- 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

Re: [PHP-DB] mysql_result

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

Re: [PHP-DB] mysql_result

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

Re: [PHP-DB] Select where

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

[PHP-DB] Dynamically build a form from mySQL table

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 =

RE: [PHP-DB] problems configuring php and postgres - call to und efined function

--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

[PHP-DB] getmxrr() timed out

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

RE: [PHP-DB] problems configuring php and postgres - call to und efined function

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

RE: [PHP-DB] problems configuring php and postgres - call to und efined function

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

Re: [PHP-DB] How to display HTML code?

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

[PHP-DB] class method

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

Re: [PHP-DB] problems configuring php and postgres - FIXED

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"

[PHP-DB] Transmitting Arrays

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

Re: [PHP-DB] class method

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

Re: [PHP-DB] Dynamically build a form from mySQL table

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

Re: [PHP-DB] No. of Users online right now?

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

Re: [PHP-DB] class method

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

[PHP-DB] Sessions and MySQL

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,

[PHP-DB] Loading extensions

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

[PHP-DB] A NETWORK MARKETER?

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

Re: [PHP-DB] Loading extensions

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