Problem with using DB array and For array at the same time!

evo4ever

Hey guys. Im here posting my problem trying to get DB entries into a for array! It just wont work!

my code:

<?php
	if($a_row = mysql_fetch_array($query0)){

$profile = array("Username: $username", 
			     "E-Mail address:" . $a_row["email"] . "", 
				 "First Name:" . $a_row["firstName"] . "", 
				 "Last Name:" . $a_row["lastName"] . "", 
				 "Profile:" . $a_row["aboutme"] . "");

for($i=0;$i<sizeof($profile);$i++){
		echo "$i. $profile[$i]<br>";
}
} else {
echo "array failed!";
}	
?>

Any suggestions? Thx.

cgraz

What's not working? The following worked for me on my database

<?php

include("config.php");

dbConnect();

$query0 = mysql_query("SELECT * FROM $table5");


if($a_row=mysql_fetch_array($query0)) {

$profile = array("Username: " . $a_row["id"], 
                 "E-Mail address: " . $a_row["email"], 
                 "First Name: " . $a_row["fname"], 
                 "Last Name: " . $a_row["lname"], 
                 "ID: " . $a_row["id"]);

for($i=0; $i < sizeof($profile); $i++){
        echo "$i. $profile[$i]<br>";
}

} else {

echo "array failed!";
}    

?>

Is it not printing the values, or not printing anything at all? If it's not printing the values, use

$query = mysql_query("SELECT * FROM your_table") or die(mysql_error());

mysql_error() will let you know if the query fails.

Cgraz

evo4ever

It echoes back the else statement "Array Failed". And theres nothing wrong with the query! I use it on different parts of the page aswel!

cgraz

What if you take out the if altogether

<?php

$a_row = mysql_fetch_array($query0);

$profile = array("Username: $username", 
                 "E-Mail address: " . $a_row["email"], 
                 "First Name: " . $a_row["firstName"], 
                 "Last Name: " . $a_row["lastName"], 
                 "Profile: " . $a_row["aboutme"]);

for($i=0; $i<sizeof($profile); $i++){
        echo "$i. $profile[$i]<br>";
}


?>

In your original code, I don't see why it would get to that else statement unless $query0 didn't exist. You're assining $a_row to equal mysql_fetch_array($query) You're not checking to see if they're equal, you're assigning them. Anways, try the above code and see if that works.

Cgraz

evo4ever

Ok. I tried that. It echoed back:

Username:
First Name:

etc

But not the values! It must be the query, but ive revised it! there really is nothing wrong with it!

evo4ever

Ok. This is thw WHOLE thing....

members.php:


...DB settings etc...

$query0  = mysql_query("SELECT * FROM cph_members WHERE username='$username'");
<html>

if($_GET["pid"]){
					include "include/context/" . $_GET["pid"] . ".php";
</html>

Link: members.php?pid=prof

prof.php:

<p><font size="2" face="Tahoma">Here you can view and edit your profile and other 
  info you submitted to us when you registered!</font></p>
<p><font size="2" face="Tahoma">Your details:</font></p>
<p><font size="2" face="Tahoma">
<?php
	$a_row = mysql_fetch_array($query0);

$profile = array("Username: $username.", 
			     "E-Mail address: " . $a_row["email"] . ".", 
				 "First Name: " . $a_row["firstName"] . ".", 
				 "Last Name: " . $a_row["lastName"] . ".", 
				 "Profile: " . $a_row["aboutme"] . ".");

for($i=0;$i<sizeof($profile);$i++){
		echo "$i. $profile[$i]<br>";
	}
?>
</font></p>

That more helpful?

cgraz

Ok. I tried that. It echoed back:

Username:
First Name:

$username isn't getting pulled out of your table, it's supposedly defined somewhere on the page. It has no value, and if it has no value, your whole select is no good because your query is based on the value of $username. Find out why it has no value, and the rest should work.

Cgraz

evo4ever

Sry lol. $username DOES come back successfully! Its set as a session variable. Thats why, as you can see, im not getting it out of the DB.

Username: Tyrannus.
First Name: failed.
Last Name: failed.

**

But i've sorted the problem. Somewhere else on the page was using the same query ($query0). I deleted that and the array worked successfully, all the details echoed back! But why cant I use the same query on different parts of the page???

diego25

Did you use the same query or the same result set ? The query is just a string, the result set is the resource returned by mysql_query.

Diego