No Data

dcjones

Hi All

I have 2 scripts,

the first has the following:

?>
<td align="left" width="766"><font color="black\" face="arial\"size="2"> <a href=\"embassies/emb.php?idname=<? echo urlencode($row["country"]).">".$row["country"] ?></a>
</td>
<?

This script calls the second when a user clicks on the country.

In the second I have:

$connection = mysql_connect($server, $user, $password);
mysql_select_db("db66511019", $connection);
$result = mysql_query("SELECT * FROM embassies WHERE country = '$idname'" , $connection);

while ($row = mysql_fetch_array($result))

The second script shows the page with no errors but does not show and data.

The database has data in it, the field country is there and all is spelt correctly.

Any ideas as to why there is no data shown.

Kind regards and thanks in advance

DCJ

BuzzLY

echo $idname to see if you are getting a value. Perhaps you have register_globals turned off?

dcjones

Yes if I echo $idname in the second script it show the correct data

Very stange

Dereck

BuzzLY

To further debug, echo your $result to see exactly what the MySQL query is. Then, copy it, paste it into MySQL and run it to see what it returns.

dcjones

When I echo $result in the second script I get the following:

Resource id #2

Embassy Name

Address

Telephone No

Fax No

E-mail

Website

The last six line are feild names which I would expect to see.
The first line is the echo $result.

Any ideas what the echo is tells me.

Regards

Dereck

BuzzLY

I'm sorry... what I meant was to take your SQL statement and run it on your MySQL server to see if it's returning any data. It's possible that your query isn't correct... If you are returning no data, then maybe the query is not correct.

dcjones

I have run the following on the server

SELECT * FROM embassies WHERE country = "india"

I used "india" because that record is in the database, it return the correct record. I can use a number of conditions and they all return the correct record.

This one is a puzzel,

I submitted the full scripts in a post last night with a title

SCRIPT ERROR if you have time to look at them

Many thanks in advance

Dereck

BuzzLY

You are right, this is a puzzle. I would suggest that instead of using $idname, you hard-code the SQL query in your code to see if it returns the data correctly. Specifically, change the $result line to read:

$result = mysql_query("SELECT * FROM embassies WHERE country = 'india'" , $connection);

Also, shouldn't "india" be capitalized?

rinjani

if you echo $result you'll just get resource id since it's an array.

echo out $result[0], $result[1] ... etc

Yoou can also try mysql_fetch_row

AND

make sure that you get something back by:

$num = mysql_num_rows($result);

echo $num;

to see that you did get the expected number of rows returned

HTH

dcjones

Hi again,

I have now adjusted the script to include another feild
i.e. country.

The second script now shows the country data but all other feilds are empty.

Have a look. goto http://www.travellingtoengland.co.uk/Embassies/embassies.php

and see what happens

Regards

Dereck