Hi folks.
I have a quetion for you which maybe a little silly as I'm still new here..
I want to build a database in which access will have only registered memebers, so I
need to protect it. The database will have over 10 records and hopefully over 1000
users-visitors. Everyone of them is go
use if($var="") or if(trim($var)="")
dengach a écrit :
> I am using a 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 Data
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> I am using a 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
I am using a 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, visit: ht
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 command
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> Got almost everything to work. Thank you all for your input. Code as
> follows:
>
>
>
> // setup SQL statement to retrieve link
>
> $SQL = " SELECT * FROM $tablename1 ";
> $SQL = $SQL . " WHERE id = $id ";
>
> // execute SQL statem
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 per
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
}
Reme
>
> 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
Got almost everything to work. Thank you all for your input. Code as
follows:
Email Sent\n");
// retrieve values
$row = mysql_fetch_array($ret);
$email = $row["email"];
$title = $row["title"];
$comments = $row["comments"];
$title = $row["title"];
mail($email, $title, $comments, $emailaddress)
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
momen
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 datab
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 Franc
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 =
>
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 =
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 account.
> 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, c
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?
>
> you gave us no info...we can give you no answer
> - Original Message -
>
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.2
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: http://www.php.n
Alex,
> 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 m
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.
/
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 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
That is what I would say as well
"Clever" <[EMAIL PROTECTED]> wrote in message
003301c1e9eb$8e1965a0$[EMAIL PROTECTED]">news:003301c1e9eb$8e1965a0$[EMAIL PROTECTED]...
> You could send it in a
>
>
> - Original Message -
> From: "Alex Francis" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTE
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
Using php & postgresql, I have 2 tables and a sequence as follows:
create sequence serial;
CREATE TABLE glmaster (
id int default nextval('serial'),
accno char(6) constraint accno_con not null unique,
reportlevel int,
nametext,
isheaderboolean defau
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
>
> The button "Email Comments" links to the following page:
>
>
>
>
> // setup SQL statement to retrieve link that we want to edit
> $SQL = " SELECT * FROM $tablename1 ";
> $SQL = $SQL . " WHERE id = $id ";
>
> // execute SQL state
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 = $
You could send it in a
- 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 a list of stories to be checked and ed
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
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 tt
I had the same problem when I wanted to compare dates. After a lot of help
through this forum I used dropdown boxes to ensure the dates were entered
correctly, (in the UK we use dd,mm,yyy). I made each value it's own variable
then merged them as follows before inserting them into a date field
$ev
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 p
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
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
36 matches
Mail list logo
