On Monday 22 April 2002 12:54, Vania Smrkovski wrote:
Hello, folks, and I apologize in advance if I break any rules here. This
is my first post on this list and I couldn't find any archive to review
existing posts for the answer to this question.
http://www.php.net/mailing-lists.php
a) How
From: Vania Smrkovski [EMAIL PROTECTED]
host with PHP and MySQL support.
a) How would you change the following the automatically find the tables
and
run through the iteration.
You should rtfm as php/mysql makes a lot of the torturous
VB/MS/Access methods very simple. All the functions below
It's a no go...
This is what I tryed:
SELECT User.NickName FROM User, Rights WHERE (User.UserID =
Rights.UserID (Rights.MainID = ${row['MainID']} ||
ISNULL(Rights.MainID))
The only thing I want to be able to retrieve is a list of nicknames
(User.NickName) based on MainID. In the Rights
On Monday 22 April 2002 16:04, Prodoc wrote:
It's a no go...
This is what I tryed:
SELECT User.NickName FROM User, Rights WHERE (User.UserID =
Rights.UserID (Rights.MainID = ${row['MainID']} ||
ISNULL(Rights.MainID))
The only thing I want to be able to retrieve is a list of nicknames
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
--- Gurhan Ozen [EMAIL PROTECTED] wrote:
This more of sounds like there is a discrepancy in internet
explorer 6 ? If
you don't have other versions/brands of browser than i.e. 6 in your
machine
Can you give the web page out so
I am trying to pass an ID to a third page as follows:
I have a list of stories to be checked and edited. When one is selected it
is passed to a detail page and is edited and comments are added before
posting the edit form back to itself to update the database. At this stage I
would like to give
On Monday 22 April 2002 18:05, Alex Francis wrote:
I am trying to pass an ID to a third page as follows:
I have a list of stories to be checked and edited. When one is selected it
is passed to a detail page and is edited and comments are added before
posting the edit form back to itself to
You could send it in a
INPUT TYPE=HIDDEN NAME=Id VALUE=AnyThingYouWant
- Original Message -
From: Alex Francis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 22, 2002 7:05 AM
Subject: [PHP-DB] Passing on an ID
I am trying to pass an ID to a third page as follows:
I have
The code for updating the database with any story editing and added comments
is:
// processed when form is submitted back onto itself
if ($REQUEST_METHOD==POST)
# setup SQL statement
$SQL = UPDATE $tablename1 SET;
$SQL = $SQL . date = '$date',;
$SQL = $SQL . name = '$name', ;
$SQL = $SQL .
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
The button Email Comments links to the following page:
?include (../config.inc.php); ?
?php
// setup SQL statement to retrieve link that we want to edit
$SQL = SELECT * FROM $tablename1 ;
$SQL = $SQL . WHERE id = $id ;
//
I would like to pull from 2 different databases at the same time so that I
can have the relating information displayed together.
This is what I have so far.any suggestions?
$sqlquery = mysql_query(SELECT * FROM log, logtime WHERE log.ID=logtime.ID
order by log.logtime desc;);
$sqlquery1
I'm trying to use a stored procedure and ref cursors.
The PHP server has the Oracle 8.x client library and the
Oracle server is 7.x. When I try to use the ref cursor
I get the infamous ORA-24370 error. This error goes away
when I connect to an Oracle 8 server (and everything else,
including the
Hi all
I am a beginner with PHP, so sorry if my question is to much basic for you.
Is possible to use PHP with support at same time for DB2 and Oracle ?
I mean can I use PHP to open two connections to different database
servers (Oracle and DB2) at same time ?
Tanks on advance.
Luis Silva
I'm still having problems with the mail function.
I have installed PHP in a Windows 2000 test server. Is there something I
should do to allow this function to work. I am a complete newbie and
installed with the default settings. I get a Failed to connect Error when I
call the mail() function.
Ok i have a problem big one. I'm using php 4.0.6 and mysql 3.23 both win.
And i use PhpMyAdmin to fill my database but MySQL reject every query i post
to it any idea why?
Thanks
Thomas omega Henning
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
mysql permissions?
you gave us no info...we can give you no answer
- Original Message -
From: Thomas omega Henning [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 22, 2002 11:25 AM
Subject: [PHP-DB] Problem
Ok i have a problem big one. I'm using php 4.0.6 and mysql 3.23
Hello, folks, and I apologize in advance if I break any rules here. This
is my first post on this list and I couldn't find any archive to review
existing posts for the answer to this question.
http://www.php.net/mailing-lists.php
Thanks for the URL. I feel stupid for having missed it,
Here is the section from my PHP.INI
[mail function]
; For Win32 only.
SMTP = localhost
; For Win32 only.
sendmail_from = [EMAIL PROTECTED]
; For Unix only. You may supply arguments as well (default:
'sendmail -t -i').
;sendmail_path =
I presume you mean the SMTP server set in my mail
just change the SMTP to your ISP's SMTP server, i.e. the server you use to
send mail from your regular mail account.
At 06:45 PM 4/22/02 +0100, Alex Francis wrote:
Here is the section from my PHP.INI
[mail function]
; For Win32 only.
SMTP = localhost
; For Win32 only.
sendmail_from = [EMAIL
Alex,
That's the info in question!
Here is the section from my PHP.INI
[mail function]
; For Win32 only.
SMTP = localhost
; For Win32 only.
sendmail_from = [EMAIL PROTECTED]
; For Unix only. You may supply arguments as well (default:
'sendmail -t -i').
;sendmail_path =
I presume
Can I set this to use the SMTP Server at my ISP but still use the database
and PHP files in house. I don't want to make any changes to either the php
pages or the database at the ISP until I have got it all working. Although I
suppose I could set up another site and database at my ISP.
Alex
Yep, that's exactly how it works. Just like the email you send from Eudora
or Outlook is all stored on your hard drive, but uses the SMTP server of
your ISP, same here.
-Lisi
At 07:17 PM 4/22/02 +0100, Alex Francis wrote:
Can I set this to use the SMTP Server at my ISP but still use the
Lisi
I realised that just after my last post. I also realised that I would never
get it to work until I make some alterations to my network. I have a
broadband cable modem connected to a Windows 98 system which I use for
everything. For test purposes I added a Windows 2000 system and at the
Got almost everything to work. Thank you all for your input. Code as
follows:
?include (../config.inc.php); ?
?php
// setup SQL statement to retrieve link
$SQL = SELECT * FROM $tablename1 ;
$SQL = $SQL . WHERE id = $id ;
// execute SQL statement
$ret = mysql_db_query($dbname,$SQL,$link);
Does the simple case (without specifying MainID) work?
And are you pretty sure that $row['MainID'] actually holds a valid value?
Have you tried printing the whole of the above query to see what it actually
contains?
If it looks valid try copy-paste that query into the mysql
mysql_fetch_array() brings back an associative array by default.
It's not $result[0] but instead $results[column_name]
Also, you can use is_set() on subarrays.
if ((isset($result[col1]))
(is_array($result[col1]))
(sizeof($result[col1])))
{
// do stuff here
}
Remember that the
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
(Thomas \Omega\ Henning) says...
no everything i try to do same old story sql error
Richard Emery [EMAIL PROTECTED] wrote in message
004e01c1ea1b$b3dff4e0$0200a8c0@C1525232">news:004e01c1ea1b$b3dff4e0$0200a8c0@C1525232...
mysql permissions?
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
Got almost everything to work. Thank you all for your input. Code as
follows:
?include (../config.inc.php); ?
?php
// setup SQL statement to retrieve link
$SQL = SELECT * FROM $tablename1 ;
$SQL = $SQL . WHERE id = $id ;
What I meant is there is I think the problem is with the mySQL privilege
system or rather the way your permissions are setup I suggested you first
go through the part of the mySQL manual with the PRIVILEGE SYSTEM then once
you set up you permissions well run the sql queries from the mysql
I am using a form to enter data into a mySQL database all is fine but, I
need to check for blank entries in rows. I was trying to use isset($var)
but it appears to return a TRUE whether or not I insert data on the form.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
I am using a form to enter data into a mySQL database all is fine but, I
need to check for blank entries in rows. I was trying to use isset($var)
but it appears to return a TRUE whether or not I insert data on the form.
isset is true
use if($var=) or if(trim($var)=)
dengach a écrit :
I am using a form to enter data into a mySQL database all is fine but, I
need to check for blank entries in rows. I was trying to use isset($var)
but it appears to return a TRUE whether or not I insert data on the form.
--
PHP Database
32 matches
Mail list logo
