Need help fixing this code

bchandel · August 15, 2009

I have this code to display data from the database to display web site URL.

This works good for field which have website address in database fields. The one which doesn't have web site address it pulls open website address from the browser.

Is it is possible to print - in the fields where no website address is in the database field. Thank you!

trq · August 15, 2009

<?php if ($Web != ''): ?>
  <a href="<?php echo $Web; ?>">Web Site</a></font></td>
<?php else: ?>
  <a href="#">Web Site</a></font></td>
<?php endif ?>

bchandel · August 15, 2009

Thank you for help. Here is the complete code. Please check this and modify for Web Site and E-mail fields. What I want is only to pull data if available in database or just to leave blank or print "-" where data is not available. Your help is appreciated.

<html>

<body>

<?php

<h1><left>Search Results:</left></h1>

<tr>

<th>First Name</th>

<th>Phone</th>

<th>Mobile</th>

<th>State</th>

<th>Country</th>

<th>Profile</th>

</tr>

<?php

$i=0;

while ($i < $num) {

$Name=mysql_result($result,$i,"Name");

$LastName=mysql_result($result,$i,"LastName");

$FirstName=mysql_result($result,$i,"FirstName");

$Phone=mysql_result($result,$i,"Phone");

$Mobile=mysql_result($result,$i,"Mobile");

$Email=mysql_result($result,$i,"Email");

$Web=mysql_result($result,$i,"Web");

$State=mysql_result($result,$i,"State");

$Country=mysql_result($result,$i,"Country");

$Profile=mysql_result($result,$i,"Profile");

?>

<tr>

<a href="<? echo "$Profile"; ?>" ?>">Profile</a></td>

</tr>

<?php

$i++;

}

?>

</body>

</html>

<?php if ($Web != ''): ?>
  <a href="<?php echo $Web; ?>">Web Site</a></font></td>
<?php else: ?>
  <a href="#">Web Site</a></font></td>
<?php endif ?>

MasterACE14 · August 15, 2009

where you have...

<a href="<? echo "$Web"; ?>" ?>">Web Site</a>

just replace it with thorpe's code.

Same goes for e-mail, just replace $Web with $Email

bchandel · August 15, 2009

Thank you for your message. I changed the code as followed. It still not working. I have some basic knowledge of PHP. I would appreciaye if you can correct if you can correct this line of code.

Secondly, I have for table I have these settings:

The cells without data looks very different. Any way to fix these.

Thank you again!

<?php else: ?> <a href="#">Web Site</a></td> <?php endif ?></td>

where you have...
<a href="<? echo "$Web"; ?>" ?>">Web Site</a>
just replace it with thorpe's code.

Same goes for e-mail, just replace $Web with $Email

bchandel · August 16, 2009

Is it possible to fix this code so it can work.

Thank you!

PHP Freaks Forums

August 16, 2009, 12:16:08 AM Hello bchandel

Show unread posts since last visit.

Show new replies to your posts.

Total time logged in: 48 minutes.

News:We are constantly trying to improve PHP Freaks and these forums, so feel free to go to the PHPFreaks Comments/Suggestions board and point out anything you'd like to see different!

Home

Help

Search

Profile

My Messages

Calendar

Members

My Bookmarks

Rules & ToS

Logout

PHP Freaks Forums

Profile Info

Summary

Show Stats

Show Posts

Messages

Topics

Attachments

Modify Profile

Account Settings

Forum Profile

Look and Layout

Authentication

Notifications

Personal Messaging

Edit Buddies

Group Membership

Actions

Paid Subscriptions

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages Topics Attachments

Messages - bchandel

Pages: [1]

1 PHP Coding / PHP Coding Help / Re: Need help fixing this code on: Yesterday at 01:28:11 AM

Thank you for your message. I changed the code as followed. It still not working. I have some basic knowledge of PHP. I would appreciaye if you can correct if you can correct this line of code.

Secondly, I have for table I have these settings:

The cells without data looks very different. Any way to fix these.

Thank you again!

<?php else: ?> <a href="#">Web Site</a></td> <?php endif ?></td>

Quote from: MasterACE14 on Yesterday at 01:10:39 AM

where you have...

just replace it with thorpe's code.

Same goes for e-mail, just replace $Web with $Email

Reply Quote Notify

2 PHP Coding / PHP Coding Help / Re: Need help fixing this code on: Yesterday at 01:08:01 AM

Thank you for help. Here is the complete code. Please check this and modify for Web Site and E-mail fields. What I want is only to pull data if available in database or just to leave blank or print "-" where data is not available. Your help is appreciated.

<html>

<body>

<?php

<h1><left>Search Results:</left></h1>

<tr>

<th>First Name</th>

<th>Phone</th>

<th>Mobile</th>

<th>State</th>

<th>Country</th>

<th>Profile</th>

</tr>

<?php

$i=0;

while ($i < $num) {

$Name=mysql_result($result,$i,"Name");

$LastName=mysql_result($result,$i,"LastName");

$FirstName=mysql_result($result,$i,"FirstName");

$Phone=mysql_result($result,$i,"Phone");

$Mobile=mysql_result($result,$i,"Mobile");

$Email=mysql_result($result,$i,"Email");

$Web=mysql_result($result,$i,"Web");

$State=mysql_result($result,$i,"State");

$Country=mysql_result($result,$i,"Country");

$Profile=mysql_result($result,$i,"Profile");

?>

<tr>

<a href="<? echo "$Profile"; ?>" ?>">Profile</a></td>

</tr>

<?php

$i++;

}

?>

</body>

</html>

Sign In

Need help fixing this code

Recommended Posts

bchandel

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

bchandel

Link to comment

Share on other sites

MasterACE14

Link to comment

Share on other sites

bchandel

Link to comment

Share on other sites

bchandel

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information