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