[Resolved] What is wrong with my SQL?

Manat

Hello all,

if ($cboAW == 1)
{

$strSQL = "SELECT * FROM awd WHERE sku = $txtSKU";
$result = mysql_query($strSQL) or die(mysql_error());
$awDesc = $row["awDesc"];
echo $awardDesc;
}

My above code doesn't seem to be working, it echos nothing.
Is there something wrong with the way im declaring the new variable?

I put other echoes to test cboAW, and it worked, so the if statement does get executed.

Thx
MK

bastien

$strSQL = "SELECT * FROM awd WHERE sku = '$txtSKU'";

text items need quotes around the name..

Manat

if ($cboAW == 1)
{

$strSQL = "SELECT * FROM awd WHERE sku = '$txtSKU'";
$result = mysql_query($strSQL) or die(mysql_error());
$awd = $row["awd"];
echo $awd;
}

It still doesn't echo anything...

bastien

$strSQL = "SELECT * FROM awd WHERE sku = '$txtSKU'";

if you
echo $strSQL;
and copy it to the the gui admin tool for your db, does it run? do you get results? the ones that you expected / wanted?

$result = mysql_query($strSQL) or die(mysql_error());

Manat

Hi,

Yes, I do get the results I wanted. And when i eacho txtSku, I also get the same value that I entered in my gui admin tool.

However... it still doesn't work

bastien

might be a connection problem to the db...have you included the db connection in this page or in another (I favor this approach as its easier to maintain)

<?php
//conn.php

//check the password from the DB and get the access level = type


$username = "root";
$pwd ="*******";
$host = "localhost";
$dbname = "my_db";



//connect to db
//$conn=mysql_connect($host, $username, $pwd) or die ("Unable to connect to database");

if (!($conn=mysql_connect($host, $username, $pwd))) {
printf("error connecting to DB by user = $username and pwd=$pwd");
exit;
}
$db=mysql_select_db($dbname,$conn) or die("Unable to connect to database1");

?>

and then i work it into the page like this

<?
include("conn.php");

$sql="select....";

$result = mysql_query($sql,$conn) or die("can't connect because ".mysql_error());

//rest of your page
?>

so in your case it changes the sql process to this:


include("conn.php"); //include the db connection page

if ($cboAW == 1) 
{ 

$strSQL = "SELECT awd FROM awd WHERE sku = '$txtSKU'"; 
$result = mysql_query($strSQL,$conn) or die(mysql_error()); 
$awd = $row["awd"]; 
echo $awd; 
}

Try creating your own conn.php and includinging it like this..see if that helps

Manat

In your conn.php

//$conn=mysql_connect($host, $username, $pwd) or die ("Unable to connect to database");

The above is to remain commented?

Because you refer to it:

if (!($conn=mysql_connect($host, $username, $pwd)))

Thanks

bastien

actually just delete the commented code...if was a test and the code below that is better...

Manat

For some reason, it still didn't work.
So I did this instead:

$strSQL = "SELECT * FROM awd WHERE sku = '$txtSKU'";
$q->doquery($db, $strSQL);
$Awd = $q->getrow();
echo($Awd["awd"]);

And it actually worked for some strange reason.

Now I have one question:

How do I put

echo($Awd["awd"]);

in this

echo "<tr>
<td width=\"200\" valign=\"top\" bgcolor=\"gray\">Awards Listing</td>

<td bgcolor=\"gray\"><textarea cols=\"45\" rows=\"10\" name=\"txtAwards\">echo($Awd["awd"]);textarea></td>
</tr>";

I know I didn't put it right, how is it to be put?

Thanks
MK

Erkilite

don't forget to fetch the row from the result

if ($cboAW == 1) 
{ 

$strSQL = "SELECT * FROM awd WHERE sku = '$txtSKU'"; 
$result = mysql_query($strSQL) or die(mysql_error()); 
$row=mysql_fetch_array($result,MYSQL_ASSOC);
$awDesc = $row["awDesc"]; 
echo $awardDesc; 
}

also

echo "<tr> 
<td width=\"200\" valign=\"top\" bgcolor=\"gray\">Awards Listing</td> 
<td bgcolor=\"gray\"><textarea cols=\"45\" rows=\"10\" name=\"txtAwards\">".$Awd["awd"]."</textarea></td> 
</tr>";