Help Please :) – PHP

  php

Q(Question):

Hey, I am trying to get some code I have written to work. Runs well
until I make a request. The I get some problems with PHP related to an
SQL statement. Here are the errors :Warning: mysql_result(): supplied
argument is not a valid MySQL result resource in c:\program
files\apache group\apache\htdocs\veiworderform.php on line 25 (error
goes to 76)

Here is the code, any help that can be offered would be great. THANKS
A TON !!

<?php
$page_title = ‘Webflexo.com -Order Form’;
$page_mark = ‘Order Form’;

?>
<body bgcolor="#009966">
<div align="center"><br>
<table width="799" border="0" ="1" cellspacing="0"
bgcolor="#aaaaaa">
<tr>
<td>
<table width="100%" border="0" bgcolor="#FFFFCC">
<tr>
<td> <div align="center">

<?php
$po = $_POST[‘po’];
if ($submitone) {
$db = mysql_connect("localhost");
mysql_select_db("webgraphics",$db);
$sql = "select * from orderform where po = $po";
$result = mysql_query($sql);

$billcompany = mysql_result($result,0,billcompany);
$billaddress = mysql_result($result,0,billaddress);
$billcity = mysql_result($result,0,billcity);
$billstate = mysql_result($result,0,billstate);
$billzip = mysql_result($result,0,billzip);
$billorder = mysql_result($result,0,billorder);
$billphone = mysql_result($result,0,billphone);
$billfax = mysql_result($result,0,billfax);
$shipcompany = mysql_result($result,0,shipcompany);
$shipaddress = mysql_result($result,0,shipaddress);
$shipcity = mysql_result($result,0,shipcity);
$shipstate = mysql_result($result,0,shipstate);
$shipzip = mysql_result($result,0,shipzip);
$shiporder = mysql_result($result,0,shiporder);
$shipphone = mysql_result($result,0,shipphone);
$shipfax = mysql_result($result,0,shipfax);
$dateneed = mysql_result($result,0,dateneed);
$description = mysql_result($result,0,description);
$proofneed = mysql_result($result,0,proofneed);
$proof = mysql_result($result,0,proof);
$proofemail = mysql_result($result,0,email);
$prooflaser = mysql_result($result,0,prooflaser);
$proofcolor = mysql_result($result,0,proofcolor);
$laserproof = mysql_result($result,0,laserproof);
$dyluxproof = mysql_result($result,0,dyluxproof);
$matchprintproof = mysql_result($result,0,matchprintproof);
$colorkeyproof = mysql_result($result,0,colorkeyproof);
$faxproof = mysql_result($result,0,faxproof);
$colornumber = mysql_result($result,0,colornumber);
$proofnumber = mysql_result($result,0,proofnumber);
$film = mysql_result($result,0,film);
$thickness = mysql_result($result,0,thickness);
$platematerial = mysql_result($result,0,platematerial);
$cylinderdirection = mysql_result($result,0,cylinderdirection);
$cut = mysql_result($result,0,cut);
$gear = mysql_result($result,0,gear);
$pitch = mysql_result($result,0,pitch);
$distort = mysql_result($result,0,distort);
$cornerradius = mysql_result($result,0,cornerradius);
$reapeatcylinder = mysql_result($result,0,reapeatcylinder);
$totalcolors = mysql_result($result,0,totalcolors);
$totalplates = mysql_result($result,0,totalplates);
$imagedimesiontwo = mysql_result($result,0,imagedimesiontwo);
$imagedimensionone = mysql_result($result,0,imagedimensionone);
$ar = mysql_result($result,0,ar);
$ac = mysql_result($result,0,ac);
$gapac = mysql_result($result,0,gapac);
$gapar = mysql_result($result,0,gapar);
$tooth = mysql_result($result,0,tooth);
$returndisk = mysql_result($result,0,returndisk);
$returnart = mysql_result($result,0,returnart);
$instructions = mysql_result($result,0,instructions);
?>
<h1 align="center"><strong>Web Graphics Online Order
Form</strong></h1>
</title><div align="center">
<table width="100%" height="30" border="0"
cellpadding="2" cellspacing="0">
<tr bgcolor="#999999">

<td width="50%"><strong>BILL TO:</strong></td>

<td width="50%" colspan="2"><strong>SHIP
TO:</strong> </td>
</tr>
<tr bgcolor="#CCCCCC">

<td>Company Name:

<input type="text" id="billcompany2"
value="$billcompany">
</td>

<td colspan="2">Company Name:

<input type="text" id="shipcompany2"
value="$shipcompany"></td>
</tr>
<tr bgcolor="#CCCCCC">

<td>Address:

<input type="text" id="billaddress2"
value="$billaddress"></td>

<td colspan="2">Address:

<input type="text" id="shipaddress2"
value="$shipaddress"></td>
</tr>
<tr bgcolor="#CCCCCC">

<td>
<p>City:
<input type="text" id="billcity2"
value="$billcity" size="20">
State :
<input type="text" id="billstate2"
value="$billstate" size="2">
Zip:
<input type="text" id="billzip2"
value="$billzip" size="9">
</p></td>

<td colspan="2">
<p>City:
<input type="text" id="shipcity2"
value="$shipcity" size="20">
State :
<input type="text" id="shipstate2"
value="$shipstate" size="2">
Zip:
<input type="text" id="shipzip2"
value="$shipzip" size="9">
</p></td>
</tr>
<tr bgcolor="#CCCCCC">

<td>Ordered By:

<input type="text" id="billorder2"
value="$billorder"></td>

<td colspan="2">Ordered By:

<input type="text" id="shiporder2"
value="$shiporder"></td>
</tr>
<tr bgcolor="#CCCCCC">

<td>Phone:

<input type="text" id="billphone2"
value="$billphone" size="9">
Fax:

<input type="text" id="billfax2"
value="$billfax" size="9"> </td>

<td colspan="2">Phone:

<input type="text" id="shipphone2"
value="$shipphone" size="9">
Fax:

<input type="text" id="shipfax2"
value="$shipfax" size="9"></td>
</tr>
<tr bgcolor="#999999">
<td colspan="3">&nbsp;</td>
</tr>
<tr bgcolor="#CCCCCC">

<td colspan="3">P.O.# :

<input type="text" id="po2" value="$po">
Description:

<input type="text" id="description2"
value="$description" size="50">
</td>
</tr>
<tr bgcolor="#999999">
<td colspan="3">&nbsp;</td>
</tr>
</table>
<table width="100%" height="30" border="0"
cellpadding="2" cellspacing="0">
<tr bgcolor="#999999">

<td width="50%" colspan="2" bgcolor="#CCCCCC">Date
Needed
By: <em> (YYYY-MM-DD) </em> <input type="text"
value="$dateneed" size="20"></td>

<td width="50%" colspan="2"
bgcolor="#CCCCCC">Proof Needed
By: <em>(YYYY-MM-DD)</em> <input type="text"
id="proofneed2" value="$proofneed" size="20">
</td>
</tr>
<tr bgcolor="#CCCCCC">

<td colspan="2" bgcolor="#999999"><strong>Proofs
Before
Plates:
<label> </label>
<label> </label>
</strong> <label>

<input <?php if (!(strcmp("$proof","Yes")))
{echo "CHECKED";} ?> type="radio" name="proof" value="Yes">
Yes</label>
<input <?php if (!(strcmp("$proof","No")))
{echo "CHECKED";} ?> type="radio" name="proof" value="No">
<label>No</label> </td>
<td colspan="2" bgcolor="#999999">&nbsp;</td>
</tr>
<tr bgcolor="#CCCCCC">

<td>
<label>

<input <?php if (!(strcmp("$emailproof","Yes")))
{echo "checked";} ?> name="emailproof" type="checkbox"
id="emailproof2" value="Yes">
E-Mail</label></td>

<td> <input <?php if
(!(strcmp("$faxproof","Yes"))) {echo "checked";} ?> name="faxproof"
type="checkbox" id="faxproof2" value="Yes">
Fax</td>

<td colspan="2">Number of Colors:

<input type="text" id="colornumber2"
value="$colornumber"></td>
</tr>
<tr bgcolor="#CCCCCC">

<td>
<input <?php if (!(strcmp("$laserproof","Yes"))) {echo "checked";} ?>
name="laserproof" type="checkbox" id="laserproof2" value="Yes">
Laser</td>

<td>
<input <?php if (!(strcmp("$colorlaserproof","Yes"))) {echo
"checked";} ?> name="colorlaserproof" type="checkbox"
id="colorlaserproof2" value="Yes">
Color Laser</td>

<td colspan="2">Number of Proofs:

<input type="text" id="proofnumber2"
value="$proofnumber"></td>
</tr>
<tr bgcolor="#CCCCCC">

<td>
<label> </label>
<input <?php if (!(strcmp("$dyluxproof","Yes")))
{echo "checked";} ?> name="dyluxproof" type="checkbox"
id="dyluxproof2" value="Yes">
Dylux</td>

<td>
<input <?php if (!(strcmp("$matchprintproof","Yes"))) {echo
"checked";} ?> name="matchprintproof" type="checkbox"
id="matchprintproof2" value="Yes">
Match Print</td>

<td colspan="2">Film:

<input type="text" id="film2"
value="$film"></td>
</tr>
<tr bgcolor="#CCCCCC">

<td colspan="4">
<input <?php if (!(strcmp("$colorkeyproof","Yes"))) {echo "checked";}
?> name="colorkeyproof" type="checkbox" id="colorkeyproof2"
value="Yes">
Color Key</td>
</tr>
<tr bgcolor="#CCCCCC">

<td colspan="4">
<div align="center">
<table width="100%" border="0"
cellpadding="0">
<tr bgcolor="#999999">

<td width="33%"><strong>Plate
Material:</strong></td>

<td width="33%"><strong>Step &amp;
Reapeat</strong></td>
<td width="33%">&nbsp;</td>
</tr>
</table>
<table width="100%" border="0"
cellpadding="0" cellspacing="0">
<!–DWLayoutTable–>
<tr>

<td width="32%" valign="top"> <p>
<label>
<input <?php if
(!(strcmp("$platematerial","PQS"))) {echo "CHECKED";} ?> type="radio"
name="platematerial" value="PQS">
PQS</label>
<br>
<label>
<input <?php if
(!(strcmp("$platematerial","HOS"))) {echo "CHECKED";} ?> type="radio"
name="platematerial" value="HOS">
HOS</label>
<br>
<label>
<input <?php if
(!(strcmp("$platematerial","EXL"))) {echo "CHECKED";} ?> type="radio"
name="platematerial" value="EXL">
EXL</label>
<br>
<label>
<input <?php if
(!(strcmp("$platematerial","UXL"))) {echo "CHECKED";} ?> type="radio"
name="platematerial" value="UXL">
UXL</label>
<br>
<label>
<input <?php if
(!(strcmp("$platematerial","TDR"))) {echo "CHECKED";} ?> type="radio"
name="platematerial" value="TDR">
TDR</label>
</p>
<p>
<label></label>
<label>

<input <?php if
(!(strcmp("$platematerial","Epic"))) {echo "CHECKED";} ?> type="radio"
name="platematerial" value="Epic">

Epic</label>
<br>
<label>

<input <?php if
(!(strcmp("$platematerial","Atlas"))) {echo "CHECKED";} ?>
type="radio" name="platematerial" value="Atlas">

Atlas </label>
<br>
<label>

<input <?php if
(!(strcmp("$platematerial","Flexcor"))) {echo "CHECKED";} ?>
type="radio" name="platematerial" value="Flexcor">

Flexcor</label>
<br>
<label>

<input <?php if
(!(strcmp("$platematerial","Blue"))) {echo "CHECKED";} ?> type="radio"
name="platematerial" value="Blue">

Blue</label>
<br>
<label>
<input <?php if
(!(strcmp("$platematerial","Kor"))) {echo "CHECKED";} ?> type="radio"
name="platematerial" value="Kor">
Kor </label>
<br>
<label> Other </label>

<input type="text" id="platematerial2"
value="$platematerial" size="20">
<br>
</p>
<p align="left"> Thickness:</p>
<p align="left">
<label>

<input <?php if
(!(strcmp("$thickness","067"))) {echo "CHECKED";} ?> type="radio"
name="thickness" value="067">
067</label>
<br>
<label>

<input <?php if
(!(strcmp("$thickness","107"))) {echo "CHECKED";} ?> type="radio"
name="thickness" value="107">
107</label>
<br>
<label>

<input <?php if
(!(strcmp("$thickness","187"))) {echo "CHECKED";} ?> type="radio"
name="thickness" value="187">
187</label>
<br>
<label> Other

<input type="text" id="thickness2"
value="$thickness" size="20">
</label>
</p>
<p align="left">Plate Direction Around
Cylinder:</p>
<p align="left">
<label>

<input <?php if
(!(strcmp("$cylinderdirection","Left To Right"))) {echo "CHECKED";} ?>
type="radio" name="cylinderdirection" value="Left To Right">
Left To Right</label>
<br>
<label>
<input <?php if
(!(strcmp("$cylinderdirection","Top To Bottom"))) {echo "CHECKED";} ?>
type="radio" name="cylinderdirection" value="Top To Bottom">
Top To Bottom</label>
<br>
<label> Other</label>

<input type="text"
id="cylinderdirection2" value="$cylinderdirection" size="20">
</p>
<p align="left"></p></td>
<td width="5">&nbsp;</td>
<td width="32%" valign="top">
<p align="left">
<label> </label>
<label>

<input <?php if (!(strcmp("$cut","Die
Cut"))) {echo "CHECKED";} ?> type="radio" name="cut" value="Die Cut">
Die Cut</label>
<br>
<label>
<input <?php if
(!(strcmp("$cut","Butt Cut"))) {echo "CHECKED";} ?> type="radio"
name="cut" value="Butt Cut">
Butt Cut</label>
<br>
<label> Other</label>

<input type="text" id="cut2"
value="$cut" size="20">
</p>
<p>Gear Pitch: </p>
<p align="left">
<label>

<input <?php if (!(strcmp("$gear","1/8
CP"))) {echo "CHECKED";} ?> type="radio" name="gear" value="1/8 CP">
1/8 CP</label>
<br>
<label>

<input <?php if (!(strcmp("$gear","32
DP"))) {echo "CHECKED";} ?> type="radio" name="gear" value="32 DP">
32 DP</label>
<br>
<label>
<input <?php if
(!(strcmp("$gear","10 MIL"))) {echo "CHECKED";} ?> type="radio"
name="gear" value="10 MIL">
10 MIL</label>
</p>
<p align="left">Distort Plate:
<label> </label>
</p>
<p align="left">
<label>

<input <?php if
(!(strcmp("$distort","Yes"))) {echo "CHECKED";} ?> type="radio"
name="distort" value="Yes">
Yes</label>
<br>
<label>
<input <?php if
(!(strcmp("$distort","No"))) {echo "CHECKED";} ?> type="radio"
name="distort" value="No">
No</label>
</p>
<p align="left">Corner Radius:

<input type="text" id="cornerradius2"
value="$cornerradius" size="8">
</p>
<p align="left">Cylinder Repeat:

<input type="text"
id="reapeatcylinder2" value="$reapeatcylinder" size="8">
</p></td>
<td width="5">&nbsp;</td>
<td width="32%" valign="top"> <p> Total
Number of
Colors :

<input type="text" id="totalcolors2"
value="$totalcolors" size="8">
</p>
<p>Total Number of Plates :

<input type="text" id="totalplates2"
value="$totalplates" size="8">
</p>
<p>Image Size:

<input type="text"
id="imagedimensionone2" value="$imagedimensionone" size="8">
<font size="-1"> x</font>

<input type="text"
id="imagedimesiontwo2" value="$imagedimesiontwo" size="8">
</p>
<p><font size="-1">AR:</font>

<input type="text" id="ar2"
value="$ar" size="20">
</p>
<p> <font size="-1">AC:

<input type="text" id="ac2"
value="$ac" size="20">
</font></p>
<p><font size="-1">Gap AC:

<input type="text" id="gapac2"
value="$gapac" size="20">
</font></p>
<p><font size="-1">Gap AR:</font>
<font size="-1">

<input type="text" id="gapar2"
value="$gapar" size="20">
</font></p>
<p>Tooth:

<input type="text" id="tooth2"
value="$tooth" size="20">
</p>
<p><font size="-1">

<input <?php if
(!(strcmp("$returndisk","Yes"))) {echo "checked";} ?>
name="returndisk" type="checkbox" id="returndisk2" value="Yes">
Return Customer Disk <br>
</font><font size="-1">

<input <?php if
(!(strcmp("$returnart","$Yes"))) {echo "checked";} ?> name="returnart"
type="checkbox" id="returnart2" value="Yes">
Return Customer Art</font> </p>
<p>Additional Instructions:

<textarea cols="25" rows="4"
id="textarea">$instructions</textarea>
</p></td>
<td width="5">&nbsp;</td>
</tr>
<tr>
<td height="9"></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</table>
</div></td>
</tr>
<tr bgcolor="#999999">
<td colspan="4">&nbsp;</td>
</tr>
</table>
<p align="right">

</p>

</div></td>
</tr>
</table></td>
</tr>
</table>
<br>
</div>
<?php
}
else{
?>

<form method="post" action="<?php echo $PHP_SELF?>">
<div align="center">
<h1>Order Form Retreival</h1>
<p align="left"> P.O. # :
<input name="po" type="text" id="po">
</p>
<p align="left">
<input type="submit" name="submitone" value="Submit">
</p>
</div>
</form>
<?php
}

?>

A(Answer):

Kurt A. Kaylor wrote:

Hey, I am trying to get some code I have written to work. Runs well
until I make a request. The I get some problems with PHP related to an
SQL statement. Here are the errors :Warning: mysql_result(): supplied
argument is not a valid MySQL result resource in c:\program
files\apache group\apache\htdocs\veiworderform.php on line 25 (error
goes to 76)

( biiiiiiiiiiiiiiiig snip )
Use error_checking!

Brute-force method
<?php
$x = mysql_connect(…) or die(‘Connect error: ‘. mysql_error());
## ____________________^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^_

$y = mysql_query(…) or die(‘Query error: ‘ . mysql_error());
## __________________^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^_

$z = mysql_fetch_array(…) or die(‘Fetch error: ‘ . mysql_error());
## ________________________^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^^^^_
?>

A(Answer):

On 15 Jan 2004 00:37:07 GMT, Pedro Graca <he****@hotpop.com> wrote:

$x = mysql_connect(…) or die(‘Connect error: ‘. mysql_error());

Yep.
$y = mysql_query(…) or die(‘Query error: ‘ . mysql_error());

Yep.
$z = mysql_fetch_array(…) or die(‘Fetch error: ‘ . mysql_error());

Nope! false from mysql_fetch_* is NOT an error, it just means you’ve finished
fetching all the rows.


Andy Hassall <an**@andyh.co.uk> / Space: disk usage analysis tool
<http://www.andyh.co.uk> / <http://www.andyhsoftware.co.uk/space>

A(Answer):

Pedro Graca wrote:

Use error_checking!
$z = mysql_fetch_array(…) or die(‘Fetch error: ‘ . mysql_error());
## ________________________^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^^^^_

Oops … sorry … don’t do that for the mysql_fetch_array() function

–= my mail box only accepts =–
–= Content-Type: text/plain =–
–= Size below 10001 bytes =–

A(Answer):

From: Andy Hassall <an**@andyh.co.uk>
Newsgroups: comp.lang.php
Subject: Re: Help Please 🙂
Date: Thu, 15 Jan 2004 00:45:33 +0000

It is *now* 00:44:27 on my clock 🙂
Andy Hassall wrote:

$z = mysql_fetch_array(…) or die(‘Fetch error: ‘ . mysql_error());

Nope! false from mysql_fetch_* is NOT an error, it just means you’ve finished
fetching all the rows.

Right, thanks. I got carried away with error checking 🙂

–= my mail box only accepts =–
–= Content-Type: text/plain =–
–= Size below 10001 bytes =–

A(Answer):

Okay, still not helping me. I HAVE THE ERROR !! I need to know how to fix it

A(Answer):

On 15-Jan-2004, Do******@SDF.LONESTAR.ORG (Kurt A. Kaylor) wrote:

Okay, still not helping me. I HAVE THE ERROR !! I need to know how to fix
it

This isn’t a chat session. If you don’t quote those of us who don’t save
every thread will most likely be unable to help you.


Tom Thackrey
www.creative-light.com
tom (at) creative (dash) light (dot) com
do NOT send email to ja*********@willglen.net (it’s reserved for spammers)

LEAVE A COMMENT