[PHP-DB] delete multiple records with one query

hi, i'm trying to delete multiple records at once from a mysql db and can't seem to figure out how to do so. here's the code i've been trying to troubleshoot with: $result_insert = mysql_query("delete from $mysql_table where id = '8' AND where id = '18'"); i've tried various things such as taki

Re: [PHP-DB] PHP/Mysql web hosting: who's best?

check out www.darkscape.net, good quality hosting for cheap. http://www.darkscape.net/?x=services for pricing which ranges from $7 to $25 - Original Message - From: "Gormley, Robert" <[EMAIL PROTECTED]> To: "'Matthew Crouch'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, Decem

[PHP-DB] date format question

hi, i'm wondering if anyone could help me in formatting a date so it is 5 hours ahead of the server time. here's the code i'm using but it doesn't seem to work: $date = date("F dS, Y g:i:s A", mktime(date("g")+5,date("i"),date("s"),date("m"),date("d"),date("Y")) ); i've already looked in the m

[PHP-DB] mysql select where problem

hello again, i'm stuck with this mysql query and can't seem to get it right // start code $result = mysql_query("select * from shows WHERE date >= '" . $year . "-" . $month . "-" . ("00") ."' AND where date <= '" . $year . "-" . $month . "-" . ("31") ."'"); // end code and yes, $year and $mo

[PHP-DB] 'replace' with 'where'

hello php-db people. i'm wondering if you could set me straight here. here's my code snippet: $result_insert = mysql_query("replace into wantlist where id = '$id' values ('', '$artist', '$title', '$tracks', '', '', '')"); the $id is already defined in the url, by the way (ex. bla.com/page.php

Re: [PHP-DB] Re: another php/mysql problem

t; <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 25, 2001 5:25 AM Subject: [PHP-DB] Re: another php/mysql problem > > > Matt Nigh schrieb: > > > Matt Nigh > > > > > $link = mysql_connect("localhost","username",&q

[PHP-DB] another php/mysql problem

bout this code or my problem, please e-mail me. Matt Nigh band name without spaces: " . $my_row["$band"]; echo "band name with spaces: " . $my_row["$band_spaces"]; echo "id: " . $my_row["$id"]; echo "email address: " . $my_row[

[PHP-DB] php/mysql query

ask and i'll try and explain a little better. thanks in advance, Matt Nigh

[PHP-DB] define variable by querying MySQL

`T_NUM_STRING' in c:\apache group\apache\htdocs\page.php on line 5 i can't figure out what to do, so if anyone can assist me, i'd be greatful. I have a feeling it's something with some quotes but i can't figure out which ones. Thanks a lot, Matt Nigh [EMAIL PROTECTED]

[PHP-DB] php/mysql horizontal listing query

hello knowledgeable people of the php-db list, i have a question for you regarding PHP using MySQL. my problem is this: I need a section of a record label site with a releases section listed horizontally but here's the twist: after every 4 releases, I want the releases to move to the next col

Re: [PHP-DB] newbie MySQL question

d confusing, I'm really sorry, I'm pretty bad at explaining things well, so ask if you don't understand what i mean by something. Thanks again, Matt > > $result = mysql_query("select * from shows"); > Change to > > $result = mysql_query("select * from

[PHP-DB] newbie MySQL question

hi, i'm building a website right now with a shows page on it which will scroll horizontally in a window. i have each show listed in a table called shows (db is called almavale_board) with the following fields: id - bandplaying - venue - date - time - cover - description what i need to do is hav