Hey, you have been awesome. Thank you so much.
I must go to a late meeting … yerk.

I will analyze all the data, links, questions and suggestions you have been kind enough to share with me.

I...

It only shows one row. I wonder if it is only showing my connection to the db since I am log into the db or that only one person is on at this moment.

I read that sometimes one does not have...

I can see the qurey SHOWPROCESS LIST in MySQL. Does not seem to provide any help. What should I be looking for exactly?

Process list

Your SQL query has been executed successfully

About your...

I am sorry: What do you mean by SHOW PROCESSLIST?

I cannot any code showing persistant db connections. My php.ini is as follow:
register_globals = off
allow_url_fopen = off

expose_php = Off...

I thought php automatically closed db connections after a script was finished.

But I guess it might still be better to close the connections after they are run.

What do you think?

If yes,...

I do not have any mysql_close anywhere in my code.
Does it mean the connections are staying open eventhough they could be safely close without bothering the user?

(PS: I will gone for 10 mn)

I think I "get" what you are saying but this does not seem to be the case.

The site functions quite well but if 1 or 2 users are on, no one else can get in. The site becomes too slow and does not...

Your first comment confirms what I thought. This would mean that anyone opening a page (without doing any searches or registration) should not connect to the database.

The second comment is...

I access MySQL through my host provider GoDaddy (Was that your question?).

I will take a look at the links (Thank you).

I just a thought that possibly the functions are creating the problem not...

Hello!

Simple php

One sample extracted from one page:
<?
$sql="select * from fsbo_properties where parent_id=0 order by property_name";
$rs=mysql_query($sql);...

Good morning everyone,

Is there a way to find out how many MySQL connections are on a particular page?
I am limited to 50 db connections (MySQL+Linux shared server).

It seems that my site...

Oui monsieur. (=yes sir) but live in California.

My name is Natasha by the way.

Never realized you could introduce yourself in DaniWeb

I have been using DaniWeb for a few months and love it. Some of the help I have received truly saved my sanity. Thank you to everyone

I...

Hey I fixed the problem.

It was as simple as adding a "/" in front of my image file name in my CSS. That way it directed to secured files when https was requested.

Fo anyone interested:
...

I have rebuilt numerous navigational buttons into CSS (.button {backgroung-image ETC) to reduce the number of http requests.

It works fine (better loading time and so forth) except that the images...

Impossible to have 100 listings per page.

But not impossible to display groups of 10 pages, 10 listings per page. That will reduce the number of rows of page numbers by ten folds.

Thank you for...

echo"<tr><td align='right'>";
if ($prev_option_page) {
echo "<a...

Thank you Rhyanfor your reply. Unfortunatly I am unable to work your suggestion into my code. It seems that all it does is limit to 10 the number of listings displayed per page, not the number of...

Good day everyone from beautiful California,

I have been able to limit the number of listings showing per page ($per_page=10)
But how do I limit the number of pages so I do not have rows after...

Hey forgot to say Hello. Sorry.

I have a Back button on the page itself (IE: Click here to return to previous page).

The Back arrow on browser does not work, it refreshes the search.

I operate a real estate directory site.

Trouble of the day: Cannot get my Back URL to go back to the previous page with all the user' search criteria still there. It goes back to the page and...

This is great info. Thanks. I will be "studying" it today. I think I am on the right path.

Just want to say thank you for your time.

Natasha

Question: How to pull info from MySQL to populate title tag?

Current code:
Include/common.inc.php
<title><? echo PAGE_TITLE; ?></title>
________________________________________
Individual...

You are SOOOOOO right. It is working great in Mozilla but not in IE. THANK YOU so much for your help.
One tiny question do you think exchanging %20 with dashes help with SEO?
Have a fantastic day.

Thanks for the link. I have been looking at it and tried different things on my site. It is complicated to say the least.
I was hoping for a simple PHP code for URL decoding (%20 "or space" to a...

Question: How to replace %20 characters in URL with a dash (-) when the information is coming from a MySQL db?

Code: href='details.php?listid=$record[listingid]&title=$record[title]

It...

It is working GREAT now for the titles.

I am not sure what went wrong the first time.

Regardless ... this was the best peice of information I ever got.

THANK...

This is where I put the define function one the page

<?
include("include/common.inc.php");
define ("PAGE_TITLE", "Title for the Page");
top();
left();
middle();
bottom();
function middle(){

Your idea seemed perfect so I tried it right away. Unfortunatly I get this error. Any suggestion?

Question: Where exactly do you place the "define" function on each page? Perhaps that is my...

Need instruction. Please.
Situation: Most of my site pages start with the following:

<?
include("include/common.inc.php");
top();
left();
middle();
bottom();
function middle(){

Thank you very much. you are great.

Yes, MySQL. I looked for js.js. in db, not there.

I did remove js.js from the website pages a while back. I checked again, it has not come back.

Something is making my database inconsistent...

Hi Omol,

Since you asked ... I have been looking into my db (not very good at it though) ... what exactly am I looking for? In the web pages, it was easy to find the intrusive url and delete. What...

I am looking into it right now. I thought my problem was over with. This is scary. I have had inconsistent behavior from MySQL and your input might help me pint point the issue. Thank you.

(<script src=http://www.uhwc.ru/js.js></script>)

Hi,
I have had the same problem and was even tagged by Google.

The only way to do it is open your entire web site (I mean all of the files) in...