More PHP Help

snike · 05-02-2006, 04:31 PM

Alright I have a script that needs to retrieve data from inside a mysql column. It need to be a speific column. Here is the database:

Database---users(table)---*username*(the column)----health(data needed)

**= i am using a login script and each person needs to sign up and a column thing is created in the users table (username, password, health, etc.)

How do i retrive the data in health from a certain user that is logged in?

<? echo $_COOKIE['user']; ?> that line echos the username of the logged in person on to the webpage.

**Eric** · 05-02-2006, 04:38 PM

PHP Code:

  <?php

 
$user = $_COOKIE['user'];

 
$query = mysql_query("SELECT health FROM users WHERE username = '".$user."'") or die("Error getting user info:<br />".mysql_error());

????: NamePros.com http://www.namepros.com/programming/193411-more-php-help.html
 
//rest here

 
?>

snike · 05-02-2006, 04:43 PM

Thank you sooo! much!

i get this:
welcome qwerty error #103You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #5' at line 1The query was Resource id #5

ok i know whats wrong:
i have this:

PHP Code:

  <? include("check.php"); ?>

<? include("db.php"); ?>

<html>

<head>

<title></title>

</head>

 

<body bgcolor="#FFFFFF">

 

welcome <? echo $_COOKIE['user']; ?>

????: NamePros.com http://www.namepros.com/showthread.php?t=193411
 

<?

## Retrive Health Start

 

//Define query

 

$user = $_COOKIE['user']; 

 
$query = mysql_query("SELECT health FROM users WHERE username = '".$user."'") or die("Error getting user info:<br />".mysql_error()); 

 
 

if($r = mysql_query($query))

{

  //Retrive and print

  while ($row = mysql_fetch_array($r))

  {

    print "$query\n";

  }

}

else

{

  die('error #103'.mysql_error().'The query was '.$query);

}

 

mysql_close();

????: NamePros.com http://www.namepros.com/showthread.php?t=193411
 

?>

</body>

</html>

Dan · 05-02-2006, 05:02 PM

You can't echo $query.

After SecondVersion's script (still inside the PHP tags) add:

$health = mysql_fetch_row($query);
echo $health;

edit: I see your edit..

You need to echo $row[0] and not $query (print.. echo.. w/e)

mysql_fetch_assoc is slower than mysql_fetch_row and other ones.

snike · 05-02-2006, 05:07 PM

Is this okay? cuz it still dont work
<? include("check.php"); ?>
<? include("db.php"); ?>
<html>
<head>
<title></title>
</head>
????: NamePros.com http://www.namepros.com/showthread.php?t=193411

<body bgcolor="#FFFFFF">

welcome <? echo $_COOKIE['user']; ?>

<?
## Retrive Health Start

//Define query

$user = $_COOKIE['user'];

$query = mysql_query("SELECT health FROM users WHERE username = '".$user."'") or die("Error getting user info:<br />".mysql_error());

if($r = mysql_query($query))
{
//Retrive and print
while ($row = mysql_fetch_array($r))
{
echo "$row[0]\n";
}
}
else
{
die('<b>Kingdom Tempost Error #103</b> '.mysql_error().'The query was '.$query);
}

mysql_close();

?>
</body>
</html>

Dan · 05-02-2006, 05:19 PM

PHP Code:

  <? include("check.php");

 include("db.php"); ?>

<html>

<head>

<title></title>

</head>

 

<body bgcolor="#FFFFFF">

 

welcome <? echo $_COOKIE['user'];

 
## Retrive Health Start

 

//Define query

 

$user = $_COOKIE['user']; 

 
$query = mysql_query("SELECT health FROM users WHERE username = '".$user."'") or die("Error getting user info:<br />".mysql_error()); 

if (!$query) {

   echo 'Could not run query: ' . mysql_error();

????: NamePros.com http://www.namepros.com/showthread.php?t=193411
   exit;

}

 
$row = mysql_fetch_row($query);

echo "$row[0]\n";

 

mysql_close();

 

?>

</body>

</html>

snike · 05-02-2006, 05:28 PM

thank you it worked! Thanks second version and Dan Friedman!

snike · 05-07-2006, 03:20 PM

There is a problem with this query:
$query = mysql_query("INSERT INTO users (inven)VALUES($inchange) WHERE username = '".$user."'");

Dan · 05-07-2006, 03:34 PM

$query = mysql_query("UPDATE users SET inven = '$inchange' WHERE username = '$user'");

snike · 05-07-2006, 09:18 PM

I get this:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1

**Eric** · 05-07-2006, 09:29 PM

PHP Code:

  $query = mysql_query("UPDATE users SET inven = $inchange WHERE username = '$user'"); 

????: NamePros.com http://www.namepros.com/showthread.php?t=193411

snike · 05-08-2006, 03:59 PM

SV your code didn't work but Dan's did even thou the error came up. Also I want to add that data to the database not update it. So do i use INSERT INTO?

05-02-2006, 04:31 PM	THREAD STARTER #1 (permalink)
snike NamePros Regular Join Date: Mar 2006 Location: USA Posts: 497	More PHP Help Alright I have a script that needs to retrieve data from inside a mysql column. It need to be a speific column. Here is the database: Database---users(table)---username(the column)----health(data needed) **= i am using a login script and each person needs to sign up and a column thing is created in the users table (username, password, health, etc.) How do i retrive the data in health from a certain user that is logged in? <? echo $_COOKIE['user']; ?> that line echos the username of the logged in person on to the webpage.

05-02-2006, 04:38 PM	#2 (permalink)
Eric Tech Support Join Date: Mar 2005 Posts: 4,944	PHP Code: `<?php $user = $_COOKIE['user']; $query = mysql_query("SELECT health FROM users WHERE username = '".$user."'") or die("Error getting user info:<br />".mysql_error()); ????: NamePros.com http://www.namepros.com/programming/193411-more-php-help.html //rest here ?>`

05-02-2006, 04:43 PM	THREAD STARTER #3 (permalink)
snike NamePros Regular Join Date: Mar 2006 Location: USA Posts: 497	Thank you sooo! much! i get this: welcome qwerty error #103You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Resource id #5' at line 1The query was Resource id #5 ok i know whats wrong: i have this: PHP Code: <? include("check.php"); ?> <? include("db.php"); ?> <html> <head> <title></title> </head> <body bgcolor="#FFFFFF"> welcome <? echo $_COOKIE['user']; ?> ????: NamePros.com http://www.namepros.com/showthread.php?t=193411 <? ## Retrive Health Start //Define query $user = $_COOKIE['user']; $query = mysql_query("SELECT health FROM users WHERE username = '".$user."'") or die("Error getting user info:<br />".mysql_error()); if($r = mysql_query($query)) { //Retrive and print while ($row = mysql_fetch_array($r)) { print "$query\n"; } } else { die('error #103'.mysql_error().'The query was '.$query); } mysql_close(); ????: NamePros.com http://www.namepros.com/showthread.php?t=193411 ?> </body> </html> Last edited by snike; 05-02-2006 at 05:01 PM.

05-02-2006, 05:07 PM	THREAD STARTER #5 (permalink)
snike NamePros Regular Join Date: Mar 2006 Location: USA Posts: 497	Is this okay? cuz it still dont work <? include("check.php"); ?> <? include("db.php"); ?> <html> <head> <title></title> </head> ????: NamePros.com http://www.namepros.com/showthread.php?t=193411 <body bgcolor="#FFFFFF"> welcome <? echo $_COOKIE['user']; ?> <? ## Retrive Health Start //Define query $user = $_COOKIE['user']; $query = mysql_query("SELECT health FROM users WHERE username = '".$user."'") or die("Error getting user info:<br />".mysql_error()); if($r = mysql_query($query)) { //Retrive and print while ($row = mysql_fetch_array($r)) { echo "$row[0]\n"; } } else { die('<b>Kingdom Tempost Error #103</b> '.mysql_error().'The query was '.$query); } mysql_close(); ?> </body> </html> Last edited by snike; 05-02-2006 at 05:11 PM.

05-02-2006, 05:19 PM	#6 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,792	PHP Code: <? include("check.php"); include("db.php"); ?> <html> <head> <title></title> </head> <body bgcolor="#FFFFFF"> welcome <? echo $_COOKIE['user']; ## Retrive Health Start //Define query $user = $_COOKIE['user']; $query = mysql_query("SELECT health FROM users WHERE username = '".$user."'") or die("Error getting user info:<br />".mysql_error()); if (!$query) { echo 'Could not run query: ' . mysql_error(); ????: NamePros.com http://www.namepros.com/showthread.php?t=193411 exit; } $row = mysql_fetch_row($query); echo "$row[0]\n"; mysql_close(); ?> </body> </html>

05-02-2006, 05:02 PM	#4 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,792	You can't echo $query. After SecondVersion's script (still inside the PHP tags) add: $health = mysql_fetch_row($query); echo $health; edit: I see your edit.. You need to echo $row[0] and not $query (print.. echo.. w/e) mysql_fetch_assoc is slower than mysql_fetch_row and other ones.

05-02-2006, 05:28 PM	THREAD STARTER #7 (permalink)
snike NamePros Regular Join Date: Mar 2006 Location: USA Posts: 497	thank you it worked! Thanks second version and Dan Friedman!

05-07-2006, 03:20 PM	THREAD STARTER #8 (permalink)
snike NamePros Regular Join Date: Mar 2006 Location: USA Posts: 497	There is a problem with this query: $query = mysql_query("INSERT INTO users (inven)VALUES($inchange) WHERE username = '".$user."'");

05-07-2006, 03:34 PM	#9 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,792	$query = mysql_query("UPDATE users SET inven = '$inchange' WHERE username = '$user'");

05-07-2006, 09:18 PM	THREAD STARTER #10 (permalink)
snike NamePros Regular Join Date: Mar 2006 Location: USA Posts: 497	I get this: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1

05-07-2006, 09:29 PM	#11 (permalink)
Eric Tech Support Join Date: Mar 2005 Posts: 4,944	PHP Code: `$query = mysql_query("UPDATE users SET inven = $inchange WHERE username = '$user'"); ????: NamePros.com http://www.namepros.com/showthread.php?t=193411`

05-08-2006, 03:59 PM	THREAD STARTER #12 (permalink)
snike NamePros Regular Join Date: Mar 2006 Location: USA Posts: 497	SV your code didn't work but Dan's did even thou the error came up. Also I want to add that data to the database not update it. So do i use INSERT INTO?

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)