Quick PHP/MySql Help ;-)

J__sh

Ok I got a databased named 'test_DB' and a table inside of that named 'Table1'. Inside of 'Table1' I have 2 feilds 'ID,Entry'.

Now on my php page How would I call a selected entry from its ID number, and display it? :S

Thanks for your future help! ;-)

Thanks, JØsh

drew010

mysql_select_db("test_DB");
$query = "SELECT ID, Entry FROM Table1 WHERE ID = 'x'";
$result = mysql_query($query);
$data = mysql_fetch_array($result);

echo "Id is $data['ID']<br>";
echo "Entry is $data['Entry']";

J__sh

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/virtual/site50/fst/var/www/html/warez/balls.php on line 9

J__sh

n/m i see what I did.

J__sh

Err. Its only displaying the ID not both the ID and Entry.

drew010

Is the name of the field actuall Entry with a capital 'e' or is it 'entry'. Case will matter. Otherwise, I'm not sure why no entry is being displayed

J__sh

well if i leave the bottom like this

echo "Id is $data['ID']<br>";
echo "Entry is $data['Entry']";

It gives me an error

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/virtual/site50/fst/var/www/html/warez/balls.php on line 8

So i changed the bottom to something and it displayed what ID it was but no entry. I think i changed it to like

echo "Id is ['$ID']<br>";
echo "Entry is ['$Entry']";

Well more help would be enjoyed ;-)