在MySQL和PHP中按ID显示特定列

Question

I have problem (i think for you is simple to solve) with PHP and MySQL. I have database, that call "tekst". There is 3 column:

1. id (autoincrement),
2. date (timestamp),
3. tresc (text)

and the site: index.html. I want to paste code like that <?php echo "$id1"; ?> into index.html to display a column "treść" assigned to some "id".

Now I do like that:

$w = mysql_fetch_array(mysql_query("SELECT * FROM tekst WHERE id=5"));

echo $w['tresc'];

but when I have many records, it will be troublesome.

How to create MySQL Query to display what i want ? In one page i will have many ID's.

Please help Thanks

Answer 1

Try using mysql_fetch_row.

example

mysql_fetch_row(mysql_query("SELECT * FROM tekst WHERE id=1"));

Official Document