need bad help.. calling text from mysql

[Smiry Kin's]

How do i call a certain part in the database??

e.g

in the table dd_items there is: ItemID ItemTitle SubCatagory, etc etc

how do i call ItemTitle? - to make it show in php.. e.g so if test was in the ItemTitle then it would call that...

damn its hard to explain!!! anyone help me further pm me?

if you understand what i mean - thank you! lol

regards

[Opserty]

SELECT `ItemTitle` FROM `dd_items`

Will select the ItemTitle for every row in the table, although this may not be very practical.

You can use this to narrow down results:

SELECT `ItemTitle` FROM `dd_items` WHERE `ItemID`=XXX

Where XXX is the ID number of a certain item, ItemID is I presume unique so this would only return one value for ItemTitle.

More info: http://dev.mysql.com/doc/refman/4.1/en/select.html

There are loads of tutorials on the web with more info you should check them out to. http://www.google.co.uk/search?hl=en...e+Search&meta=

[nico_swd]

EDIT: Too late.

PHP Code:

$query = mysql_query("SELECT ItemTitle FROM dd_items WHERE ItemID = 3 LIMIT 1") OR die(mysql_error());
$item = mysql_fetch_array($query);
echo $item['ItemTitle']; 


This will get the item title for the row with ID 3.

[Smiry Kin's]

how can i get this to work in php? o.0

[Opserty]

This might help you:

https://vborg.vbsupport.ru/showthread.php?t=154021#8