Session issues????

[hightechredneck]

I have a script that first selects info from the DB, then uses that info to call the rows that need to be edited... or at least it's supposed to, when I have a WHERE clause in the select statement I get the following error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data/sites/104595/milliondollarhomepagecolorado.com/www/submit_link.phpon line 78

If I don't have the WHERE clause in the select statement, it calls all of the info in the DB. I can't seem to get the session info to pass to the second part of the script once the submit button is clicked, obviously I'm missing something. Guess I'm too close... can't see the forest for the trees. Can anyone see what I'm missing?

Here's a snippet of the code:

// Start session.
session_start();
$_SESSION['square_number'] = $row[1];
$_SESSION['id'] = $row[0];
include ('./header.inc');
// Use the HTML header file.
require_once ('../mysql_connect.php');
//Connect to the db.

?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td valign="top">
<?php # PHP Script - submit links.php
// This page allows admin to edit ads.

if (isset($_POST['Submit'])) { // Handle the form.



// Validate square number
if ($_POST['square_number'] == 'new') {

   // If it's a new square_number, add to the database.
   $query = 'INSERT INTO square_number (id, square_number) VALUES
   (NULL, ';

   if (!empty($_POST['square_number'])){
      $query .= "'" . escape_data($_POST['square_number']) . "')";
} else {
      $query .= 'NULL, ';
}

// Check for Description.
if (!empty($_POST['square_number'])) {
      $query .= "'" . escape_data($_POST['square_number']) . "')";
      $result = @mysql_query ($query); // Run the query
   $sn = @mysql_insert_id(); // Get the ID.
   $sn = FALSE;
   echo '<p><font color="red">Please enter the square number!</font></p>';
}

} elseif ( ($_POST['square_number'] == 'existing') && ($_POST['existing'] > 0)) {
   $sn = $_POST['existing'];
}else {
   $sn = FALSE;
   echo '<p><font color="red">Please select the square number(s)!</font></p>';
   }



if ('$sn') {

$query = "SELECT id, square_number, alt, hyper_link, available, name, company, paid, email, height, width, order_id, number_of_squares FROM ads WHERE id = {$_SESSION['id']}";
$result = mysql_query ($query);   


echo '<fieldset><legend><table border="2" width="95%" cellspacing="3" cellpadding="3" align="center">
<tr>
<td><b>ID</b></td>
<td><b>Square Number</b></td>
<td><b>Alt</b></td>
<td><b>Hyper Link</b></td>
<td><b>Available</b></td>
<td><b>Name</b></td>
<td><b>Company</b></td>
<td><b>Payment Status</b></td>
<td><b>E Mail</b></td>
<td><b>Height</b></td>
<td><b>Width</b></td>
<td><b>Order ID</b></td>
<td><b>Number of Squares</b></td>
</tr>';

// Display all the URLs.
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {

   // Display each record.
   echo "<tr>
   <td>$row[0]</td>
   <td>$row[1]</td>
   <td>$row[2]</td>
   <td>$row[3]</td>
   <td>$row[4]</td>
   <td>$row[5]</td>
   <td>$row[6]</td>
   <td>$row[7]</td>
   <td>$row[8]</td>
   <td>$row[9]</td>
   <td>$row[10]</td>"; 

Thanks

T

[bradgrafelman]

Debug the MySQL query.

$query = "SELECT id, square_number, alt, hyper_link, available, name, company, paid, email, height, width, order_id, number_of_squares FROM ads WHERE id = {$_SESSION['id']}";
$result = mysql_query ($query) or die('MySQL said: ' . mysql_error());

[hightechredneck]

I tried debugging with:

$query = "SELECT id, square_number, alt, hyper_link, available, name, company, paid, email, height, width, order_id, number_of_squares FROM ads WHERE id = {$_SESSION['id']}";

echo $query;

$result = mysql_query ($query);	

if (mysql_errno() != 0 ){
  echo mysql_error();
}

the result I got in phpmyadmin:

#1064 - You have an error in your SQL syntax near '$query = "SELECT id, square_number, alt, hyper_link, available, name, company, p' at line 1

and in a browser:

SELECT id, square_number, alt, hyper_link, available, name, company, paid, email, height, width, order_id, number_of_squares FROM ads WHERE id = You have an error in your SQL syntax near '' at line 1

but I don't see any obvious syntax errors... what am I missing???

[bradgrafelman]

There is no 'id' in session, because it's not showing up in the query. Notice it says "WHERE id =" and then stops?

Fix the 'id' problem and you should be fine.

EDIT: I see this:

$_SESSION['id'] = $row[0];

But where is $row coming from??

[hightechredneck]

Thanks Brad! I really appreciate the help! Well.... the intent was that it would pull $row from the select query... guess that's not happening though.

I changed this:

 $_SESSION['id'] = $row[0];

to this:

$_SESSION['id'] = $row[id];

Still the same result. I also tried moving the session start to immediately after the query... you guessed it... same result again... any more ideas?

T

[bradgrafelman]

Wait a minute... you expect PHP to pull data from a query it hasn't even executed yet? Furthermore, this variable that it's supposed to know by looking into the future is even part of your query?

Uh... yeah, you might need to rethink the logic on this one!

[hightechredneck]

Like I said, I tried moving the session start to immediately after the select query, thinking maybe that it wasn't being set because the select query hadn't been executed. I'm still getting the same result. Here's what I've got surrounding the select query:

if ('$sn') {

$query = "SELECT id, square_number, alt, hyper_link, available, name, company, paid, email, height, width, order_id, number_of_squares FROM ads WHERE id = {$_SESSION['id']}";

echo $query;

$result = mysql_query ($query);   

$row = mysql_fetch_array ($result, MYSQL_NUM);
// Start session.
session_start();
$_SESSION['square_number'] = $row[1];
$_SESSION['id'] = $row[0];

if ($row){

echo '<fieldset><legend><table border="2" width="95%" cellspacing="3" cellpadding="3" align="center">
<tr>
<td><b>ID</b></td>
<td><b>Square Number</b></td>
<td><b>Alt</b></td>
<td><b>Hyper Link</b></td>
<td><b>Available</b></td>
<td><b>Name</b></td>
<td><b>Company</b></td>
<td><b>Payment Status</b></td>
<td><b>E Mail</b></td>
<td><b>Height</b></td>
<td><b>Width</b></td>
<td><b>Order ID</b></td>
<td><b>Number of Squares</b></td>
</tr>';

// Display all the URLs.
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {

   // Display each record.
   echo "<tr>
   <td>$row[0]</td>
   <td>$row[1]</td>
   <td>$row[2]</td>
   <td>$row[3]</td>
   <td>$row[4]</td>
   <td>$row[5]</td>
   <td>$row[6]</td>
   <td>$row[7]</td>
   <td>$row[8]</td>
   <td>$row[9]</td>
   <td>$row[10]</td>";

I think I'm on the right track, but why isn't the session being set?

[hightechredneck]

I think I'm making progress.... maybe! I added a second select query, now it's returning every record in the table EXCEPT the selected row.

if ('$sn') {

$query = "SELECT id, square_number, alt, hyper_link, available, name, company, paid, email, height, width, order_id, number_of_squares FROM ads";

echo $query;

$result = mysql_query ($query);	
$row = mysql_fetch_array ($result, MYSQL_NUM);

if ($row){

// Start session.
session_start();
$_SESSION['square_number'] = $row[1];
$_SESSION['id'] = $row[0];

$query = "SELECT id, square_number, alt, hyper_link, available, name, company, paid, email, height, width, order_id, number_of_squares FROM ads WHERE id = {$_SESSION['id']}";

echo '<fieldset><legend><table border="2" width="95%" cellspacing="3" cellpadding="3" align="center">
<tr>
<td><b>ID</b></td>
<td><b>Square Number</b></td>
<td><b>Alt</b></td>
<td><b>Hyper Link</b></td>
<td><b>Available</b></td>
<td><b>Name</b></td>
<td><b>Company</b></td>
<td><b>Payment Status</b></td>
<td><b>E Mail</b></td>
<td><b>Height</b></td>
<td><b>Width</b></td>
<td><b>Order ID</b></td>
<td><b>Number of Squares</b></td>
</tr>';

// Display all the URLs.
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {

   // Display each record.
   echo "<tr>
   <td>$row[0]</td>
   <td>$row[1]</td>
   <td>$row[2]</td>
   <td>$row[3]</td>
   <td>$row[4]</td>
   <td>$row[5]</td>
   <td>$row[6]</td>
   <td>$row[7]</td>
   <td>$row[8]</td>
   <td>$row[9]</td>
   <td>$row[10]</td>";

Why would it do the inverse of what I need it to do?

[hightechredneck]

Got it! at least part of it!

I added:

$result = mysql_query ($query);

after the second select query, now it displays only the selected record!

The only problem is, that it is supposed to be a multiple select, but it will only select one record.

What do I do to get over that hurdle?