[Resolved] mysql and value!(must be easy..)

kikki

Hi,
I'm trying to find if the value already there in the table or not.. this is checking only the FIRST row, I really want to know how to check that through the table.

TIA.

$SelectedReplyX = $_GET['show'];

$query7 = "SELECT id, username, accepted_img_id, accepted_by FROM accepted_pictures ";
$result7 = mysql_query($query7);
$row7 = mysql_fetch_array($result7);
$AcceptedReply = $row7['accepted_img_id'];

if ($AcceptedReplyX == $SelectedReplyX )
{
echo 'This value is already there, cannot insert again!</font>';
}else{

//do something else

}

Huuggee

you have two options here.

the first is to loop through your entire resultset for $result7.

But I would guess you can chqnge your SQL to

"SELECT id, username, accepted_img_id, accepted_by FROM accepted_pictures
WHERE accepted_img_id=\"$_GET['show']\" "

This is better because the database search will be quicker

kikki

Originally posted by Huuggee
"SELECT id, username, accepted_img_id, accepted_by FROM accepted_pictures
WHERE accepted_img_id=\"$_GET['show']\" "
[/B]

Pls take a look at my code again.. The point of this code is not to let anyone to add the same valued img ID for the 2nd time. It should be able to add only once.

//Currently Selected img ID
$SelectedReplyX = $_GET['show'];

//Using this code, I'm trying to get submitted image id from a table called: accepted_pictures.

$query7 = "SELECT id, username, accepted_img_id, accepted_by FROM accepted_pictures ";
$result7 = mysql_query($query7);
$row7 = mysql_fetch_array($result7);
$AcceptedReply = $row7['accepted_img_id'];


//Here I'm trying see if the Selected img ID has been submitted b4so checking the grabbed img id as same as Selected img ID...
if ($AcceptedReplyX == $SelectedReplyX )
{
echo 'This value is already there, cannot insert again!</font>';
}else{

//do something else/insert the img ID

}

Huuggee

That's what the SQL does. Instead of using PHP to go through every row of your database, it simply looks to see if that id alreay exists.
If there is nothing returned by the SQL, then you know that the imige ID does not exist.
If you do get a result, then you need to trigger your error.

kikki

Originally posted by Huuggee
That's what the SQL does. Instead of using PHP to go through every row of your database, it simply looks to see if that id alreay exists.
If there is nothing returned by the SQL, then you know that the imige ID does not exist.
If you do get a result, then you need to trigger your error.

Hi Huuggee,
sorry for the late reply..

Thankyou v.much, I was kinda confuced with that sql..

Now everything is clear... 🙂