FUDforum: comp.lang.php » part 2 - file exists not working

Home » Imported messages » comp.lang.php » part 2 - file exists not working

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

Re: part 2 - file exists not working [message #182885 is a reply to message #182884]

Tue, 24 September 2013 05:57

richard

Messages: 213
Registered: June 2013

Karma:

Senior Member

On Mon, 23 Sep 2013 22:07:29 -0400, Lew Pitcher wrote:

> On Monday 23 September 2013 20:46, in comp.lang.php, me(at)home(dot)invalid wrote:
>
>> richard wrote:
>>
>>> I am attempting to show a play button when the file actually exists.
>>>
>>> This does pass the test the way it should, however, my test for display
>>> does not.
>>>
>>> How should I test to make sure a button shows when the file is there and
>>> show nothing when it isn't?
>>>
>>>
>>>
>>> $number=1;
>>>
>>> echo '<table border="1">';
>>> echo "<tr><th>Rank</th><th>Charted -
>>> Artist</th><th>Play</th><th>Flipside</th><th>Label</th><th>First
>>> Week</th><th>Peak</th><th>Weeks On Chart</th></tr>";
>>>
>>> while ($number<=100){
>>> $result = mysql_query("SELECT atitle,btitle,artist,label,avid,bvid FROM
>>> A$year WHERE id = $number");
>> <SNIP>
>>
>> Why on earth are you sending _100_ separate mysql queries when you could
>> do it with one query using BETWEEN ???
>
> Perhaps he wants his results in ascending sequence by id, and doesn't know
> about the ORDER BY clause.
>
> $result = mysql_query("SELECT atitle,btitle,artist,label,avid,bvid "
> "FROM A$year "
> "WHERE id BETWEEN 1 and 100 "
> "ORDER BY id ASC");

Thanks for the clue.
As given, I got a parse error. Eliminated the extra quotes.
Output reseulted in one table row showing with no data.

www.mroldies.met/filetest.php

Report message to a moderator

[Message index]

		part 2 - file exists not working By: richard on Mon, 23 September 2013 14:04
		Re: part 2 - file exists not working By: Tim Streater on Mon, 23 September 2013 14:17
		Re: part 2 - file exists not working By: richard on Mon, 23 September 2013 14:35
		Re: part 2 - file exists not working By: Paul Herber on Mon, 23 September 2013 14:33
		Re: part 2 - file exists not working By: David Robley on Tue, 24 September 2013 00:46
		Re: part 2 - file exists not working By: Lew Pitcher on Tue, 24 September 2013 02:07
		Re: part 2 - file exists not working By: richard on Tue, 24 September 2013 05:57
		Re: part 2 - file exists not working By: David Robley on Tue, 24 September 2013 07:49
		Re: part 2 - file exists not working By: richard on Tue, 24 September 2013 08:10
		Re: part 2 - file exists not working By: richard on Tue, 24 September 2013 08:32
		Re: part 2 - file exists not working By: Doug Miller on Tue, 24 September 2013 23:23
		Re: part 2 - file exists not working By: David Robley on Wed, 25 September 2013 00:18
		Re: part 2 - file exists not working By: Lew Pitcher on Tue, 24 September 2013 13:45
		Re: part 2 - file exists not working By: Thomas 'PointedEars' on Tue, 24 September 2013 14:34
		Re: part 2 - file exists not working By: Lew Pitcher on Tue, 24 September 2013 14:41
		Re: part 2 - file exists not working By: richard on Tue, 24 September 2013 16:17
		Re: part 2 - file exists not working By: Richard Yates on Tue, 24 September 2013 16:29
		Re: part 2 - file exists not working By: bill on Tue, 24 September 2013 22:51
		Re: part 2 - file exists not working By: Denis McMahon on Tue, 24 September 2013 19:10
		Re: part 2 - file exists not working By: bill on Tue, 24 September 2013 23:08
		Re: part 2 - file exists not working By: Richard Yates on Wed, 25 September 2013 01:39
		Re: part 2 - file exists not working By: Peter H. Coffin on Wed, 25 September 2013 03:17
		Re: part 2 - file exists not working By: bill on Thu, 26 September 2013 21:20
		Re: part 2 - file exists not working By: Richard Yates on Thu, 26 September 2013 22:43
		Re: part 2 - file exists not working By: Jerry Stuckle on Thu, 26 September 2013 23:43
		Re: part 2 - file exists not working By: Scott Johnson on Wed, 25 September 2013 01:54
		Re: part 2 - file exists not working By: bill on Thu, 26 September 2013 21:39
		Re: part 2 - file exists not working By: Richard Yates on Thu, 26 September 2013 22:47
		Re: part 2 - file exists not working By: bill on Sat, 28 September 2013 17:58
		Re: part 2 - file exists not working By: Richard Yates on Sat, 28 September 2013 18:45
		Re: part 2 - file exists not working By: Tim Streater on Wed, 25 September 2013 08:01
		Re: part 2 - file exists not working By: Thomas 'PointedEars' on Tue, 24 September 2013 16:54
		Re: part 2 - file exists not working By: Tim Streater on Tue, 24 September 2013 17:30
		Re: part 2 - file exists not working By: Scott Johnson on Tue, 24 September 2013 22:40
		Re: part 2 - file exists not working By: bill on Tue, 24 September 2013 23:14
		Re: part 2 - file exists not working By: Richard Yates on Wed, 25 September 2013 01:43
		Re: part 2 - file exists not working By: bill on Thu, 26 September 2013 21:42
		Re: part 2 - file exists not working By: bill on Tue, 24 September 2013 22:50
		Re: part 2 - file exists not working By: Scott Johnson on Wed, 25 September 2013 01:56
		Re: part 2 - file exists not working By: Curtis Dyer on Thu, 26 September 2013 06:01
		Re: part 2 - file exists not working By: bill on Thu, 26 September 2013 22:04
		Re: part 2 - file exists not working By: Curtis Dyer on Fri, 27 September 2013 01:47
		Re: part 2 - file exists not working By: Jerry Stuckle on Fri, 27 September 2013 02:56
		Re: part 2 - file exists not working By: Richard Yates on Fri, 27 September 2013 03:11
		Re: part 2 - file exists not working By: Jerry Stuckle on Fri, 27 September 2013 03:41
		Re: part 2 - file exists not working By: Curtis Dyer on Fri, 27 September 2013 06:04
		OT Re: part 2 - file exists not working By: bill on Sat, 28 September 2013 18:33
		Re: OT Re: part 2 - file exists not working By: Fiver on Sat, 28 September 2013 21:12
		Re: OT Re: part 2 - file exists not working By: The Natural Philosoph on Sun, 29 September 2013 05:50
		Re: OT Re: part 2 - file exists not working By: Peter H. Coffin on Sun, 29 September 2013 15:39
		Re: OT Re: part 2 - file exists not working By: Jerry Stuckle on Sun, 29 September 2013 18:49
		Re: part 2 - file exists not working By: Doug Miller on Tue, 24 September 2013 23:20
		Re: part 2 - file exists not working By: Richard Yates on Wed, 25 September 2013 01:46
		Re: part 2 - file exists not working By: richard on Wed, 25 September 2013 02:27
		Re: part 2 - file exists not working By: The Natural Philosoph on Wed, 25 September 2013 05:21
		Re: part 2 - file exists not working By: David Robley on Wed, 25 September 2013 05:50
		Re: part 2 - file exists not working By: Doug Miller on Thu, 26 September 2013 20:30
		Re: part 2 - file exists not working By: Denis McMahon on Wed, 25 September 2013 07:42
		Re: part 2 - file exists not working By: The Natural Philosoph on Wed, 25 September 2013 08:07
		Re: part 2 - file exists not working By: Richard Yates on Wed, 25 September 2013 13:29
		Re: part 2 - file exists not working By: The Natural Philosoph on Wed, 25 September 2013 14:09

Previous Topic:	[urgent] need solution of Questions, in context of PHP5
Next Topic:	Host recommendations (slightly OT)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 08:45:38 GMT 2024

Total time taken to generate the page: 0.05178 seconds