2 questions

nickk

Hi,

I have 2 questions:

Firstly, I have the following function, but it doesnt work Sad

function insert($school_id, $email, $text, $pic) {
$sql = "select class, first_name, second_name from yearbook where school_id = '$school_id'";
$result = mysql_query($sql);
$class = mysql_result($result, 1, "class");
$first_name = mysql_result($result, 1, "first_name");
$last_name = mysql_result($result, 1, "last_name");
$pic = "../" . $class . "/" . $first_name . "-" . $last_name . ".jpg";

$sql = "update yearbook set email = '$email', text = '$text', pic = '$pic' where school_id = '$school_id'";
if(mysql_query($sql)) {
echo "<b>Text and picture sucessfully uploaded!</b>\n";
return 1;
} else {
echo "<b>Error submitting text and picture to the database, go back and try again</b>\n";
return 0;
}
} //end function insert

It gives me the following errors:
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/home/nickk/public_html/yearbook/provide/upload.php on line 228

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/home/nickk/public_html/yearbook/provide/upload.php on line 229

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /usr/home/nickk/public_html/yearbook/provide/upload.php on line 230

and it doesnt add the proper values for "pic" to the database Sad

Secondly, I'm having problems uploading files (pictures to be exact) with PHP. Does anyone know how this is done?

Thanks, Nick

nunomira

hi,

I wasn't even familiar with mysql_result() and it seems that's because there are preferred ways over it.

For example, mysql_fetch_assoc() :

<?php
$sql = "select class, first_name, second_name from yearbook where school_id = '$school_id'";
$result = mysql_query($sql);
$row = mysql_fetch_assoc ($result);
$class = $row['class']; 
$first_name = $row['first_name'];
// ...
?>

And depending on what you're doing, it might be a good idea checking if any results were found (unless you are sure) with mysql_num_rows().

Have you looked at handling file uploads?

nickk

Thanks for the reply. Hmm nope, still get an error:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/home/nickk/public_html/yearbook/provide/upload.php on line 228

and it doesnt submit it properly 🙁

nunomira

Really don't get it...

I understand it is complaining about the variable $result, that should hold the result... I just don't understand why it's wrong.

Try:

print_r ($result);

After that line, to see what you get. It should be something like:

Resource id #3

Which version of php/mysql are you runing. Have you had any other problems. Other applications run fine?

bodzan

...you are missing these lines:

$link = mysql_connect('databaseServer', 'mysql_user', 'mysql_password');
mysql_select_db(databaseName,$link);

i.e. the connection to the database and to connection to the database you are are about to use - you allways need theseto let the PHP know where to execute the query.

And for the second issue try reading
http://www.php.net/manual/en/features.file-upload.php

nunomira

If those two lines are missing, when you try a mysql_query() you get an error...
I tried that because I thought those lines might be missing as well.

bodzan

only other thing that comes to mind might be to use capital letters for the sql statement and to ommit spaces between the fields like:

SELECT class,first_name,second_name FROM yearbook WHERE school_id = '$school_id'

either that or I'm totally confused...:queasy:

Maybe, we're missing something fairly obvious...