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&q=mysql+select+sql&btnG=Google+Search&meta=

[nico_swd]

EDIT: Too late.


$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