On Fri, 2010-06-04 at 06:46 -0400, Gary wrote:
I am trying to get an update command to work in PHP. I am able to update
records going directly to phpmyadmin command line. I have even let it
produce the php code to insert, but have not been able to get it to work.
I have it stripped down
Ashley Sheridan a...@ashleysheridan.co.uk wrote in message
news:1275649100.2217.45.ca...@localhost...
On Fri, 2010-06-04 at 06:46 -0400, Gary wrote:
I am trying to get an update command to work in PHP. I am able to update
records going directly to phpmyadmin command line. I have even let it
Gary gwp...@ptd.net wrote in message
news:a9.ea.07323.381e8...@pb1.pair.com...
Ashley Sheridan a...@ashleysheridan.co.uk wrote in message
news:1275649100.2217.45.ca...@localhost...
On Fri, 2010-06-04 at 06:46 -0400, Gary wrote:
I am trying to get an update command to work in PHP. I am
On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta [EMAIL PROTECTED]wrote:
What I want to do is find the top 10 servers where the column steps =
iisreset. The following code works great except that the page is not
displaying the servername in the 'Server Name' column of my results (nothing
Dan Joseph [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta
[EMAIL PROTECTED]wrote:
What I want to do is find the top 10 servers where the column steps =
iisreset. The following code works great except that the page is not
displaying
On Wed, Sep 17, 2008 at 2:30 PM, Vinny Gullotta [EMAIL PROTECTED]wrote:
Dan Joseph [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta [EMAIL PROTECTED]
wrote:
What I want to do is find the top 10 servers where the column steps =
Dan Joseph [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Wed, Sep 17, 2008 at 2:30 PM, Vinny Gullotta
[EMAIL PROTECTED]wrote:
Dan Joseph [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta
[EMAIL PROTECTED]
wrote:
What
You'll want to change your Order By statement to 'ORDER BY CountSteps DESC'.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
Vinny Gullotta wrote:
echo $query;
yields
SELECT servername, COUNT(steps) as CountSteps FROM monitoring WHERE
steps =
Still no luck displaying the stupid servername. Any other things I can try?
Micah Gersten [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
You'll want to change your Order By statement to 'ORDER BY CountSteps
DESC'.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta [EMAIL PROTECTED]wrote:
What I want to do is find the top 10 servers where the column steps =
iisreset. The following code works great except that the page is not
displaying the servername in the 'Server Name' column of my results (nothing
Do var_dump($i) in the loop to see if you're getting the data you want.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
Vinny Gullotta wrote:
Still no luck displaying the stupid servername. Any other things I can
try?
Micah Gersten [EMAIL PROTECTED]
Dan Joseph [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta
[EMAIL PROTECTED]wrote:
What I want to do is find the top 10 servers where the column steps =
iisreset. The following code works great except that the page is not
displaying
var_dump($i); looks messy, but I can see the server names in there and they
are the correct names.
Micah Gersten [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Do var_dump($i) in the loop to see if you're getting the data you want.
Thank you,
Micah Gersten
onShore Networks
What is the key for the server name? That's what you need when you
output it.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
Vinny Gullotta wrote:
var_dump($i); looks messy, but I can see the server names in there and
they are the correct names.
Micah
On Wed, Sep 17, 2008 at 4:21 PM, Vinny Gullotta [EMAIL PROTECTED]wrote:
var_dump($i); looks messy, but I can see the server names in there and they
are the correct names.
Micah Gersten [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Do var_dump($i) in the loop to see if you're
var_dump looks like this:
array(2) { [0]= string(9) wehost006 [1]= string(2) 72 } array(2) {
[0]= string(8) H7848-49 [1]= string(2) 71 } array(2) { [0]= string(7)
H7853-2 [1]= string(2) 70 } array(2) { [0]= string(7) H7842-2 [1]=
string(2) 64 } array(2) { [0]= string(9) WEHOST005 [1]=
If by key you mean the column in the database, it's called: servername
Micah Gersten [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
What is the key for the server name? That's what you need when you
output it.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
That's your problem, you need to use mysql_fetch_assoc instead of
mysql_fetch_row.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
Vinny Gullotta wrote:
var_dump looks like this:
array(2) { [0]= string(9) wehost006 [1]= string(2) 72 } array(2)
{ [0]=
On Wed, Sep 17, 2008 at 4:30 PM, Vinny Gullotta [EMAIL PROTECTED]wrote:
If by key you mean the column in the database, it's called: servername
Micah Gersten [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
What is the key for the server name? That's what you need when you
output
I meant key in the array that was returned by MySQL. I answered you in
my other post. The array was numerically index based instead of column
based.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
Vinny Gullotta wrote:
If by key you mean the column in the
That was it!!! Thank you all so much for your help!!! =D
Dan Joseph [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Wed, Sep 17, 2008 at 4:30 PM, Vinny Gullotta
[EMAIL PROTECTED]wrote:
If by key you mean the column in the database, it's called: servername
Micah Gersten [EMAIL
Dan Joseph schreef:
On Wed, Sep 17, 2008 at 2:17 PM, Vinny Gullotta [EMAIL PROTECTED]wrote:
...
$i[servername]
Try: $i['servername']
notice the ' and ' around the name. I've heard you can do w/o those, but
I've had issues in the past where it didn't work. ITs also good practice to
use
Vinny Gullotta wrote:
So I have this code I'm working with (pasted below) that queries a
mysql db table called timetracking. The goal of the page is to search
the db for all data based on a certain engineer, sorted by product and
it takes pre-defined values based on actions performed, sums
Sorry, I took that stuff out because it was making the page not load and so
I figured it was wrong. I guess I should have posted the whole thing, but
since it didn't work I left it out.
Micah, thank you very much for the idea, it is working great!!!
Micah Gersten [EMAIL PROTECTED] wrote in
1. To get last months date, you can use strtotime(1 month ago)
instead of mktime.
2. I don't see anywhere in the code where you are limiting by date.
Try using and . Between is tricky on dates.
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
Vinny
This is a question from a guy who does NOT really do Unicode very well...
If everything else in your entire system is iso-8859-1 (aka Latin1)
why are you making your output be utf-8?
Seems to me that that is where the conversion is probably taking place...
On Sun, April 29, 2007 11:07 am,
the field values, as I understanded from the above
explanation.
Did I understood it wrong?
Thanks,
Rangel
- Original Message -
From: Richard Lynch [EMAIL PROTECTED]
To: Rangel Reale [EMAIL PROTECTED]
Cc: php-general@lists.php.net
Sent: Wednesday, May 02, 2007 6:53 PM
Subject: Re: [PHP] PHP
On Wed, May 2, 2007 5:32 pm, Rangel Reale wrote:
You are right, I really don't know Unicode very much! :P
What I was trying to understand was, because unicode.runtime_encoding
=
iso-8859-1, I tought that all internal operations were done in this
encoding, and only when outputting
Dave Goodchild wrote:
Hi all, I am in the process of creating a national events directory where
people can enter their events (car boot sales, evening classes etc) and
specify whether those events are one-ff events or repeating (daily, weekly
etc) affairs and people can search for those events
On Wed, September 13, 2006 5:56 am, Dave Goodchild wrote:
Hi all. I am building an online events registry and have mapped out
all the
dates between Oct 1 2006 and Dec 31 2030, stored in the database as
timestamps incremented by 86400 to give daily slots. I have output the
values using the php
[snip]
Hi all. I am building an online events registry and have mapped out all the
dates between Oct 1 2006 and Dec 31 2030, stored in the database as
timestamps incremented by 86400 to give daily slots.
[/snip]
I do not really understand the purpose of mapping all dates between Oct 1
2006 and
Thanks. I have been so up close and personal with this that I can't see the
wood for the trees. Of course, so obvious. Thank you - you have made me very
happy.
--
http://www.web-buddha.co.uk
http://www.projectkarma.co.uk
No problem, now I will go and make my girlfriend happy :)
-Original Message-
From: Dave Goodchild [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 13, 2006 6:27 PM
To: Peter Lauri
Cc: PHP General
Subject: Re: [PHP] PHP and mySQL dates
Thanks. I have been so up close and personal
Good luck with that.
--
http://www.web-buddha.co.uk
http://www.projectkarma.co.uk
--
http://www.web-buddha.co.uk
http://www.projectkarma.co.uk
On Wed, May 17, 2006 6:55 am, Russell Jones wrote:
I have a site that is getting 30K+ traffic daily and it is smashing
mySQL -
any ideas on what to do to make the mysql connections more efficient,
or
anything in general. No bandwidth issue here, just the server getting
killed.
It depends on
I have a site that is getting 30K+ traffic daily and it is smashing mySQL -
any ideas on what to do to make the mysql connections more efficient, or
anything in general. No bandwidth issue here, just the server getting
killed.
...I may be wrong but using persistent connections (mysql_pconnect)
perhaps post some code so we can look at how you doing your queries...
HTH
Angelo Zanetti
Z Logic
www.zlogic.co.za
[c] +27 72 441 3355
[t] +27 21 469 1052
[f] +27 86 681 5885
Dave Goodchild wrote:
I have a site that is getting 30K+ traffic daily and it is smashing mySQL -
any ideas on what
[snip]
I have a site that is getting 30K+ traffic daily and it is smashing
mySQL -
any ideas on what to do to make the mysql connections more efficient, or
anything in general. No bandwidth issue here, just the server getting
killed.
[/snip]
Without seeing any code or table information my bet
On 17/05/06, Dave Goodchild [EMAIL PROTECTED] wrote:
I have a site that is getting 30K+ traffic daily and it is smashing mySQL -
any ideas on what to do to make the mysql connections more efficient, or
anything in general. No bandwidth issue here, just the server getting
killed.
...I may be
Jay Blanchard wrote:
[snip]
I have a site that is getting 30K+ traffic daily and it is smashing
mySQL -
any ideas on what to do to make the mysql connections more efficient, or
anything in general. No bandwidth issue here, just the server getting
killed.
[/snip]
Without seeing any code or table
On Wed, July 20, 2005 5:22 pm, John Hinton said:
I don't get it... I have been upping my memory limit for PHP. 32megs
now... and am making calls to a database on a different server. I see
the loads run up on the other server as it cruches the numbers.. and PHP
is in the process of creating a
John Hinton wrote:
I don't get it... I have been upping my memory limit for PHP. 32megs
now... and am making calls to a database on a different server. I see
the loads run up on the other server as it cruches the numbers.. and
PHP is in the process of creating a single little page with
This is a beginner's guide to SQL syntax, please review it
http://www.webdevelopersnotes.com/tutorials/sql/mysql_guide_querying_mys
ql_tables.php3?PHPSESSID=fb6c7c7a548b6a271a75d623ce04cc9c
The answer to your question (which someone has already given in a
previous reply to you) is
SELECT
(posted again with another syntax error corrected)
This is a beginner's guide to SQL syntax, please review it
http://www.webdevelopersnotes.com/tutorials/sql/mysql_guide_querying_mys
ql_tables.php3?PHPSESSID=fb6c7c7a548b6a271a75d623ce04cc9c
The answer to your question (which someone has already
[snip]
$sql = SELECT `User_name` AND `User_pass` FROM `user` WHERE `User_name`
= '$_POST['user_id']' AND '$_POST['user_id']' ;
[/snip]
echo $sql; //to see the query and check the syntax
$sql = SELECT `User_name` AND `User_pass` FROM `user` WHERE `User_name`
= ' . $_POST['user_id'] . ' AND ' .
On Sat, May 7, 2005 4:56 am, Deep said:
Hi,
If you are using localhost, i dont think u need to
specify the port number. Localhost would be enough.
Also pls check the user privileges and all in the
database.
..Deep..
--- Oscar Andersson [EMAIL PROTECTED]
wrote:
I have made a instal of
Hi,
If you are using localhost, i dont think u need to
specify the port number. Localhost would be enough.
Also pls check the user privileges and all in the
database.
..Deep..
--- Oscar Andersson [EMAIL PROTECTED]
wrote:
I have made a instal of the latest mySQL and PHP 5
on my computer.
I
hey
On 5/5/05, Oscar Andersson [EMAIL PROTECTED] wrote:
I have made a instal of the latest mySQL and PHP 5 on my computer.
I have made the following changes to my php.ini file
extension=php_mysql.dll
extension_dir = c:\php\
and i have put the php_mysql. and libmysql.dll in c:\php\ and in
On Tuesday 05 April 2005 23:35, Todd Cary wrote:
Does something have to be specially done with the FC 3 install?
I kindly redirect you to google for LAMP which is short for Linux Apache MySQL
PHP
I have also learned to setup this kind of system on Fedora Core 3.
While you CAN rely on the
Todd Cary mailto:[EMAIL PROTECTED]
on Tuesday, April 05, 2005 2:35 PM said:
I have installed FC 3 with Apache and MySQL. When I run phpinfo(), I
do not see MySQL listed as a database nor can I connect via php.
Does something have to be specially done with the FC 3 install?
Other than
Curt Zirzow wrote:
* Thus wrote Ian Porter:
Hi,
I am just wondering how to obtain the result from a mysql procedure OUT
parameter within PHP e.g.
MYSQL
create procedure test_out(OUT testvar int)
BEGIN
select max_connections into testvar from mysql.user limit 1;
END
PHP
$query
* Thus wrote Ian Porter:
Hi,
I am just wondering how to obtain the result from a mysql procedure OUT
parameter within PHP e.g.
MYSQL
create procedure test_out(OUT testvar int)
BEGIN
select max_connections into testvar from mysql.user limit 1;
END
PHP
$query = 'call
On Sat, 8 Jan 2005 16:10:47 + (GMT), babu [EMAIL PROTECTED] wrote:
Hi all,
I am using php 3.0 and mysql and win xp.
i want to add users to database through php page.
adduser.php
html
FORM METHOD=post ACTION=add.php
Real Name: INPUT TYPE=text MAXLENGTH=70 NAME=real_name SIZE=20Br
At 07:38 AM 11/24/2004, you wrote:
In the phpinfo() output, the MySQL client API version is shown as 3.23.49.
Shouldn't this be upgraded to 4.1 (generally available/stable)?
To do so, you would need to upgrade it. I know I am being a smartaleck
when I say this, but it won't upgrade on its own
Steve Buehler wrote:
To do so, you would need to upgrade it. I know I am being a smartaleck
when I say this, but it won't upgrade on its own and it won't upgrade
just because you upgraded just PHP itself. PHP only reads what the
version is from what you have installed, not something that is
On Wed, 24 Nov 2004 10:37:19 -0600, Steve Buehler [EMAIL PROTECTED] wrote:
At 07:38 AM 11/24/2004, you wrote:
In the phpinfo() output, the MySQL client API version is shown as 3.23.49.
Shouldn't this be upgraded to 4.1 (generally available/stable)?
To do so, you would need to upgrade it.
John Nichel wrote:
Steve Buehler wrote:
My phpinfo client API shows: 3.23.58
Which would be because that is the version of mysql that I am
running. My mysql, mysql-server and mysql-devel are all 3.23.58.
Only my php-mysql module is 4.3.2-14
No, this is not the case. If you install with RPM,
Olaf van der Spek wrote:
But why is the bundled client not upgraded?
Aren't 4.0 and 4.1 clients backwards compatible with 3.23 server?
Why they didn't upgrade the bundle to include the 4.0 release, I don't
know. However with the password 'issues' between 4.1 and earlier
versions, I'm sure
At 10:59 AM 11/24/2004, you wrote:
On Wed, 24 Nov 2004 10:37:19 -0600, Steve Buehler [EMAIL PROTECTED] wrote:
At 07:38 AM 11/24/2004, you wrote:
In the phpinfo() output, the MySQL client API version is shown as 3.23.49.
Shouldn't this be upgraded to 4.1 (generally available/stable)?
To do
John Nichel wrote:
Olaf van der Spek wrote:
But why is the bundled client not upgraded?
Aren't 4.0 and 4.1 clients backwards compatible with 3.23 server?
Why they didn't upgrade the bundle to include the 4.0 release, I don't
know. However with the password 'issues' between 4.1 and earlier
Olaf van der Spek wrote:
snip
Isn't that only an issue for 4.1 clients and = 4.1 servers and not
for the 'other way around'?
I was actually asking because I have a 4.1 server and I couldn't use PHP
to connect, because it doesn't support new passwords.
It works both ways. You can make your 4.1
John Nichel wrote:
Olaf van der Spek wrote:
snip
Isn't that only an issue for 4.1 clients and = 4.1 servers and not
for the 'other way around'?
I was actually asking because I have a 4.1 server and I couldn't use
PHP to connect, because it doesn't support new passwords.
It works both ways.
[snip]
Regarding to php with mysql , if the php with mysql implement data
manipulating like (insert , update , delete ..etc) or just implement the
query operation only ??.
[/snip]
You can do any SQL operation with PHP and MySQL.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe,
* Thus wrote Minuk Choi ([EMAIL PROTECTED]):
I have a RedHat9 machine.
I needed to have multiple MySQL installations, so I removed the RPM
installation and did a binary installation of MySQL-4.0.20. As it stands, I
have the following installations
/usr/local/mysql-4.0.20-webpage
Sure you can :) ... I've been doing it for a very long time now ... works
alot better than FAT32 actually ... much faster...
The programs don't care about the file system, that's for the OS to deal
with. Only pure DOS programs have problems with the NTFS ... for all other
programs they can't see
Because someone that's subscribed to the list has a full mailbox ... I get
it too ... all the time ... just like the address harvesters masquerading as
banks ... Advance Credit Suisse Bank [EMAIL PROTECTED] and
Information Desk [EMAIL PROTECTED]
Rene
According to historical records, on Sat, 24
PM
To: Jay Blanchard
Subject: RE: [PHP] php and mysql help
Please remove my address from any future correspondence about PHP.
Jay, you are confusing persons at a university with persons who may have a
Clue [TM]
David (also recipient of this message)
--
PHP General Mailing List (http
Why are you sending this to me? You're at Stanford, you can probably
figure out the unsubscribe link and stuff
-Original Message-
From: David A. Stevens [mailto:[EMAIL PROTECTED]
Sent: Friday, April 16, 2004 12:41 PM
To: Jay Blanchard
Subject: RE: [PHP] php and mysql help
Please remove
* Thus wrote webmaster ([EMAIL PROTECTED]):
Hello i need help with mysql_create_db i found the solution once but cant remember
what it was if someone could tell me the proper way to create a database with php
and mysql i would be greatly thankfull.
You just need to issue a create database
[snip]
Hello i need help with mysql_create_db i found the solution once but
cant remember what it was if someone could tell me the proper way to
create a database with php and mysql i would be greatly thankfull.
Thank you.
[/snip]
http://www.php.net/mysql_create_db
You're welcome.
--
PHP General
Try this:
SELECT COUNT(*), order_number FROM . $prefix . _purchases GROUP BY
order_number
as your query.
Shaunak
- Original Message -
From: Ryan A [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 09, 2004 8:36 PM
Subject: [PHP] php with mysql COUNT, DISTINCT syntax,
Hey,
Thanks for replying.
Nope, that didnt work, but i modified my search terms on google and kept on
trying with different search terms and got the solution here:
http://dbforums.com/arch/230/2002/11/623223
Cheers,
-Ryan
On 2/10/2004 3:14:21 AM, Shaunak Kashyap ([EMAIL PROTECTED])
wrote:
Try
If you need to store both date and time, there are several ways to accomplish this.
MySQL has built-in date/timestamp options, but those long strings would need to be
converted for be human readable.
The option I use most is telling PHP what format I want to use and entering it into
the
[snip]
A query in mysql become with STATE set to STATISTICS and all queries
after this query are LOCKED.What is the decision please.
[/snip]
The decision is to ask for a better description if possible, along with
some of the suspected code.
--
PHP General Mailing List (http://www.php.net/)
To
From: Frank Tudor [EMAIL PROTECTED]
The problem I am having is that when I try to pass values to the
database the php fails.
I think I have singled it down to the connection string but I am
not sure.
[snip]
function db_connect() {
global $dbhost, $dbusername, $dbuserpassword,
* Thus wrote Moritz Steiner ([EMAIL PROTECTED]):
I've heard that php 5 is going to support mysql replication, has anyone
more details about it, it is already working in the beta release?
Can you enlighten me as to what special things php needs to do
replication?
Curt
--
I used to think I was
It looks like your adding 10 to 8 thus getting 18... of course I maybe
looking at this wrong
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 9:23 AM
Subject: [PHP] PHP and Mysql Limit
I've created a script that reads a sorted mysql
|- Original Message -
|From: [EMAIL PROTECTED]
|To: [EMAIL PROTECTED]
|Sent: Wednesday, July 02, 2003 9:23 AM
|Subject: [PHP] PHP and Mysql Limit
|
|
|
| I've created a script that reads a sorted mysql query and outputs specific
| results into text files defined by the start and limit of
Yes, the next page of results would start at #18. The page number only
increments by 1.
Ed
On Wed, 2 Jul 2003, Chris Sherwood wrote:
It looks like your adding 10 to 8 thus getting 18... of course I maybe
looking at this wrong
- Original Message -
From: [EMAIL PROTECTED]
To:
On Wed, 2 Jul 2003, Jeff Harris wrote:
Then, once you've done it enough times, $start = $count = 178.
[code]
while ($start = $count) {
// when $start = $count = 178, you won't retrive any data
[/code]
The recordset would not alway contain an even number of records resulting
in 10 records
We have a multi-user database we use for telemarketing. It is used
across
the internet. All the pages are PHP, I am trying to lock or keep other
users
from accessing the same record, so that they do not call the same
lead.
For
example, the user selects a zip code to work from and then a lead
At 15:50 24-3-03, you wrote:
I'm currently stuck in a project where I need to pull info from a
database and sort it by order of 2 seperate fields and creates a text
report of the results. No problems there but
now what the boss is wanting to do is break it up into slices of 8 records
per file and
Since you are using fulltext search it is going to look for the exact
spelling of what you pass in.
If you wanted to get matches with Chris then you will want to modify
your query by using LIKE.
In version 4.0.1 of mysql you can do fulltext search in boolean mode.
On Thu, 20 Feb 2003 17:44:51 +, you wrote:
When using a php script to pull recorda from a db how can I cut the records
at 1/4 of the total and arrange them alaphabetically according to a certain
field? Thanks in advance.
http://www.mysql.com/doc/en/SELECT.html
LIMIT and ORDER BY.
This is
I'm not sure what you mean by cut the records at 1/4, if you mean only
bringing back 1/4 of the rows you could use the LIMIT clause in your sql
statement and give it a number of rows you want brought back.
To sort alphabetically just use the order by command in SQL
So your query would look
Your answer is in the error message. You have been denied access to the
database. Are you connecting to the db before you run your query? If
not, php is going to try to connect with the default user/password.
César Aracena wrote:
Hi all,
I'm uploading a new web site and when doing some
Cesar,
The error you are receiving is from MYSQL. It is telling you you need
a password to access the database with the username you are using.
See http://www.php.net/manual/en/function.mysql-connect.php for more
information regarding connection to a mysql database and how to add in
a
I cant give you a solution, and I''m running on Linux.
But I have pages were I do 6-7 queries on one page always using the same connection.
Never had a problem with that.
Mike
*** REPLY SEPARATOR ***
I'm using PHP and MySQL to make my programs. But I think I discovered a bug
Does it work if you put quotes around the array keys as follows...
echo $line['idn'];
echo $line['total'];
echo $line['idp'];
echo $line['position'];
echo $line['points'];
Rich
-Original Message-
From: Beauford.2002 [mailto:[EMAIL PROTECTED]]
Sent: 18 December 2002 20:28
To: PHP General
So print out $query before you execute it and see what you're actually
sending to MySQL. You're apparently sending a valid query, but it's not
matching any rows...
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
My guess is you don't have register_globals on. Replace each variable with
$_POST['field_name'] or $_GET['field_name'] depending on what your form's
method is. You could also turn register_globals on but that is a security
risk I've heard.
- Original Message -
From: Pushpinder Singh
Numerous syntax errors produce your invalid query...
1) If you use double quotes to enclose the string, INSERT..., then you do
not have to delimit your single quotes.
2) You accidently delimit a variable at VALUES ('\$select
3) The SQL command its self does not need to end with a semi-colon.
On Thursday 12 December 2002 04:30, Pushpinder Singh Garcha wrote:
Hello,
I am using PHP to create forms and then am entering the user input into
a MySQL DB
In the first query I am trying to select the values that the user
entered on the form
THIS DOES NOT WERK gives error unable to
Thanks Jason...that werked fine for me..
--pS
On Wednesday, December 11, 2002, at 03:50 PM, Jason Wong wrote:
On Thursday 12 December 2002 04:30, Pushpinder Singh Garcha wrote:
Hello,
I am using PHP to create forms and then am entering the user input
into
a MySQL DB
In the first query I am
Jason Wong wrote:
Not sure why you're escaping the single quote. It's unnecessary -- and I
suspect you mis-escaped $select as well. Any you can use this format, which
IMHO, is a lot easier on the eyes:
$sql = INSERT INTO `guest`
SET `title` = '$title',
On Thursday 12 December 2002 09:22, BABA Yoshihiko wrote:
Jason Wong wrote:
Not sure why you're escaping the single quote. It's unnecessary -- and I
suspect you mis-escaped $select as well. Any you can use this format,
which IMHO, is a lot easier on the eyes:
$sql = INSERT INTO `guest`
You don't need to use forms (which you got wrong), but simple links with
target=lowerframe and
href=lowerframe.php?tableID=$tableID, then you get in your
lowerframe.php $_GET['tableID']
Adrian Partenie wrote:
Hello,
I could use some help.
I have two framed pages, upperframe.html and
Hello,
[EMAIL PROTECTED] wrote:
I'm sorting records using COUNT with the following mysql command
$result = mysql_query (SELECT company_name, agent_name, count(*) FROM
$cur_listings GROUP BY company_name, agent_name);
Running this in MySQL does exactly what I need it to do but how do I
Actually, using your original query and referring to
$row['count(*)']
would work too. However, when using calculated fields I always use a
column alias as Rich recommends - it makes things a lot clearer.
-steve
At 1:54 PM + 11/13/02, Rich Gray [EMAIL PROTECTED] wrote:
try '... ,count(*)
-Original Message-
here any way to speed up MySQL queries?
--
Sure, ask for only the data you need. or halt your query when you have what you need.
HTH
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
1 - 100 of 146 matches
Mail list logo
