Database tutorials

[bazt]

Hi folks

I have been working my way thru the tutorials and am having

some problems.

Authors/Managing Authors works fine but when it has some

"authors" in it all I get is the bulit piont and the option

to edit or delete.

Any suggestions??

Thanks in advance

bazt

[Son Nguyen]

Which tutorial you are talking about?
I don't quite understand what problem you having. So please clarify, maybe I could help

[bazt]

Hi there
I'm working my way thru the PHP/mysql database tutorial on

the jokes database by Kevin Yank

There is a PHP file for doing admin on the joke authors

table ie:- add delete edit their details. although it works

fine (I can add/edit/delete info) it shows up a list of

authors in the table but without a name against the entry?

hope this is more helpfull

bazt

[bazt]

further to my last bit I had to move machine here is the code that is giving me a problem

$advertisers = mysql_query("SELECT ID, AdvertiserName FROM Advertisers");
if (!$advertisers) {
echo("<P>Error retrieving advertisers from database!<BR>".
"Error: " . mysql_error());
exit();
}

while ($advertiser = mysql_fetch_array($advertisers)) {
$id = $advertiser["ID"];
$name = $advertiser["AdvertiserName"];
echo("<LI>$name ".
"[<A HREF='editadvertisers.php?id=$id'>Edit</A>|".
"<A HREF='deleteadvertisers.php?id=$id'>Delete</A>]");
}


when this is echoed <li> gives a bullit point $name gives nothing editadvertisers & deleteadvertisers work fine

I know I have missed something I just can't see it


Thanks folks

bazt

[edshuck]

hi

i have duplicated the problem.

this is code i am using on my site.

$shops = mysql_query("SELECT shop_id, name FROM shop");
if (!$shops) {
echo("<P>Error retrieving shops from database!<BR>".
"Error: " . mysql_error());
exit();
}

while ($shop = mysql_fetch_array($shops)) {
$shop_id = $shop["shop_id"];
$name = $shop["name"];
echo("<LI>$name ".
"[<A HREF='editshop.php?shop_id=$shop_id'>Edit</A>|".
"<A HREF='deleteshop.php3?shop_id=$shop_id'>Delete</A>]");
}

i remembered having the same problem you described while turning up my site.

By changing to the following line:

while ($Shop = mysql_fetch_array($shops)) {

i get the same result. Just $Shop instead of $shop.

But i think for you is should be $Advertisers instead of $advertiser

But for sure, this is the area to work in.

[Kevin Yank]

bazt,

The problem you're having is symptomatic of a misspelled variable name, but as far as I can tell at this late hour, your code is flawless!

Did you copy/paste your code into your message directly?

[bazt]

Hi Folks

edshuck I will give that a go and let you know how I get on
kyank The code was cut&pasted from the page

Ta Folks

bazt

[bazt]

Back again folks

I changed the variable names from advertiser to Advertiser and this made no real change

However as I was working thru some of the other pages I discovered that the "name" field of the database which should appear elswhere dosen't if I go in and edit the advertiser the name then becomes visible in the aformentioned page and it seemed (at 1am) not to matter weither Ad or ad was the variable name ??? Hey sure I'm learning.( so an auld dog can be taught new tricks after all).

I'll keep at it untill it works

Barry

[edshuck]

Hi

cut and paste this code and it should work. the one change i made is the spelling of Advertisers in the start of the while statement. This makes it match the spelling of the table name.

$advertisers = mysql_query("SELECT ID, AdvertiserName FROM Advertisers");
if (!$advertisers) {
echo("<P>Error retrieving advertisers from database!<BR>".
"Error: " . mysql_error());
exit();
}

while ($Advertisers = mysql_fetch_array($advertisers)) {
$id = $advertiser["ID"];
$name = $advertiser["AdvertiserName"];
echo("<LI>$name ".
"[<A HREF='editadvertisers.php?id=$id'>Edit</A>|".
"<A HREF='deleteadvertisers.php?id=$id'>Delete</A>]");
}

[Edited by edshuck on 10-23-2000 at 10:11 AM]

[freddydoesphp]

Sorry Ed I doubt that will work you have
while ($Advertisers = mysql_fetch_array($advertisers)) {
$id = $advertiser["ID"];
$name = $advertiser["AdvertiserName"];
echo("<LI>$name ".
"[<A HREF='editadvertisers.php?id=$id'>Edit</A>|".
"<A HREF='deleteadvertisers.php?id=$id'>Delete</A>]");
}

And then you try and call $id = $advertiser["ID"]
What you should beusing is
while ($advertiser = mysql_fetch_array($advertisers)) {
$id = $advertiser["ID"];
$name = $advertiser["AdvertiserName"];
echo("<LI>$name ".
"[<A HREF='editadvertisers.php?id=$id'>Edit</A>|".
"<A HREF='deleteadvertisers.php?id=$id'>Delete</A>]");
}