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
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
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
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
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
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
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
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
Sorry, then. Just that people were helping me earlier...but anyway never mind
thanks for all your previous help.
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
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
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, "/");
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
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
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
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 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
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
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
[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 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 .= ', ';
> > > }
> > > }
> > >
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
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
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($
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(', ',
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(
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
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
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
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
thks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
>"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
>
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
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
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
> -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
36 matches
Mail list logo