21.11.2011, 22:18
What have you tried so far to select the information from the database? Can you show us?
I suggest you go and have a look at some tutorials in the Scripting Tutorials section, such as this tutorial: https://sampforum.blast.hk/showthread.php?tid=159785
In short, you need to learn how to make use of the SELECT syntax in SQL and then use mysql_fetch_row to store the result in a string, then split the result. Alternatively if you can use mysql_fetch_row_field to select column data and store it individually.
I suggest you go and have a look at some tutorials in the Scripting Tutorials section, such as this tutorial: https://sampforum.blast.hk/showthread.php?tid=159785
In short, you need to learn how to make use of the SELECT syntax in SQL and then use mysql_fetch_row to store the result in a string, then split the result. Alternatively if you can use mysql_fetch_row_field to select column data and store it individually.