•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 397,613 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,571 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 5817 | Replies: 3
 |
•
•
Join Date: Aug 2004
Posts: 6
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
<form target="paypal" action="https://www.paypal.com/cgi-bin/webscr" method="post"> <input type="image" src="https://www.paypal.com/en_GB/i/btn/x-click-but22.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!"> <input type="hidden" name="add" value="1"> <input type="hidden" name="cmd" value="_cart"> <input type="hidden" name="business" value="info@wildcar.co.uk"> <input type="hidden" name="item_name" value=""> <input type="hidden" name="item_number" value=""> <input type="hidden" name="amount" value=""> <input type="hidden" name="no_note" value="1"> <input type="hidden" name="currency_code" value="GBP"> </form>
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
Location: VA, USA
Posts: 458
Reputation:
Rep Power: 6
Solved Threads: 17
Posting Pro in Training
can you provide more specifics on sql versions, platform, etc?
My Home Away from Home: Yet Another Linux Blog
•
•
Join Date: Aug 2004
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
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
Location: Toronto, Canada
Posts: 354
Reputation:
Rep Power: 6
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]
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb PHP Marketplace
Linear Mode
- 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)
- Unable to insert form data into a database (ASP)
- Javascript array from sql query (JSP)
- Please help me out with MySQL query (MySQL)
- PHP/SQL query help (PHP)
Other Threads in the PHP Forum
- Previous Thread: Which template is it? [vbulletin]
- Next Thread: need help with PHP Script translation
