AyKay47

Are you sure that all of the conditions are being met in order for $msg to have a value?

In the SQL, use UNIX_TIMESTAMP() to convert the daytime field to a TIMESTAMP, then use the php function date to format it.

Arrays need to be declared before you can push values onto them. You define the first array $itemcode_array = array(); but not the other two.

I am not familiar with that either, but if you are simply trying to remove characters from a string, use str_replace

Use JS events to change the CSS direction: property of the <texarea>.

can you provide the relevant code please? The correct way to do this would be to modify the CSS.

Well, that's relationships between tables.. I'm talking complete different databases. you think the concept is any different? Referential Integrity has absolutely NOTHING to do with multiple databases. From IBM... Debbie As noted, you can most certainly reference tables between databases, and if the databases are to relate in any specific way, you need to. Please do not read a quick article on a certain subject and pretend that you know what you are talking about, you don't. I was responding to a suggestion of using separate databases, which in this case would not benefit you in any sort of way. To your question, encrypting data to be inserted into a db table is a waste of resources and db space. Simply prevent SQL injection in the first place using the methods that you have already been given.

Well, that's relationships between tables.. I'm talking complete different databases. you think the concept is any different?

It's called referential integrity, and it should be practiced.

that is the exact thread I was referring to. This topic should be continued there, I posted the last reply, a response is needed. And my replies are most certainly not short there. If you do not want my help, I do not have to give it.

would that be a join statement ? yes, refer to the join documentation for correct syntax

echo mysql_num_rows($result); = 0 this means that there are 0 results being returned. Something is not right in the SQL if you are expecting results.

then there aren't any rows being grabbed from your query. Have you debugged your query?

in the mysql_num_rows call, the variable should be $results, not $result. what exactly are you asking?

didn't we discuss this topic in the application design forum a few days ago? I gave a very detailed answer in that thread.

not a problem, sometimes the easiest fixes are the hardest to spot.

this is because a textarea accepts text as plain/text instead of html. There are ways to convert the text in a textarea to html, what exactly are you trying to do?

Look at this bug report https://bugs.php.net/bug.php?id=34536 It should be returning a value. As a quick fix, change the header to header("location:home.php?myusername=" . $myusername); and grab the value in home.php using $_POST['myusername'];

If this is solved, please post the solution.

well you are sending $myusername to home.php, which comes from this line in the checklogin page: $myusername=$_POST['myusername']; So it should contain the username that the user enters. Check to see if register_globals is turned on, place this code at the top of the page. <?php echo "Register Globals: " . ini_get('register_globals'); ?>

<div id="leftnav"><center> <?php echo $_GET['username']; ?> <br><br>

please don't double post, this belongs in the html section. Refer to my reply there.

post the relevant code.

this actually made me laugh. That is not how it works. Inputs are used to send form data, not divs.

you have a space in the URL instead of a question mark (?). The question mark starts the query string of the URL. Use: header("location:home.php?username=" . $myusername); NOT header("location:home.php username=" . $myusername);