new at php help plz

hwoarang69

2 errors:
Notice: Undefined index: id in C:\xampp\htdocs\phpSTUFF\WEB\get.php on line 6

Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 4 in C:\xampp\htdocs\phpSTUFF\WEB\get.php on line 13

line 6:

$id = $_GET['id'];

line 13:
echo mysql_result($image, 0);

//get.php

<?php 
//connect to database 
mysql_connect("localhost", "root", "") or die(mysql_error()); 
mysql_select_db("uploadsitestorepic") or die(mysql_error()); 

$id = $_GET['id']; 

$sql = "SELECT image FROM store WHERE id =' " . $id . "' ";
$image = mysql_query($sql); 

header("Content-type: image/png"); 

echo mysql_result($image, 0); 
?>

bradgrafelman

The first error should be quite obvious - there is no 'id' element in the $_GET array (e.g. there was no 'id' parameter in the query string).

You should never attempt to access external data without first verifying that it exists (e.g. using [man]isset/man or [man]empty/man).

You shouldn't be using any result-fetching functions (mysql_result(), mysql_fetch_*(), etc.) without first verifying that there is something to retrieve in the first place, e.g. using [man]mysql_num_rows/man.