mysql binary / images / mp3s

[crow2icedearth2]

i have been learning and mysql and php i was wondering how to insert binary files into mysql


i have read to use BLOB for type but i havnt found alot of info on how to do this.

so far i think mysql is a kick *** database server. i took a few database classes while at school and at that time was bored by the theory of it but now rereading it i think its cool.

[hard candy]

Here's the article you need:
Saving Binary Data in Mysql (http://www.onlamp.com/pub/a/php/2000/09/15/php_mysql.html)

[crow2icedearth2]

yeah thanks i came across that article right after i posted this msg. thanks man.

[crow2icedearth2]

i tried that site u said i copied and pasted the examples ecept for the password for the binary_user and i still get errrors here they are

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/binary/main.php on line 7

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /www//binary/main.php on line 29
Filename Type Size Description

i know that both of those are PHP mysql functions and why am i getting the errors i copied what the article said and it just doenst work .

[crow2icedearth2]

why am i getting those errors i still cant figure it out. ?

i copy and pasted the example from the site it doesnt work its telling me its incorrect syntax.

[crow2icedearth2]

still cant not get this to work........ i copy and paste the code and it just doesnt not work

i dont get any errors now but it doesnt upload if u go to add.php and select a file it does nothing .

and if i look at main.php it only says FILE and TYPE


http://www.onlamp.com/pub/a/php/2000/09/15/php_mysql.html (http://http://www.onlamp.com/pub/a/php/2000/09/15/php_mysql.html)


i want to get binary image files to be able to store them in mysql then use php to output them dyn to website....... please help anyone ?

[crow2icedearth2]

mysql binary (http://tp://www.onlamp.com/pub/a/php/2000/09/15/php_mysql.html)

[crow2icedearth2]

its the first link when i copy and paste it somereason not pasting correctly ..... weird