im using mySQL

[djsimple007]

so any field that isnt used show as NULL when I look at the actual db, But I think my question is very simple. I dont know how to script the statements to run this loop. If you look at the previous example you can see what I mean. Unfortunately My PHP class doenstn start until next term. So .... any help with the actual code would be great!

[djsimple007]

I cant get this to work=
Ive gotten to the point where it shows a link no matter what, even if there is no data, but Id like to put in an if else loop so if theres no data it just echoes 'NONE'
This is my knarly code that wont work======

if ($row_Recordset1['emailwork2']; != "")

{ <a href="mailto:<?php if

($row_Recordset1['emailwork2']; != "") echo $value; ?>">None</a>
} else ($row_Recordset1['emailwork2']; != "['emailwork2']") {
<a href="mailto:<?php echo $row_Recordset1['emailwork2']; ?>">E-Mail

Work 2</a>
}

[cheese]

Hi DJ,

OK, here comes the silly question...... why have you got ($row_Recordset1['emailwork2']; != "") in all of the parts of your code

I haven't tried it but how about;

<?php
if ($row_Recordset1['emailwork2']; != "") 
{ 
print "<p><a href='mailto:" . $row_Recordset1['emailwork2'] . ">E-Mail Work 2</a></p>"; 
}
else
{
print "<p> none </p>";
} 
?>

Does that help.

Cheers,

Neil.

[djsimple007]

It didnt work. It threw an error. Man I cant wait til I can tak my class!

Any other ideas?!

Bo

[cheese]

OK Bo,

You will need to mod this for your database, but here goes.....

<?php
$sql_server = "localhost";
$sql_username = "yourusername";
$sql_password = "yourpassword";
$sql_database = "yourdatabase";
global $sql_server;
global $sql_username;
global $sql_password;
global $sql_database;
$link = mysql_connect($sql_server, $sql_username, $sql_password)
        or die("Could not connect : " . mysql_error());
    mysql_select_db($sql_database) or die("Could not select database");

$query = mysql_query("SELECT emailwork2 FROM YourTable");

while ($row = mysql_fetch_array($query, MYSQL_NUM))
{

if ($row[0] != "")  

{  

print "<p><a href='mailto:" . $row[0] . ">E-Mail Work 2</a></p>";  

} 
else 
{ 
print "<p> none </p>"; 
}  

}
?>

This should do the job...... if there is a problem please post the errors.

Cheers,

Neil.