[TUT] Performing a simple database select query with PHP

[Excellent2]

12-07-2008, 01:40 AM
I don't think that being a long time ago.

Well I take it you're no good with maths.

Lets make a simple add here.
7 + 5 = 12.
The month number of December = 12.

I make it that the thread you're reffering to was made 4 months and 29 days ago. In this time I've much improved at PHP and actually learnt to take on comments.



I also won't be posting in here again as I've already got 5 infractions.

If you want some "on topic" comments I'd suggest you make a much better post including how to connect to the database and using a query to get some submit or grab some information from that particular database.

[L?KE]

Will you phannies stop arguing please

Admittedly it's a simple tutorial which could be improved a lot, but what is there is helpful to anyone who needs it and was not posted in malice. Even though Lucas is my life partner, I'm gona have to say that you're wrong here babe. You won't be getting any tonight.

[Jackboy]

performing simple database select queries are so damn hard!

Im sure glad this tutorial was available.

[Calon]

performing simple database select queries are so damn hard!

Im sure glad this tutorial was available.

I'm so glad that you're here, otherwise I would have killed myself.. You are such a pro...

not

[Jackboy]

I'm so glad that you're here, otherwise I would have killed myself.. You are such a pro...

not

No im not pro. I have read this tutorial 5 times over and still don't understand how to select queries.

Heres my code

<?
include "http://google.co.uk/config.php";
$google = mysql_query("SELECT * FROM `googleusers` WHERE `level` = 'admin'");
while ($googleadmins = mysql_fetch_array($google)){
echo "<b>Username:</b> $googleadmins[username]<br>
<b>Password:</b> $googleadmins[password]<br>
<b>Email Address:</b> $googleadmins[email]<br>";

}
?>

WHY DOES IT NOT WORK!

[Blinger1]

<?
include "http://google.co.uk/config.php";
$google = mysql_query("SELECT * FROM `googleusers` WHERE `level` = 'admin'");
while ($googleadmins = mysql_fetch_array($google)){
echo "<b>Username:</b> $googleadmins[username]<br>
<b>Password:</b> $googleadmins[password]<br>
<b>Email Address:</b> $googleadmins[email]<br>";

}
?>

WHY DOES IT NOT WORK!

hmm... i wonder...:eusa_thin

[Calon]

No im not pro. I have read this tutorial 5 times over and still don't understand how to select queries.

Heres my code

<?
include "http://google.co.uk/config.php";
$google = mysql_query("SELECT * FROM `googleusers` WHERE `level` = 'admin'");
while ($googleadmins = mysql_fetch_array($google)){
echo "<b>Username:</b> $googleadmins[username]<br>
<b>Password:</b> $googleadmins[password]<br>
<b>Email Address:</b> $googleadmins[email]<br>";

}
?>

WHY DOES IT NOT WORK!

You are one terrible coder..

Short tags, including variables without 'word' . $var .'otherpart';

[Jackboy]

You are one terrible coder..

Short tags, including variables without 'word' . $var .'otherpart';

Lmao!

Yes because what i put up there is how i code normally.

Im so happy that you understand the concept of sarcasm. You are so smart!

Noob.

[Calon]

Lmao!

Yes because what i put up there is how i code normally.

Im so happy that you understand the concept of sarcasm. You are so smart!

Noob.

Shall I define "noob" for you, because clearly you don't understand the definition?

Thanks for the private message, I think I shall report it.

[Jackboy]

Shall I define "noob" for you, because clearly you don't understand the definition?

Thanks for the private message, I think I shall report it.

Go for it? I'm honestly not fussed.

Anyway i will stop arguing with you now as it'll annoy a loads of the members.

Talk tomoz, Cya