[Variable not affected outside if statement]

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

[Turning date fields into actual dates]

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

[Array/Session problem]

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.

[text with at signs (@)before and after]

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

[change direction inside a text area]

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

[help: get rid of global class]

can you provide the relevant code please?

The correct way to do this would be to modify the CSS.

[Creating Secure PM's??]

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

 

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...

Referential integrity is the relational property that each foreign key value in a table exists as a primary key in the referenced table.

 

 

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.

[Creating Secure PM's??]

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

 

Well, that's relationships between tables.. I'm talking complete different databases.

 

you think the concept is any different?

[Creating Secure PM's??]

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

[Setting up tables for PM System]

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.

[difficluty with a if statement]

would that be a join statement ?

 

yes, refer to the join documentation for correct syntax

[difficluty with a if statement]

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.

[difficluty with a if statement]

then there aren't any rows being grabbed from your query.

Have you debugged your query?

[difficluty with a if statement]

in the mysql_num_rows call, the variable should be $results, not $result.

what exactly are you asking?

[Setting up tables for PM System]

didn't we discuss this topic in the application design forum a few days ago?

I gave a very detailed answer in that thread.

[help]

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

[send data in a form using div !]

textarea can send data also ..

 

anyway im having the problem of making changes inside textarea .. i couldnt do that cuz textarea considers everything a test

 

so if i write something like this

 

<textarea><b>test</b></texterea>

 

it wont work , it will display <b>test</b>

 

soo i need something like textarea that let html tags work !

 

any advice ?

 

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?

[Help please!!]

It just returns at the top of the page

 

Register Globals:

 

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'];

[Not inserting]

If this is solved, please post the solution.

[Help please!!]

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'); ?>

[Help please!!]

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

[send data in a form using div !]

please don't double post, this belongs in the html section.

Refer to my reply there.

[Help please!!]

post the relevant code.

[send data in a form using div !]

this actually made me laugh.

That is not how it works.

Inputs are used to send form data, not divs.

[Help please!!]

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);