New question about PHP (Topic)

Staredit Network > Forums > Technology & Computers > Topic: New question about PHP

New question about PHP

Jan 12 2009, 2:02 pm
By:

Devourer

Pages: 1

Jan 12 2009, 2:02 pm

Devourer Post #1

Hello

I'm currently working on a "profile-script". It displays the information staying in the mysql database table 'users'.
One of my friends and I worked on it but we still don't get it. It always says that the mysql_fetch_array supplys an invalid argument.

here is the code:
<?php

$user = $_GET['user'];

$con = mysql_connect("localhost","name","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("my_db", $con);

$sql = "SELECT `username`,`geld`,`avatar`,`joined`,`posts`,`topics`,`shouts` FROM users WHERE `username`='" . $user . "'";
$result = mysql_query($sql,$con);

if(mysql_num_rows($result)==1){

while($row = mysql_fetch_array($result)){
echo "<table border=1>";
echo "<tr><td bgcolor=black><center> Username: </center></td>";
echo "<td bgcolor=black><center>" . $row['username'] . "</center></td>";

echo "<tr><td bgcolor=black><center> Geld: </center></td>";
echo "<td bgcolor=black><center>" . $row['geld'] . "</center></td>";

echo "<tr><td bgcolor=black><center> Avatar: </center></td>";
echo "<td bgcolor=black><center>" . $row['avatar'] . "</center></td>";

echo "<tr><td bgcolor=black><center> Joined: </center></td>";
echo "<td bgcolor=black><center>" . $row['joined'] . "</center></td>";

echo "<tr><td bgcolor=black><center> Posts: </center></td>";
echo "<td bgcolor=black><center>" . $row['posts'] . "</center></td>";

echo "<tr><td bgcolor=black><center> Topics: </center></td>";
echo "<td bgcolor=black><center>" . $row['topics'] . "</center></td>";

echo "<tr><td bgcolor=black><center> Shouts: </center></td>";
echo "<td bgcolor=black><center>" . $row['shouts'] . "</center></td>";
echo "</table>";
echo "<table border=1><tr height=30%><colgroup width=500></colgroup>";
echo "<td bgcolor=black <center>";
}
}
else{
if(mysql_num_rows($result)==0)
{echo "no user found in database"; }
else{
echo "more than one user found in database";
}
}

?>

We get the $_get['user'] from the "memberlist" however, the memberlist.php is right programmed, we are pretty sure.
Help please.

Please report errors in the Staredit.Network forum.

Jan 12 2009, 2:18 pm

Forsaken Archer Post #2

Try mysql_fetch_assoc() instead.

None.

Jan 13 2009, 1:59 am slayer766 Post #3

It's not best to use the <center> tag in HTML, as it's deprecated. I don't know if that's all the code you are using but you also have an open td and center tag at the end. But try this out:

Code

<?php
$user = $_GET['user'];
$con = mysql_connect("localhost","name","password");

if (!$con){
die('Could not connect: ' . mysql_error());
}

mysql_select_db("my_db");
$result = mysql_query("SELECT `username`,`geld`,`avatar`,`joined`,`posts`,`topics`,`shouts` FROM users WHERE `username`='" . $user . "'");

if(mysql_num_rows($result) == 0){
echo "no user found in database";
}
else if(mysql_num_rows($result) == 1){
while($row = mysql_fetch_array($result)){
echo "<table border=1>";
echo "<tr><td bgcolor=black><center> Username: </center></td>";
echo "<td bgcolor=black><center>" . $row['username'] . "</center></td>";

echo "<tr><td bgcolor=black><center> Geld: </center></td>";
echo "<td bgcolor=black><center>" . $row['geld'] . "</center></td>";

echo "<tr><td bgcolor=black><center> Avatar: </center></td>";
echo "<td bgcolor=black><center>" . $row['avatar'] . "</center></td>";

echo "<tr><td bgcolor=black><center> Joined: </center></td>";
echo "<td bgcolor=black><center>" . $row['joined'] . "</center></td>";

echo "<tr><td bgcolor=black><center> Posts: </center></td>";
echo "<td bgcolor=black><center>" . $row['posts'] . "</center></td>";

echo "<tr><td bgcolor=black><center> Topics: </center></td>";
echo "<td bgcolor=black><center>" . $row['topics'] . "</center></td>";

echo "<tr><td bgcolor=black><center> Shouts: </center></td>";
echo "<td bgcolor=black><center>" . $row['shouts'] . "</center></td>";
echo "</table>";
echo "<table border=1><tr height=30%><colgroup width=500></colgroup>";
echo "<td bgcolor=black> <center>";
}
}
else{
echo "more than one user found in database";
}
?>

None.

Jan 13 2009, 2:35 pm

Devourer Post #4

Hello

Both didn't worked.

Please report errors in the Staredit.Network forum.

Jan 13 2009, 7:43 pm slayer766 Post #5

Hmm...you are inputting your name,pass, and database correct?

Add this at the end of your mysql_query, but before the semicolon:

Code

or trigger_error("Error querying database. Please contact administrator.")

If you get that error, then there is a problem with your query, which you might want to change to this:

Code

mysql_query("SELECT * FROM users WHERE `username`='" . $user . "'")

None.

Jan 13 2009, 11:36 pm

Forsaken Archer Post #6

Yeah, I was going to suggest that in your last topic: put error catching on all your sql queries.

None.

Options

Pages: 1

Back to forum
Please log in to reply to this topic or to report it.
Members in this topic: None.

Global Shoutbox

[01:36 am]

Moose -- Thinking on it more, I vaguely remember it being annoying because it kept repeating some short loop of the Super Mario World theme LMAO

[12:57 am]

Oh_Man -- I thought i remembered an old mario map but i searched super mario starcraft on utube and i couldnt see anything cept UMS

[11:40 pm]

lil-Inferno -- Blizzard forgot about SC so it's okay

[07:04 pm]

Symmetry -- malware maps for everyone

[07:03 pm]

Moose -- probs lmao

[06:57 pm]

Symmetry -- (and will be patched)

[06:56 pm]

Symmetry -- The old stuff would've gotten patched no? this is current

[06:55 pm]

Moose -- Just made? I thought we had that years ago

[2026-8-09. : 5:23 pm]

Oh_Man -- so someone just made super mario in brood war https://www.youtube.com/watch?v=DmrUcKU65oQ

[2026-8-06. : 2:41 am]

Oh_Man -- i used to play TF2 competitive in that clan, and also was PR manager (ie: i wrote all the website posts)

Please log in to shout.

Members Online: lifebot,

NudeRaider