On Sat, 2002-08-17 at 21:25, Jason Wong wrote:
> You have to check them before inserting.
>
> if ($value !== "") {
> insert_value();
> }
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Okay, so I tried this -
if ($date_am || $exercise_am || $reps_am !== "")
On Sat, 2002-08-17 at 19:49, John Coder wrote:
>
> This may or may not work but what the h***. If you have multiple insets
> commands test for ! isnull() on each input field ,i.e. variable.
>
> if (! isnull($input_field))
> then "insert_query"
>
> as I said this will only work with an insert
Hello,
On 08/17/2002 04:28 PM, Leif K-Brooks wrote:
> I'm redoing my web site, and I'm considering using a db abstraction
> layer. Would I need one, and should it be db-type specific (like, can
> just do one db type)? I don't plan to change database types.
If you don't plan to change databas
On Sunday 18 August 2002 09:54, Georgie Casey wrote:
> rite,
> i run a web server and sell space to workers. my admin setup apache, mysql
> and php with all the settings. each customers gets one sql db with a host
> acc. the system runs ensim. but now i want one of my accounts do be able to
> acce
I have this query:
select avg(article_comment.vote) as avg, article_data.aid,
article_data.time, article_data.name, article_data.description from
article_data, article_comment where article_comment.aid = article_data.aid
AND released > 1 GROUP BY article_data.aid order by time desc
One table has
Thanks
I originally wasn't doing a cross-table join with that query so I forgot to
put the join in :-}
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
--
Please reply on the list/newsgroup unless the reply it OT.
"Michael Hazelden" <[EMAIL PROTECTED]> wrote in message
C1260EE72F22C44F833D033
> > -Original Message-
> > From: Chip Wiegand [mailto:[EMAIL PROTECTED]]
> > Sent: Sunday, 18 August 2002 7:08 AM
> > To: phpdb
> > Subject: [PHP-DB] oddity with insert multiple input fields to multiple
> > tables
> >
> >
> >
> > I have a web page interface to a mysql database. In this we
On Sat, 2002-08-17 at 17:08, Chip Wiegand wrote:
> I have a web page interface to a mysql database. In this web page I have
> about a dozen form input fields. On submit these are submitted to
> multiple tables, a differant table for each input field. If I leave any
> fields blank, and insert only
Hi there - it's quite simple.
In this query - you're asking for the average of the vote over the entire
article_comment table - you haven't placed a join between the two tables.
You need to find your linking field - and join them on that.
Cheers,
Michael.
-Original Message-
From: JJ H
rite,
i run a web server and sell space to workers. my admin setup apache, mysql
and php with all the settings. each customers gets one sql db with a host
acc. the system runs ensim. but now i want one of my accounts do be able to
access the database of another, but it wont let me. what setting do
Here the query is:
select avg(article_comment.vote) as avg, article_data.aid,
article_data.time, article_data.name, article_data.description from
article_data, article_comment where released > 1 GROUP BY article_data.aid
order by time
It works fine but the average echoed is always the same (whic
You need to have the postgresql client library (called libpq) and
its associated header files installed on the machine you are compiling PHP
on.
-Rasmus
On Sat, 17 Aug 2002, Brian Noecker wrote:
> Newbie here.
>
> I need to install php with postgres support. Problem is I need to have it
> conn
Newbie here.
I need to install php with postgres support. Problem is I need to have it
connect to a non-local database. Now, the pgconnect function seems to allow
for that, but the install wants local files.
Can someone point me in the right direction here?
Thanks,
Brian
--
PHP Database M
Hmmm... OK this may a long way around but if when you
are generating your graph, if the value returned is
then get the next value minus it from the last good
value and store it as a value. Get the last the
last good, minus the calculated value and use that
as the missing value.
Put this all into
My Linux box is setup with Sybase ASE 11.9.2-3 (same for the common
files) and the openclient is 11.1.1-3. The server I'm connecting to is
running 11.9.2.5. phpinfo shows sybase_ct support. PHP version is
4.1.2.
I'm getting intermittent connection failures on various queries. Maybe
1 out of
My Linux box is setup with Sybase ASE 11.9.2-3 (same for the common
files) and the openclient is 11.1.1-3. The server I'm connecting to is
running 11.9.2.5. phpinfo shows sybase_ct support. PHP version is
4.1.2.
I'm getting intermittent connection failures on various queries. Maybe
1 out of
I have a web page interface to a mysql database. In this web page I have
about a dozen form input fields. On submit these are submitted to
multiple tables, a differant table for each input field. If I leave any
fields blank, and insert only some of the fields, the database will
insert an empty row
My current website is www.ecritters.biz. I think I need one mostly for
counting how many queries a page uses, for changing stuff about how
queries are executed (like doing something with the errors on every
query), etc.
MET wrote:
>What's your current website? Why do you think you need one?
What's your current website? Why do you think you need one?
~MET
-Original Message-
From: Leif K-Brooks [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 17, 2002 3:28 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Database abstraction layer needed?
I'm redoing my web site, and I'm consi
I'm redoing my web site, and I'm considering using a db abstraction
layer. Would I need one, and should it be db-type specific (like, can
just do one db type)? I don't plan to change database types.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
I want connect cisco router over telnet connection
a need send char CTRL-Z for update change
from DB and save and exit.
I do not know how Scan code or CHR() have
combination from keyboard CTRL + Z.
Plese help me.
My code:
<%
$ctrlz=???;
$fp = fsockopen ($myIPadress, 23, $errno, $errstr, 30);
On 17-Aug-02 bo wrote:
> $insertQuery = "INSERT INTO tablename VALUES ( \"{$Seeking}\",
^^
('$Seeking',...)";
>
> )";
>
> (and in the future how do I retrieve those from mySQL and ou
here is a block of code inside a form
Record Contract
Pub Contract
Live Gigs
three radio button with the same name but different value, my question is
how to insert the value that user clicked when processing the for
23 matches
Mail list logo