Codezwiz >> Forums >> General PHP Nuke Help >> MySQL help!!!!!

Register

Ok sorry for more topics...lol...

Here's my problem. I'm clicking on a link and what it is supposed to do is connect to the DB, search for a specific table, specific field, and then echo what all is in that feild. here is the code im using:

<?php

@ $database = mysql_pconnect("localhost", "UsernamE", "PassworD");

if (!$database)
{
echo "Error: Could not connect to database.";
exit;
}

mysql_select_db("DatabasE");

$query = "SELECT Email FROM nuke_themes";
$result = mysql_query($query);

$query2 = "SELECT Homepage FROM nuke_themes";
$result2 = mysql_query($query2);

$query3 = "SELECT Themename FROM nuke_themes";
$result3 = mysql_query($query3);

if (!$result || !$result2 || !$result3)
{
echo "There are no requests for a new theme.";
exit;
}

$row = mysql_fetch_array($result);
$new = stripslashes($row["Email"]);

$row = mysql_fetch_array($result2);
$new2 = stripslashes($row["Homepage"]);

$row = mysql_fetch_array($result3);
$new3 = stripslashes($row["Themename"]);

echo "$new<br>";
echo "$new2<br>";
echo "$new3<br>";

?>

It's because you're not telling it to display more than one row. You need a loop in there so that when it gets finished displaying everything in the first row, it moves to the next row and displays everything in that row and so on until it has displayed all the rows.

Register

ok, can you help me with this loop? Here is what I have now:

<?php

@ $database = mysql_pconnect("localhost", "UseR", "PassworD");

if (!$database)
{
echo "Error: Could not connect to database.";
exit;
}

mysql_select_db("DatabasE");

$query = "SELECT Email FROM nuke_themes";
$result = mysql_query($query);

$query2 = "SELECT Homepage FROM nuke_themes";
$result2 = mysql_query($query2);

$query3 = "SELECT Themename FROM nuke_themes";
$result3 = mysql_query($query3);

if (!$result || !$result2 || !$result3)
{
echo "There are no requests for a new theme.";
exit;
}

for($i=0; $i<mysql_affected_rows(); $i++)
{
$row = mysql_fetch_array($result);
}
$new = stripslashes($row["Email"]);

for($i2=0; $i2<mysql_affected_rows(); $i2++)
{
$row = mysql_fetch_array($result2);
}
$new2 = stripslashes($row["Homepage"]);

for($i3=0; $i3<mysql_affected_rows(); $i3++)
{
$row = mysql_fetch_array($result3);
}
$new3 = stripslashes($row["Themename"]);

echo "<table border=\"2\">";
echo "<tr>";
echo "<td><center><b>Email:</b></center></td>";
echo "<td><center><b>Home&nbspPage:</b></center></td>";
echo "<td><center><b>Theme&nbspName:</b></center></td>";
echo "</tr>";
echo "<tr>";
echo "<td><center>$new</center></td>";
echo "<td><center>$new2</center></td>";
echo "<td><center>$new3</center></td>";
echo "</tr>";
echo "</table>";

?>

Try this:

<?php @ $database = mysql_pconnect("localhost", "UseR", "PassworD");

if (!$database)
{
echo "Error: Could not connect to database.";
exit;
}
mysql_select_db("DatabasE");
$query = "SELECT Email, Homepage, Themename FROM nuke_themes";
$result = mysql_query($query);
$rows = mysql_fetch_assoc($result);
$total_rows = mysql_num_rows($result);

if (!isset($result) || ($result == ""))
{
echo "There are no requests for a new theme.";
}
else {
   $req = "";
   $i = 0;
   if ($total_rows> 0) {
   mysql_data_seek ( $result, 0 );
   while ($row = mysql_fetch_assoc($result)) {
   $email = $row['Email'];
   $homepage = $row['homepage'];
   $themename = $row['Themename'];

   echo "<table border=\"2\"><tr>";
   echo "<td align=\"center\"><b>Email:</b></td>";
   echo "<td align=\"center\"><b>Home Page:</b></td>";
   echo "<td align=\"center\"><center><b>Theme Name:</b></td></tr><tr>";
   echo "<td align=\"center\">$email</td>";
   echo "<td align=\"center\">$homepage</td>";
   echo "<td align=\"center\">$themename</td></tr></table>";
      } //end loop
   }
   $i++;
   echo "$req";
}
?>

Register

ok, im on a school computer at the moment, but i will try it when i get home...thanks kelly!

Register

Worked really nicely, thanks Kelly.

I have one more question. This is taking in requests, so there will be a page posting all the requests form the database. If that request was made, i will want to delete that request from the database. I have looked at ALTER...and that is just changing the fields, and ive looked at dropping a row...then in the page posting all the requests, in that PHP code...I could make an if statement, and check whether or not the table exists. If it doesnt, make it. If it does, skip "Creat Table" and go on to adding the information into it.

Is there a better way to do that? I think im going to go with the second way...but if theres a shorter better way, im all ears.

Thanks, Wolf.