mysql_query("select

[MrLibya]

Hallo

That My First Time To Use Mysql In Quest
So Litile Help PLz

You See In The Quest :

PHP Code:

        when login begin
        local title = mysql_query("select * from player.news where id = '"..l.."' ")
        local title_table = {}
        for i = 1,table.getn(news),1 do
        table.insert(title_table,news.title[i])
    end
        local m = select_table(title_table)
        say_title(title_table[m]) 


Sql:
</b>

PHP Code:

CREATE TABLE `news` (
`id`  int(16) NOT NULL ,
`title`  varchar(50) NOT NULL ,
`text1`  varchar(50) NOT NULL ,
`text2`  varchar(50) NOT NULL ,
`text3`  varchar(50) NOT NULL ,
`text4`  varchar(50) NOT NULL ,
`text5`  varchar(50) NOT NULL ,
PRIMARY KEY (`id`)
)
; 


But In The Sql I Write In
ID : 1
title : Test



It's Has To Be When I Login The Game
I Have To Get The Word That I Write In The Sql
But Nothing Show To Me

Sry For My Bed English

[Ʀyuzaki]

PHP Code:

        when login begin
        local title = mysql_query("select * from player.news where id = '"..l.."' ")
        local title_table = {}
        for i = 1,table.getn(title),1 do
            table.insert(title_table,title.title[i])
        end
        local m = select_table(title_table)
        say_title(title_table[m]) 


[MrLibya]

Not Work

[Lord iRemix]

Which mysql query function do you use?

[ProfessorEnte]

PHP Code:

when login begin
    local title = mysql_query("select * from player.news where id = '"..l.."' ")
    local title_table = {}
    for i = 1,table.getn(news),1 do
        table.insert(title_table,news.title[i])
    end
    local m = select_table(title_table)
    say_title(title_table[m]) 


There is no "news" table.

PHP Code:

when login begin
    local title = mysql_query("select * from player.news where id = 1 ")
    local title_table = {}
    for i = 1,table.getn(title),1 do
        table.insert(title_table,title.title[i])
    end
    local m = select_table(title_table)
    say_title(title_table[m]) 


[MrLibya]

Originally Posted by ProfessorEnte

PHP Code:

when login begin
    local title = mysql_query("select * from player.news where id = '"..l.."' ")
    local title_table = {}
    for i = 1,table.getn(news),1 do
        table.insert(title_table,news.title[i])
    end
    local m = select_table(title_table)
    say_title(title_table[m]) 


There is no "news" table.

PHP Code:

when login begin
    local title = mysql_query("select * from player.news where id = '"..l.."' ")
    local title_table = {}
    for i = 1,table.getn(title),1 do
        table.insert(title_table,title.title[i])
    end
    local m = select_table(title_table)
    say_title(title_table[m]) 


There news table in plyer i make it

Originally Posted by [iRemix]

Which mysql query function do you use?

I Really Don't Know
My First Time To Use The Mysql , So I Don't Know Allot

[ProfessorEnte]

Originally Posted by MrLibya

There news table in plyer i make it



I Really Don't Know
My First Time To Use The Mysql , So I Don't Know Allot

but there is no news table in your quest. You save the result of the query in the table " title" so you are only able to access the values through this table.

[MrLibya]

Can You Edit It To Make It save In news table ?

[Mijago]

He already did!
Please keep your eyes open

[MrLibya]

Yes But Didn't Work