Newbie - I think I missed ??? - PHPBuilder Forums

Newbie - I think I missed ???

Anon

Hi Everyone,
The code below gives me "Couldn't execute query." Can someone take a quick gander at it and let me know possibly what I did wrong, Please.

Thanks for your inputs.
:o) Ivan R.

$chk_id = "SELECT org from lsv WHERE org = \"$org\"";

$chk_id_res = @($chk_id,$connection) or die("Couldn't execute query.");

$chk_id_num = mysql_num_rows($chk_id_res);

if ($chk_id_num == "0") {

echo "$logo";

echo "<body bgcolor=\"$bg_color\" background=\"$background\" text=\"$tcolor\"";

echo "  Sorry, No Records Found!";

echo " $author";

exit;

} else {

$sql = "
SELECT *
FROM lsv, insp, insp.qrtrly + INTERVAL 90 DAY as nextdue
WHERE lsv.vid = \"insp.vid\"
";

$result = @($sql,$connection) or die("Couldn't execute query.");

}

Anon

You have to set up your connection first.

For example, before the code you posted, you need to do

// change the following as appropriate
$server = "localhost";
$username = "username";
$password = "password";
$database = "database";

$connection = mysql_connect($server, $username, $password);

mysql_select_db($database, $connection);

Only then can you use the function mysql_query.

Lacey

Anon

I'm sorry I already have that done and it still is giving me "Couldn't execute query."

Here's my entire clip:

include("config.inc");

$db_name = "$db";

$connection = @mysql_connect("$server", "$user", "$password") or
die("Couldn't connect.");

$db = @mysql_select_db($db_name, $connection) or die("Couldn't select
database.");

$chk_id = "SELECT org from lsv WHERE org = \"$org\"";

$chk_id_res = @($chk_id,$connection) or die("Couldn't execute query.");

$chk_id_num = mysql_num_rows($chk_id_res);

if ($chk_id_num == "0") {

echo "$logo";

echo "<body bgcolor=\"$bg_color\" background=\"$background\" text=\"$tcolor\"";

echo "  Sorry, No Records Found!";

echo " $author";

exit;

} else {

$sql = "
SELECT *
FROM lsv, insp, insp.qrtrly + INTERVAL 90 DAY as nextdue
WHERE lsv.vid = \"insp.vid\"
";

$result = @($sql,$connection) or die("Couldn't execute query.");

}

$the_unit = "

<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">
<tr>
<td>
 
<center>
$org Golf Cart / LSV's Inspection Dates
 
</center>
</td>
</tr>
</table>

<tr>

<td bgcolor=#800000>Registration:</td>

<td bgcolor=#800000>Serial Number:</td>

<td bgcolor=#800000>Office Stmbol:</td>

<td bgcolor=#800000>Inspection Date:</td>

</tr>

while ($row = mysql_fetch_array($result)) {

$vid = $row['vid'];

$reg = $row['reg'];

$sn = $row['sn'];

$org = $row['org'];

$offsym = $row['offsym'];

$vco_n = $row['vco_n'];

$vco_e = $row['vco_e'];

$qrtrly = $row['qrtrly'];

$the_unit .= "<tr>

<td bgcolor=#ECDC94>$offsym</td>

<td bgcolor=#ECDC94>$qrtrly</td>

<td bgcolor=#ECDC94>$nextdue</td>

";
}

$the_unit .= "</tr></table>";

bastien

$chk_id = "SELECT org from lsv WHERE org = \"$org\"";

take the slashes out of the query and change the double quote to a single quote like this :

$chk_id = "SELECT org from lsv WHERE org = '$org'";

hth

bastien

Anon

Found my error. Thanks.

I had the insp.qrtrly + INTERVAL 90 DAY as nextdue on the FROM vs the SELECT.

Brain @#@%$

:o) Ivan