i get this message when i am trying to load some data from mysql.
Warning: Unable to jump to row 0 on MySQL result index 2 in
/home/sites/site3/web/showthumb on line 71
--here is my code
$connetion = mysql_connect("localhost","cel34243","s2343223");
$query = "select images from celeb where name=\"$dir.\" ";
$result = mysql_db_query("celebzone", $query);
$imagesnum= mysql_result($result, "images");
can you please tell me why?
i think it's the problem with my codes.
------------------my mysql table-------
+-----------------------+------------+--------+--------+------+--------+
| name | DOB | weight | height | vote | images |
+-----------------------+------------+--------+--------+------+--------+
| alicia_silverstone | 1976-10-04 | 0 | 5'9" | 0 | 59 |
| alyssa_milano | 1972-12-19 | 0 | 5'2" | 0 | 57 |
| anna_kournikova | 1981-07-07 | 112 | 5'6" | 0 | 80 |
| britney_spears | 1981-12-02 | 127 | 5'4" | 0 | 127 |
| cameron_diaz | 1972-08-30 | 120 | 5'9" | 0 | 39 |
| christina_aguilera | 1980-12-18 | 102 | 5'2" | 0 | 92 |
| drew_barrymore | 1975-02-22 | 120 | 5'4" | 0 | 44 |
| jennifer_aniston | 1969-02-11 | 0 | 5'5" | 0 | 37 |
| jennifer_lopez | 1970-07-24 | 0 | 5'5" | 0 | 53 |
| jennifer_love_hewitt | 1979-02-21 | 0 | 5'2" | 0 | 39 |
| jessica_simpson | 1980-07-10 | 0 | 5'3" | 0 | 21 |
| julia_roberts | 1967-10-28 | 0 | 5'7" | 0 | 40 |
| sarah_michelle_gellar | 1977-04-14 | 0 | 5'3" | 0 | 38 |
| mandy_moore | 1984-04-10 | 0 | 5'9" | 0 | 97 |
| cindy_crawford | 1966-02-20 | 0 | 5'9" | 0 | 32 |
| carmen_electra | 1972-04-20 | 110 | 5'4" | 0 | 80 |
+-----------------------+------------+--------+--------+------+--------+
$dir is the name
say, http://www.celebritieszones.com/file.php?dir=carmen_electra
then, it should query the databse and get the image number from it. IN this case, it should show 80.
Can you please write me the code? Mine didn't work.
