another PHP/MySQL question - GoFuckYourself.com

poe · 04-17-2006, 10:13 AM

I am creating links for mysql data..

my code looks like this

Code:

echo "<a href=".$row['url']." title=".$row['title'].">".$row['name']."</a>";

now, sometimes there is no 'url' data for that entry.. how do make it so if there isn't, it doesn't display that entry as a link?

thanks!

poe · 04-17-2006, 10:14 AM

the name should still be displayed, just not the link

Voodoo · 04-17-2006, 10:15 AM

Read a book.

poe · 04-17-2006, 10:17 AM

Quote:

Originally Posted by Voodoo

Read a book.

Voodoo · 04-17-2006, 10:19 AM

Code:

if(isset($row['url'])){
echo "<a href=".$row['url']." title=".$row['title'].">".$row['name']."</a>";
}else{
echo "$row['name']";
}

Try this.

poe · 04-17-2006, 10:26 AM

Thanks, dude!

hmm, it doesn't produce any errors, but it doesn't work.. should i try something other than isset?

poe · 04-17-2006, 10:28 AM

switched around the if and else and tried empty()

that worked!

thanks!

poe · 04-17-2006, 10:30 AM

also: i have a separator between each entry.. is there an if something() to check if it's the last entry, so the separator doesn't show up at the end?

poe · 04-17-2006, 10:41 AM

it's now 1041

Voodoo · 04-17-2006, 10:45 AM

Code:

if($row['url'] != empty){
echo "<a href=".$row['url']." title=".$row['title'].">".$row['name']."</a>";
}else{
echo "$row['name']";
}

04-17-2006, 10:13 AM	#1
poe Confirmed User Join Date: Mar 2004 Posts: 455	another PHP/MySQL question I am creating links for mysql data.. my code looks like this Code: echo "<a href=".$row['url']." title=".$row['title'].">".$row['name']."</a>"; now, sometimes there is no 'url' data for that entry.. how do make it so if there isn't, it doesn't display that entry as a link? thanks! __________________ ’

04-17-2006, 10:14 AM	#2
poe Confirmed User Join Date: Mar 2004 Posts: 455	the name should still be displayed, just not the link __________________ ’

04-17-2006, 10:15 AM	#3
Voodoo ♥ ♦ ♣ ♠ Industry Role: Join Date: Sep 2002 Posts: 10,592	Read a book. __________________ "I'm selflessly supporting the common good, but only coincidentally looking out for No.1."

04-17-2006, 10:19 AM	#5
Voodoo ♥ ♦ ♣ ♠ Industry Role: Join Date: Sep 2002 Posts: 10,592	Code: if(isset($row['url'])){ echo "<a href=".$row['url']." title=".$row['title'].">".$row['name']."</a>"; }else{ echo "$row['name']"; } Try this. __________________ "I'm selflessly supporting the common good, but only coincidentally looking out for No.1."

04-17-2006, 10:26 AM	#6
poe Confirmed User Join Date: Mar 2004 Posts: 455	Thanks, dude! hmm, it doesn't produce any errors, but it doesn't work.. should i try something other than isset? __________________ ’

04-17-2006, 10:28 AM	#7
poe Confirmed User Join Date: Mar 2004 Posts: 455	switched around the if and else and tried empty() that worked! thanks! __________________ ’

04-17-2006, 10:30 AM	#8
poe Confirmed User Join Date: Mar 2004 Posts: 455	also: i have a separator between each entry.. is there an if something() to check if it's the last entry, so the separator doesn't show up at the end? __________________ ’

04-17-2006, 10:41 AM	#9
poe Confirmed User Join Date: Mar 2004 Posts: 455	it's now 1041 __________________ ’

04-17-2006, 10:45 AM	#10
Voodoo ♥ ♦ ♣ ♠ Industry Role: Join Date: Sep 2002 Posts: 10,592	Code: if($row['url'] != empty){ echo "<a href=".$row['url']." title=".$row['title'].">".$row['name']."</a>"; }else{ echo "$row['name']"; } __________________ "I'm selflessly supporting the common good, but only coincidentally looking out for No.1."