Posted by Sugimoto on 04/20/05 06:07

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

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

• Next in forum: Re: [PHP] Sorting table columns dynamically on normalized MySQL tables
• Prev in forum: Re: [PHP] can I join two mp3 files with php
• Thread view: Thanks but problem again! Re: [PHP] PHP script problem (with MySQL)

[Reply to this message]