Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
MYSQL Error emailing my Cell Phone ??
I used this code to have a PHP file email my cell phone and it worked. ------------------------ <?php mail("9999999999@mobile.att.net", "Header here", "More Text here"); ?> ------------------------ My question is does anyone know the code I would need to put into this mysql statement to get... -
1 SQL statement - Can you have 2 while statements?
---------------------------------- $sql_statement = "SELECT id, price, title, date, FROM table where date = \"2004/12/7\""; $result = mysql_query($sql_statement) or die(mysql_error()); while($abc = mysql_fetch_array( $result )) { $id = $abcd[0]; $price = $abc[1]; $title = $abc[2]... -
1 SQL statement - Can you have 2 while statements?
I want to loop through results with a while statement without having to do another SQL statement. Here is my example. ---------------------------------- $sql_statement = "SELECT id, price, title, date, FROM table where date = \"2004/12/7\""; $result = mysql_query($sql_statement) or... -
Currency - Column Type - $13.10 and not $13.1
Anyone that can help with this will be appreciated. I am using Navicat and setting up a simple database. I want currency to show up properly. Ex: 13.10 should show up 13.10 and not 13.1 I set up the column as decimal and decimals I set to 2. I have Zerofill clicked. But when I add a record or... -
Basic Question - Need Help
I have a basic question that I hope someone can help me with. I need to grab info from two different tables but don't know how. $sql_statement = "SELECT * FROM table1, table2 where table1.item_id = \"$ARG\" && table2.item_id = \"$ARG\""; $result = mysql_query($sql_statement) or...
