Re: [PHP] Thanks but problem again! Re: [PHP] PHP script problem (with MySQL)

[Petar Nedyalkov]

On Wednesday 20 April 2005 06:07, Sugimoto wrote:
(B Thank you, Richard,
(B
(B I simply change this part
(B (select * from openart_table) into
(B (select substring(loc1, 1, 3) as THREE_LETTER_CODE, * from openart_table)
(B but Ive got this error, whats wrong with it?
(B
(B Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
(B resource in c:\apache..\openart\test\openart_search.php on line 98
(B Records Found
(B
(BWhy don't you try the query in the mysql console? You'll see what it returns 
(Band debug the error easily.
(B
(B
(B Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
(B resource in c:\apache\openart\test\openart_search.php on line 100
(B
(B Cheers
(B
(B-- 
(B
(BCyberly yours,
(BPetar Nedyalkov
(BDevoted Orbitel Fan :-)
(B
(BPGP ID: 7AE45436
(BPGP Public Key: http://bu.orbitel.bg/pgp/bu.asc
(BPGP Fingerprint: 7923 8D52 B145 02E8 6F63 8BDA 2D3F 7C0B 7AE4 5436

pgpBAtVz6F3Ky.pgp
Description: PGP signature

[PHP] Thanks but problem again! Re: [PHP] PHP script problem (with MySQL)

[Sugimoto]

Thank you, Richard,
(B
(BI simply change this part
(B(select * from openart_table) into
(B(select substring(loc1, 1, 3) as THREE_LETTER_CODE, * from openart_table)
(Bbut Ive got this error, whats wrong with it?
(B
(BWarning: mysql_num_rows(): supplied argument is not a valid MySQL result
(Bresource in c:\apache..\openart\test\openart_search.php on line 98
(BRecords Found
(B
(BWarning: mysql_fetch_array(): supplied argument is not a valid MySQL result
(Bresource in c:\apache\openart\test\openart_search.php on line 100
(B
(BCheers
(B
(B-- 
(BPHP General Mailing List (http://www.php.net/)
(BTo unsubscribe, visit: http://www.php.net/unsub.php