[PHP-DB] Re: Pulling a long list of data stalls PHP

try mysql_fetch_array... mysql_fetch_row is a crappy old function. - Original Message - From: "Peter Westergaard" <[EMAIL PROTECTED]> Newsgroups: php.db To: <[EMAIL PROTECTED]> Sent: Monday, January 07, 2002 8:32 AM Subject: Pulling a long list of data stalls PHP > Hi, > > I'm

[PHP-DB] Re: DESC & LIMIT

to use a desc, you need an order by "Barry Rumsey" <[EMAIL PROTECTED]> wrote in message 001001c197d6$ceb70160$0100a8c0@weizmain">news:001001c197d6$ceb70160$0100a8c0@weizmain... $query = "SELECT * FROM xp_sings,xp_artist,xp_songs WHERE xp_artist.artist_id = xp_sings.artist_id AND xp_sings.song_id

[PHP-DB] Re: Problem with buttons

if you look closely at your code (instead of posting yet another silly message on this board) you'll notice that the first has an onclink event..i am not presently aware of any such event. to all you newbies out there: look over your code, check php.net, check the comments sections, if ALL els

[PHP-DB] Re: Selecting last row

order by tableId desc limit 1 "Necro" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > What query can I use to select the last row in a table?? > > Andrew -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additi

[PHP-DB] Re: Populating a MySQL database

look at the mysql_insert() function and then look at the comments for the function mt_rand() "Pjc" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I need a script that will populate a MySQL database with mostly random data > (without crashing my box) with field

[PHP-DB] Re: Dumb Question??

$table = "some_junk"; $resultset=mysql_query("select blah ,blah from $table"); "Russ Michell" <[EMAIL PROTECTED]> wrote in message news:SIMEON.10112131209.A@k1c. anglia.ac.uk... > Hi there everyone: > > I have a genericphp/MySQL search+retrival mechanism. Generic in that it takes table names, > f

[PHP-DB] Re: How to get Session ID

there is a very cryptic function for getting the session id: session_id() if you pass it a value, it will also set the id "Chris Payne" <[EMAIL PROTECTED]> wrote in message 000c01c184ef$53abc220$0200a8c0@chris">news:000c01c184ef$53abc220$0200a8c0@chris... Hi there everyone, I know how to get the

[PHP-DB] Re: Is MySQL enough for a huge amount of data?

mysql is better for quick and lightless overhead than postgress, less functionality too. overall, if you sit and tune it, you can get postgress to run better, but who has the time. "Andy" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi there, > > I am wo

Re: [PHP-DB] Re: Dynamically populating a dropdown box

also, to get existing vals to show in the select as default, while($row=mysql_fetch_array($result)){ $selected=($row["ID"]==$ID)?"selected":""; echo "" . $row["name"] . "\n"; } the value can be in single quotes also, altho i dont think quotes matter unless you use opera or some other wierdass b

[PHP-DB] anybody using stored procedures in sql server

is anybody using procs in sql server? has anyone been able to get a return parameter? can you use mssql_query, or only odbc? is this just a BIG FAT php limitation??? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-ma

[PHP-DB] return parameters for stored procedures with sql server 7 using odbc

t;password",5); if (!odbc_execute($stmt, &$parms)) die("odbc_execute failed"); is it possible to change this to both: explicitly pass the parameters by name and pass the return value to a variable? thx Ian Ferger -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]