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($s
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]
// htt
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
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 this accepted input into
> -mm-dd format to store in database ?
>
> thnx and regards
>
>
>
> _
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 up
...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 sup
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
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 email='$em
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 8/
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
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 .
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 som
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)
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
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 scr
On Sunday 18 August 2002 04:22 pm, you wrote:
> 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..
20 matches
Mail list logo
