Supplied argument is not a valid MySQL-Link

[mancroft]

I am trying to get php to send an email part of which is a display of a MySQL table.

The code below may or may not be correct but I am getting the error message:

Warning: Supplied argument is not a valid MySQL-Link resource in /home/mancroft/

http://www/test/emailform.php

on line 32

plus two similar messages for other lines.

Any ideas please?

MYSQL_CONNECT(localhost, mancroft, xxxxxx) OR DIE("Unable to connect"

mysql_select_db("mancroft_test",$db);

$result = mysql_query("SELECT * FROM cart",$db);
if ($result === false) die("failed"

while ($row=mysql_fetch_row($result)) {
$RBI=$row[0];
$RUI=$row[1];
$RON=$row[2];
}

$serveroutput = "$RBI $RUI $RON";

 

[sleipnir214]

You're getting that error because you are supplying an optional resourse-link identifier in the form of a value in $db, when you haven't initialized $db.

Either change your database connection line to read:

$db = mysql_connect (.....)

or drop the optional parameter in mysql_query():

$result = mysql_query("SELECT * FROM cart"


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!