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 #182891 is a reply to message #182885]

Tue, 24 September 2013 13:45

Lew Pitcher
Messages: 60
Registered: April 2013

Karma:

Member

On Tuesday 24 September 2013 01:57, in comp.lang.php, noreply(at)example(dot)com
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.

Yah, sorry. I wrote that php, thinking in C. I forgot the string
concatenation operator between each quote.

> Output reseulted in one table row showing with no data.
>
> www.mroldies.met/filetest.php

If $result is not FALSE, you loop through it using mysql_fetch_array() or
one of it's child functions (mysql_fetch_row or mysql_fetch_assoc()) to
retrieve individual rows

Something like

while ($row = mysql_fetch_array($result) )
{
printf("atitle: %s\n",$row['atitle']);
printf("btitle: %s\n",$row['btitle']);
/* and so on */
}

--
Lew Pitcher
"In Skills, We Trust"
PGP public key available upon request

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 05:31:11 GMT 2024

Total time taken to generate the page: 0.06540 seconds