query issue

2 Message(s) by 2 Author(s) originally posted in php language

From: Chenky

Date: Wednesday, September 26, 2007

I have been trying to nut this error

1. A discrepancy between a computed, observed, or measured
	value or condition and the true, specified, or theoretically
	correct value or condition.

	2. <programming> A mental mistake made by a programmer that
	may result in a program {fault}.

	3. (verb) What a program does when it stops as result of a
	programming error.

	(2000-03-28)

out for the last three days to no
success. Here's the code:

$usern = "myusername";
$passw = "mypassword";
$db="mydatabase";$link2 = @xxxxxxxxxxx("localhost", $usern, $passw);
if (! $link2) {
die("Connect error.");}mysql_select_db($db) or die("DB Select error");

$status = mysql_query("SELECT * FROM members WHERE usern='$user'");while ($display = mysql_fetch_array($status)) {print $display['usern'];
}mysql_close($link2);

(Obviously Ive change the real

1. Not simulated.  Often used as a specific antonym to
	{virtual} in any of its jargon senses.

	2. <mathematics> {real number}.

	[{Jargon File}]

	(1997-03-12)

database

1. <database> One or more large structured sets of persistent
	data, usually associated with software to update and {query}
	the data.  A simple database might be a single file containing
	many {records}, each of which contains the same set of
	{fields} where each field is a certain fixed width.

	A database is one component of a {database management system}.

	See also {ANSI/SPARC Architecture}, {atomic}, {blob}, {data
	definition language}, {deductive database}, {distributed
	database}, {fourth generation language}, {functional
	database}, {object-oriented database}, {relational database}.

	{Carol E. Brown's tutorial
	(http://accounting.rutgers.edu/raw/aies/www.bus.orst.edu/faculty/brownc/lectures/db_tutor/db_tutor.htm)}.

	2. <hypertext> A collection of {nodes} managed and stored in
	one place and all accessible via the same {server}.  {Links}
	outside this are "external", and those inside are "internal".

	On the {World-Wide Web} this is called a {website}.

	3. All the facts and rules comprising a {logic programming}
	program.

	(2005-11-17)

name, user and password, but
rest assured the real ones are correct - this I have triple and
quadruple checked)On a whim I changed the $status variable

<programming> (Sometimes "var" /veir/ or /var/) A named memory
	location in which a program can store intermediate results and
	from which it can read it them.  Each {programming language}
	has different rules about how variables can be named, typed,
	and used.  Typically, a value is "assigned" to a variable in
	an {assignment} statement.  The value is obtained by
	evaluating an expression and then stored in the variable.  For
	example, the assignment

		x = y + 1

	means "add one to y and store the result in x".  This may look
	like a mathematical equation but the mathematical equality is
	only true in the program until the value of x or y changes.
	Furthermore, statements like

		x = x + 1

	are common.  This means "add one to x", which only makes sense
	as a state changing operation, not as a mathematical equality.

	The simplest form of variable corresponds to a single-{word}
	of {memory} or a {CPU} {register} and an assignment to a
	{load} or {store} {machine code} operation.

	A variable is usually defined to have a {type}, which never
	changes, and which defines the set of values the variable can
	hold.  A type may specify a single ("atomic") value or a
	collection ("aggregate") of values of the same or different
	types.  A common aggregate type is the {array} - a set of
	values, one of which can be selected by supplying a numerical
	{index}.

	Languages may be {untyped}, {weakly typed}, {strongly typed},
	or some combination.  {Object-oriented programming} languages
	extend this to {object} types or {classes}.

	A variable's {scope} is the region of the program source
	within which it represents a certain thing.  Scoping rules are
	also highly language dependent but most serious languages
	support both {local variables} and {global variables}.
	{Subroutine} and {function} {formal arguments} are special
	variables which are set automatically by the language runtime
	on entry to the subroutine.

	In a {functional programming} language, a variable's value
	never changes and change of state is handled as recursion over
	lists of values.

	(2004-11-16)

to:
$status = mysql_query("SELECT * FROM members WHERE usern='$user'") or
die (mysql_error());
and was given this error:Access denied for user 'myusername@xxxxxxxxxxx' (Using password: NO)This is what confuses me - why is not it recognising the use of
password? All help appreciated.

From: C.

Date: Thursday, September 27, 2007

wrote in message:

I've been trying to nut this error out for the last three days to no
success. Here's the code:
$usern = "myusername";
$passw = "mypassword";
$db="mydatabase";
$link2 = @xxxxxxxxxxx("localhost", $usern, $passw);
if (! $link2) {
die("Connect error.");
}
mysql_select_db($db) or die("DB Select error");
$status = mysql_query("SELECT * FROM members WHERE usern='$user'");
while ($display = mysql_fetch_array($status)) {
print $display['usern'];
}
mysql_close($link2);
(Obviously Ive change the real database name, user and password, but
rest assured the real ones are correct - this I have triple and
quadruple checked)
On a whim I changed the $status variable to:
$status = mysql_query("SELECT * FROM members WHERE usern='$user'") or
die (mysql_error());
and was given this error:
Access denied for user 'myusername@xxxxxxxxxxx' (Using password: NO)
This is what confuses me - why is not it recognising the use of
password? All help appreciated.

try:

error_reporting(E_ALL);
...
$link2 = mysql_connect("localhost", $usern, $passw);

and also:

error_reporting(E_ALL);
...
$link2 = mysql_connect('127.0.0.1', $usern, $passw);

If you're still stuck, try with the mysql command

<operating system> A character string which tells a program to
	perform a specific action.  Most commands take {arguments}
	which either modify the action performed or supply it with
	input.  Commands may be typed by the user or read from a file
	by a {command interpreter}.  It is also common to refer to
	menu items as commands.

	(1997-06-21)

line

1. <hardware> An electrical conductor.  For distances larger
	than a breadbox, a single line may consist of two electrical
	conductors in twisted, parallel, or concentric arrangement
	used to transport one logical signal.

	By extension, a (usually physical) medium such as an {optical
	fibre} which carries a signal.

	(1995-09-29)

client:

mysql -h localhost -u myusername -p mypassword

HTH

C.

Next Message: debug and __LINE__ , __FILE__

Blogs related to query issue

COPR Query
Mine has my daughter listed as a dependent. My wife's does not. Problem when doing the landing hop over and back ? All the details on all 3 documents are correct but just this 'missing' info on my wife's. I presume it's because I am the ...

PHP General :: RE: Slow query, beginner problem
Author: lostboy Posted: Tue Sep 18, 2007 10:00 pm (GMT 2) Topic Replies: 3 do you have any indexes on the tables? they usually help to speed up the query. Lostboy Cat, the other other white meat Please read Posting Etiquette before ...

query issue
comp.lang.php: query issue.

MySQL Java Login Issues
Asï¿½ como se necesita un statement.getResulSet para obtener los valores que * el query estaba buscando en la BD. */ ConnectionDB.setStatement(statement = (Statement) connection.createStatement()); statement.execute(SQLStatement); ...

Issues and Bugs :: RE: Servoyism? controller.setSelectedIndex ...
If you do a controller.loadAllRecords(), Servoy will fire a SELECT * query to the database. This can result in 100 records or in 100.000.000 records. Servoy will never transfer all records to the client as you can easily understand if ...

Paging Problem
Now let us start executing the query with variables $eu and $limit set at the top of the page/////////// $query=" SELECT * FROM student_adv limit $eu, $limit "; $result=mysql_query($query); echo mysql_error(); ...