jakebur01

I am having trouble with this. I am trying to make each row active. echo "<a href=\"show_cat.php?catid=".$myrow[catid]."\">"; echo"<TD ALIGN=center><small>"; echo$myrow["isbn"]; echo"</small></td><TD ALIGN=center><small>"; echo$myrow["catid"]; echo"</small></td><TD ALIGN=center><small>"; echo$myrow["description"]; echo"</small></td><TD ALIGN=center><small>"; echo$myrow["title"]; echo"</small></td><TD ALIGN=center><small>"; echo$myrow["author"]; echo"</small></td>"; echo"</a>";

What is a RSS Feed? Is their something I could connect to without having the client entering in emails manually?

Hey I have a client who is requesting this on their website: "A visitor does a job search, listings come up, then, at the bottom it has a place to submit your email if you want to be notified when more jobs that meet your search criteria are posted." I've search on Google to try to find out what you would connect to to pull the job listings. Does anyone have any ideas on how I could go about doing this?

Ha ha, your right! I don't know what I was thinking.

you were right about the number deal bbaker. Any column I take that has a number value, when i go to sql it I get 0 affected rows whether it's the orderid, amount, or whatever. Do I need to use some type of number format function when sqling?

Could be. I could use just one value if I could get the auto-incremented number off of my last insertion. How would I do this? If on the previous page I inserted data into a new row and has it auto-increment a number under the column `orderid` ? I want to find out what number it created when it inserted the data and store that number into a session.

I am still getting Affected rows: 0 It has something to do with using two values. It works fine with one, but when I add an additional one no matter what it is it said 0 affected rows.

ok heres my problem, I am trying to update new information on a row in my mysql database. This works fine: $query = "UPDATE `orders` SET `c_phone` = '$c_phone', `c_email` = '$c_email', `card_type` = '$card_type', `card_number` = '$card_number', `card_month` = '$card_month', `card_year` = '$card_year', `card_name` = '$card_name', `three_number` = '$amex_code', `total_amount` = '$c_total', `total_cost` = '$t_price', `total_shipping` = '$c_ship' WHERE `orders` .`ship_name` = '$name'"; And this way does not: $query = "UPDATE `orders` SET `c_phone` = '$c_phone', `c_email` = '$c_email', `card_type` = '$card_type', `card_number` = '$card_number', `card_month` = '$card_month', `card_year` = '$card_year', `card_name` = '$card_name', `three_number` = '$amex_code', `total_amount` = '$c_total', `total_cost` = '$t_price', `total_shipping` = '$c_ship' WHERE `orders` .`ship_name` = '$name' and `orders` .`amount` ='$t_price'"; I get my problem when I added the {and `orders` .`amount` ='$t_price'} part on the end. I need to match the new information with the row by using two values " by name and total". I have tried printing the querys out in all different ways. When I paste it into the sql, it accepts it but it has 0 affected rows even when amount does equal $t_price.

this message: Error in my_thread_global_end(): 1 threads didn't exit is on my page where I am connecting to mysql. Everything works fine. How do I comment out or make it to where it won't display this message on my page?

sorry... this is what echoed onto the page.. : UPDATE `orders` SET `c_phone` = '555.555.5555', `c_email` = '[email protected]', `card_type` = 'VISA', `card_number` = '5555666677778888', `card_month` = '01', `card_year` = '00', `card_name` = 'mr. test', `three_number` = 123, `total_amount` = , `total_cost` = 58.42, `total_shipping` = 12.99 WHERE `ship_name` = 'mr. test' AND `amount` = '58.42' AND `ship_address` = '121 test lane'

SQL query: UPDATE `orders` SET `c_phone` = '555.555.5555', `c_email` = '[email protected]', `card_type` = 'VISA', `card_number` = '5555666677778888', `card_month` = '01', `card_year` = '00', `card_name` = 'mr. test', `three_number` =123, `total_amount` = , `total_cost` = 58.42, `total_shipping` = 12.99 WHERE `ship_name` = 'mr. test' AND `amount` = '58.42' AND `ship_address` = '121 test lane' MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `total_cost` = 58.42, `total_shipping` = 12.99 WHERE `ship_name` = 'mr. test' A' at line 1 here is what echoed onto the page: SQL query: UPDATE `orders` SET `c_phone` = '555.555.5555', `c_email` = '[email protected]', `card_type` = 'VISA', `card_number` = '5555666677778888', `card_month` = '01', `card_year` = '00', `card_name` = 'mr. test', `three_number` =123, `total_amount` = , `total_cost` = 58.42, `total_shipping` = 12.99 WHERE `ship_name` = 'mr. test' AND `amount` = '58.42' AND `ship_address` = '121 test lane' MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' `total_cost` = 58.42, `total_shipping` = 12.99 WHERE `ship_name` = 'mr. test' A' at line 1 i pasted this into the sql and got the above error

this didn't give me the error.

hey i've echoed this onto the page and pasted it into mysql... i have an error in my mysql syntax... I'm assuming I cannot use all of these "and where's" that i have in my code. What would be an alternative way do do this? $conn = db_connect(); // insert customer address $query = "UPDATE `orders` SET `c_phone` = '$c_phone', `c_email` = '$c_email', `card_type` = '$card_type', `card_number` = '$card_number', `card_month` = '$card_month', `card_year` = '$card_year', `card_name` = '$card_name', `three_number` = $amex_code, `total_amount` = $c_total, `total_cost` = $t_price, `total_shipping` = $c_ship WHERE `orders` .`ship_name` = '$name' AND WHERE `orders` .`amount` = '$t_price' AND WHERE `orders` .`ship_address` = '$address'"; echo $query;

yea,,, sorry.... thanks

hey... I am getting 5.99 back as my shipping every time. I am missing something, I cannot figure out what it is. No matter what the $t_number is... it is returning 5.99.. <?php function calculate_shipping_cost() { // return 20.00; $t_number = number_format($_SESSION['total_price'],2); if ($t_number >= 0.01 and $number <= 14.99) { return 5.99; } else if ($t_number >= 15.00 and $number <= 29.99) { return 8.99; } else if ($t_number >= 30.00 and $number <= 49.99) { return 10.99; } else if ($t_number >= 50.00 and $number <= 74.99) { return 12.99; } else if ($t_number >= 75.00 and $number <= 99.99) { return 14.99; } else if ($t_number >= 100.00 and $number <= 149.99) { return 16.99; } else if ($t_number >= 150.00 and $number <= 199.99) { return 18.99; } else if ($t_number >= 200.00 and $number <= 299.99) { return 21.99; } else if ($t_number >= 300.00) { return 28.99; } else { return 10.00; } }

i am still not having any luck. Could you please post an example that you know works?

i turned the filter off. The mail does not seem to be coming through. But, the e-mail is able to come through on one of my accounts. What else could I do to allow the mail to come through? Thanks, Jake

The address i'm trying to send to is a centurytel account. If I log into the preferences... Could I just allow the server address???.... What do I type in for it to allow?? Would it be like an ip address or something?

ok... my form that I made will not deliver to hotmail or gmail... What is the problem?? <?php $name = $_POST['name']; $company = $_POST['company']; $phone = $_POST['phone']; $email = $_POST['email']; $feedback = $_POST['message']; $name = trim($name); $company = trim($company); $phone = trim($phone); $email = trim($email); $feedback = trim($feedback); $toaddress = '[email protected]'; $subject = 'Website Form - mysite.com'; $mailcontent = 'Customer name: '.$name."\n" .'Customer company: '.$company."\n" .'Customer e-mail: '.$email."\n" .'Customer phone: '.$phone."\n" ."Customer comments: \n".$feedback."\n"; // header information not including sendTo and Subject // these all go in one variable. First, include From: $fromaddress = 'From: [email protected]'; mail($toaddress, $subject, $mailcontent, $fromaddress); ?>

bump.

bump...

Hey, I was wondering if any of you all could give me information on how to go about getting my orders into an accounting program like quickbooks. What should be the process? What could I write the data into in order to be able to import the data into quickbooks? thank you, Jake

Cool. Thank you.

I'm sorry, I'm a little slow. How do I implement that in with this following code? $query = "SELECT * FROM order_items WHERE orderid = '$coolid'"; $result = mysql_query($query, $db) or die(mysql_error()); while ($row = mysql_fetch_assoc($result)) { $rows[] = $row; }

for ($i = 0; $i<3; $i++ ) echo "$rows[$i] "; I tried this. All I got back was: Array Array