RE: [PHP-DB] Can't see the results - It works now!!!

2002-09-09 Thread Wilmar Perez
Hello guys (again) Well, just wanted to let you know that my code is working now, at the end it worked thanks to the help of Jim and Peter. The following is the resulting code just in case anyone can make use of it. Thankyou so much. $query_cat = "select concat(author.author_names,' ',author

RE: [PHP-DB] Can't see the results

2002-09-09 Thread Wilmar Perez
Hi guys, it's me again. Well, I did as Peter suggested and changed my code for this: $query_cat = "select author.author_names || ' ' || author.author_surnames as author_full_name from author, authorxcat

RE: [PHP-DB] Can't see the results

2002-09-07 Thread Peter Lovatt
Message----- From: Wilmar Perez [mailto:[EMAIL PROTECTED]] Sent: 07 September 2002 00:38 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Can't see the results Hello again Well I followed Jim recomendation but it didn't work either, I think I'd better send the full code to you (don't

Re: [PHP-DB] Can't see the results

2002-09-06 Thread Wilmar Perez
Hello again Well I followed Jim recomendation but it didn't work either, I think I'd better send the full code to you (don't worry is very short), so you can have a broader idea of what I'm intending to do, which is actually quite a simple thing, just to retrieve results from a database accord

Re: [PHP-DB] Can't see the results

2002-09-06 Thread Jim Hunter
Your problem seems to stem from the $content .= $row; $row is an Array and you must use an index to get at any given value it holds. If you need all of the values in $row, use the count() function to get the number of elements (columns in this case), then loop through them adding them to $content