PHP/MySQL Array Exclude

Question

I've got a page that displays all of a users' photos but I'm looking to exclude the default profile picture which is thumb-default.png. How do I do that?

<?

$getphotos = mysql_query("SELECT ID, Link FROM images WHERE MemberID = '$vid'");
while($iph = mysql_fetch_array($getphotos))
{
$pID = $iph['ID'];
$pLINK = $iph['Link'];

echo "

<li><a href=\"members_image/$vid/$pLINK\" rel=\"prettyPhoto[gallery]\"><img src='/members_image/$vid/thumb-$pLINK' width='105'></a></li>

";


}

Thank you!! :-)

you know you can use combination of double quote and single quote to get rid of escape character `\` — Mayank K. Swami
– Mayank K. Swami, Commented Apr 9, 2013 at 13:39
@NullPonyPointer That is true, but if doing the single quote in HTML makes in 'technically' invalid HTML, and if doing it on the outside, requires concatenation of multiple string which adds more code that really isn't needed, nor does it help with readability. — Jon
– Jon, Commented Apr 9, 2013 at 13:48

SeanWM · Accepted Answer · 2013-04-09 13:38:31Z

3

Add at the end of your query AND Link != 'thumb-default.png'

$getphotos = mysql_query("SELECT ID, Link FROM images WHERE MemberID = '$vid' AND Link != 'thumb-default.png'");

This excludes every entry with this link to be selected.

edited Apr 9, 2013 at 13:38

SeanWM

17.1k10 gold badges54 silver badges85 bronze badges

answered Apr 9, 2013 at 13:37

bwoebi

23.8k5 gold badges64 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TheEwook Over a year ago

I think 'Link' should have the value default.png (not thumb-default.png)

CG_DEV · Accepted Answer · 2013-04-09 13:56:51Z

0

I agree with the above and also it is better to use this,

while($iph = mysql_fetch_object($getphotos))
{
$pID = $iph->ID;
$pLINK = $iph->Link;

}

Because I think mysql_fetch_array, prefers array element keys as numbers. $iph[0], $iph[1]...

I think for alpha key elements, you use

mysql_fetch_assoc

answered Apr 9, 2013 at 13:56

CG_DEV

8188 silver badges7 bronze badges

Collectives™ on Stack Overflow

PHP/MySQL Array Exclude

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related