> -Original Message-
>
> You can use
>
>
>
>
> and each tr becomes an excel row and each td becomes a cell. This may or
> may not work in/before excel97??
>
> If you're looking to create true excel files, then i highly suggest
> spreadsheetwrite_excel,
> It is an ex
may be you have not uncommented
extension_dir="c:/php/ext/"
(Directory in which the loadable extensions (modules) reside)
please check.
balwant
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 18, 2004 3:47 AM
To: [EMAIL PROTECTED]
Subject: [PH
Hi all,
can someone kindly point me to a resource that converts all kinds of possible date
inputs into MySQL format of -MM-DD?
example of formats to be converted includes:
d/m/yy
d/m/
d/mm/yy
d/mm/yyy
dd/mm/yy
dd/mm/yyy
d/mmm/yy
d/mmm/
dd/mmm/yy
dd/mmm/
yy - 2 digit repre
This is a MySQL error on the server side - you need to make sure that
whatever user you're signing into MySQL with has access to modify the
database/table you're using. I believe the GRANT keyword in MySQL is
what you need -- look at the MySQL reference manual:
http://dev.mysql.com/doc/
Good luc
>"Ng Hwee Hwee" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>Hi all,
>
>can someone kindly point me to a resource that converts all kinds of
possible date inputs into MySQL format of -MM-DD?
>
>example of formats to be converted includes:
>
>d/m/yy
>d/m/
>d/mm/yy
>d/mm/yyy
>
thks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Also, take care with the new password hashing:
http://dev.mysql.com/doc/mysql/en/Password_hashing.html
Paul
On Wed, 18 Aug 2004 00:56:08 -0700, Peter Ellis <[EMAIL PROTECTED]> wrote:
> This is a MySQL error on the server side - you need to make sure that
> whatever user you're signing into MySQL
can somebody advise me
i want to use checkboxes on my website, i want that if user selects some
checkboxes (there will be more than 20 checkboxes), checkbox's value will be
stored in variables and than SELECT query command will be run using these
variables through PHP. but my problem is that in SE
balwantsingh wrote:
can somebody advise me
i want to use checkboxes on my website, i want that if user selects some
checkboxes (there will be more than 20 checkboxes), checkbox's value will be
stored in variables and than SELECT query command will be run using these
variables through PHP. but my p
i am using following coding
$a1 = $_POST['ch1'];
$a2 = $_POST['ch2'];
$a3 = $_POST['ch3'];
if ($a1 or $a2 or $a3) {
$query = "SELECT $a1, $a2, $a3 FROM form";
[EMAIL PROTECTED] ($query);
}
Enter_Date
Opening_Units
Unit_Consumed
-Original Message-
From: John Holmes [mailto:[EMAIL PROTEC
If one of the checkboxes is NOT checked, then your query will break as
ift will look something like this:
SELECT xxx,,yyy FROM form;
Name your checkboxes like so: ch[]
Then you can loop through the checkbox array and run your query that way
$chkboxes = $_POST['ch'];
$sql = 'SELECT ';
foreach(
On 18 August 2004 11:24, randy wrote:
> $chkboxes = $_POST['ch'];
> $sql = 'SELECT ';
> foreach($chkboxes as $k => $v)
> {
> $sql .= $v;
> if($k < (sizeof($chkboxes) - 1))
> {
> $sql .= ', ';
> }
> }
> $sql .= ' FROM form';
$sql = 'SELECT ' . implode(', ',
yeah yeah...it's damn near 4 in the morning here...my brain isn't
exactly on at the moment.
:)
On Wed, 18 Aug 2004 11:35:59 +0100, Ford, Mike [LSS]
<[EMAIL PROTECTED]> wrote:
> On 18 August 2004 11:24, randy wrote:
>
> > $chkboxes = $_POST['ch'];
> > $sql = 'SELECT ';
> > foreach($
John Holmes wrote:
[EMAIL PROTECTED] wrote:
I've been trying to install mysql. I installed that new PHP5 that just
came out with the zip file. I configured in php.ini where the .dll
files are: c:/php/ext/. Then I uncommented php_mysql.dll and
php_mysqli.dll.
When I restarted apache 1.3.31, my s
Ford, Mike [LSS] wrote:
$chkboxes = $_POST['ch'];
$sql = 'SELECT ';
foreach($chkboxes as $k => $v)
{
$sql .= $v;
if($k < (sizeof($chkboxes) - 1))
{
$sql .= ', ';
}
}
$sql .= ' FROM form';
$sql = 'SELECT ' . implode(', ', $chkboxes) . 'FROM form';
J
On 18 August 2004 15:53, John Holmes wrote:
> Ford, Mike [LSS] wrote:
>
> > > $chkboxes = $_POST['ch'];
> > > $sql = 'SELECT ';
> > > foreach($chkboxes as $k => $v)
> > > {
> > > $sql .= $v;
> > > if($k < (sizeof($chkboxes) - 1))
> > > {
> > > $sql .= ', ';
> > > }
> > > }
> > >
[EMAIL PROTECTED] wrote:
I finally got my PHP5 installation to support MySQL and now this. When I try
to edit anything on mysqlgui.exe, it just gives me this error: error in
database function: access denied for user @localhost...
I don't know if this has to do with my php installation or what. I
On Wednesday 18 August 2004 20:07, Ford, Mike [LSS] wrote:
> > > $sql = 'SELECT ' . implode(', ', $chkboxes) . 'FROM form';
> >
> > Just note that with either solution, someone can post a value of "*
> > FROM table WHERE 1#" and see everything in any table in your database.
>
> I was waiting for
Greetings,
I am having some trouble with this error message and finding out what it really means.
I receive this in my HTTP error log from apache 1.3.
[Tue Aug 17 23:36:04 2004] [error] PHP Warning: odbc_connect(): SQL error: , SQL
state ÿÿÿþ in SQLConnect in /srv/www/htdocs/acquisuite/idxdb2.p
You might want to look into date conversion on the MySQL side:
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
Look for
DATE_FORMAT(date,format)
Paul
On Wed, 18 Aug 2004 10:16:59 +0200, Torsten Roehr <[EMAIL PROTECTED]> wrote:
> >"Ng Hwee Hwee" <[EMAIL PROTECTED]> wrote in mes
Look I'm totally new to this, so all this MySQL stuff you are sending me too
is like an alien language to me.
Can you just tell me how to delete all this MySQL stuff so I can start again
or something? Because even when I reinstall MySQL and delete my old
MySQLgui.exe, it still gives me the same
you need to ditch the 'data' directory (in the MySQL installation
root) and start from scratch. If you just re-install the MySQL server,
I don't think it will overwrite your data directory.
On Wed, 18 Aug 2004 10:30:25 EDT, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> Look I'm totally new to th
On Wednesday 18 August 2004 22:30, [EMAIL PROTECTED] wrote:
> Look I'm totally new to this, so all this MySQL stuff you are sending me
> too is like an alien language to me.
New doesn't excuse you from reading documentation. Last time I looked the
documentation was available in English too.
> C
Ok, thanks to many people's help, I have managed to install MySQL right and
login as root with no password. However, MySQL will not allow to log in to my
databases as root. Is this normal, because when I try it brings back the old
access denies: [EMAIL PROTECTED] thing.
So I thought maybe I jus
After connecting to a database I execute the following code. I never get a
file created on the computer that is logging in. At the top of the code I do
have ob_start(); and ob_end_flush();
If I go to other web sites I get there cookies file.
setcookie("logged_in", 1, time()+300, "/");
This isn't the appropriate list to direct this question to. I suggest
one of the MySQL help lists or a careful reading of the documentation,
which tells you exactly what you need to know.
--
Peter Ellis - [EMAIL PROTECTED]
Web Design and Development Consultant
naturalaxis | http://www.naturalaxis
Sounds like it could be permissions -- more code would help, but general
comments:
1) make sure you have access to the database
2) make sure the server you're using has write access to wherever that
file is being written
3) you might consider putting setcookies close to the top of the file,
as it
Sorry, then. Just that people were helping me earlier...but anyway never mind
thanks for all your previous help.
I have a bunch of thumbnails that are pulled from a recordset based on a
user profile.
Each thumbnail opens the picture into another page so that the picture is
larger and I want to now have that user's pictures accessible by clicking a
previous and/or next arrow.
The first recordset of thumbnails
I assume you mean the 1052367746 portion of that URL? Am I right? If
so:
$id = basename($photoid, ".jpg");
That would work, I think, if you just wanted the numeric portion of the
path. Not sure if this is what you want.
--
Peter Ellis - [EMAIL PROTECTED]
Web Design and Development Consultant
That's not what I mean at all. I actually have no idea where you got that
from. :)
Basically what I'm trying to say is this. The following is my url:
mypage.php?photoID=uploads/1052367746.jpg&userID=215
photoID = uploads/1052367746.jpg
userID = 215
I want to point to a record in a
Ach, and the light bulb goes on. Sorry, wasn't really thinking about it
completely earlier.
Here's a less dimbrained suggestion: could you encode the user ID as
part of the filename itself? Like, for instance, write the script so
that it would read something like:
blah.jpg.215
and strip off th
Sorry but that doesn't make and sense either. I have no problems passing the
variables along. Why are you trying to tag that to the image?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi Vern,
Vern wrote:
The first recordset of thumbnails is retrieved by a URL link
($HTTP_GET_VARS['id']) which is the user's ID number.
Click on one of the thumbnails a new page is open that display the larger
photo, but only that photo. I can of course pass along the user's ID as well
mypage.php?p
mysql> grant all privileges on *.* to [EMAIL PROTECTED] identified by
'password' with grant option;
try this out
balwant
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 19, 2004 12:13 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL denying ac
On Thursday 19 August 2004 09:23, Vern wrote:
> Basically what I'm trying to say is this. The following is my url:
>
> mypage.php?photoID=uploads/1052367746.jpg&userID=215
>
> photoID = uploads/1052367746.jpg
> userID = 215
>
> I want to point to a record in a recordset.
> That recor
36 matches
Mail list logo
