Search results

In my PHP code I return the date a user received a private message on their account. The date doesn't look visually appealing and I hear there are different ways to output the date. Here is the line of code that needs changing: echo "Received on:" . $rowA['Date'] . "<br /><br />"; I would...

When a user loads a page, I would like a simple database update to occur, but am unsure how. Can you help me. I need this to happen: I want to UPDATE the MAIL table, and change the STATUS to NULL WHERE ID = 7.

I am telling the user how many messages in their inbox are new, but don't know how to count the table rows and output the results. The details needed are shown below. user id = $user and Status = 1 user id defines which user to look up, and the 1 indicates the message is new. Both values must...

I am telling the user how many messages in their inbox are new, but don't know how to count the table rows and output the results. The details needed are shown below. user id = $user and Status = 1 user id defines which user to look up, and the 1 indicates the message is new. Both values must...

I have this statement to pull back all information from my database. Select * from news; Within those results I want to say how many comments are held on each news item, but I'm not sure how. At the moment I manage to get the total number of comments held for ALL news entries, but not for each...

I have a table named 'comments', and I would like to use PHP to return to the browser how many comments are already stored within the database. Can you help me with this? Thanks!

I have a table named 'comments', and I would like to use PHP to return to the browser how many comments are already stored within the database. Can you help me with this? Thanks!

I have a form that submits to another page as per usual. How do i read the values checked in the previous page? Here is a simplified version of my code: <form action="availability.php" method="post"> <input type="checkbox" name="sat7-9" value="sat7-9" /> <input type="checkbox" name="sun9-11"...

I have a form with drop down options. The form works fine, but you must make a selection in order to find results. How can I add an 'any' value into some of the dropdowns to search all data?

I have a site where some pages contain streaming media. My question is how do I stream media from my server folders to the browser. Someone suggested API and Flash, but I'm unsure how to go bout this. Advice?

top of coding i have this: $q = "SELECT * FROM property WHERE Prop_beds = '$Prop_beds' AND Prop_type = '$Prop_type' AND Prop_location = '$Prop_location'"; Then this part is reporting an error: while($row = mysql_fetch_array($q)) What am I doing wrong?

How do I use a drop down list to query a database table? I want users to be able to search Prop_type and have the results returned to them. Hellllppp!

My session is like this right now: if (isset($_SESSION['Seller_firstname'])) { echo ", {$_SESSION['Seller_firstname']}!"; } I need to change the session into a $name type variable so I can use it in other ways. Show me how?

I have a website that uploads images to a folder. Howver, I need the address of the uploaded file to be placed into a database. Can you advise me how, or point me in the right direction? Thanks!

I am making a website and it must have an availability calander on it. Availability is stored within a database and I need to know how to grey out dates that and unavailable. Can anyone point me in the right direction with this?

I am making a website and it must have an availability calander on it. Availability is stored within a database and I need to know how to grey out dates that and unavailable. Can anyone point me in the right direction with this?

I have a php calendar but i need to grey out the days a user is unavailable that are defined in a database? Anyone know how, or point me in the right direction?

I have a user login using databases and PHP. There are 3 tiers of users, each tier has different options after they login. Some have few links, and some many more. My IF statement works well for this. If user = tier 1 then give these links. else give these links. because IF statements say...

I have some code that returns information frommy database side by side like this. Name Content But i would rather it be returned underneath each other like this: Name Content At current my code is like this: $num_rows = mysql_num_rows($result); print "<table width=100% border=0>\n"...

I have some code that returns information frommy database side by side like this. Name Content But i would rather it be returned underneath each other like this: Name Content At current my code is like this: $num_rows = mysql_num_rows($result); print "<table width=100% border=0>\n"...