Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.
Mysql /php how do I retrive data
Name: Geiri Date: February 24, 2004 at 05:03:22 Pacific OS: Xp CPU/Ram: 2.4/1gb
Comment:
I have set up my Mysql database And some data in it now I need some help geting my data to my php page.
I know how to connect to the database but I need to know how I can pull data from a <? mysql_connect( 'host', 'user', 'pass' ); mysql_select_db( 'database' ); $query = mysql_query( "SELECT ??????
now I need to pull text from a field called name and add to it a url from a field called url. and print that to page ?
Name: 3Dave Date: February 24, 2004 at 07:01:20 Pacific
Reply:
Looks like you're stuck on "SELECT ??????". It is expecting a standard SQL statement. This will depend on exactly what data you want to pull and how your database is structured. You may want to read up a little on it, try here for starters: http://www.w3schools.com/sql/default.asp
0
Response Number 2
Name: Geiri Date: February 25, 2004 at 09:15:18 Pacific
Summary: http://www.perfectionconstruction.c... Here's where I'm at today. I'll post the code below. Laler, last I checked this page validates! Yay!! "the whole code seems to be done in a hurry :D (or made ...
Summary: Hi, I want to know how do I do this: when you do a rollover on the book image it appears a box with some text.... http://www.amazon.com/exec/obidos/tg/detail/-/076451637X/qid=1108960954/sr=1-2/ref=sr_...
Summary: Hi folks, How do I send HTML documents including images & Photo? I sent one of the documents but my friend says that he did not find images or photo. Thanks for any solve! Masud ...
0 
CSS with Netscape 7.1
