new at php. need help plz.

hwoarang69

need help with this error plz

Notice: Undefined index: imagelocation in C:\xampp\htdocs\phpSTUFF\WEB\view.php on line 13

//file one
<?php
include('header.php');
require('connect.php');

$username = $_SESSION['username'];

$query=mysql_query("SELECT * FROM users WHERE username='$username'");
if(mysql_num_rows($query) == 0)
die("User not found!");
else
{
$row = mysql_fetch_assoc($query);
$location = $row['imagelocation'];
echo "<img src='$location' width='100' height'100'>";
}

include('footer.php')
?>

:php:
different file
$location = "avatars/$name";
move_uploaded_file($tmp_name, $location);
$query = mysql_query("UPDATE users SET imageLocation= '$location' WHERE username='$username'");

Undrium

imageLocation has a cap "L", your correct row should therefor be:

$location = $row['imageLocation'];

hwoarang69

i did tht it gave me the same error again.

Notice: Undefined index: imageLocation in C:\xampp\htdocs\phpSTUFF\WEB\view.php on line 13

plz help

Undrium

Do a echo mysql_error(); after your mysql_query and see if it gives some feedback.

hwoarang69

thanks for the help but it still giving me the same error 🙁. i wish it would give me different error so i can fix it

bradgrafelman

When posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze.

As for your problem, can you show us a fresh copy of your code? Also, don't use 'SELECT *' - instead, only SELECT the columns you need (which, in this case, appears to be just one column).

For any MySQL query: you should be checking to see if mysql_query() returns boolean FALSE, indicating that an error has occurred, and then either output or log detailed error information (such as the error message returned by the MySQL server).