addressalign-toparrow-leftarrow-leftarrow-right-10x10arrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcredit-cardcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobe--smallglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1languagelaunch-new-window--smalllight-bulblightning-boltlinklocation-pinlockm-swarmSearchmailmediummessagesminusmobilemoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstar-shapestartickettrashtriangle-downtriangle-uptwitteruserwarningyahooyoutube

Re: [php-49] sql error

From: Jd D.
Sent on: Monday, February 18, 2013, 1:49 PM
instead of mysql_fetch_assoc try mysql_fetch_row

and before you get gangbanged by complaints, please do not use the mysql_ stuff. Its a bad bad idea....

Use use either PDO or MYSQLI


On Mon, Feb 18, 2013 at 1:43 PM, max steinmetz <[address removed]> wrote:
Hello, newb here with a question.

I'm attempting to build a simple shopping cart, this is my first time doing so and I am getting an error message which reads as follows:


Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in


Any help would be greatly appreciated as I'm google this error messag a bit and seen so many possible options that my mind turned to goop.

Again thank you for any help/direction possible.



This is the code starting with line #42

<div class="container">
<span class="top-label">
<span class="label-txt">PRODUCTS (TAKE Displayed things from here)</span>
</span>
<div class="content-area">
<div class="content drag-desired">
<?php
$result = mysql_query("SELECT * FROM internet_shop");
while($row=mysql_fetch_assoc($result))
{
echo '<div class="product"><img src="_img/products/'.$row['img'].'" alt="'.htmlspecialchars($row['name']).'" width="128" height="128" class="pngfix" /></div>';
}
?>
<div class="clear"></div>
</div>
</div>
<div class="bottom-container-border">
</div>
</div>





--
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by max steinmetz ([address removed]) from The Seattle PHP Meetup Group.
To learn more about max steinmetz, visit his/her member profile
Set my mailing list to email me As they are sent | In one daily email | Don't send me mailing list messages

Meetup, POB 4668 #37895 NY NY USA 10163 | [address removed]



--
Jd Daniel || ERADO
Senior Applications Architect
7901 Delridge Way SW #36D, Seattle
C.   [masked]

Seattle, WA

Founded Mar 15, 2003

Organizer:

Tim Bond
Contact

People in this
group are also in: