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 #182888 is a reply to message #182887]

Tue, 24 September 2013 08:10

richard

Messages: 213
Registered: June 2013

Karma:

Senior Member

On Tue, 24 Sep 2013 17:19:28 +0930, David Robley wrote:

> richard wrote:
>
>> 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
>
> You do of course realise that you handle the returned result set by looping
> over it to get all the results? Please see
> http://www.php.net/manual/en/function.mysql-fetch-assoc.php which should
> give you a few tips on working with a result set of multiple records.
>
> You might have to rethink your code a little to get the correct display
> format.

interesting idea I will try it.

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:37:49 GMT 2024

Total time taken to generate the page: 0.06286 seconds