MySQL - What are rows and fields?
#2

When you select a player's data from the database, you know for sure that the max records exist for that player is 1 so the row is 0.

In case you'd select everything from a table and use a loop, the variable is used in the iterator would be the "rowid" instead.

About the not loading part, you'll need to explain more about what actually happens.

EDIT:

The first query is fine, if you remove `` around the fields you can then reduce the size of it.

About the second one, I've never used "name[x]" and I'm not sure if it's acceptable (check mysql logs) but there's a really good tutorial about how to save weapons: https://sampforum.blast.hk/showthread.php?tid=505081
Reply


Messages In This Thread
MySQL - What are rows and fields? - by Ciarannn - 28.04.2015, 19:46
Re: MySQL - What are rows and fields? - by Konstantinos - 28.04.2015, 19:53
Re: MySQL - What are rows and fields? - by Ciarannn - 28.04.2015, 20:01
Re: MySQL - What are rows and fields? - by Konstantinos - 28.04.2015, 20:04
Re: MySQL - What are rows and fields? - by Ciarannn - 28.04.2015, 20:06
Re: MySQL - What are rows and fields? - by Konstantinos - 28.04.2015, 20:09
Re: MySQL - What are rows and fields? - by Ciarannn - 28.04.2015, 20:30
Re: MySQL - What are rows and fields? - by Konstantinos - 28.04.2015, 20:35
Re: MySQL - What are rows and fields? - by Ciarannn - 28.04.2015, 20:37
Re: MySQL - What are rows and fields? - by Konstantinos - 28.04.2015, 20:40

Forum Jump:


Users browsing this thread: 2 Guest(s)