The mysql_create_db() and the other functions are fine but I find it
easier to use SQL statements and then send them through the mysql_query()
function
George
At 05:10 11/11/2000 +0100, Henning Block wrote:
>Hi,
>with the php-command
>mysql_create_db ("my_db");
>
Oli,
You may wish to visit www.udzone.com and have a look through a
few of the tutorials on how to set up UD with PHP and the Phakt server model.
George
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e
It's probably alot more efficient to set up a scheduled job which
removes timed out users every minute. This keeps your 'check and see if
the user is expired' code from running any more frquently than it needs
to be.
george
Toby Butzon wrote:
>
> Set up an expire tim
MaxClients inyour httpd.conf is a nice way to limit it. :)
Karsten Dambekalns wrote:
>
> On Thu, Jan 25, 2001 at 08:22:07PM +0100, Matthias Kopolt wrote:
> > Are you useing persistent connections (I had no real luck with them)?
> >
> > How do you connect to your DB over Multi Threaded Server (M
more educated opinions than mine regarding this.
Anyone know?
Best,
George
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
#by numeric index..
echo $row["shed"]; #or by column name..
If you wish to find out all the column names and values, try
print_r($row);
George Patterson
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ld be a good
idea as well, as I am not aware of any legitimate users coming from
there.
Thanks,
George
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
svote453.vote as hud_vote, energyrollcall630.vote as energy
vote, medicarerollcall669.vote as medicare_vote from fullhouse2,
medicarerollcall669, hr2passage, estatetaxrepeal, headstartvote444,
hudappropsvote453, energyrollcall630
Regards
George Patterson
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Thu, 15 Apr 2004 14:58:09 -0700 (PDT)
andy amol <[EMAIL PROTECTED]> wrote:
> Hi,
>I have a problem with the second file. I am not able to update the
> data from the php program. Any help on that would be appreciated.
> Any modification which would be reduce the code like directly using
>
Bump?
[EMAIL PROTECTED] wrote:
Hi,
I have a page that grabs some data from a MySQL 3.23.58 database on a
RedHat 9 box. I'm trying to migrate the db to a Suse box running MySQL 4.0.15.
When I connect to the MySQL 4.0 DB, I get strange results. For example,
there's a certain query that just retur
d was inserted.
The other way is to alter your insert queries to
insert into table set date_field=now()
George Patterson
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
first letter of a string?
> > - Matt
> >
Or to properly answer the question,
$letter=substr("abc", 0, 1); // returns the first character which is a.
Unless Matt wanted the first letter as opposed to the first character??
George Patterson
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
i know that postgres has a raw binary datatype called bytea for storing
pictures and whatnot, but i'm having trouble finding an example of
displaying an image on a web page with php that is pulled directly from
the database?
is this possible?
if so, how?
thanks.
- philip
--
PHP Database Mailing
Typically, it's infinitely more performance-friendly to simply store
your
files on the hard disk and use the database to refer to that location.
For instance, assume your root web dir is /www. Inside there you have
an
/images directory.
If you religiously put all files inside of /images you can
Tutorials that shows how to upload and store image/binary files in a
database
also usually shows how to retrieve them (and in the case of images,
also how
to display them).
One function you'll find useful is
imagecreatefromstring()
thanks.
i found an example for uploading an image into the pr
$result = pg_exec($dbconn, "SELECT $image FROM thetable where
name='$name');
nevermind. i had a missing double-quote on this line. works great now.
thanks.
- philip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
t;' ' that
Excel puts around any cell containing a comma. So you might need to filter
the output from excel in a text editor too but if its a one-off, its worth
it.
george
- Original Message -
From: "Hendra" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent
- Original Message -
From: George Lioumis
To: B.J.Rumsey
Sent: Wednesday, January 30, 2002 11:47 AM
Subject: Re: [PHP-DB] Drop down list
Try the following:
";
$res = mysql_query($get_list) or die (mysql_error());
while ($row = mysql_fetch_array($res))
{
$artid= $row["
Good day to all.
I tried the following code from PHP's manual
if (isset($submit))
{
if ($submit == "Save")
{
echo "$im_file";
$tok = strtok($im_file, "\\");
while ($tok)
{
echo "$tok";
$tok = strtok ("\\");
}
}
}
I have the string $im_file ="C:image.jpg" and I want to
Thanx!!
It worked perfectly
George
- Original Message -
From: "David Sullivan" <[EMAIL PROTECTED]>
To: "George Lioumis" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 01, 2002 11:51 AM
Subject: Re: [PHP-DB] Help in tokeniz
reate a list of files (links) that he would be
able to access.
Is php the right scripting language for this job?
Thank you for your time, it is greatly appreciated.
John George
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
The first time you enter the page submit button is not pressed. That's why
it gives you this error.
Try the following:
- Original Message -
From: "chris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 08, 2002 3:38 PM
Subject: [PHP-WIN] why doesnt this work?
> i get
I forgot somthing
- Original Message -
From: "George Lioumis" <[EMAIL PROTECTED]>
To: "chris" <[EMAIL PROTECTED]>; "PHP Mailing List"
<[EMAIL PROTECTED]>
Sent: Friday, February 08, 2002 3:37 PM
Subject: [PHP-DB] Re: [PHP-WIN] why do
gin ok but not the select db part.
I tried creating a db using a php script and then selecting it and got the
same problem.
I'm new on Linux so it might be something in the configuration which needs
working on.
Any suggestions?
George in Edinburgh
--
PHP Database Mailing List (http://w
4.0.6/Apache) and I am about to
retest so I'll report back soon.
George
- Original Message -
From: "Greg Donald" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 18, 2002 2:08 PM
Subject: Re: [PHP-DB] Problem connecting to db on Linux
>
login to server and stalled on the select db part?
George
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'George Pitcher'" <[EMAIL PROTECTED]>; "Greg Donald"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent:
an it is correct. Am I missing something else
which is obvious?
George
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'George Pitcher'" <[EMAIL PROTECTED]>; "Rick Emery" <[EMAIL PROTECTED]>;
"Greg Donald&qu
Rick,
Sorry, here it is:
Warning: Supplied argument is not a valid MySQL result resource in
/var/www/html/HERONweb/home.php on line 32
I have 'echo mysql_errno();' just after the query is called but no number is
being displayed.
George
- Original Message -
From: "Rick
onvert the date format from '-00-00' to
'dd/mm'' but have tried displaying the dates with and without the use of
this function with no success.
Any suggestions?
George in Edinburgh
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi!
I think I have solved your problem...
I have attached an sql file to create the sample DB I created for my test
and a PHP file for you to run to see how I have implemented it.
First create the tables with the .sql file an then execute the .php file
from your browser.
Hope these help.
---
I think I forgot something usefull...
- Original Message -
From: "Beau Lebens" <[EMAIL PROTECTED]>
To: "PHP DB (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, February 21, 2002 3:59 AM
Subject: [PHP-DB] SELECT where something exists but something else does not
> Hey guys,
> I am a lit
You can use:
if ( ($var == 1) or ($var == 2) or ($var == 3))
{
...
}
- Original Message -
From: "Dave Carrera" <[EMAIL PROTECTED]>
To: "php List" <[EMAIL PROTECTED]>
Sent: Thursday, February 21, 2002 12:40 PM
Subject: [PHP-DB] How do I add multiple var to a if clause ?
> Hi
and I want to be able to have the user enter 'dd/mm'' into a
form and have it put into MySQL in the -mm-dd format.
Now I have written a function in php to do this but I might be mising an
easier, more elegant/efficient way of doing this.
Any suggestions?
George
Bartek,
This is snipped from a working form on my site:
contains
exact match
begins with
and it works.
George
- Original Message -
From: "Bartek Pawlik" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 26, 2002 10:49 AM
Subj
ourse_ID' I get 18 (for a
particular course) and the above query only displays 3 results.
Any suggestions? I didn't want to clog the list with the whole query but I
can if it's necessary.
George, in Edinburgh
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
o not necessarily relate just to these
records.
Hope this clarifies rather than confuses.
George
- Original Message -
From: "Kevin Bucknum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 4:17 PM
Subject: RE: [PHP-DB] Conflict
lem:
If I do a simple count of transactions.CourseID='$Course_ID' I get 18 (for a
particular course) and the above query only displays 3 results.
Any suggestions? I didn't want to clog the list with the whole query but I
can if it's necessary.
George, in Edinburgh
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ransferred values.
Any ideas as to where it going wrong?
I'm using PHP-4.1.1, Apache (console) on Win 2000Pro.
Regards
George
George Pitcher is Technical Manager for the HERON Project
at Napier University, Edinburgh.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscri
show related information
from the bib_extract table and the scanrates (prices) table.
I've checked the data in these tables and nothing is odd. Maybe there is a
different way to build my query so that it displays the full set of records.
Any suggestions?
George
- Original Message -
F
Thanks to Kevin, who yesterday emailed me with a solution to my JOIN
problem.
Thanks to all who helped me see the wood for the trees.
George
- Original Message -
From: "Doug Thompson" <[EMAIL PROTECTED]>
To: "George Pitcher" <[EMAIL PROTECTED]>; <[E
!
MTIA
George in Edinburgh
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
I'm working on a small Access 2000-based project and I'm getting a SQL Error
.
This is the query (built in PHP):
SELECT * FROM 'Documents'WHERE (CourseRef='4712' AND
Valid_From<=#26/03/2002# AND Valid_Until>=#26/03/2002#) Order by
Author,Title
Any
Adam,
Thanks for the assist.
The query works fine without the ( ) arount the conditions.
Now on to the next part.
George
- Original Message -
From: "Adam Royle" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, March 26, 20
g that debug is still available from the C: prompt?
George
- Original Message -
From: "Sommai Fongnamthip" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 8:53 AM
Subject: [PHP-DB] csv without line feed
> Hi,
> I have text file with CSV
tus from /var/tmp/rpm-tmp.8748 (%build)
RPM build errors:
Bad exit status from /var/tmp/rpm-tmp.8748 (%build)
--- Ebd relevant screen output ---
I have contacted IBM's support desk and they're at a complete loss.
If anyone here can help, I'd be more than gr
thout a problem. Possibly a cursor problem (I remember some, but not
enough, stuff from my brief flirtation with ASP).
Any clues?
George in Edinburgh
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
t one solution is to ditch the primary key (not really needed in
this table) and just insert the values into the table without specifying the
recipient fields (it is a log table).
George
- Original Message -
From: "Miles Thompson" <[EMAIL PROTECTED]>
To: "George
Steve,
That only produces a data type mismatch error message.
George
- Original Message -
From: "Steve" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 04, 2002 5:05 AM
Subject: [PHP-DB] Re: Inserting into Access
> Try adding single quotes to
You can't have NOT NULL assigned to a text field.
george
- Original Message -
From: "Lisi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 08, 2002 10:11 AM
Subject: [PHP-DB] Error creating new table
> I am trying to create the fo
Orders/Cust Average over prev 12 months.
My work with MySQL has never been this detailed.
Can anyone give me any pointers?
Regards
George in Edinburgh
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Suman,
Firstly, it's a bit longer than necessary.
Make your form a 'POST' rather than 'GET' and you'll hide your query and
will then be the equivalent.
I presume that you have been able to display other PHP stuff?
Check your php.ini file and make sure that the part that allows you to use
th
Just a thought.
Try putting quotes around the 'True'.
George (no expert - not even a novice - yet)
- Original Message -
From: "Daniel J Owen-Mcgee" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 04, 2002 2:29 PM
Subject: [PHP-DB] M
Hi,
Can anyone point me in the direction of resources on PHP and Oracle9i
(Win2K). I have the db installed on my laptop, on which I already have PHP
running with IIS5 and would like to use PHP with Oracle.
Any tips (even if it's a 'waste of effort' type) would be welcome.
G
AME'];
print ("");
print $row['ACFTREF.TYPE_ACFT'];
print ("");
print $row['MASTER.SERIAL_NUMBER'];
print ("");
} while ($row = mysql_fetch_array($result)) ;
} else {print "Sorry, no results found!";}
}
?>
Just for info, the M
Hi all,
Well, I played about abit more and discivered that I as overcomplicating
things by specifying the tablename in field to be displayed. Once I set it
to just display the fieldname it worked swimmingly.
Now I can really get going.
George
- Original Message -
From: George Pitcher
Guys,
If the purpose of the first message which prompted this thread was to reduce
bandwidth, then it gives the impression that its ok to waste bandwidth
having a meaningless debate like this but not if it's to deal with a
newbie's request.
just my 2c
George, an English newbie i
Hi all,
I have a MySQL table with approx 350,000 records (US aviation register) and
the way the FAA produce it is without the 'N' prefix which I wish to add.
Can anyone point me to a sql command which will upodate the N-Number field
to 'N' + N-Number field
ppears to have more '.h' files.
Obviously the files are there somewhere but I'm stuck as to how to do the
'./configure'.
I cannot use the prescribed '--with-mysql=/usr/local/mysql' coz that won't
point to anything. So what
'/usr/src/mysql-3.23.37/sql'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory '/usr/src/mysql-3.23.37'
make: *** [all-recursive] Error 2
Any suggestions
Regards
George Pitcher
Technical Manager
HERON Project
Napier University
Edinburgh EH10 5DT
[EMAIL PROTE
Justin,
Thanks. It appears to happen in the same place each time I try (4 attempts
as its not that quick [about 1 hr each try]).
So should I download a new compiler (is it the gcc++ or if not, what?)?
George
- Original Message -
From: Justin Buist <[EMAIL PROTECTED]>
To: George P
esult));
} else {print ("Sorry, no aircraft matching your criteria were found.");}
?>
=
Any suggestions as to where I'm going wrong?
Regards
George Pitcher
Technical Manager
HERON Project
Napier University
Edinburgh EH10 5DT
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[E
| G-AXDL |
|DM | BAE HS 125/400B | 25194 | | G-AXDM |
++-+-+--+-+---+
In these records, what is actually in the ID field is also being displayed in
'History'.
Not sure if this clarifies things?
Geo
');
> > if ($Serial == "")
> > {$Serial = '%';}
> > if ($Type == "")
> > {$Type = '%';}
> > if ($Con == "")
> > {$Con = '%';}
> > $result=mysql_query ("SELECT * FROM biz WHERE
> > ID LIKE
Jason,
Having tried your suggestion, I see that I can connect to the server but
cannot select the db.
Where do I go from here?
George
- Original Message -
From: Jason Wong <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 03, 2001 4:39 PM
Subject: Re: [PH
Oops, I forgot to say that I can handle this db as a client on the command
line and it shows up under mysqlshow.
George
- Original Message -
From: George Pitcher <[EMAIL PROTECTED]>
To: Jason Wong <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, Septembe
main.php?sectionName=home&variable_2=value&...&variable_n=value
- Original Message -
From: "Tony Leach" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 17, 2001 5:11 PM
Subject: [PHP-WIN] variables in URL
> How do I construct a URL to pass more than one variable t
Yes, but mySQL 4.0 is alpha Release and Apache 1.3.22 for Win32 is not as
stable as for Unix platforms
So, let's wit a bit more!
- Original Message -
From: "suraj" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 18, 2001 10:55 AM
Subject: [PHP-WIN] released
> Hel
Il faut tu ecrire:
if ($colonne["LIV_TYPE_EVT"] == 21)
{
$couleur = "yellow";
}
else if ($colonne["LIV_TYPE_EVT"] == 1)
{
$couleur = "009933";
}
else
{
$couleur = "FF";
}
Georges Lioumis.
I think that you MUST retype the whole URL.
George.
- Original Message -
From: "J-E-N" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, October 20, 2001 2:22 PM
Subject: [PHP-DB] https
hello,
how can i switch from http to https without typing
Good day to all!
Consider the following code:
I want to get the text that the user writes into the text field into a php variable to
use it in the same page.
I want to use this text as a criteria to search for an entry in my mySQL DB using a
LIKE statement in the select.
Does anyone kno
TML?
> Try...
>
>
>
> Then in your page have a php tag that checks for the presence of $Find (in
> your case), e.g.
>
> if ($Find) {
> sql = (SELECT * FROM table WHERE $criteria = "value");
> then the rest...
> }
>
> -torrent
>
> "Geo
What if you are on win2K?
- Original Message -
From: "Jonathan Hilgeman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, December 20, 2001 12:22 PM
Subject: [mysql-support] RE: [PHP-DB] Run php page automatically
> I usually just cre
look at http://www.phpbuilder.com/columns/siddarth2228.php3 for a good
tutorial.
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
<[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[E
pls help me with syntax for insert into mdb via odbc.
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
it's OK. I did it.
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
"George Nicolae" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> pls help me with syn
for Win32(NT) and MSAcess 2000, whenever you retrieve a date column/field,
php will automatically convert it to '/mm/dd hh:mm:ss' format regardless
of the style of date you've denoted in Access
how can I resolve this problem and print in a different format?
--
Best regards,
"select * from your_database where pid=1234"
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
"Dave Carrera" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]
i did it with date("F j, Y",strtotime(odbc_result($cur,"date"))).
but i very curios about the query. it must looke like..?
select date from my_table?
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.
ery "select date
from my_table"
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
"Andrew Hill" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Geo
date() use a timestamp. I receive a string. if I echo
odbc_result($cursor,"date") it shows like "2001-11-21 00:00". Can it echo
(without date() function because I don't receive a timestamp) "21 Nov 2001"?
--
Best regards,
George Nicolae
IT Manager
you can't make this query because type mismatches.
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
"Thomas "Omega" Henning" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]&quo
and who looks the query with "substr the date so i get only the year"? Type
the exact query you make.
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
"Thomas "Omega" Henning" <[EMAIL PR
ecord is a date column
id is an integer column
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
"Thomas "Omega" Henning" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAI
select substring_index(date_record,"-",1)+id as sum from test order by sum
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
"Thomas "Omega" Henning" <[EMAIL PROTECTED]> wrote in me
Try the following:
I believe that this should work (I haven't tried it though!!!)
May the force be with you!!!
George
- Original Message -
From: "Andy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 04, 2002 3:50 PM
Subject: [PHP-DB] How t
if ($myrow[Admin] == "Y"){
> header ("Location:admin.php");
> }else{
> header ("Location:user.php");
> }
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
"Matt Stewa
please give us some more code to help you.
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
"Nathon Jones" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
if (empty($var)) {
}
else
{
}
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
"Gary Smith" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hiya, I'm w
look at http://www.webmasterbase.com/article/228
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
"Sg" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi,
>
s to parse the data both ways. All the example I could find on Dates
used 'today' as the example. I want to be able to play around with stored
dates. Is my function method the correct way or is there another way?
MTIA
George in Edinburgh
---
Outgoing mail is certified Virus Free.
Check
can think of
at least one other query which would be needed to cover another process.
If a single query is taking so long, what will 6 do to my database's overall
performance? Would indexing help?
George
- Original Message -
From: "Miles Thompson" <[EMAIL PROTECTED]&g
];
$day = $today[2];
$year = $today[0];
$p_date = $day . "/" . $month . "/" . $year ;
return $p_date;
}
function revdate($input)
{
$ztoday = explode("/",$input);
$day = $ztoday[0];
$month = $ztoday[1];
$year = $ztoday[2];
$revdate = $year . "-" . str_pad($mon
ur comments tomorrow when I get back in.
Regards
George
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: "George Pitcher" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 08, 2002 1:07 PM
Subject: Re: [PHP-DB] Concept help
tion_block .= "$prd";
}
I want to store into another table in my DB the product_id that corresponds to the
product_name that the user has selected
Any help greatly appreciated.
George
/Lasso) and that as well as the dev databases being on my laptop,
so is the MySQL/PHP solution. New laptop expected within a couple of weeks
and this one will then be switched to Linux.
Regards
George
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.gri
eems to me that you are not offering this
data
> > to "the web", ie I can't get to it;
> > > you are only offering it to the copyright fee-paying clients. Hence
the
> > publishers' argument seems
> > > illogical/ignorant...
> > Yes, exactly, bu
hen use this as an example of how to shift functionality out
of PHP (the 'middle box') and into
> SQL (the 'left-hand box')?
Yes, please do. But if I could interject with a sub-concept question. Much
of what I will be scratching my head about can probably be achieved with SQL
rname will be substituted inside the single quotes, eg
>
> SELECT Month, Score FROM scores WHERE Username = 'George Pitcher'
>
> =The second line throws the query at MySQL and receives two results by
return. Firstly the logical: "did the
> call work or not?" w
I was having something similar and solved it by wrapping the column names in
parentheses:
select password, 1 as auth from acl where (username='andrewd' and
password=MD5(andrewd.madonna));
It might help. or eliminate something if I'm not right.
George
- Original Message ---
pad($day, 2, "0", STR_PAD_LEFT);
return $revdate;
}
I've stored these in a file which I include and any call to the db to
display dates uses the dbdate() function and if I want to insert or update a
date then I use the revdate() function.
There are probably better ways to do
1 - 100 of 157 matches
Mail list logo
