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. If not,
flame me for all
-Original Message-
You can use
table
tr
td
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
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:
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
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
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
dd/mm/yy
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
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
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_Dateinput type=checkbox name=ch1 value=Enter_Date
Opening_Unitsinput type=checkbox name=ch2
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[]
input type=checkbox name=ch[] value=Enter_Date/
Then you can loop through the checkbox array and run your query that way
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(', ', $chkboxes) .
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($chkboxes
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
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';
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 .= ', ';
}
}
$sql .= ' FROM form';
[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.
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 someone to
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
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 message
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
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
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
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.
code
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 |
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
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.jpguserID=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
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
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
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.jpguserID=215
photoID = uploads/1052367746.jpg
userID = 215
I want to point to a record in a recordset.
That records id is
36 matches
Mail list logo