Need help in storing and retreving images

2005-06-18 Thread madderla sreedhar
 
 

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



need help in stroing and retreving images from database

2005-06-18 Thread madderla sreedhar
Sir , 

Iam working on Mysql5.0 version. 
Can I store .jpeg or .png or .gif etc imagefiles
in database.
If so where can I get the tutorials or sample code
to insert and retrive the images from mysql
database.

Any help is welcome.

Thanking you ,
Sreedhar


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Need help

2005-06-18 Thread madderla sreedhar
Isn't MySql supports large amounts of data to be
stored in databases. What is the maximum number of
records  that can be handled or stored in Mysql.
Is there any limit. If i want to store large
amounts of data then is it necessary to migrate to
another database. Please reveal this .

Any help is welcome.

Thanking you ,
Sreedjhar.


__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Need help in running MySql in PHP script

2005-05-17 Thread madderla sreedhar
Hi,

Iam using php 5.0, IIS 5.0, Mysql 5.04 ,win2000 NT
and IE as web browser and executed the php
script,but got a fatal error describing that
undefined fuction mysql_connect() in the file and
not getting the desired output.

I had uncommented the php.ini file the entry named
'extension=php_mysql.dll' and also set the path
for PHPRC = c:\php , also the PATH variable to
c:\php;.  But still Iam not getting the desired
output in browser.

Kindly tell me where iam going wrong.

Any sort of help is welcome.

thanks,
Sreedhar.

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Need help in running MySqli (extension) in PHP script

2005-05-17 Thread madderla sreedhar
hi,
 I use php 5.0,Mysql 5.04 ,IIS 5.0 ,IE in 
windows2000 NT os and still got errors in running 
php script with Mysqli functions.

when I execute the Php script with Mysql functions

in it, it gives fatal error  undefined function 
Mysqli_connect() on line no etc.,,  in browser.
IS that correct, can I use Mysqli functions in 
this because I am using Mysql 5.04 (beta) version
in PHP documentation it was told that those who
are 
using Mysql 4.0 or higher can use Mysqli in php
scripts.

if so how i can install Mysqli ( Extension MYSQL)
in PHP. 

I doesn't understand the command  use
--with-mysqli= mysql_config_path/mysql_config
 configuration option where mysql_config_path
 represents the location of the mysql_config
 program that comes with MySQL versions greater
 than 4.1. 
 where should I type this command in order to
 install the mysqli extension so that I can use 
the
 Mysql 5.0 version in php script.

Any help is welcome.

Thanks

SReedhar



__ 
Do you Yahoo!? 
Read only the mail you want - Yahoo! Mail SpamGuard. 
http://promotions.yahoo.com/new_mail 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Need help in locating configuration file

2005-05-17 Thread madderla sreedhar
Hi,
Iam using Mysql5.04
What does it mean,

To install the mysqli extension for PHP, use the 
--with-mysqli=mysql_config_path/mysql_config
configuration option where mysql_config_path
represents the location of the mysql_config
program that comes with MySQL versions greater
than 4.1.

in this,is mysql_config file is same as my.ini and
the path to it in windows 2000 NT (on my system is
)c:\Program Files\mysql\mysql server 5.0 ; is it
correct, then after editing the php.ini file why
doesnot it is working.

Any help is welcome.

Thanks
Sreedhar



__ 
Do you Yahoo!? 
Read only the mail you want - Yahoo! Mail SpamGuard. 
http://promotions.yahoo.com/new_mail 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Need help in running MySql in PHP script

2005-05-16 Thread madderla sreedhar
Hi,
  Iam using mysql 5.04 , php 5.0 with IIS 5.0
webserver  and written some scripts and executed
on IE webbrowser but getting an fatal error
undefined function mysql_connect() in the code 
kindly tell me where iam going wrong and also tell
the mysql username how to find it out becoz when
Iam opening the Mysql from start button it only
asks the password and doesnot prompt for an
username tell the porcedure to create a new user
an tell me how to identify the current user in
Mysql.
Is there any special code to be written in .ini
file of php to link Mysql with php to run the
Mysql code in php scripts,if so please tell the
code required  in detail.

Any sort of help is welcome.

Thanks 


Sreedhar

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



NEED HELP IN IF STATEMENT

2005-05-02 Thread madderla sreedhar
Can u please execute the following procedure in MySql
and tell me where I had gone wrong because on my
system the same code is giving error near line 
  := 'TRUE' 

CREATE  PROCEDURE cart_items_validate
(IN mcustid INT ,IN mprodid varchar(10),
OUT mvalidate  varchar(10))

BEGIN

DECLARE rowexists INT(6);


select count(*) into rowexists from esr_cartitems_data

where customer_id=mcustid and item_id=mprodid;

if rowexists0 THEN
   mvalidate := 'TRUE'
else
   mvalidate := 'FALSE';
end if;

END;


Any help is welcome .



Thanks,

Sreedhar.

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Need hlep for creating a Package in MySql 5.0.4 beta nt

2005-04-30 Thread madderla sreedhar
Is there any statement in MySql 5.0 to create a
package of my own i,e 
create package Pack_name ( ) etc., 
if so please give the syntax of that or 
what to do if I want to create a package of my own in
mysql 5.0 . Any help is welcome.

Thanks ,


Sreedhar

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



need help in syntax for create package or compile etc

2005-04-30 Thread madderla sreedhar
Is there any statement named create and complie java
source named ..  syntax in the mysql for creation
of a java source file for loading data from java files
or retriving data etc .
 
Any help is welcome . 

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Need help with stored procedures in mysql

2005-04-28 Thread madderla sreedhar
 
 

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Need help with stored procedures in MySQL

2005-04-28 Thread madderla sreedhar
Hi, 
Iam looking to migrate an Oracle database to MySQL and
trying to write a simple stored procedure in MySQL 4.1
.I reffered few examples posted and used the
statements from them but I get errors while creating
procedures 

create procedure helloworld (out p_text VARCHAR(30))
BEGIN
set p_text = HELLO WORLD ;
END
//
After pressin enter key an error message is displayed
ERROR 1064(42000):
you have an erro in your SQL syntax; 
check the manual that corresponds to your mysql server
version for the right syntax t ouse near 'procedure
HElloWorld ( OUT p_text = 'HELLO World' ' at line 1


Any help would be appreciated .

Thanks, 

Sreedhar.







__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]