Hi Guys...

Thanks for ur help..my problem already solved..:)

Hi WaltP,

Thanks for ur reply. I get what do u mean for this statement:


but for this statement:

how should i modify my IF statement in order for the query to execute properly based on...

Hi guys,

need ur help regarding the above matter. I've write a code for if statement but it didnt work as expected when I run the program. Below is my code:


// Get ChannelID
strcpy(src,...

Hi guys..

I already solved the above problem...i just only change this portion:

sprintf(filename,"twop_%04d""%02d""%02d""%02d""%02d"".dat",yr,mon,day,hour,min);

Thanks

hi guys..

sorry for asking again regarding segmentation fault..my query consists of 12 columns in the resultset and I already called to access from row[0] until row[11]...when I try to run the...

ok..that's 1 idea...how about if there is 2 rows that have same value but i should display only 1..meaning that, i should check if 2 column have same value..i should display only 1..


Thanks for...

how to combine the rows?. actually i want to combine addr and addr2 to become for example address but separated with (,).

ley say addr = no.17
addr2 = loke yew road
and it should be =...

ooohhhh..thanks..i thought..the declared row depends on the row inside the table of database..

sorry..aku post again my codes:


int main(int argc, char *argv[])
{

char string1[1600], string2[1600], query[1600], query1[1600], mobileno[50];
int i, j, len;
FILE *fp2;

Hi All,

Need our expertise out there regarding the above mention error and below are the codes:


/* send SQL query */

bzero(query1, sizeof(query1));
sprintf(query1, "select...

Hi all,

I have another problem regarding this program..actually after this program write the data query from database into a filename, this program should update the status of data to show that...

Hi all,

The problem before has been solved...thanks to all...:D

Hi..thanks for the code..it's work..but then..the filename created is sumthing like this:

DATA-11-02d-02d-04s.txt

actually i already add for the hour section...supposedly the filename should be...

Hi all,

i've changed my code and it's more simpler than before..I already can compile the code but then, when i'm trying to run it, i've got the "Segmentation Fault" error.

The code is as...

Hi all..

I've written a code something like this:

void get_year(char* year)
{
strcpy(year, Year);
}

void get_month(char* month)

Hi all,

Thanks for ur reply....the above problem has been solved...

i have another thing..hopefully u all can help me. as u all can see, i have written a writeLogFile function where it...

Hi all,

I try to compile my program and got this kind of error:
test6.c: In function `main':
test6.c:46: too many arguments to function `mysql_query'

Here is my code:


int main(int argc,...

Hi All,

I've written a code to append string into a file. How to modify that code so that, before the string had been appended, it should check the existing of the file. If the file does exist,...

Hi,

I've made some changes to my coding..but unfortunately, there were errors when compiling it..dunno how to solve it..hope anyone can help me...the errors:

client.c: In function senddata:...

Hi All,

I've write a code for client and server. It works well so far but the server just acknowledge the client of what it received. How to recode this program to make sure that once server...

Hi All,

Im currently try to write a code to read the data from mysql tables and then write the contents into a text file. Below is my code. I dunt know what's wrong with this code because in the...

Hi All,

This is the code to read the text file:

#include <stdio.h>
#include <string.h>
#include <mysql.h>

#define HOST "localhost"
#define USER "yati"

Hi WolfPack,

oooo...ic..if that so, maybe I need to provide bash script to execute the program..im using OS Red Hat Linux...:)

Thanks...

Hi WolfPack,

ok..I've got what do u mean..and I already try it n it works..but..I still need to type the filename right?..If possible, I just want to run program.exe only but then it can read all...

Hi WolfPack,

I've done like this:

int main()
{
char filename[100];
scanf("%s",&filename);
readLogFile(filename);
}

Hi WolfPack,

Refer to your given code, it's work but I still need to hardcode the filename. I want it to automatically read all the files received because I'll always receive files every hour and...

Hi all,

Basically, I have done my code and it already successfully read the text file n insert the content into the database. But the problem is..i dunt know how to write a code so that, this...

Hi Eddy,

Actually, I want to read the file and then extract the content of the file to be inserted into the database (MySQL database). I had created a table in MySQL so that, when this C program...

Hi Eddy,

Yerp, I need to write that code in C...n what I meant by sending it to database is that, I have 1 text file to be read, n after that, this program need to insert all the read data from...

Hi all,

I'd posted this problem previously but in the wrong place..:)..Hopefully, I can get the answer from this thread. I'm a newbie in C..Right now, I have to write a code to read a text file...

Hi alc6379,

I'll be using C for this assignment

Thanks

Hi all,

I'm a newbie in C..Right now, I have to write a code to read a text file and then insert all the info inside that text file into database. Should anyone have a simple sample of it, maybe...