result in one single line

Hoangsta

my result from my sql:

Buzzabiz
7652 Casino Way
Los Angeles
California
90210
Business Phone:
Business Fax:
Web Page Link:

I want the result to be....

Buzzabiz
7652 Casino Way, Los Angeles, CA 90210
Business Phone, Business Fax. Web Page Link.

my codes:

$row = mysql_fetch_array($result);
echo "".($i+1).". ";
echo htmlspecialchars( stripslashes($row["business_name"]));
echo " ";
echo htmlspecialchars (stripslashes($row["business_address"]))

my web page link is not linking...how can I code it to have it hyperlink. my web page link is within my database.

thanks in advance

zhabala

$row = mysql_fetch_array($result); 
echo "<p><strong>".($i+1).". "; 
echo htmlspecialchars( stripslashes($row["business_name"])); 
echo "</strong><br> ";  // this <br> makes new lines, when it is kicked out, you will have it in one line, and you can replace it by a coma if you want
echo htmlspecialchars (stripslashes($row["business_address"]))

When you want to have web address as a link you have to put there propper HTML code like this:

echo "<A HREF=\"$row->web_address\">$row->web_address</A>";

Hoangsta

thanks for helping me with my line problems...

but my email address link that you mention

didn't work. I had to play with the code...made it to:

echo " <A HREF=$row->webpagelink>";
echo htmlspecialchars (stripslashes($row["webpagelink"]));

I can't use the </a>...don't know why..it won't link to it.

echo "<A HREF=\"$row->web_address\">$row->web_address</A>";

is it safe not to use the </a>. ????? It's not...I tried it with an additonal line..

echo " Address: ";
echo htmlspecialchars (stripslashes($row["business_address"]));

it linked the whole thing...but if I modied that code to:

echo "</a> Address: ";
echo htmlspecialchars (stripslashes($row["business_address"]));

it works... I have to close the <A href> somehow...so I did it the line after...

If you could find another way to do it, it would be cool.... I also, I am getting my emails off of a database.

thanks for helping, ur awesome!!!!!!!

Hoangsta

zhabala, what version of php are u coding to help me with?

Hoangsta

echo htmlspecialchars (stripslashes($row["business_fax"]));
echo "<A HREF=\"webpagelink\">";
//echo " <A HREF=$row->webpagelink>";
echo htmlspecialchars (stripslashes($row["webpagelink"]));
echo "</a>";

the link is not linking to an outside source, but it's linking back to my search page....help??

zhabala

I use a 4.3.0, but I did a mistake, sorry, your code should look like:

echo htmlspecialchars (stripslashes($row["business_fax"])); 
echo "<A HREF=\"$row['webpagelink']\">"; 
echo htmlspecialchars (stripslashes($row["webpagelink"])); 
echo "</a></p>";

I forgot that you are using mysql_fetch_array, then you have to access the fields as in array $row["webpagelink"], not as I recommend as in object $row->webpagelink.

Sorry once more.

Hoangsta

I had to modified the code after doing some research.

echo "<a href=\"http://{$row['webpagelink']}\">";
echo htmlspecialchars (stripslashes($row["webpagelink"]));
echo "</a>";

it's working...yeah. it feels soooooooooooooo good!!!!!! 😃 🙂 😉 :p 🆒