 |  |  |  |  |  |  |  |
Retreiving variables from a sql query into a form
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
I need to add a paypal 'add to cart' button to my page to submit the contents of my table to a shopping cart. The contents of the table are variables as they are from a sql query. Does anyone know hoe I could get the paypal link(script below) to retreive the variables from my query and submit them to the shopping cart.
I need $myrow[0] to be used for item_number, $myrow[1],$myrow[2],$myrow[3] and $myrow[4] to be combined to make item_name and $myrow[5] to be used for Ammount.
Thanks
Huw
PHP Syntax (Toggle Plain Text)
I need $myrow[0] to be used for item_number, $myrow[1],$myrow[2],$myrow[3] and $myrow[4] to be combined to make item_name and $myrow[5] to be used for Ammount.
Thanks
Huw
•
•
Join Date: Jan 2004
Posts: 468
Reputation: 
Solved Threads: 18
Posting Pro in Training
can you provide more specifics on sql versions, platform, etc?
My Home Away from Home: Yet Another Linux Blog
•
•
•
•
Originally Posted by TKS
can you provide more specifics on sql versions, platform, etc?
The Host company use Linux servers and run the latest versions of SQL & PHP
Huw
•
•
Join Date: Nov 2003
Posts: 360
Reputation:
Solved Threads: 5
PHP/vBulletin Guru
You could run a query like:
[php]<?php
// don't forget to create a connection to database first!
// i.e.:
@mysql_connect('localhost','username','password');
// and choose a database
@mysql_select_db('database_name');
// fetch the info from database
$myrow = @mysql_query("SELECT * FROM table");
// make it so that it's like $myrow[0], $myrow[1], etc.
$myrow = mysql_fetch_row($myrow);
?>[/php]
[php]<?php
// don't forget to create a connection to database first!
// i.e.:
@mysql_connect('localhost','username','password');
// and choose a database
@mysql_select_db('database_name');
// fetch the info from database
$myrow = @mysql_query("SELECT * FROM table");
// make it so that it's like $myrow[0], $myrow[1], etc.
$myrow = mysql_fetch_row($myrow);
?>[/php]
|
Similar Threads
- simple sql query (PHP)
- Help in using SQL Query in Crstal report with VB.NET (VB.NET)
- Creating Table using SQL query from wondows Form (VB.NET)
- retrieving a particular value with a sql query (PHP)
- C# VS 2005 - SQL Query Parameters to an ODBC DataSource (C#)
- sql query updating problem (Visual Basic 4 / 5 / 6)
Other Threads in the PHP Forum
- Previous Thread: Which template is it? [vbulletin]
- Next Thread: need help with PHP Script translation
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
# address apache api array autoincrement beginner binary broken cakephp checkbox class clean cms code countingeverycharactersfromastring crack cron curl database date decode dehasher directory display dissertation dynamic echo email error fairness file files folder form forms function functions google href htaccess html image include incode insert ip javascript joomla legislation limit link login mail masterthesis match menu method mlm multiple mysql newsletters oop pagerank paypal pdf persist php play protocol query question radio random remote root script search server sessions simple sms soap source space spam sql support! syntax system table tutorial update upload url validator variable video web youtube
