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 query for
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 Sunday 18 August 2002 13:40, Chip Wiegand wrote:
Okay, so I tried this -
if ($date_am || $exercise_am || $reps_am !== )
{
$sql_am = insert into absmachine (today,exercise,reps,comments)
values ('$date_am','$exercise_am','$reps_am','$comments_am');
mysql_query($sql_am) or
hii
i'm using php with my sql. i wanted to take date input in the dd-mm-yy
format from user. is there any function to convert this accepted input into
-mm-dd format to store in database ?
thnx and regards
_
Send and receive
if (!isnull($date_am || $exercise_am || $reps_am)) then
mysql_query($sql_am) or die
(Error in this query $sql : .mysql_error());
Try:
if(!isnull($date_am) !isnull($exercise_am) !isnull($reps_am))
This should IMO work :)
-Joni-
--
// Joni Järvinen
// [EMAIL PROTECTED]
//
Read about GRANT function in the MySQL manual.
-Joni-
--
// Joni Järvinen
// [EMAIL PROTECTED]
// http://www.reactorbox.org/~wandu
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
?
$datum=07-11-76;
$date=explode('-',$datum);
echo date('Y-m-d',mktime(0,0,0,$date[1],$date[0],$date[2]));
?
Op zondag 18 augustus 2002 09:53, schreef Smita Manohar:
hii
i'm using php with my sql. i wanted to take date input in the dd-mm-yy
format from user. is there any function to convert
I'm not actually running PostgreSQL so it's setup could be different
that MySQL. But if you want to install PHP with MySQL support and the
database isn't running locally you just do '--with-mysql' in the
configure statement. It'll give you a warning saying that its not
suggested to do this, but
As Joni said you need to read about the GRANT functions in the MySQL
manual. But basically here's what's happening.
Each person your hosting has a specific login/pass into the database.
When they login MySQL looks in the 'MySQL' database and checks the users
privileges. By default Ensim sets
...listen to Ramsus =)
~Matthew
-Original Message-
From: Brian Noecker [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 17, 2002 9:08 PM
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] installing to connect to a remote database server
Newbie here.
I need to install php with postgres
On Sun, 2002-08-18 at 01:20, Joni Järvinen wrote:
if (!isnull($date_am || $exercise_am || $reps_am)) then
mysql_query($sql_am) or die
(Error in this query $sql : .mysql_error());
Try:
if(!isnull($date_am) !isnull($exercise_am) !isnull($reps_am))
This should IMO work :)
-Joni-
Im trying to solve a problem with windows xp.
I have 2 identical scripts with the same db schema. One on FreeBSD
running php 4.2.2/mysql 3.23.49 the other
on windows xp php 4.2.2/mysql 3.23.52.
The section of the script is supposed to update a table.
--
$sql = UPDATE users SET
I have a field in a form which allows user to upload thier biographys.Once
they upload a bunch of texts,the script I wrote automatically show it on a
webpage, however, the contents are all scrambled toghther without line break
and formatting..
How am I able to show the formatted outputs?
I tried
Gerard,
This is a shot in the dark, but does the web server (usually NOBODY, but
crash in this case? Ominous name!) have an account on the XP box and the
appropriate permissions to write to the MySQL database? That's where I'd
start, along with checking mysql_error().
Miles
At 04:18 PM
On Sun, 2002-08-18 at 01:20, Joni Järvinen wrote:
if (!isnull($date_am || $exercise_am || $reps_am)) then
mysql_query($sql_am) or die
(Error in this query $sql : .mysql_error());
Try:
if(!isnull($date_am) !isnull($exercise_am) !isnull($reps_am))
This should IMO work :)
-Joni-
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
I have a field in a form which allows user to upload thier biographys.Once
they upload a bunch of texts,the script I wrote automatically show it on a
webpage, however, the contents are all scrambled toghther without line break
and
If the method they use to upload involves pasting
the text into an HTML textbox, I usually do this:
replace all occurances of \n with br.
Look into the ereg_replace() function in the manual or
at php.net for more info, but that is some limited
formatting.
If you need further formatting, like
On Sun, 2002-08-18 at 21:21, Chip Wiegand wrote:
On Sun, 2002-08-18 at 01:20, Joni Järvinen wrote:
if (!isnull($date_am || $exercise_am || $reps_am)) then
mysql_query($sql_am) or die
(Error in this query $sql : .mysql_error());
Try:
if(!isnull($date_am) !isnull($exercise_am)
hello,
i'm using php with sql i wanted to store text in database along with
formatting, so that when i retrieve it, it should be printed with all the
formatting which is used while storing the value in database. is there any
function as such for this stuff?
thnx and regards,
smita.
On Sun, 2002-08-18 at 01:20, Joni Järvinen wrote:
if (!isnull($date_am || $exercise_am || $reps_am)) then
mysql_query($sql_am) or die
(Error in this query $sql : .mysql_error());
Try:
if(!isnull($date_am) !isnull($exercise_am) !isnull($reps_am))
This should IMO work :)
-Joni-
This is CorpseEater's reply on your message send to him on 8/19/2002 :
Well, there has been a lot of talk on this list about whether you should put
anything into the database except the data it self - and i don't think you
should. Place the data in the database and make the output
21 matches
Mail list logo