need help with mysql
#2

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:

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)
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
Reply


Messages In This Thread
need help with mysql - by ancezas - 12.05.2012, 06:55
Re: need help with mysql - by FalconX - 12.05.2012, 07:24
AW: need help with mysql - by ancezas - 12.05.2012, 07:29
AW: need help with mysql - by ancezas - 12.05.2012, 08:43
Re: need help with mysql - by CoaPsyFactor - 12.05.2012, 09:45
AW: need help with mysql - by ancezas - 12.05.2012, 10:51

Forum Jump:


Users browsing this thread: 1 Guest(s)