from "mysql_query" to "echo"

I’m trying to figure out how to echo these variables that I’m pulling from a MySQL table.

Here’s my PHP code:

[code=php]<?

include(“config.php”);

// connect to the mysql server
$link = mysql_connect($server, $db_user, $db_pass)
or die (“Register Error 1 – Could not connect to mysql because “.mysql_error());

// select the database
mysql_select_db($database)
or die (“Register Error 2 – Could not select database because “.mysql_error());

$chron = $_POST[‘custom’];

$first_name = $_POST[‘first_name’];

$last_name = $_POST[‘first_name’];

$receiver_email = $_POST[‘receiver_email’];

$quantity = $_POST[‘quantity’];

$custom = $_POST[‘custom’];

$payment_date = $_POST[‘payment_date’];

$address_zip = $_POST[‘address_zip’];

$address_state = $_POST[‘address_state’];

$address_city = $_POST[‘address_city’];

$address_street = $_POST[‘address_street’];

$contact_phone = $_POST[‘contact_phone’];

$reg1name = mysql_query(“SELECT reg1name FROM $table4 WHERE chron = $chron”);

$reg1food = mysql_query(“SELECT reg1food FROM $table4 WHERE chron = $chron”);

$reg2name = mysql_query(“SELECT reg2name FROM $table4 WHERE chron = $chron”);

$reg3name = mysql_query(“SELECT reg3name FROM $table4 WHERE chron = $chron”);

$reg4name = mysql_query(“SELECT reg4name FROM $table4 WHERE chron = $chron”);

$reg5name = mysql_query(“SELECT reg5name FROM $table4 WHERE chron = $chron”);

$reg6name = mysql_query(“SELECT reg6name FROM $table4 WHERE chron = $chron”);

$reg7name = mysql_query(“SELECT reg7name FROM $table4 WHERE chron = $chron”);

$reg8name = mysql_query(“SELECT reg8name FROM $table4 WHERE chron = $chron”);

$reg2food = mysql_query(“SELECT reg2food FROM $table4 WHERE chron = $chron”);

$reg3food = mysql_query(“SELECT reg3food FROM $table4 WHERE chron = $chron”);

$reg4food = mysql_query(“SELECT reg4food FROM $table4 WHERE chron = $chron”);

$reg5food = mysql_query(“SELECT reg5food FROM $table4 WHERE chron = $chron”);

$reg6food = mysql_query(“SELECT reg6food FROM $table4 WHERE chron = $chron”);

$reg7food = mysql_query(“SELECT reg7food FROM $table4 WHERE chron = $chron”);

$reg8food = mysql_query(“SELECT reg8food FROM $table4 WHERE chron = $chron”);

$reg2tablemate = mysql_query(“SELECT reg2tablemate FROM $table4 WHERE chron = $chron”);

$reg3tablemate = mysql_query(“SELECT reg3tablemate FROM $table4 WHERE chron = $chron”);

$reg4tablemate = mysql_query(“SELECT reg4tablemate FROM $table4 WHERE chron = $chron”);

$reg5tablemate = mysql_query(“SELECT reg5tablemate FROM $table4 WHERE chron = $chron”);

$reg6tablemate = mysql_query(“SELECT reg6tablemate FROM $table4 WHERE chron = $chron”);

$reg7tablemate = mysql_query(“SELECT reg7tablemate FROM $table4 WHERE chron = $chron”);

$reg8tablemate = mysql_query(“SELECT reg8tablemate FROM $table4 WHERE chron = $chron”);

$tablemate1 = mysql_query(“SELECT tablemate1 FROM $table4 WHERE chron = $chron”);

$tablemate2 = mysql_query(“SELECT tablemate2 FROM $table4 WHERE chron = $chron”);

$tablemate3 = mysql_query(“SELECT tablemate3 FROM $table4 WHERE chron = $chron”);

$tablemate4 = mysql_query(“SELECT tablemate4 FROM $table4 WHERE chron = $chron”);

$tablemate5 = mysql_query(“SELECT tablemate5 FROM $table4 WHERE chron = $chron”);

$tablemate6 = mysql_query(“SELECT tablemate6 FROM $table4 WHERE chron = $chron”);

$tablemate7 = mysql_query(“SELECT tablemate7 FROM $table4 WHERE chron = $chron”);

$reg1name = mysql_result($reg1name);

$reg1food = mysql_result($reg1food);

$reg2name = mysql_result($reg2name);

$reg3name = mysql_result($reg3name);

$reg4name = mysql_result($reg4name);

$reg5name = mysql_result($reg5name);

$reg6name = mysql_result($reg6name);

$reg7name = mysql_result($reg7name);

$reg8name = mysql_result($reg8name);

$reg2food = mysql_result($reg2food);

$reg3food = mysql_result($reg3food);

$reg4food = mysql_result($reg4food);

$reg5food = mysql_result($reg5food);

$reg6food = mysql_result($reg6food);

$reg7food = mysql_result($reg7food);

$reg8food = mysql_result($reg8food);

$reg2tablemate = mysql_result($reg2tablemate);

$reg3tablemate = mysql_result($reg3tablemate);

$reg4tablemate = mysql_result($reg4tablemate);

$reg5tablemate = mysql_result($reg5tablemate);

$reg6tablemate = mysql_result($reg6tablemate);

$reg7tablemate = mysql_result($reg7tablemate);

$reg8tablemate = mysql_result($reg8tablemate);

$tablemate1 = mysql_result($tablemate1);

$tablemate2 = mysql_result($tablemate2);

$tablemate3 = mysql_result($tablemate3);

$tablemate4 = mysql_result($tablemate4);

$tablemate5 = mysql_result($tablemate5);

$tablemate6 = mysql_result($tablemate6);

$tablemate7 = mysql_result($tablemate7);

@mail(“[email protected]”, “TEST IPN – $name”, ”

Payment Details

Payment Date: $payment_date

Name: $first_name $last_name

E-mail: $receiver_email

Address:

$address_street

$address_city, $address_state $address_zip

————–

Events Options

Names Registered: $quantity

Database Number: $chron

Main Registrant: $reg1name
Main Registrant Entree: $reg1food
Registrant 2: $reg2name – $reg2food – $reg2tablemate
$reg3name
$reg4name
$reg5name
$reg6name
$reg7name
$reg8name

$reg3food
$reg4food
$reg5food
$reg6food
$reg7food
$reg8food

$reg3tablemate
$reg4tablemate
$reg5tablemate
$reg6tablemate
$reg7tablemate
$reg8tablemate
$tablemate1
$tablemate2
$tablemate3
$tablemate4
$tablemate5
$tablemate6
$tablemate7″);

?>[/code]

Before I added that last set of variables to try to convert the mysql_query variables to mysql_result variables I was getting “Resource id #” results, but now I’m not getting anything.

Anyone have any idea why?

Also in #PHP _↴