Cutting off URL

[JackieB]

I am using a php links program. I have added an affiliate url as a new link. It has a long URL.

The link is coming up bad because its being cut off.

Would this be a setting in myphpadmin (there is an option in the called "fulltext"), a general php limitation or a setting on one of the supplied php files?

Thanks,
Jackie

[jatar_k]

how long is the url? (characters)
is it stored int the db?
How big is the corresponding column in the db?

[JackieB]

The url is 60 characters. All characters show when I input. When it links out it is only 50 characters.

Jackie

[JackieB]

When I went back in to check, the url is only saving as 50 characters.

I have already edited the submit url text fields to 80 characters.

But something is making it cut off at 50.

Thanks,
Jackie

[henry0]

<edit> Was I sleeping!, so much happened while I was thinking about it</edit>

Welcome to WebmasterWorld
PHPmyAdmin is a great tool that only helps you setting a new MySQL Database or managing an existing one
But data accessible from PHPmyAdmin are only data originated from PHP scripts “speaking” to your MySQL database
DO NOT EDIT ANYTHING from there unless you know what you are doing.And there are almost no chances that your problem can be addressed via PHPmyAdmin
You are presumably describing an URL dynamically generated by PHP
That has a bunch of numbers and equal signs and question marks – Correct?

There are a few ways to palliate to your problem however we need to look at that URL (Please when pasting it replace information such as your real site name by mysite or anything in that range)

Then a few things can be done that will require for you to have some sort of server access to possibly upload a “ .htaccess “ file that will rewrite the URL and deliver what’s called a clean URL

If you delve into the forum and search for mode_rewrite or htaccess you will find enough resources to get a good idea on what is happening
Cheers

Henry

[JackieB]

"There are a few ways to palliate to your problem however we need to look at that URL (Please when pasting it replace information such as your real site name by mysite or anything in that range."

I think this is how you're requesting it.

<a href="www.example.net/link">www.mysite.net/links</a>

On the main page, scroll down -the bad url is "Shop by Occasion".

Jackie

[edited by: jatar_k at 4:11 am (utc) on April 5, 2005]
[edit reason] generalized url [/edit]

[henry0]

As I mentioned it is not the safest way to deal with your problem
But you can verify what is the type of field used for that UrL
And what is the length allowed
Go to your PHPmyAdmin and open it, verify that you are in “structure mode”
Add a check in front of the URL field and click “edit” you should see a value in your case probably 50 and it reads Varchar
If so bring the value to 100 clik save,
refresh your web page and check the results
Varchar goes up to 256 if needed

[JackieB]

Henry!
Thank you! It worked.

Jackie

[henry0]

Glad it works!
so disregard my answer to your PM
I looked at it before going to the forum
Cheers
Henry