Re: Apache + php + MYSQL

Hi, How do i check whether PHP has MYsql support built or not Please help Sameer -- you wrote: On Tuesday 21 May 2002 09:51, Robert Vetter wrote: On Tuesday 21 May 2002 10:38, Sameer Maggon wrote: in /var/www/html/rcmms/appl.php on line 5 Hello, 1. make shure the PHP module

Apache + php + MYSQL

Hi, I have my Database in MYSQL and wanna use PHP on Apache At the starting of the page I have given ?php $query = SELECT * FROM appl; // Establish a connection to the MySQL DBMS $connection = mysql_connect(linuxsrv, sameer, sameer); // Use the rcmms database

BLOB - JPG

Hi, If i have a JPG file, how can i put it into the database / table in MYsql with one field defined as BLOB.. Please help Sameer -- http://www.dypatil.edu For Better tomorrow - Before posting, please

Re: Re: store JPG in MySQL DB

Hi, That explains me a problem but i could not see strmov() function any where, while linking with -lmysqlclient also it gives unreferenced function.. I am using Mysql 3.23 Please help Sameer -- you wrote: Sameer, Monday, May 20, 2002, 11:17:48 AM, you wrote: SM Can you please

Binary Data mysql_real_escape_

Hi, Please see the code given below:: // strcpy(query,INSERT INTO blobtest VALUES('abc','); qptr = query; len = strlen(query); qptr += len; qptr += mysql_real_escape_string(mysql, qptr, data, iBytesRead); *qptr += '\''; *qptr += ')';

Mysql Connection from Webserver

Hi, I am using ASP and using IIS webserver.. I have a Mysql server installed on a linux box. what is the connectstring that i have to use to connect and gather data from my Mysql server Sameer -- http://www.dypatil.edu For Better tomorrow

Insert into Table

Hi, I have a table in which i have a field of VARCHAR(255), i am picking up URLs from a file and INSERTING into mysql table, i am using MySQL C API, the problem is that file contains 6700 records and it is just inserting few records like 100 or so, what may be the probnlem Please help Sameer

Please help - Inserting

Hi, I have a table in which i have a field of VARCHAR(255), i am picking up URLs from a file and INSERTING into mysql table, i am using MySQL C API, the problem is that file contains 6700 records and it is just inserting few records like 100 or so, what may be the probnlem Please help Sameer

query - primary key

Hi, I have a table with four colums id date time addr - varchar (used my sql C API) I want that when i add an entry, the PRIMARY KEY IS ALL OF THEM means that no entry should repeat. I used ALTER TABLE sss ADD PRIMARY KEY (all four field) but not when i add my things,

Re: query - primary key

Hi, Here are the errors i am getting You have an error in your SQL syntax near 'http://www.indianrail.gov.in/frame.html')
file://C:\\IIK\\for_you.html ')' at line 1 You have an error in your SQL syntax near 'http://www.cultureholidays.com/')
file://C:\\IIK\\Tour_del.html ')' at line 1 You

Re: query - primary key

Hi, Firstly, how do i correct that error of BAD text coz i actually have a text file which has a HISTORY dump from IE. Secondly what about the Duplicate Entry stuff, its comming for all the URLs why?? Regards Sameer -- you wrote: I'd take a look at this error first; you seem

store JPG in MySQL DB

Hi, Can i have a table in which i can store my JPG file somehow in MYSQL database. like i can do it in Oracle Sameer -- http://www.dypatil.edu For Better tomorrow - Before posting, please check:

Re: store JPG in MySQL DB

Hi, Can you please put some light on it.. How i can do it, or is it described in manual Sameer -- you wrote: Hi Hi, Can i have a table in which i can store my JPG file somehow in MYSQL database. Absolutely. just declare a BLOB column, and load your images rightinto the