On Apr 28, 2008, at 12:49 AM, Chris wrote:
Philip Thompson wrote:
On Apr 27, 2008, at 9:15 AM, Ron wrote:
Hi,
How can i retrieve via php a media stored in a mysql database as
longblob?
I'd like to be able to retrieve the media and stream it.
TIA
regards,
ron
Just like any other field
On Apr 28, 2008, at 9:22 AM, Ron wrote:
hi yves,
not sure how large the file is, but i'm assuming a caller would not
leave a voicemail longer than a minute. max maybe 30 secs. is there
a query to get the size of a data in a certain row/column?
thank you
regards
ron
Assuming you're
Hi,
Why my program is not going in while loop? When I run the same query in SQL
cmd, it brings result but here when I print $result gives Resouce ID number
means $result has data then why $row is empty.
$query = 'SELECT * FROM `gig` LEFT JOIN genre ON gig.genreId=genre.genreId LEFT
JOIN venue
I could be wrong, but I don't think table aliases continue to exist in PHP;
only the column names.
$g_name = $row[gigName];
$vname = $row[venueName];
$genre = $row[name];
You may also consider revising the query to only grab the columns you need,
using an alias for at least
Try doing print_r($row); in your while loop and see what exactly is in
that array.
Ken
On Tue, Apr 29, 2008 at 1:46 PM, Jon L. [EMAIL PROTECTED] wrote:
I could be wrong, but I don't think table aliases continue to exist in PHP;
only the column names.
$g_name = $row[gigName];
Nasreen Laghari wrote:
Hi,
Why my program is not going in while loop? When I run the same query in SQL
cmd, it brings result but here when I print $result gives Resouce ID number
means $result has data then why $row is empty.
No, it means the query worked. If it wasn't a resource it would be
To find out more about Twitter, visit the link below:
http://twitter.com/i/40475d1b6ab3da83e89dcb271fb89addd231b64d
Thanks,
-The Twitter Team
About Twitter
Twitter is a unique approach to communication and networking based on the
simple concept of status. What are you doing? What are your
Hi all,
I am currently responsible for a subscription module and need to design the
DB tables and write code.
I have described my table design and queries in the post:
http://phparch.cn/index.php/mysql/38-MySQL-configuration/152-best-practices-for-using-mysql-index
The problem is, in a short