Viewing Thread:
"Getting Info From a Database (PHP, MySQL) Hell :D"

Lo. Again. :D

My problem this time is : I have a table with 3 rows. I need to display all the information from these rows in various places on the page. I had one query :

SELECT * FROM portal WHERE gameID='1'

But now I need info from the other 2 rows, ie,

SELECT * FROM portal WHERE gameID='2' etc

However, obviously, the second query wipes out the variables (the column names) and puts in it's own data, as does the 3rd. I tried after each query doing :

$columnname=$columnname2;

But that didn't work.

So, how can I successfully display all the info?

Oh, and I extract the data from the rows after querying the database using only SELECT *.

Alas, it works! AT LAST!

*quietly weeps happy tears*

More help required, me rather silly.

*slams head with club*

Have a browse of this ::


session_start();
session_register('userentry', 'password','status');
?>







echo "

";
?>






What it should do is :

| 1 | Open a new session
| 2 | Set up session variables
| 3 | Show a form with 2 fields, userentry and password (matching session variables)
| 4 | Pass the contents of these 2 fields on when Submit is clicked to another page.

The page processes these and does some password comparison to verify the log in and if it was a success or not.

However, the form doesn't send any information across. If I set the variables myself, like

$userentry="Phuzzy" etc

It gives the correct results. So it's the form and the variables.

Please help me with a solution!

Aoe wrote:
> The amount of sense them few posts made to someone not knowing
> anything about php is actually funny.

I haven't got a clue and I spent about 2 hours today making a little MySQL submit/editing thingy which uses all that!

If you think that's difficult you should see some of the P5 I found today.

http://www.sine-wave.net/stuff/p5.jpg

The amount of sense them few posts made to someone not knowing anything about php is actually funny.

Me being dumb, sorted.

Thanks Turbo.

After numbering the 3 queries, what would you type different in the variable names to differentiate between the results from the 3 queries?

Just use $query = mysql_query(" [ your first select ] "); $query2 = mysql_query(" [ your second select ] "); etc...

Lo. Again. :D

My problem this time is : I have a table with 3 rows. I need to display all the information from these rows in various places on the page. I had one query :

SELECT * FROM portal WHERE gameID='1'

But now I need info from the other 2 rows, ie,

SELECT * FROM portal WHERE gameID='2' etc

However, obviously, the second query wipes out the variables (the column names) and puts in it's own data, as does the 3rd. I tried after each query doing :

$columnname=$columnname2;

But that didn't work.

So, how can I successfully display all the info?

Oh, and I extract the data from the rows after querying the database using only SELECT *.