PAUL FERRIE wrote:
i am getting this error returned but i dont know why :( error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/pferrie/public_html/vinrev/adm/insert2.php on line 6
php file
<?php
include("connection.php");
if(!empty($rating)){
$query="SELECT * FROM $tablename WHERE rating = '$rating'";
if(mysql_query($query)) {
$myrow = mysql_fetch_array($query);// This line returns an error!
you sould write : if ($result = mysql_query($query)) { $myrow = mysql_fetch_array($result);
Hope this helps
-- Cordialement, --------------------------- Sophie Mattoug Développement web dynamique [EMAIL PROTECTED] ---------------------------
$id = $myrow ['id']; echo"Error! There is another row in the database with a rating value of $rating\n You must first edit the row with a rating of $rating ! Row id = $id<br><br>"; echo"<a href='edit2.php?tablename=$tablename&id=$id'>Edit record</a><br>"; } }else { if(!empty($_FILES['userfile']['tmp_name'])) { $name = strtolower(eregi_replace('#| |\?|!', '', $_FILES['userfile']['name'])); $destination = 'img/'.$name; if(move_uploaded_file($_FILES['userfile']['tmp_name'], $destination)) { $picture=$destination; $query = "INSERT INTO $tablename (artist, title, picture, review, label, format, price, rating)VALUES ('$artist', '$title', '$picture', '$review', '$label', '$format', '$price', '$rating')"; if(!mysql_query($query)) { fail("Error updating DB1"); } Header("Location: main.php?success=New row has been inserted into the database"); } } if(empty($userfile)) { $query2 = "INSERT INTO $tablename (artist, title, picture, review, label, format, price, rating)VALUES ('$artist', '$title', '$picture', '$review', '$label', '$format', '$price', '$rating')"; if(!mysql_query($query2)) { fail("Error updating DB2"); } Header("Location: main.php?success=New row has been inserted into the database");
} } ?>
I am trying to check for a duplicate entry for rating and if one is found grab the row ID and then use it to load the edit page for the row.
Anyone Cheers Paul
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php