Thanks Bj and Sheila,

This was cut and paste from a tutor course!    Your variation produced
this:

1146: Table 'mydb.employees' doesn't exist

Which is more confusing than ever.    Since MSDos set up the database
without confirming and was offended when I tried to set it up again, I
assumed the data had also been moved into the db since dos did not say
'error'.   I also had the impression that if the PHP info list didn't
include something it meant that version could not recognise it.
Simple!   What has happened to simple?

But the set up seems also to refuse to recognise a new file until I do
a restart;   I suppose it is the limits of this computer.   Or it
could be some corruption somewhere?    Don't tell me....    it's
something else...

Joseph
Chacha Joe
For a site of laughs and a FREE ezine:
www.smilepoetryweekly.com

> It doesn't like the value of $result. Try this.
>
>
> $result = mysql_query("SELECT * FROM employees",$db);
> if (!$result) {
>
>    echo mysql_errno() . ": " . mysql_error(). "<br>\n";
>
> } else {
>
>    printf("First Name: %s<br>\n", mysql_result($result,0,"first"));
>    printf("Last Name: %s<br>\n", mysql_result($result,0,"last"));
>    printf("Address: %s<br>\n", mysql_result($result,0,"address"));
>    printf("Position: %s<br>\n", mysql_result($result,0,"position"));
>
> }
>
>
>
> It won't fix the problem but it will give you more information.
>
> Sheila
> --
> Sheila Fenelon
> http://www.shefen.com/
> CGI and Database Programming
>
>
>
> ____ . The WDVL Discussion List from WDVL.COM . ____
> To Join wdvltalk, Send An Email To:
mailto:[EMAIL PROTECTED]
>        Send Your Posts To: [EMAIL PROTECTED]
> To set a personal password send an email to [EMAIL PROTECTED]
with the words: "set WDVLTALK pw=yourpassword" in the body of the
email.
> To change subscription settings to the wdvltalk digest version:
>     http://wdvl.internet.com/WDVL/Forum/#sub
>
> ________________  http://www.wdvl.com  _______________________
>
> You are currently subscribed to wdvltalk as:
[EMAIL PROTECTED]
> To unsubscribe send a blank email to
%%email.unsub%%


____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] 
       Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set 
WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
    http://wdvl.internet.com/WDVL/Forum/#sub

________________  http://www.wdvl.com  _______________________

You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

Reply via email to