12.05.2012, 07:24
Hello, you can not fetch the row like that you will have to make a new query for getting the data from the mysql database.
For that you will have to make a new query:
It should be something like this, since I don't know what are your table and column names so I can not make a query for you. But the above query is just an example to "select" data from the database.
For more info click the following link for the tutorial of MySQL:-
https://sampforum.blast.hk/showthread.php?tid=129183
-FalconX
For that you will have to make a new query:
pawn Код:
format(musicquery,sizeof(musicquery),"SELECT `url` FROM `playlist` WHERE `music` LIKE '%s%s%s'", "%%", musicname, "%%"); // SELECT is to select the data of URL (URL is a Column) FROM "playlist" (playlist is a table name) then WHERE? music (it's a column) LIKE %name%s
mysql_query(musicquery)
For more info click the following link for the tutorial of MySQL:-
https://sampforum.blast.hk/showthread.php?tid=129183
-FalconX