PureBasic Forums - English

That part of the code is ok. "OK" gets sent to the debug log..

Sorry, should have explained more. The DLL is accessible, no errors compiling, this is only the query code. It connects without trouble, and the SQL query is correct, however, it doesnt put the expected values in the variables.

Hi, again.

Been having some trouble with using this lib..libmysql.dll..hoping someone here has experience using this.

I'm trying to get the value of ID and name from this query:
SQL = "SELECT id,name FROM ibf_members WHERE name='"+Str(Username)+"'"

However, have failed miserably. This is the ...

Thanks for the lib, works great..kinda...

If i do this:

If OpenLibrary(#libmysql,"libmysql.dll")
Result=CallFunction(#libmysql,"mysql_init",dbHnd)
If Result
dbHnd = Result
If CallFunction(#libmysql,"mysql_real_connect",dbHnd, host, user, passwd, db, port, "", 0) = 0
;GetError("error ...

What i dont get, is the part where you connect to the DB. Where is the line where you supply the MySQL server's IP?

Ive seen that code..and its confusing. Could you provide an example code that simply connects to a MySQL database on a spoof ip with a spoof user/pass, and sends a query?

I know this sounds a lot like "do my code for me", but that really just confuses me.

Hi, ive searched for this, but couldnt find anything i could understand XD

Anyway, could anyone show me example code of how to connect to a remote MySQL database from PB? I know all the SQL commands, i just need to know how to open a connection ready to send queries to it..Im a PB n00b, so anything ...

ah, that simple? in my previous language you couldnt do that with atrings :-\

thank you. I did not use that german one because i cant read german, plus i now have tha basic grasps. i have one last, noobish question. How would i append a string infront of another string? e.g. put "name: " in front of "hello" to make "name: hello"

Edit: and how do you send the message to all ...

hey dibble, remember me from blitzcoder? probably not as morduun stole my password. :-\. i was also a blitz user, and ive never looked back, even though i started learning purebasic just a month ago.

ok then, for now ill just create a client to connect to an IRC server. HOwever, i believe you need to send something to the IRC server before you can join, your name, etc..., however i dont know what order/where/how you send this to the server. If someone could give me what you need to send, that ...

I cant seem to find any examples on a chat client/server, and, all the advanced sources, and some of the sources in the purebaisc example directory doesnt work :-\, error messages come up like "AllocateMEmory function error: too many parameters", and "Function not found".

Hi, i am pretty new at programming, and to start me off, i would like to create a small chat server/client, but i dont know how to go about it. Can someone please show me an example of a server recieving data from a client, and then sending that data again to all clients? This would be of great help ...

Thank you srod.

Hi, im new to this forum, and to purebasic. I have just converted from BlitzBasic, because i wanted something a bit more powerful, and robust. I am doing a very small little project to help me learn the language, (not an MMOROREDGJOGDRGOERPG), its a small runescape toolkit in windows, however, i ...