mysql loading - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql loading (/showthread.php?tid=614861)

---

mysql loading - MerryDeer - 14.08.2016

Hi,

I don't want create a lot of tables and row i create one and i want to save in it, but how to safe i can to load? i think that i could separate everything with ex. @

Hello this is my message@Another message@Other player message

How i need right load it? like i want to show it like this

Hello this is my message\n
Another message\n
Other player message

---

Re: mysql loading - Sew_Sumi - 14.08.2016

Use 1 table, use many rows.

Especially if it's just a random message to show to people at various times.


Then you can get the number of rows, and do random on that.

You could also do a for loop from the number of rows as well to load a list of them up in one pass.

---

Re: mysql loading - Vince - 14.08.2016

Bad. Never store more than one piece of information per field. One of my gamemodes, which sadly went unfinished, exceeded fifty tables.

---

Re: mysql loading - MerryDeer - 14.08.2016

WHy? i need to store about ~100 last messages, so i need create 100 rows..

---

Re: mysql loading - Vince - 14.08.2016

And? Isn't that exactly what a database is meant for? Unless you're confusing columns with rows.

---