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, <!-- m --><a class="postlink" href="http://www.celebritieszones.com/file.php?dir=carmen_electra">http://www.celebritieszones.com/file.ph ... en_electra</a><!-- m -->
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.
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, <!-- m --><a class="postlink" href="http://www.celebritieszones.com/file.php?dir=carmen_electra">http://www.celebritieszones.com/file.ph ... en_electra</a><!-- m -->
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.