FUDforum: comp.lang.php » isset not working with select

Home » Imported messages » comp.lang.php » isset not working with select

Show: Today's Messages :: Polls :: Message Navigator

isset not working with select [message #181342]

Mon, 13 May 2013 11:01

richard

Messages: 213
Registered: June 2013

Karma:

Senior Member

http://mroldies.net/showtable.php?year=1960

$result = mysql_query("SELECT acover,bcover FROM A$year WHERE id =
$number");
if (!$result) { echo 'Could not run query: ' . mysql_error(); exit; }
$cov = mysql_fetch_row($result);

if (isset($cov[0]))
{echo "<img src='http://mroldies.net/covers/$year/".$cov[0]."'>";}
echo "<img src='http://mroldies.net/covers/$year/".$cov[1]."'>";

On item #1 in the table, the panel appears with the desired images as
wanted.
On item #2 image place holders appear because I do not have them online
yet.
I do not want to see the place holders if there is not an image.
What to use to do that?

Also, if you click on 1961, or any other year, and then any item in the
table, you will get a message below the videos stating the column does not
exist so it can't continue processing.
How can I bypass this when that database does not have that column?

Report message to a moderator

[Message index]

		isset not working with select By: richard on Mon, 13 May 2013 11:01
		Re: isset not working with select By: Scott Johnson on Mon, 13 May 2013 12:49
		Re: isset not working with select By: Peter H. Coffin on Mon, 13 May 2013 12:43
		Re: isset not working with select By: The Natural Philosoph on Mon, 13 May 2013 22:31
		Re: isset not working with select By: J.O. Aho on Mon, 13 May 2013 18:10
		Re: isset not working with select By: The Natural Philosoph on Mon, 13 May 2013 22:43
		Re: isset not working with select By: Denis McMahon on Mon, 13 May 2013 19:54
		Re: isset not working with select By: richard on Tue, 14 May 2013 21:38
		Re: isset not working with select By: richard on Wed, 15 May 2013 20:23
		Re: isset not working with select By: Denis McMahon on Wed, 15 May 2013 20:34
		Re: isset not working with select By: richard on Wed, 15 May 2013 21:07
		Re: isset not working with select By: Christoph Becker on Wed, 15 May 2013 21:18
		Re: isset not working with select By: richard on Wed, 15 May 2013 23:07
		Syntax Highlighting (was: isset not working with select) By: Christoph Becker on Wed, 15 May 2013 23:33
		Re: isset not working with select By: Tim Streater on Thu, 16 May 2013 07:27
		Re: isset not working with select By: richard on Wed, 15 May 2013 21:12
		Re: isset not working with select By: Denis McMahon on Wed, 15 May 2013 23:54
		Re: isset not working with select By: Tim Streater on Wed, 15 May 2013 21:15

Previous Topic:	mkdir no such file or directory
Next Topic:	makes searching and booking applications airfares

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 10 10:41:41 GMT 2024

Total time taken to generate the page: 0.05687 seconds